SHOW FULL COLUMNS FROM `rrz_plugin` [ RunTime:0.005894s ]
SELECT `code` FROM `rrz_plugin` WHERE `status` = 1 [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `rrz_site_menus` [ RunTime:0.004199s ]
SELECT `id`,`dir_name` FROM `rrz_site_menus` WHERE length(dir_name) > 0 [ RunTime:0.000289s ]
SHOW FULL COLUMNS FROM `rrz_goods_cat` [ RunTime:0.005451s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000435s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' LIMIT 1 [ RunTime:0.000567s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' LIMIT 1 [ RunTime:0.000236s ]
SELECT * FROM `rrz_site_menus` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000311s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000570s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.001315s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000380s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `rrz_article_nodes` [ RunTime:0.004156s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000990s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000278s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000391s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000269s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000366s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/7.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000268s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000383s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/7.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000263s ]
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.000327s ]
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.000276s ]
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.000260s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 1 ORDER BY path asc,id asc [ RunTime:0.000382s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/16.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000272s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000248s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000335s ]
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.000339s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 1 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000431s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/8.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000240s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/9.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/10.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000241s ]
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.000263s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 6 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000393s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000269s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000219s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000254s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000215s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/26.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000228s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/27.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000249s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/28.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000229s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/29.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000302s ]
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.000319s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 2 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000350s ]
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.000357s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 4 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000380s ]
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.000321s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 5 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000329s ]
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.000233s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 7 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000358s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000203s ]
SELECT `id`,`name` FROM `rrz_goods_cat` WHERE `id` IN (1,21) ORDER BY `path` ASC,`id` ASC [ RunTime:0.000344s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000280s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000264s ]
SELECT `title`,`dir_name`,`url` FROM `rrz_site_menus` WHERE `url` LIKE '%/cats.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000214s ]
SELECT `id`,`title`,`dir_name`,`url` FROM `rrz_site_menus` WHERE `id` = 9 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000329s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 21 ORDER BY path asc,id asc [ RunTime:0.000262s ]
SELECT `id_path`,`parent_id` FROM `rrz_goods_cat` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000211s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cats%' LIMIT 1 [ RunTime:0.000233s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 1 ORDER BY path asc,id asc [ RunTime:0.000435s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/16.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000218s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000234s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000237s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000291s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000210s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000266s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000254s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.001167s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000258s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000321s ]
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.000240s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000202s ]
SHOW FULL COLUMNS FROM `rrz_goods` [ RunTime:0.006152s ]
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.000460s ]
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.000614s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/item/71.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000287s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `rrz_forms` [ RunTime:0.008069s ]
SELECT * FROM `rrz_forms` WHERE `id` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000330s ]
SELECT `code` FROM `rrz_plugin` WHERE ( status=1 and ishome=1 and isload=1 and (loadtemp='' or loadtemp like '%:cat,%') ) [ RunTime:0.000310s ]