SHOW FULL COLUMNS FROM `lm_shop` [ RunTime:0.000586s ]
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.000349s ]
SHOW FULL COLUMNS FROM `lm_page` [ RunTime:0.000411s ]
SELECT `id`,`title`,`type` FROM `lm_page` WHERE `type` = 1 ORDER BY `sort` [ RunTime:0.000210s ]
SELECT `id`,`title`,`type` FROM `lm_page` WHERE `type` = 2 ORDER BY `sort` [ RunTime:0.000209s ]
SELECT * FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000186s ]
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.000263s ]
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.000485s ]
SELECT `class_id` FROM `lm_product` WHERE `status` = 1 AND `is_del` = 1 AND `shop_id` = 109 GROUP BY `class_id` [ RunTime:0.000433s ]
SELECT `class_id` FROM `lm_product` WHERE `status` = 1 AND `is_del` = 1 AND `shop_id` = 109 GROUP BY `class_id` [ RunTime:0.000357s ]
SHOW FULL COLUMNS FROM `lm_classification` [ RunTime:0.000411s ]
SELECT * FROM `lm_classification` WHERE `id` = 316 AND `id` = 316 [ RunTime:0.000130s ]
SELECT * FROM `lm_classification` WHERE `id` = 316 AND `id` = 316 [ RunTime:0.000151s ]
SHOW FULL COLUMNS FROM `lm_config` [ RunTime:0.000390s ]
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.000100s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000097s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000086s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000086s ]
SELECT `shop_img` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000099s ]
SELECT `shop_logo` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000087s ]
SELECT `shop_name` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000085s ]
SELECT `shop_goods` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000109s ]
SHOW FULL COLUMNS FROM `lm_link` [ RunTime:0.000380s ]
SELECT * FROM `lm_link` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000123s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_phone' LIMIT 1 [ RunTime:0.000126s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_email' LIMIT 1 [ RunTime:0.000097s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'address' LIMIT 1 [ RunTime:0.000102s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_copyright' LIMIT 1 [ RunTime:0.000090s ]
鲁公网安备 37010302001115号
