SHOW FULL COLUMNS FROM `lm_shop` [ RunTime:0.000576s ]
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.000331s ]
SHOW FULL COLUMNS FROM `lm_page` [ RunTime:0.000397s ]
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.000190s ]
SELECT * FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000169s ]
SHOW FULL COLUMNS FROM `lm_product` [ RunTime:0.000420s ]
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.000280s ]
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.000470s ]
SELECT `class_id` FROM `lm_product` WHERE `status` = 1 AND `is_del` = 1 AND `shop_id` = 109 GROUP BY `class_id` [ RunTime:0.000403s ]
SELECT `class_id` FROM `lm_product` WHERE `status` = 1 AND `is_del` = 1 AND `shop_id` = 109 GROUP BY `class_id` [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `lm_classification` [ RunTime:0.000381s ]
SELECT * FROM `lm_classification` WHERE `id` = 316 AND `id` = 316 [ RunTime:0.000131s ]
SELECT * FROM `lm_classification` WHERE `id` = 316 AND `id` = 316 [ RunTime:0.000116s ]
SHOW FULL COLUMNS FROM `lm_config` [ RunTime:0.000379s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_logo' LIMIT 1 [ RunTime:0.000121s ]
SELECT `shop_name` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000120s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000093s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000088s ]
SELECT `confirm` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000095s ]
SELECT `shop_img` FROM `lm_shop` WHERE `id` = 109 LIMIT 1 [ RunTime:0.000088s ]
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.000108s ]
SHOW FULL COLUMNS FROM `lm_link` [ RunTime:0.000356s ]
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.000115s ]
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.000092s ]
SELECT `value` FROM `lm_config` WHERE `code` = 'site_copyright' LIMIT 1 [ RunTime:0.000091s ]
鲁公网安备 37010302001115号
