SHOW FULL COLUMNS FROM `lm_shop` [ RunTime:0.000570s ]
SELECT * FROM `lm_shop` INNER JOIN `lm_user` ON `lm_shop`.`user_id`=lm_user.id AND lm_user.status=1 INNER JOIN `lm_qualifications` ON `lm_qualifications`.`user_id`=lm_shop.user_id AND lm_qualifications.state=1 WHERE `lm_qualifications`.`states` > '0' AND `lm_shop`.`id` = '109' LIMIT 1 [ RunTime:0.000360s ]
SHOW FULL COLUMNS FROM `lm_page` [ RunTime:0.000434s ]
SELECT `id`,`title`,`type` FROM `lm_page` WHERE `type` = 1 ORDER BY `sort` [ RunTime:0.000205s ]
SELECT `id`,`title`,`type` FROM `lm_page` WHERE `type` = 2 ORDER BY `sort` [ RunTime:0.000198s ]
SELECT * FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000175s ]
SHOW FULL COLUMNS FROM `lm_product` [ RunTime:0.000437s ]
SELECT COUNT(*) AS think_count FROM `lm_product` `p` INNER JOIN `lm_shop` `s` ON `p`.`shop_id`=`s`.`id` WHERE `p`.`p_status` = '2' AND `p`.`status` = '1' AND `p`.`is_del` = '1' AND `p`.`shop_id` = '109' AND 1 LIMIT 1 [ RunTime:0.000262s ]
SELECT `p`.*,s.id s_id,`s`.`shop_name` FROM `lm_product` `p` INNER JOIN `lm_shop` `s` ON `p`.`shop_id`=`s`.`id` WHERE `p`.`p_status` = '2' AND `p`.`status` = '1' AND `p`.`is_del` = '1' AND `p`.`shop_id` = '109' AND 1 LIMIT 0,8 [ RunTime:0.000500s ]
SELECT `class_id` FROM `lm_product` WHERE `status` = 1 AND `is_del` = 1 AND `shop_id` = 109 GROUP BY `class_id` [ RunTime:0.000429s ]
SELECT `class_id` FROM `lm_product` WHERE `status` = 1 AND `is_del` = 1 AND `shop_id` = 109 GROUP BY `class_id` [ RunTime:0.000324s ]
SHOW FULL COLUMNS FROM `lm_classification` [ RunTime:0.000392s ]
SELECT * FROM `lm_classification` WHERE `id` = 316 AND `id` = 316 [ RunTime:0.000138s ]
SELECT * FROM `lm_classification` WHERE `id` = 316 AND `id` = 316 [ RunTime:0.000110s ]
SHOW FULL COLUMNS FROM `lm_config` [ RunTime:0.000407s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_logo' LIMIT 1 [ RunTime:0.000122s ]
SELECT `shop_name` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000099s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000091s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000087s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000219s ]
SELECT `shop_img` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000105s ]
SELECT `shop_logo` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000091s ]
SELECT `shop_name` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000086s ]
SELECT `shop_goods` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000086s ]
SHOW FULL COLUMNS FROM `lm_link` [ RunTime:0.000369s ]
SELECT * FROM `lm_link` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000127s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_phone' LIMIT 1 [ RunTime:0.000116s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_email' LIMIT 1 [ RunTime:0.000103s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'address' LIMIT 1 [ RunTime:0.000093s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_copyright' LIMIT 1 [ RunTime:0.000092s ]
鲁公网安备 37010302001115号
