SHOW FULL COLUMNS FROM `rrz_plugin` [ RunTime:0.005700s ]
SELECT `code` FROM `rrz_plugin` WHERE `status` = 1 [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `rrz_site_menus` [ RunTime:0.004041s ]
SELECT `id`,`dir_name` FROM `rrz_site_menus` WHERE length(dir_name) > 0 [ RunTime:0.000339s ]
SHOW FULL COLUMNS FROM `rrz_goods_cat` [ RunTime:0.004782s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000286s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' LIMIT 1 [ RunTime:0.000222s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' LIMIT 1 [ RunTime:0.000278s ]
SELECT * FROM `rrz_site_menus` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000292s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000367s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000312s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000354s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000294s ]
SHOW FULL COLUMNS FROM `rrz_article_nodes` [ RunTime:0.005076s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000471s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000441s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000305s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000392s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/7.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000252s ]
SELECT * FROM `rrz_article_nodes` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000315s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/7.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000246s ]
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.000402s ]
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.000285s ]
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.000335s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 1 ORDER BY path asc,id asc [ RunTime:0.000375s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/16.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.001086s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000304s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000254s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000244s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000341s ]
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.000260s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 1 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000437s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/8.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000284s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/9.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000234s ]
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.000305s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 6 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000482s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000264s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000226s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000274s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/26.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/27.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000278s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/28.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000233s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/node/29.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000295s ]
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.000252s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 2 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000401s ]
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.000243s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 4 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000357s ]
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.000253s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 5 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000413s ]
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.000318s ]
SELECT * FROM `rrz_article_nodes` WHERE `parent_id` = 7 AND `ifpub` = 'true' ORDER BY path asc,id asc [ RunTime:0.000341s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000238s ]
SELECT `id`,`name` FROM `rrz_goods_cat` WHERE `id` IN (1,17) ORDER BY `path` ASC,`id` ASC [ RunTime:0.000257s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000221s ]
SELECT `title`,`dir_name`,`url` FROM `rrz_site_menus` WHERE `url` LIKE '%/cats.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000266s ]
SELECT `id`,`title`,`dir_name`,`url` FROM `rrz_site_menus` WHERE `id` = 9 ORDER BY `path` ASC,`id` ASC [ RunTime:0.000208s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 17 ORDER BY path asc,id asc [ RunTime:0.000316s ]
SELECT `id_path`,`parent_id` FROM `rrz_goods_cat` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000447s ]
SELECT `id` FROM `rrz_site_menus` WHERE `url` LIKE '%/cats%' LIMIT 1 [ RunTime:0.000253s ]
SELECT * FROM `rrz_goods_cat` WHERE `parent_id` = 1 ORDER BY path asc,id asc [ RunTime:0.000310s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/16.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000266s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000227s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/18.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000244s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/19.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000218s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/20.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000225s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/21.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000220s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000229s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000329s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000231s ]
SELECT * FROM `rrz_goods_cat` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000316s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/1.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000227s ]
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.000239s ]
SELECT `id_path` FROM `rrz_goods_cat` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000227s ]
SHOW FULL COLUMNS FROM `rrz_goods` [ RunTime:0.004553s ]
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=17 or(b.id_path like '1,17,%') ) [ RunTime:0.000572s ]
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=17 or(b.id_path like '1,17,%') ) ORDER BY `a`.`sort` ASC,`a`.`id` DESC LIMIT 0,6 [ RunTime:0.000590s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/item/65.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000322s ]
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 '%/item/77.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000274s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000257s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/item/67.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.000234s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/item/66.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000274s ]
SELECT `dir_name` FROM `rrz_site_menus` WHERE `url` LIKE '%/cat/17.html' ORDER BY `depth` DESC LIMIT 1 [ RunTime:0.000227s ]
SHOW FULL COLUMNS FROM `rrz_forms` [ RunTime:0.004785s ]
SELECT * FROM `rrz_forms` WHERE `id` = 1 AND `is_del` = 0 LIMIT 1 [ RunTime:0.000272s ]
SELECT `code` FROM `rrz_plugin` WHERE ( status=1 and ishome=1 and isload=1 and (loadtemp='' or loadtemp like '%:cat,%') ) [ RunTime:0.000236s ]