IBC - 轴承行业的京东 - 贝果轴链正品包邮

^ array:9 ["base" => array:4 [ 0 => array:3 [ 0 => "g.is_delete_time" 1 => "=" 2 => 0 ] 1 => array:3 [ 0 => "g.is_shelves" 1 => "=" 2 => 1 ] 2 => array:3 [ 0 => "g.inventory" 1 => ">" 2 => 0 ] 3 => array:3 [ 0 => "g.brand_id" 1 => "in" 2 => array:1 [ 0 => 16 ] ] ] "keywords" => [] "keywords_substr" => [] "fankeywords" => [] "keywords_fansubstr" => [] "goods_params" => [] "screening_price" => [] "order_by" => "goodslen asc,g.min_price asc,b.sort asc,g.access_count desc, g.sales_count desc, g.id desc" "is_map" => 1]

^ "SELECT g.id,g.shop_category_id,g.brand_id,g.title,g.simple_desc,g.model_base,g.inventory,g.images,g.original_price,g.max_original_price,g.min_original_price,g.price,g.min_price,g.max_price,g.buy_max_number,g.buy_min_number,g.photo_count,g.sales_count,g.access_count,g.is_exist_many_spec,g.model,g.model_base,length(g.model) as goodslen FROM `brg_brand` `b` INNER JOIN `brg_goods` `g` ON `g`.`brand_id`=`b`.`id` WHERE `g`.`id` IN ('983430','983488','983491','983553','1116889','1132829','1621223','1621224','1621231','1621260','1623886','1623935','1624027','1624028','1624099','1624100','1624101','1624102','1624103','1624104','1624105','1624106','1624107','1624108','1624109','1624110','1624168','1624169','1624170','1624186','1624187','1624188','1624189','1624190','1624191','1624192','1624193','1624194','1624195','1624196','1624197','1624198','1624237','1624238','1624244','1624245','1624246','1624377','1624378','1624379','1624380','1624381','1624382','1624383','1624384','1624385','1624386','1624387','1624388','1624389','1624390','1624391','1624392','1624393','1624394','1624395','1624396','1624479','1624480','1624481','1624482','1624483','1624489','1624602','1624603','1624604','1624686','1624689','1624833','1624899','1624900','1624901','1625891','1625892','1627229','1627746','1630309','1630310','1630315','1630316','1630317','1630319','1630351','1630401','1630421','1633443','1633444','1633477','1635094','1635097','1635099','1635137','1635139','1635146','1635148','1641732','1641772','1641773','1646625','1646650','1646651','1646662','1646663','1646666','1646867','1647548','1647549','1647554','1647633','1647634','1647635','1647636','1647637','1647638','1652238','1653053','1653236','1654281','1654291','1654307','1654315','1654318','1654324','1654335','1654337','1654342','1654360','1654369','1654408','1654411','1654413','1654422','1654429','1654718','1654719','1654724','1654725','1654726','1654727','1655996','1656028','1656029','1656030','1656031','1656032','1656033','1656034','1656080','1656082','1656872','1657075','1657076','1657077','1657078','1657751','1657757','1657774','1657791','1658099','1659837','1659838','1659840','1659912','1660243','1660251','1660253','1660258','1660272','1660286','1660915','1660919','1660920','1660924','1661007','1662361','1662364','1662468','1662725','1662740','1662741','1662762','1662763','1662764','1662765','1662934','1662936','1662938','1662939','1662940','1662951','1663433','1663435','1663439','1663460','1663551','1663582','1663587','1667935','1669736','1669737','1669738','1669739','1669740','1672903','1672910','1672930','1674647','1674737','1674784','1674795','1674805','1674968','1674980','1674981','1674987','1675020','1675049','1675052','1675056','1675112','1675113','1675139','1675143','1675178','1675187','1675202','1675222','1675296','1675372','1675458','1675464','1675468','1675500','1675570','1675614','1677126','1677279','1677297','1677298','1677299','1677301','1677302','1677303','1677304','1677305','1677308','1677310','1677314','1677315','1677316','1683734','1683735','1696275','1696292','1696294','1696295','1696296','1696298','1697185','1697196','1697206','1697227','1697243','1697580','1697596','1697614','1697634','1697651','1697661','1697672','1697683','1697701','1697718','1697735','1697752','1697777','1697788','1697802','1697823','1697851','1697859','1697867','1697875','1697887','1697907','1697952','1697961','1697964','1697967','1697972','1697979','1697984','1697988','1697997','1698004','1698095','1698109','1698118','1698129','1698146','1698459','1698534','1698589','1698823','1699028','1699129','1707049','1707277','1707299','1707300','1707301','1708137','1719392','1719394','1719397','1721942','1723893','1723995','1724224','1736057','1736058','1736059','1736060','1736087','1736101','1736102','1756916','1758581','1765088','1769774','1769806','1781154','1781180','1781201','1781301','1781329','1781358','1781359','1781374','1781457','1781469','1781482','1781507','1781508','1784583','1788323','1788346','1788358','1788384','1788385','1788402','1788414','1788435','1788449','1788509','1788528','1788592','1788646','1793031','1793043','1793060','1793066','1793079','1793097','1793231','1793339','1793362','1793383','1793417','1794580','1794602','1795536','1795538','1798886','1799318','1799905','1800773','1800786','1800802','1800830','1800860','1800870','1800882','1800920','1800976','1800999','1801021','1801039','1801076','1801892','1803229','1809188','1813476','1813495','1813521','1813530','1813536','1813546','1813553','1813563','1813574','1813590','1813608','1813610','1813633','1813666','1813696','1813720','1813903','1813972','1813999','1814018','1814026','1814071','1814094','1814111','1814128','1814416','1814435','1814544','1819178','1819188','1819203','1819217','1819235','1819247','1819263','1819280','1819294','1819968','1819988','1820005','1823488','1823489','1823514','1823536','1823569','1823577','1823587','1823597','1823604','1823614','1823622','1823663','1823729','1823819','1824034','1824048','1824058','1824123','1824135','1824143','1825913','1826270','1831567','1831582','1831592','1831823','1831836','1831851','1831863','1831880','1831896','1831904','1831910','1831921','1831931','1836963','1843463','1845702','1846117','1847304','1848769') ORDER BY `goodslen` ASC,`g`.`min_price` ASC,`b`.`sort` ASC,`g`.`access_count` DESC,`g`.`sales_count` DESC,`g`.`id` DESC LIMIT 0,18"

^ "SELECT DISTINCT(gct.name),gct.id FROM `brg_goods` `g` INNER JOIN `brg_goods_category` `gct` ON `g`.`shop_category_id`=`gct`.`id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND `g`.`brand_id` = '16' AND `g`.`id` IN ('983430','983488','983491','983553','1116889','1132829','1621223','1621224','1621231','1621260','1623886','1623935','1624027','1624028','1624099','1624100','1624101','1624102','1624103','1624104','1624105','1624106','1624107','1624108','1624109','1624110','1624168','1624169','1624170','1624186','1624187','1624188','1624189','1624190','1624191','1624192','1624193','1624194','1624195','1624196','1624197','1624198','1624237','1624238','1624244','1624245','1624246','1624377','1624378','1624379','1624380','1624381','1624382','1624383','1624384','1624385','1624386','1624387','1624388','1624389','1624390','1624391','1624392','1624393','1624394','1624395','1624396','1624479','1624480','1624481','1624482','1624483','1624489','1624602','1624603','1624604','1624686','1624689','1624833','1624899','1624900','1624901','1625891','1625892','1627229','1627746','1630309','1630310','1630315','1630316','1630317','1630319','1630351','1630401','1630421','1633443','1633444','1633477','1635094','1635097','1635099','1635137','1635139','1635146','1635148','1641732','1641772','1641773','1646625','1646650','1646651','1646662','1646663','1646666','1646867','1647548','1647549','1647554','1647633','1647634','1647635','1647636','1647637','1647638','1652238','1653053','1653236','1654281','1654291','1654307','1654315','1654318','1654324','1654335','1654337','1654342','1654360','1654369','1654408','1654411','1654413','1654422','1654429','1654718','1654719','1654724','1654725','1654726','1654727','1655996','1656028','1656029','1656030','1656031','1656032','1656033','1656034','1656080','1656082','1656872','1657075','1657076','1657077','1657078','1657751','1657757','1657774','1657791','1658099','1659837','1659838','1659840','1659912','1660243','1660251','1660253','1660258','1660272','1660286','1660915','1660919','1660920','1660924','1661007','1662361','1662364','1662468','1662725','1662740','1662741','1662762','1662763','1662764','1662765','1662934','1662936','1662938','1662939','1662940','1662951','1663433','1663435','1663439','1663460','1663551','1663582','1663587','1667935','1669736','1669737','1669738','1669739','1669740','1672903','1672910','1672930','1674647','1674737','1674784','1674795','1674805','1674968','1674980','1674981','1674987','1675020','1675049','1675052','1675056','1675112','1675113','1675139','1675143','1675178','1675187','1675202','1675222','1675296','1675372','1675458','1675464','1675468','1675500','1675570','1675614','1677126','1677279','1677297','1677298','1677299','1677301','1677302','1677303','1677304','1677305','1677308','1677310','1677314','1677315','1677316','1683734','1683735','1696275','1696292','1696294','1696295','1696296','1696298','1697185','1697196','1697206','1697227','1697243','1697580','1697596','1697614','1697634','1697651','1697661','1697672','1697683','1697701','1697718','1697735','1697752','1697777','1697788','1697802','1697823','1697851','1697859','1697867','1697875','1697887','1697907','1697952','1697961','1697964','1697967','1697972','1697979','1697984','1697988','1697997','1698004','1698095','1698109','1698118','1698129','1698146','1698459','1698534','1698589','1698823','1699028','1699129','1707049','1707277','1707299','1707300','1707301','1708137','1719392','1719394','1719397','1721942','1723893','1723995','1724224','1736057','1736058','1736059','1736060','1736087','1736101','1736102','1756916','1758581','1765088','1769774','1769806','1781154','1781180','1781201','1781301','1781329','1781358','1781359','1781374','1781457','1781469','1781482','1781507','1781508','1784583','1788323','1788346','1788358','1788384','1788385','1788402','1788414','1788435','1788449','1788509','1788528','1788592','1788646','1793031','1793043','1793060','1793066','1793079','1793097','1793231','1793339','1793362','1793383','1793417','1794580','1794602','1795536','1795538','1798886','1799318','1799905','1800773','1800786','1800802','1800830','1800860','1800870','1800882','1800920','1800976','1800999','1801021','1801039','1801076','1801892','1803229','1809188','1813476','1813495','1813521','1813530','1813536','1813546','1813553','1813563','1813574','1813590','1813608','1813610','1813633','1813666','1813696','1813720','1813903','1813972','1813999','1814018','1814026','1814071','1814094','1814111','1814128','1814416','1814435','1814544','1819178','1819188','1819203','1819217','1819235','1819247','1819263','1819280','1819294','1819968','1819988','1820005','1823488','1823489','1823514','1823536','1823569','1823577','1823587','1823597','1823604','1823614','1823622','1823663','1823729','1823819','1824034','1824048','1824058','1824123','1824135','1824143','1825913','1826270','1831567','1831582','1831592','1831823','1831836','1831851','1831863','1831880','1831896','1831904','1831910','1831921','1831931','1836963','1843463','1845702','1846117','1847304','1848769') ORDER BY gct.id asc"

^ "SELECT DISTINCT(gptc.name),gptc.value,Length(gptc.name) as namelen FROM `brg_goods` `g` INNER JOIN `brg_goods_params_template_config` `gptc` ON `g`.`brand_id`=`gptc`.`brand_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND `g`.`brand_id` = '16' AND `g`.`id` IN ('983430','983488','983491','983553','1116889','1132829','1621223','1621224','1621231','1621260','1623886','1623935','1624027','1624028','1624099','1624100','1624101','1624102','1624103','1624104','1624105','1624106','1624107','1624108','1624109','1624110','1624168','1624169','1624170','1624186','1624187','1624188','1624189','1624190','1624191','1624192','1624193','1624194','1624195','1624196','1624197','1624198','1624237','1624238','1624244','1624245','1624246','1624377','1624378','1624379','1624380','1624381','1624382','1624383','1624384','1624385','1624386','1624387','1624388','1624389','1624390','1624391','1624392','1624393','1624394','1624395','1624396','1624479','1624480','1624481','1624482','1624483','1624489','1624602','1624603','1624604','1624686','1624689','1624833','1624899','1624900','1624901','1625891','1625892','1627229','1627746','1630309','1630310','1630315','1630316','1630317','1630319','1630351','1630401','1630421','1633443','1633444','1633477','1635094','1635097','1635099','1635137','1635139','1635146','1635148','1641732','1641772','1641773','1646625','1646650','1646651','1646662','1646663','1646666','1646867','1647548','1647549','1647554','1647633','1647634','1647635','1647636','1647637','1647638','1652238','1653053','1653236','1654281','1654291','1654307','1654315','1654318','1654324','1654335','1654337','1654342','1654360','1654369','1654408','1654411','1654413','1654422','1654429','1654718','1654719','1654724','1654725','1654726','1654727','1655996','1656028','1656029','1656030','1656031','1656032','1656033','1656034','1656080','1656082','1656872','1657075','1657076','1657077','1657078','1657751','1657757','1657774','1657791','1658099','1659837','1659838','1659840','1659912','1660243','1660251','1660253','1660258','1660272','1660286','1660915','1660919','1660920','1660924','1661007','1662361','1662364','1662468','1662725','1662740','1662741','1662762','1662763','1662764','1662765','1662934','1662936','1662938','1662939','1662940','1662951','1663433','1663435','1663439','1663460','1663551','1663582','1663587','1667935','1669736','1669737','1669738','1669739','1669740','1672903','1672910','1672930','1674647','1674737','1674784','1674795','1674805','1674968','1674980','1674981','1674987','1675020','1675049','1675052','1675056','1675112','1675113','1675139','1675143','1675178','1675187','1675202','1675222','1675296','1675372','1675458','1675464','1675468','1675500','1675570','1675614','1677126','1677279','1677297','1677298','1677299','1677301','1677302','1677303','1677304','1677305','1677308','1677310','1677314','1677315','1677316','1683734','1683735','1696275','1696292','1696294','1696295','1696296','1696298','1697185','1697196','1697206','1697227','1697243','1697580','1697596','1697614','1697634','1697651','1697661','1697672','1697683','1697701','1697718','1697735','1697752','1697777','1697788','1697802','1697823','1697851','1697859','1697867','1697875','1697887','1697907','1697952','1697961','1697964','1697967','1697972','1697979','1697984','1697988','1697997','1698004','1698095','1698109','1698118','1698129','1698146','1698459','1698534','1698589','1698823','1699028','1699129','1707049','1707277','1707299','1707300','1707301','1708137','1719392','1719394','1719397','1721942','1723893','1723995','1724224','1736057','1736058','1736059','1736060','1736087','1736101','1736102','1756916','1758581','1765088','1769774','1769806','1781154','1781180','1781201','1781301','1781329','1781358','1781359','1781374','1781457','1781469','1781482','1781507','1781508','1784583','1788323','1788346','1788358','1788384','1788385','1788402','1788414','1788435','1788449','1788509','1788528','1788592','1788646','1793031','1793043','1793060','1793066','1793079','1793097','1793231','1793339','1793362','1793383','1793417','1794580','1794602','1795536','1795538','1798886','1799318','1799905','1800773','1800786','1800802','1800830','1800860','1800870','1800882','1800920','1800976','1800999','1801021','1801039','1801076','1801892','1803229','1809188','1813476','1813495','1813521','1813530','1813536','1813546','1813553','1813563','1813574','1813590','1813608','1813610','1813633','1813666','1813696','1813720','1813903','1813972','1813999','1814018','1814026','1814071','1814094','1814111','1814128','1814416','1814435','1814544','1819178','1819188','1819203','1819217','1819235','1819247','1819263','1819280','1819294','1819968','1819988','1820005','1823488','1823489','1823514','1823536','1823569','1823577','1823587','1823597','1823604','1823614','1823622','1823663','1823729','1823819','1824034','1824048','1824058','1824123','1824135','1824143','1825913','1826270','1831567','1831582','1831592','1831823','1831836','1831851','1831863','1831880','1831896','1831904','1831910','1831921','1831931','1836963','1843463','1845702','1846117','1847304','1848769') AND ( g.suffix LIKE concat('%', gptc.NAME, '%') and Length(gptc.name)>1 ) ORDER BY namelen asc"

^ "SELECT gsb.region as value,count(gsb.region) as count FROM `brg_goods_region` `gr` INNER JOIN `brg_goods_spec_base` `gsb` ON `gr`.`name`=`gsb`.`region` INNER JOIN `brg_goods` `g` ON `g`.`id`=`gsb`.`goods_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `g`.`inventory` > '0' AND `g`.`brand_id` = '16' GROUP BY `gsb`.`region` ORDER BY `gr`.`sort` ASC"