SHOW FULL COLUMNS FROM `ds_articleclass` [ RunTime:0.000993s ]
SELECT * FROM `ds_articleclass` WHERE `ac_id` <= 7 ORDER BY `ac_sort` ASC [ RunTime:0.000744s ]
SHOW FULL COLUMNS FROM `ds_article` [ RunTime:0.003387s ]
SELECT `article`.`article_id`,`article`.`ac_id`,`article`.`article_url`,`article`.`article_title`,`article`.`article_time`,`article_class`.`ac_name`,`article_class`.`ac_parent_id` FROM `ds_article` `article` LEFT JOIN `ds_articleclass` `article_class` ON `article`.`ac_id`=`article_class`.`ac_id` WHERE ( article.article_show = '1' and (article_class.ac_id <= 7 or (article_class.ac_parent_id > 0 and article_class.ac_parent_id <= 7)) ) ORDER BY `article_sort` ASC,`article_time` DESC LIMIT 300 [ RunTime:0.001192s ]
SHOW FULL COLUMNS FROM `ds_cart` [ RunTime:0.000890s ]
SELECT * FROM `ds_cart` WHERE `buyer_id` IS NULL [ RunTime:0.002716s ]
SHOW FULL COLUMNS FROM `ds_adv` [ RunTime:0.000903s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 21 AND `adv_enabled` = 1 AND `adv_startdate` < 1653249600 AND `adv_enddate` > 1653249600 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.002824s ]
SHOW FULL COLUMNS FROM `ds_v_goodsclass_forselect` [ RunTime:0.001071s ]
SELECT * FROM `ds_v_goodsclass_forselect` WHERE ( gc_idthree =687 ) LIMIT 1 [ RunTime:0.003012s ]
SHOW FULL COLUMNS FROM `ds_v_storelist` [ RunTime:0.003986s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `ds_v_storelist` `v` WHERE `v`.`gc_id_3` = 687 GROUP BY `v`.`store_id` ) `_group_count_` [ RunTime:0.245530s ]
SELECT distinct v.store_id FROM `ds_v_storelist` `v` WHERE `v`.`gc_id_3` = 687 GROUP BY `v`.`store_id` LIMIT 0,10 [ RunTime:0.244741s ]
SELECT
`goods`.`goods_id` AS `goods_id`,
`goods`.`store_id` AS `store_id`,
`goods`.`goods_name` AS `goods_name`,
`goods`.`goods_image` AS `goods_image`,
`goods`.`goods_price` AS `goods_price`,
`goods`.`goods_salenum` AS `goods_salenum`,
`company`.`shopname` AS `shopname`,
(CASE
WHEN ( `gtag`.`gtag_name` = '推荐' ) THEN
1 ELSE 0
END
) AS `recommend`
FROM
(
`ds_goods` `goods`
LEFT JOIN (
SELECT
`sns`.`goods_id` AS `goods_id`,
`sns`.`gtag_id` AS `gtag_id`,
tag.gtag_name
FROM
(
`ds_snsgtaggoods` `sns`
LEFT JOIN `ds_snsgoodstag` `tag` ON ((
`tag`.`gtag_id` = `sns`.`gtag_id`
)))
WHERE
((
`tag`.`isplatform` = '1'
)) ) gtag
ON goods.goods_id = gtag.goods_id
LEFT JOIN `ds_company_introduction` `company` ON ((
`goods`.`store_id` = `company`.`store_id`
)))
WHERE
(( `goods`.`state` <> '2' )
AND ( `goods`.`goods_state` = '1' )
AND ( `goods`.`goods_verify` = '1' )
AND goods.store_id = 77584)
ORDER BY
recommend DESC,
`goods`.`on_shelf_time` DESC,
`goods`.`goods_sort` DESC
LIMIT 0 [ RunTime:0.000929s ]
SELECT
`goods`.`goods_id` AS `goods_id`,
`goods`.`store_id` AS `store_id`,
`goods`.`goods_name` AS `goods_name`,
`goods`.`goods_image` AS `goods_image`,
`goods`.`goods_price` AS `goods_price`,
`goods`.`goods_salenum` AS `goods_salenum`,
`company`.`shopname` AS `shopname`,
(CASE
WHEN ( `gtag`.`gtag_name` = '推荐' ) THEN
1 ELSE 0
END
) AS `recommend`
FROM
(
`ds_goods` `goods`
LEFT JOIN (
SELECT
`sns`.`goods_id` AS `goods_id`,
`sns`.`gtag_id` AS `gtag_id`,
tag.gtag_name
FROM
(
`ds_snsgtaggoods` `sns`
LEFT JOIN `ds_snsgoodstag` `tag` ON ((
`tag`.`gtag_id` = `sns`.`gtag_id`
)))
WHERE
((
`tag`.`isplatform` = '1'
)) ) gtag
ON goods.goods_id = gtag.goods_id
LEFT JOIN `ds_company_introduction` `company` ON ((
`goods`.`store_id` = `company`.`store_id`
)))
WHERE
(( `goods`.`state` <> '2' )
AND ( `goods`.`goods_state` = '1' )
AND ( `goods`.`goods_verify` = '1' )
AND goods.store_id = 109656)
ORDER BY
recommend DESC,
`goods`.`on_shelf_time` DESC,
`goods`.`goods_sort` DESC
LIMIT 0 [ RunTime:0.000940s ]
SELECT
`goods`.`goods_id` AS `goods_id`,
`goods`.`store_id` AS `store_id`,
`goods`.`goods_name` AS `goods_name`,
`goods`.`goods_image` AS `goods_image`,
`goods`.`goods_price` AS `goods_price`,
`goods`.`goods_salenum` AS `goods_salenum`,
`company`.`shopname` AS `shopname`,
(CASE
WHEN ( `gtag`.`gtag_name` = '推荐' ) THEN
1 ELSE 0
END
) AS `recommend`
FROM
(
`ds_goods` `goods`
LEFT JOIN (
SELECT
`sns`.`goods_id` AS `goods_id`,
`sns`.`gtag_id` AS `gtag_id`,
tag.gtag_name
FROM
(
`ds_snsgtaggoods` `sns`
LEFT JOIN `ds_snsgoodstag` `tag` ON ((
`tag`.`gtag_id` = `sns`.`gtag_id`
)))
WHERE
((
`tag`.`isplatform` = '1'
)) ) gtag
ON goods.goods_id = gtag.goods_id
LEFT JOIN `ds_company_introduction` `company` ON ((
`goods`.`store_id` = `company`.`store_id`
)))
WHERE
(( `goods`.`state` <> '2' )
AND ( `goods`.`goods_state` = '1' )
AND ( `goods`.`goods_verify` = '1' )
AND goods.store_id = 109853)
ORDER BY
recommend DESC,
`goods`.`on_shelf_time` DESC,
`goods`.`goods_sort` DESC
LIMIT 0 [ RunTime:0.000912s ]
SELECT
`goods`.`goods_id` AS `goods_id`,
`goods`.`store_id` AS `store_id`,
`goods`.`goods_name` AS `goods_name`,
`goods`.`goods_image` AS `goods_image`,
`goods`.`goods_price` AS `goods_price`,
`goods`.`goods_salenum` AS `goods_salenum`,
`company`.`shopname` AS `shopname`,
(CASE
WHEN ( `gtag`.`gtag_name` = '推荐' ) THEN
1 ELSE 0
END
) AS `recommend`
FROM
(
`ds_goods` `goods`
LEFT JOIN (
SELECT
`sns`.`goods_id` AS `goods_id`,
`sns`.`gtag_id` AS `gtag_id`,
tag.gtag_name
FROM
(
`ds_snsgtaggoods` `sns`
LEFT JOIN `ds_snsgoodstag` `tag` ON ((
`tag`.`gtag_id` = `sns`.`gtag_id`
)))
WHERE
((
`tag`.`isplatform` = '1'
)) ) gtag
ON goods.goods_id = gtag.goods_id
LEFT JOIN `ds_company_introduction` `company` ON ((
`goods`.`store_id` = `company`.`store_id`
)))
WHERE
(( `goods`.`state` <> '2' )
AND ( `goods`.`goods_state` = '1' )
AND ( `goods`.`goods_verify` = '1' )
AND goods.store_id = 109922)
ORDER BY
recommend DESC,
`goods`.`on_shelf_time` DESC,
`goods`.`goods_sort` DESC
LIMIT 0 [ RunTime:0.003222s ]
SHOW FULL COLUMNS FROM `ds_company_introduction` [ RunTime:0.003394s ]
SELECT company.ty_name,company.store_id,company.shopname,mastertype.name companytype,
GROUP_CONCAT(class.gc_name SEPARATOR " ") ptype, company.year, masterusd.name yearmoney,
company.introduce,company.company_address,company.company_address_detail,
company.num,company.register_no,company.legal_person,
date_format( from_unixtime( company.year ), "%Y-%m-%d" ) AS year,
company.registration_authority,company.registration_status,
company.business_scope,store.grade_id,company.tel,
area.area_name,area1.area_name as area_name1,area2.area_name as area_name2,company.company_province_id,sj.auth_verify FROM `ds_company_introduction` `company` LEFT JOIN `ds_store` `store` ON `store`.`store_id`=`company`.`store_id` LEFT JOIN `ds_goodsclass` `class` ON FIND_IN_SET( class.gc_id, company.ptype ) LEFT JOIN `ds_master` `masterusd` ON `masterusd`.`status`=0 and masterusd.id=company.yearmoney and masterusd.type = "zczj" LEFT JOIN `ds_master` `mastertype` ON `mastertype`.`status`=0 and mastertype.id=company.companytype and mastertype.type = "QYLX" LEFT JOIN `ds_area` `area` ON `area`.`area_id`=`company`.`company_province_id` LEFT JOIN `ds_area` `area1` ON `area1`.`area_id`=`company`.`company_city_id` LEFT JOIN `ds_area` `area2` ON `area2`.`area_id`=`company`.`company_area_id` LEFT JOIN `ds_storejoinin` `sj` ON `company`.`userid`=`sj`.`member_id` WHERE `company`.`store_id` IN (77473,77584,109627,109629,109635,109656,109660,109853,109880,109922) GROUP BY `company`.`store_id` [ RunTime:0.007962s ]
SHOW FULL COLUMNS FROM `ds_goods` [ RunTime:0.003045s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=77473 ) [ RunTime:0.000641s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=77584 ) [ RunTime:0.000957s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109627 ) [ RunTime:0.000611s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109629 ) [ RunTime:0.000899s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109635 ) [ RunTime:0.000671s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109656 ) [ RunTime:0.002402s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109660 ) [ RunTime:0.002343s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109853 ) [ RunTime:0.000614s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109880 ) [ RunTime:0.000723s ]
SELECT COUNT(*) AS think_count FROM `ds_goods` WHERE ( store_id=109922 ) [ RunTime:0.002399s ]