SHOW FULL COLUMNS FROM `lm_shop` [ RunTime:0.000545s ]
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.000318s ]
SHOW FULL COLUMNS FROM `lm_page` [ RunTime:0.000390s ]
SELECT `id`,`title`,`type` FROM `lm_page` WHERE `type` = 1 ORDER BY `sort` [ RunTime:0.000190s ]
SELECT `id`,`title`,`type` FROM `lm_page` WHERE `type` = 2 ORDER BY `sort` [ RunTime:0.000186s ]
SELECT * FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000182s ]
SHOW FULL COLUMNS FROM `lm_product` [ RunTime:0.000429s ]
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.000274s ]
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.000480s ]
SELECT `class_id` FROM `lm_product` WHERE `status` = 1 AND `is_del` = 1 AND `shop_id` = 109 GROUP BY `class_id` [ RunTime:0.000419s ]
SELECT `class_id` FROM `lm_product` WHERE `status` = 1 AND `is_del` = 1 AND `shop_id` = 109 GROUP BY `class_id` [ RunTime:0.000345s ]
SHOW FULL COLUMNS FROM `lm_classification` [ RunTime:0.000387s ]
SELECT * FROM `lm_classification` WHERE `id` = 316 AND `id` = 316 [ RunTime:0.000127s ]
SELECT * FROM `lm_classification` WHERE `id` = 316 AND `id` = 316 [ RunTime:0.000108s ]
SHOW FULL COLUMNS FROM `lm_config` [ RunTime:0.000391s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_logo' LIMIT 1 [ RunTime:0.000125s ]
SELECT `shop_name` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000100s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000153s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000102s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000087s ]
SELECT `shop_img` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000089s ]
SELECT `shop_logo` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000086s ]
SELECT `shop_name` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000084s ]
SELECT `shop_goods` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000085s ]
SHOW FULL COLUMNS FROM `lm_link` [ RunTime:0.000364s ]
SELECT * FROM `lm_link` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000121s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_phone' LIMIT 1 [ RunTime:0.000122s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_email' LIMIT 1 [ RunTime:0.000095s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'address' LIMIT 1 [ RunTime:0.000090s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_copyright' LIMIT 1 [ RunTime:0.000089s ]
鲁公网安备 37010302001115号
