SHOW FULL COLUMNS FROM `lm_page` [ RunTime:0.000916s ]
SELECT `id`,`title`,`type` FROM `lm_page` WHERE `type` = 1 ORDER BY `sort` [ RunTime:0.000324s ]
SELECT `id`,`title`,`type` FROM `lm_page` WHERE `type` = 2 ORDER BY `sort` [ RunTime:0.000284s ]
SHOW FULL COLUMNS FROM `lm_adv` [ RunTime:0.000902s ]
SELECT * FROM `lm_adv` WHERE `pid` = 8 AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `lm_ad` [ RunTime:0.000924s ]
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.000411s ]
SHOW FULL COLUMNS FROM `lm_shop` [ RunTime:0.000871s ]
SELECT `id`,`shop_name` FROM `lm_shop` WHERE `id` IN (70,91,89,82,88) [ RunTime:0.000302s ]
SHOW FULL COLUMNS FROM `lm_product` [ RunTime:0.000781s ]
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.000310s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 225 ORDER BY `sort`,`id` [ RunTime:0.000693s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 226 ORDER BY `sort`,`id` [ RunTime:0.000625s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001575s ]
SHOW FULL COLUMNS FROM `lm_qualifications` [ RunTime:0.001191s ]
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.000815s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001789s ]
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.000813s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 227 ORDER BY `sort`,`id` [ RunTime:0.000459s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001040s ]
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.000812s ]
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` = '231' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000701s ]
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` = '234' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000845s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 228 ORDER BY `sort`,`id` [ RunTime:0.000507s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001095s ]
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.000693s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001091s ]
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.000790s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001096s ]
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.000744s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001085s ]
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.000659s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 229 ORDER BY `sort`,`id` [ RunTime:0.000508s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001088s ]
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.000910s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001092s ]
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.000658s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001094s ]
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.001072s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001098s ]
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.000755s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' AND `pid` = 243 ORDER BY `sort`,`id` [ RunTime:0.000495s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001076s ]
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.000653s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001079s ]
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.001008s ]
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` = '249' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000945s ]
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` = '250' ORDER BY `Msg`.`id` DESC LIMIT 10 [ RunTime:0.000692s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001090s ]
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.000752s ]
SELECT * FROM `lm_classification` WHERE `status` = '1' [ RunTime:0.001094s ]
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.000736s ]
SHOW FULL COLUMNS FROM `lm_config` [ RunTime:0.000778s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_name' LIMIT 1 [ RunTime:0.000246s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_seo_title' LIMIT 1 [ RunTime:0.000227s ]
SHOW FULL COLUMNS FROM `lm_adv_position` [ RunTime:0.000702s ]
SELECT * FROM `lm_adv_position` WHERE `status` = 1 AND `id` = 8 LIMIT 1 [ RunTime:0.000261s ]
SELECT * FROM `lm_adv` WHERE `status` = 1 AND `pid` = 8 ORDER BY `sort` DESC [ RunTime:0.000373s ]
SHOW FULL COLUMNS FROM `lm_user` [ RunTime:0.000815s ]
SELECT `level_id` FROM `lm_user` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000209s ]
SHOW FULL COLUMNS FROM `lm_link` [ RunTime:0.000788s ]
SELECT * FROM `lm_link` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000282s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_phone' LIMIT 1 [ RunTime:0.000459s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_email' LIMIT 1 [ RunTime:0.000247s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'address' LIMIT 1 [ RunTime:0.000264s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_copyright' LIMIT 1 [ RunTime:0.000239s ]
鲁公网安备 37010302001115号