SHOW FULL COLUMNS FROM `ba_lang` [ RunTime:0.000329s ]
SELECT `code`,`name`,`icon`,`weigh` FROM `ba_lang` WHERE `status` = 1 ORDER BY `weigh` DESC [ RunTime:0.000178s ]
SHOW FULL COLUMNS FROM `ba_web_product` [ RunTime:0.000314s ]
SELECT `p`.`id`,`p`.`cover`,`p`.`images`,`p`.`classify_id`,`pt`.`name`,`pt`.`description`,`pt`.`specs`,pz.name AS name_zh,pz.description AS description_zh,pz.specs AS specs_zh FROM `ba_web_product` `p` LEFT JOIN `ba_web_product_trans` `pt` ON `pt`.`product_id`=p.id AND pt.lang = 'zh-cn' LEFT JOIN `ba_web_product_trans` `pz` ON `pz`.`product_id`=p.id AND pz.lang = 'zh-cn' WHERE `p`.`id` = '29' AND `p`.`status` = '1' AND `p`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000430s ]
SHOW FULL COLUMNS FROM `ba_web_classify_trans` [ RunTime:0.000274s ]
SELECT `name` FROM `ba_web_classify_trans` WHERE `classify_id` = 21 AND `lang` = 'zh-cn' LIMIT 1 [ RunTime:0.000154s ]
SELECT `p`.`id`,`p`.`identifier`,`p`.`title` FROM `ba_web_page` `p` INNER JOIN `ba_web_page_tpl` `t` ON `t`.`id`=`p`.`page_tpl_id` WHERE `t`.`identifier` = 'products' AND `t`.`delete_time` IS NULL AND `p`.`delete_time` IS NULL ORDER BY `p`.`id` ASC LIMIT 1 [ RunTime:0.000206s ]
SELECT `id`,`title` FROM `ba_web_page` WHERE `identifier` = 'home' AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000144s ]
SELECT * FROM `ba_web_page` WHERE `identifier` = 'common' AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000148s ]
SHOW FULL COLUMNS FROM `ba_web_page_tpl` [ RunTime:0.000271s ]
SELECT * FROM `ba_web_page_tpl` WHERE `id` = 4 AND `delete_time` IS NULL LIMIT 1 [ RunTime:0.000185s ]
SHOW FULL COLUMNS FROM `ba_web_page_items` [ RunTime:0.000269s ]
SELECT * FROM `ba_web_page_items` WHERE `page_id` = 2 AND `delete_time` IS NULL ORDER BY `id` ASC [ RunTime:0.000377s ]
SHOW FULL COLUMNS FROM `ba_web_page_items_trans` [ RunTime:0.000282s ]
SELECT * FROM `ba_web_page_items_trans` WHERE `page_items_id` IN (58,59,60,62,63,65,66,67,68,73,74,75,76,77,78,79,80,82,83,84,85,86,87,300,302) AND `lang` = 'zh-cn' [ RunTime:0.001202s ]
SHOW FULL COLUMNS FROM `ba_web_menu` [ RunTime:0.000327s ]
SELECT * FROM `ba_web_menu` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.000257s ]
SHOW FULL COLUMNS FROM `ba_web_menu_trans` [ RunTime:0.000265s ]
SELECT `name`,`menu_id` FROM `ba_web_menu_trans` WHERE `menu_id` IN (47,46,45,21,44,30,43,31,7,42,32,20,1,41,33,29,2,40,34,28,3,39,35,27,4,38,36,26,5,37,25,8,6,24,23,22) AND `lang` = 'zh-cn' [ RunTime:0.000298s ]
SELECT `identifier`,`id` FROM `ba_web_page` WHERE `id` IN (46,45,44,15,43,29,42,30,3,41,31,8,1,40,32,23,39,33,24,38,34,25,37,35,26,36,27,4,21,18,17,16) [ RunTime:0.000212s ]
SELECT * FROM `ba_web_menu` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.000250s ]
SELECT `name`,`menu_id` FROM `ba_web_menu_trans` WHERE `menu_id` IN (47,46,45,21,44,30,43,31,7,42,32,20,1,41,33,29,2,40,34,28,3,39,35,27,4,38,36,26,5,37,25,8,6,24,23,22) AND `lang` = 'zh-cn' [ RunTime:0.000285s ]
SELECT `identifier`,`id` FROM `ba_web_page` WHERE `id` IN (46,45,44,15,43,29,42,30,3,41,31,8,1,40,32,23,39,33,24,38,34,25,37,35,26,36,27,4,21,18,17,16) [ RunTime:0.000204s ]