SHOW FULL COLUMNS FROM `rrz_plugin` [ RunTime:0.005035s ]
SELECT `code` FROM `rrz_plugin` WHERE `status` = 1 [ RunTime:0.000387s ]
SHOW FULL COLUMNS FROM `rrz_site_menus` [ RunTime:0.004528s ]
SELECT `id`,`dir_name` FROM `rrz_site_menus` WHERE length(dir_name) > 0 [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `rrz_goods_cat` [ RunTime:0.004388s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000333s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' LIMIT 1 [ RunTime:0.000243s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' LIMIT 1 [ RunTime:0.000226s ]
SELECT * FROM `rrz_site_menus` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000336s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000392s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000273s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000340s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000523s ]
SHOW FULL COLUMNS FROM `rrz_article_nodes` [ RunTime:0.004817s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000450s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000385s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000312s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000356s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/7.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000306s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/7.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`title`,`en_title`,`dir_name`,`url`,`id_path`,`depth`,`target_blank` FROM `rrz_site_menus` WHERE `parent_id` = 0 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000298s ]
SELECT `id`,`title`,`en_title`,`dir_name`,`url`,`id_path`,`depth`,`target_blank` FROM `rrz_site_menus` WHERE `parent_id` = 1 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000353s ]
SELECT `id`,`title`,`en_title`,`dir_name`,`url`,`id_path`,`depth`,`target_blank` FROM `rrz_site_menus` WHERE `parent_id` = 9 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000235s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 1 ORDER BY path asc,id asc [ RunTime:0.000368s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/16.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000236s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000312s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000222s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000228s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000212s ]
SELECT `id`,`title`,`en_title`,`dir_name`,`url`,`id_path`,`depth`,`target_blank` FROM `rrz_site_menus` WHERE `parent_id` = 2 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000253s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 1 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000680s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/8.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000223s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/9.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000294s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/10.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000210s ]
SELECT `id`,`title`,`en_title`,`dir_name`,`url`,`id_path`,`depth`,`target_blank` FROM `rrz_site_menus` WHERE `parent_id` = 7 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000255s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 6 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000403s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000226s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000213s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000275s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/26.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000209s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/27.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000236s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/28.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000211s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/29.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000226s ]
SELECT `id`,`title`,`en_title`,`dir_name`,`url`,`id_path`,`depth`,`target_blank` FROM `rrz_site_menus` WHERE `parent_id` = 3 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000833s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 2 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000382s ]
SELECT `id`,`title`,`en_title`,`dir_name`,`url`,`id_path`,`depth`,`target_blank` FROM `rrz_site_menus` WHERE `parent_id` = 5 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000239s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 4 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000317s ]
SELECT `id`,`title`,`en_title`,`dir_name`,`url`,`id_path`,`depth`,`target_blank` FROM `rrz_site_menus` WHERE `parent_id` = 6 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000330s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 5 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000526s ]
SELECT `id`,`title`,`en_title`,`dir_name`,`url`,`id_path`,`depth`,`target_blank` FROM `rrz_site_menus` WHERE `parent_id` = 8 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000274s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 7 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000520s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000282s ]
SELECT `id`,`name` FROM `rrz_goods_cat` WHERE `id` IN (1,19) ORDER BY `path` ASC,`id` ASC [ RunTime:0.000294s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000239s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000273s ]
SELECT `title`,`dir_name`,`url` FROM `rrz_site_menus` WHERE `url` LIKE '%/cats.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000241s ]
SELECT `id`,`title`,`dir_name`,`url` FROM `rrz_site_menus` WHERE `id` = 9 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000270s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 19 ORDER BY path asc,id asc [ RunTime:0.000281s ]
SELECT `id_path`,`parent_id` FROM `rrz_goods_cat` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000325s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cats%' LIMIT 1 [ RunTime:0.000224s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 1 ORDER BY path asc,id asc [ RunTime:0.000315s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/16.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000231s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000214s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000263s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000227s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000230s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000228s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000301s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000263s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000230s ]
SELECT `id`,`title`,`en_title`,`dir_name`,`url`,`id_path`,`depth`,`target_blank` FROM `rrz_site_menus` WHERE `parent_id` = 9 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000253s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000222s ]
SHOW FULL COLUMNS FROM `rrz_goods` [ RunTime:0.004486s ]
SELECT COUNT(*) AS think_count FROM `rrz_goods` `a` LEFT JOIN `rrz_goods_cat` `b` ON `a`.`cat_id`=`b`.`id` LEFT JOIN `rrz_goods_brand` `c` ON `a`.`brand_id`=`b`.`id` WHERE `a`.`ifpub` = 'true' AND ( b.id=19 or(b.id_path like '1,19,%') ) [ RunTime:0.000356s ]
SELECT `a`.*,b.name as type_name,b.id as type_id,c.title as brand_name FROM `rrz_goods` `a` LEFT JOIN `rrz_goods_cat` `b` ON `a`.`cat_id`=`b`.`id` LEFT JOIN `rrz_goods_brand` `c` ON `a`.`brand_id`=`b`.`id` WHERE `a`.`ifpub` = 'true' AND ( b.id=19 or(b.id_path like '1,19,%') ) ORDER BY `a`.`sort` ASC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.000557s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/item/70.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000238s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `rrz_forms` [ RunTime:0.003997s ]
SELECT * FROM `rrz_forms` WHERE `id` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000439s ]
SELECT `code` FROM `rrz_plugin` WHERE ( status=1 and ishome=1 and isload=1 and (loadtemp='' or loadtemp like '%:cat,%') ) [ RunTime:0.000345s ]