SHOW FULL COLUMNS FROM `lm_page` [ RunTime:0.001040s ]
SELECT `id`,`title`,`type` FROM `lm_page` WHERE `type` = 1 ORDER BY `sort` [ RunTime:0.000334s ]
SELECT `id`,`title`,`type` FROM `lm_page` WHERE `type` = 2 ORDER BY `sort` [ RunTime:0.000296s ]
SHOW FULL COLUMNS FROM `lm_adv` [ RunTime:0.000861s ]
SELECT * FROM `lm_adv` WHERE `pid` = 8 AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000355s ]
SHOW FULL COLUMNS FROM `lm_ad` [ RunTime:0.000882s ]
SELECT `Ad`.* FROM `lm_ad` `Ad` INNER JOIN `lm_product` `Product` ON `Ad`.`product_id`=`Product`.`id` WHERE `Product`.`status` = '1' AND `Product`.`p_status` = '2' AND `Product`.`is_del` = '1' AND `Ad`.`state` <> '0' AND `position` = 7 AND `state` <> 0 ORDER BY `number` [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `lm_shop` [ RunTime:0.000956s ]
SELECT `id`,`shop_name` FROM `lm_shop` WHERE `id` IN (70,91,89,82,88) [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `lm_product` [ RunTime:0.000917s ]
SELECT `id`,`name`,`img` FROM `lm_product` WHERE `status` = 1 AND `p_status` = 2 AND `is_del` = 1 AND `id` IN (154,163,277,257,231,194,195,258) [ RunTime:0.000339s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 225 ORDER BY `sort`,`id` [ RunTime:0.000702s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 226 ORDER BY `sort`,`id` [ RunTime:0.000639s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001486s ]
SHOW FULL COLUMNS FROM `lm_qualifications` [ RunTime:0.000947s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '232' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000618s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001082s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '233' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000745s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 227 ORDER BY `sort`,`id` [ RunTime:0.000454s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001159s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '230' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000935s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001069s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '231' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000780s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001160s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '234' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000876s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 228 ORDER BY `sort`,`id` [ RunTime:0.000502s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001195s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '235' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000791s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001111s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '236' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000758s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001116s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '237' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000674s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001152s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '238' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000731s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 229 ORDER BY `sort`,`id` [ RunTime:0.000494s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001105s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` IN ('239','346','347') ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000856s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001105s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` IN ('240','244','245','246') ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000737s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001112s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` IN ('241','341','342') ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000990s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001103s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` IN ('242','348','349','350','351','352','353','354','355','356','357','358','359','360','1039') ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000982s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 243 ORDER BY `sort`,`id` [ RunTime:0.000540s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001157s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '247' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000906s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001124s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '248' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000766s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001170s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '249' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000694s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001127s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '250' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000689s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001103s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '251' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.001727s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001612s ]
SELECT `Msg`.* FROM `lm_msg` `Msg` INNER JOIN `lm_user` `User` ON `Msg`.`user_id`=`User`.`id` INNER JOIN `lm_qualifications` `Qualifications` ON `Msg`.`user_id`=`Qualifications`.`user_id` WHERE `Qualifications`.`states` <> '0' AND `Msg`.`type` = '1' AND `Msg`.`type_id` = '252' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000914s ]
SHOW FULL COLUMNS FROM `lm_config` [ RunTime:0.000951s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_name' LIMIT 1 [ RunTime:0.000269s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_seo_title' LIMIT 1 [ RunTime:0.000224s ]
SHOW FULL COLUMNS FROM `lm_adv_position` [ RunTime:0.000905s ]
SELECT * FROM `lm_adv_position` WHERE `status` = 1 AND `id` = 8 LIMIT 1 [ RunTime:0.000259s ]
SELECT * FROM `lm_adv` WHERE `status` = 1 AND `pid` = 8 ORDER BY `sort` DESC [ RunTime:0.000458s ]
SHOW FULL COLUMNS FROM `lm_user` [ RunTime:0.001014s ]
SELECT `level_id` FROM `lm_user` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000219s ]
SHOW FULL COLUMNS FROM `lm_link` [ RunTime:0.000931s ]
SELECT * FROM `lm_link` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000303s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_phone' LIMIT 1 [ RunTime:0.000246s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_email' LIMIT 1 [ RunTime:0.000257s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'address' LIMIT 1 [ RunTime:0.000251s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_copyright' LIMIT 1 [ RunTime:0.000285s ]
鲁公网安备 37010302001115号