SHOW FULL COLUMNS FROM `rrz_plugin` [ RunTime:0.004898s ]
SELECT `code` FROM `rrz_plugin` WHERE `status` = 1 [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `rrz_site_menus` [ RunTime:0.004525s ]
SELECT `id`,`dir_name` FROM `rrz_site_menus` WHERE length(dir_name) > 0 [ RunTime:0.000429s ]
SHOW FULL COLUMNS FROM `rrz_goods_cat` [ RunTime:0.005037s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000359s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' LIMIT 1 [ RunTime:0.000354s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' LIMIT 1 [ RunTime:0.000294s ]
SELECT * FROM `rrz_site_menus` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000349s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000359s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000375s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000406s ]
SHOW FULL COLUMNS FROM `rrz_article_nodes` [ RunTime:0.004693s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000407s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000268s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000999s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000259s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000391s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/7.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000243s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000316s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/7.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000468s ]
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.000398s ]
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.000283s ]
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.000543s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 1 ORDER BY path asc,id asc [ RunTime:0.001315s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/16.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000273s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000214s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000232s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000237s ]
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.000316s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 1 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000448s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/8.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000272s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/9.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000288s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/10.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000249s ]
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.000267s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 6 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000440s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000240s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000208s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000237s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000223s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/26.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000249s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/27.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/28.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000242s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/29.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000722s ]
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.000427s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 2 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000428s ]
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.000622s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 4 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000418s ]
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.000439s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 5 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000379s ]
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.000353s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 7 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000342s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000208s ]
SELECT `id`,`name` FROM `rrz_goods_cat` WHERE `id` IN (1,21) ORDER BY `path` ASC,`id` ASC [ RunTime:0.000304s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000230s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `title`,`dir_name`,`url` FROM `rrz_site_menus` WHERE `url` LIKE '%/cats.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`title`,`dir_name`,`url` FROM `rrz_site_menus` WHERE `id` = 9 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000352s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 21 ORDER BY path asc,id asc [ RunTime:0.000331s ]
SELECT `id_path`,`parent_id` FROM `rrz_goods_cat` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000225s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cats%' LIMIT 1 [ RunTime:0.000333s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 1 ORDER BY path asc,id asc [ RunTime:0.000398s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/16.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000295s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000291s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000245s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000240s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000326s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000256s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000286s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000272s ]
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.000252s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000236s ]
SHOW FULL COLUMNS FROM `rrz_goods` [ RunTime:0.007222s ]
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=21 or(b.id_path like '1,21,%') ) [ RunTime:0.000448s ]
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=21 or(b.id_path like '1,21,%') ) ORDER BY `a`.`sort` ASC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.000915s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/item/71.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000249s ]
SHOW FULL COLUMNS FROM `rrz_forms` [ RunTime:0.003938s ]
SELECT * FROM `rrz_forms` WHERE `id` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000285s ]
SELECT `code` FROM `rrz_plugin` WHERE ( status=1 and ishome=1 and isload=1 and (loadtemp='' or loadtemp like '%:cat,%') ) [ RunTime:0.000262s ]