SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003199s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069603s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066864 LIMIT 5 [ RunTime:0.065820s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066864 ORDER BY `minOrder` ASC [ RunTime:0.106022s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.017027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066864 ORDER BY `unit` DESC [ RunTime:0.091904s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066864 LIMIT 2 [ RunTime:0.059404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066864 ORDER BY `minOrder` ASC [ RunTime:0.042558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237843 LIMIT 5 [ RunTime:0.081181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237843 ORDER BY `minOrder` ASC [ RunTime:0.136115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12237843 ORDER BY `unit` DESC [ RunTime:0.110929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12237843 LIMIT 2 [ RunTime:0.093998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237843 ORDER BY `minOrder` ASC [ RunTime:0.019320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266179 LIMIT 5 [ RunTime:0.077817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266179 ORDER BY `minOrder` ASC [ RunTime:0.171053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15266179 ORDER BY `unit` DESC [ RunTime:0.255141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15266179 LIMIT 2 [ RunTime:0.108953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266179 ORDER BY `minOrder` ASC [ RunTime:0.031606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982232 LIMIT 5 [ RunTime:0.124841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982232 ORDER BY `minOrder` ASC [ RunTime:0.246281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982232 ORDER BY `unit` DESC [ RunTime:0.082746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982232 LIMIT 2 [ RunTime:0.135047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982232 ORDER BY `minOrder` ASC [ RunTime:0.003026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982018 LIMIT 5 [ RunTime:0.112997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982018 ORDER BY `minOrder` ASC [ RunTime:0.178053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982018 ORDER BY `unit` DESC [ RunTime:0.037532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982018 LIMIT 2 [ RunTime:0.078824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982018 ORDER BY `minOrder` ASC [ RunTime:0.019452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974662 LIMIT 5 [ RunTime:0.066418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974662 ORDER BY `minOrder` ASC [ RunTime:0.051869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974662 ORDER BY `unit` DESC [ RunTime:0.102249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974662 LIMIT 2 [ RunTime:0.187598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974662 ORDER BY `minOrder` ASC [ RunTime:0.078788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793778 LIMIT 5 [ RunTime:0.063555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793778 ORDER BY `minOrder` ASC [ RunTime:0.197070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18793778 ORDER BY `unit` DESC [ RunTime:0.135822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18793778 LIMIT 2 [ RunTime:0.019659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793778 ORDER BY `minOrder` ASC [ RunTime:0.063010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775574 LIMIT 5 [ RunTime:0.053019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775574 ORDER BY `minOrder` ASC [ RunTime:0.065678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775574 ORDER BY `unit` DESC [ RunTime:0.040395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775574 LIMIT 2 [ RunTime:0.048579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775574 ORDER BY `minOrder` ASC [ RunTime:0.003873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775119 LIMIT 5 [ RunTime:0.014102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775119 ORDER BY `minOrder` ASC [ RunTime:0.004383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775119 ORDER BY `unit` DESC [ RunTime:0.038408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775119 LIMIT 2 [ RunTime:0.032838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775119 ORDER BY `minOrder` ASC [ RunTime:0.008798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772620 LIMIT 5 [ RunTime:0.034727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772620 ORDER BY `minOrder` ASC [ RunTime:0.055067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772620 ORDER BY `unit` DESC [ RunTime:0.034423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772620 LIMIT 2 [ RunTime:0.032387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772620 ORDER BY `minOrder` ASC [ RunTime:0.016486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049047 LIMIT 5 [ RunTime:0.005821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049047 ORDER BY `minOrder` ASC [ RunTime:0.029947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17049047 ORDER BY `unit` DESC [ RunTime:0.028806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17049047 LIMIT 2 [ RunTime:0.027778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049047 ORDER BY `minOrder` ASC [ RunTime:0.003604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266291 LIMIT 5 [ RunTime:0.031094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266291 ORDER BY `minOrder` ASC [ RunTime:0.036870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15266291 ORDER BY `unit` DESC [ RunTime:0.007407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15266291 LIMIT 2 [ RunTime:0.019463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266291 ORDER BY `minOrder` ASC [ RunTime:0.009113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15265073 LIMIT 5 [ RunTime:0.015747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15265073 ORDER BY `minOrder` ASC [ RunTime:0.007261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15265073 ORDER BY `unit` DESC [ RunTime:0.038652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15265073 LIMIT 2 [ RunTime:0.012734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15265073 ORDER BY `minOrder` ASC [ RunTime:0.011505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224005 LIMIT 5 [ RunTime:0.025398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224005 ORDER BY `minOrder` ASC [ RunTime:0.003060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224005 ORDER BY `unit` DESC [ RunTime:0.000971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224005 LIMIT 2 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224005 ORDER BY `minOrder` ASC [ RunTime:0.002077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223184 LIMIT 5 [ RunTime:0.016227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223184 ORDER BY `minOrder` ASC [ RunTime:0.029120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223184 ORDER BY `unit` DESC [ RunTime:0.011591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223184 LIMIT 2 [ RunTime:0.029182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223184 ORDER BY `minOrder` ASC [ RunTime:0.014843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223163 LIMIT 5 [ RunTime:0.017426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223163 ORDER BY `minOrder` ASC [ RunTime:0.005204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223163 ORDER BY `unit` DESC [ RunTime:0.004908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223163 LIMIT 2 [ RunTime:0.012640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223163 ORDER BY `minOrder` ASC [ RunTime:0.003148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223120 LIMIT 5 [ RunTime:0.009747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223120 ORDER BY `minOrder` ASC [ RunTime:0.015000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15223120 ORDER BY `unit` DESC [ RunTime:0.011445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15223120 LIMIT 2 [ RunTime:0.000895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15223120 ORDER BY `minOrder` ASC [ RunTime:0.003979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196959 LIMIT 5 [ RunTime:0.001338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14196959 ORDER BY `minOrder` ASC [ RunTime:0.016022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14196959 ORDER BY `unit` DESC [ RunTime:0.007173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14196959 LIMIT 2 [ RunTime:0.010612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14196959 ORDER BY `minOrder` ASC [ RunTime:0.002551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12521026 LIMIT 5 [ RunTime:0.004608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12521026 ORDER BY `minOrder` ASC [ RunTime:0.009438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12521026 ORDER BY `unit` DESC [ RunTime:0.012310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12521026 LIMIT 2 [ RunTime:0.011213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12521026 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047081 LIMIT 5 [ RunTime:0.005634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047081 ORDER BY `minOrder` ASC [ RunTime:0.000709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12047081 ORDER BY `unit` DESC [ RunTime:0.013469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12047081 LIMIT 2 [ RunTime:0.019368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047081 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001516s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57739570 LIMIT 5 [ RunTime:0.006306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739570 ORDER BY `minOrder` ASC [ RunTime:0.003192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57739570 ORDER BY `unit` DESC [ RunTime:0.003827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57739570 LIMIT 2 [ RunTime:0.013644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739570 ORDER BY `minOrder` ASC [ RunTime:0.002467s ]
select * from pdf where partno='10559CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.005885s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10559CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.017473s ]
SELECT `id` FROM `stock` WHERE `id` <> 57739570 AND `partno` = '10559CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.007437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066864 [ RunTime:0.001362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212654 LIMIT 5 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212654 ORDER BY `minOrder` ASC [ RunTime:0.005975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212654 ORDER BY `unit` DESC [ RunTime:0.000765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212654 LIMIT 2 [ RunTime:0.002868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212654 ORDER BY `minOrder` ASC [ RunTime:0.002780s ]
select * from pdf where partno='1055981' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055981' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002016s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212654 AND `partno` = '1055981' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237843 [ RunTime:0.011733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57983884 LIMIT 5 [ RunTime:0.000820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57983884 ORDER BY `minOrder` ASC [ RunTime:0.003876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57983884 ORDER BY `unit` DESC [ RunTime:0.009377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57983884 LIMIT 2 [ RunTime:0.009156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57983884 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
select * from pdf where partno='1055909' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055909' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010446s ]
SELECT `id` FROM `stock` WHERE `id` <> 57983884 AND `partno` = '1055909' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266179 [ RunTime:0.000493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63388695 LIMIT 5 [ RunTime:0.001532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63388695 ORDER BY `minOrder` ASC [ RunTime:0.005579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63388695 ORDER BY `unit` DESC [ RunTime:0.009012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63388695 LIMIT 2 [ RunTime:0.004931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63388695 ORDER BY `minOrder` ASC [ RunTime:0.001854s ]
select * from pdf where partno='10559A' and brandshort='Essentra Components' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10559A' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.008247s ]
SELECT `id` FROM `stock` WHERE `id` <> 63388695 AND `partno` = '10559A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.006382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047081 [ RunTime:0.007460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63381449 LIMIT 5 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381449 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63381449 ORDER BY `unit` DESC [ RunTime:0.004593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63381449 LIMIT 2 [ RunTime:0.002938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381449 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='10559F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10559F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.004693s ]
SELECT `id` FROM `stock` WHERE `id` <> 63381449 AND `partno` = '10559F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.006200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380728 LIMIT 5 [ RunTime:0.006982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380728 ORDER BY `minOrder` ASC [ RunTime:0.001740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380728 ORDER BY `unit` DESC [ RunTime:0.009558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380728 LIMIT 2 [ RunTime:0.006379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380728 ORDER BY `minOrder` ASC [ RunTime:0.004924s ]
select * from pdf where partno='10559' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10559' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.002961s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380728 AND `partno` = '10559' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.001714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63201036 LIMIT 5 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63201036 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63201036 ORDER BY `unit` DESC [ RunTime:0.000459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63201036 LIMIT 2 [ RunTime:0.002800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63201036 ORDER BY `minOrder` ASC [ RunTime:0.002614s ]
select * from pdf where partno='1055926' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055926' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001671s ]
SELECT `id` FROM `stock` WHERE `id` <> 63201036 AND `partno` = '1055926' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15265073 [ RunTime:0.002452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200757 LIMIT 5 [ RunTime:0.001078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200757 ORDER BY `minOrder` ASC [ RunTime:0.002746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200757 ORDER BY `unit` DESC [ RunTime:0.017147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200757 LIMIT 2 [ RunTime:0.015046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200757 ORDER BY `minOrder` ASC [ RunTime:0.014255s ]
select * from pdf where partno='1055920' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055920' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003991s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200757 AND `partno` = '1055920' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974662 [ RunTime:0.005155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198921 LIMIT 5 [ RunTime:0.002075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198921 ORDER BY `minOrder` ASC [ RunTime:0.006484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198921 ORDER BY `unit` DESC [ RunTime:0.005117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198921 LIMIT 2 [ RunTime:0.004366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198921 ORDER BY `minOrder` ASC [ RunTime:0.009946s ]
select * from pdf where partno='1055984' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055984' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002997s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198921 AND `partno` = '1055984' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982232 [ RunTime:0.007844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60629204 LIMIT 5 [ RunTime:0.022495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629204 ORDER BY `minOrder` ASC [ RunTime:0.015105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60629204 ORDER BY `unit` DESC [ RunTime:0.014185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60629204 LIMIT 2 [ RunTime:0.018544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60629204 ORDER BY `minOrder` ASC [ RunTime:0.014341s ]
select * from pdf where partno='1055960000' and brandshort='Weidmüller' limit 1 [ RunTime:0.039687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055960000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010898s ]
SELECT `id` FROM `stock` WHERE `id` <> 60629204 AND `partno` = '1055960000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.018428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57987867 LIMIT 5 [ RunTime:0.004377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57987867 ORDER BY `minOrder` ASC [ RunTime:0.008316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57987867 ORDER BY `unit` DESC [ RunTime:0.001937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57987867 LIMIT 2 [ RunTime:0.027887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57987867 ORDER BY `minOrder` ASC [ RunTime:0.017477s ]
select * from pdf where partno='1055965' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055965' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009453s ]
SELECT `id` FROM `stock` WHERE `id` <> 57987867 AND `partno` = '1055965' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775574 [ RunTime:0.014403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57987691 LIMIT 5 [ RunTime:0.014924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57987691 ORDER BY `minOrder` ASC [ RunTime:0.015978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57987691 ORDER BY `unit` DESC [ RunTime:0.033909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57987691 LIMIT 2 [ RunTime:0.013091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57987691 ORDER BY `minOrder` ASC [ RunTime:0.007826s ]
select * from pdf where partno='1055983' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.012762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055983' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021593s ]
SELECT `id` FROM `stock` WHERE `id` <> 57987691 AND `partno` = '1055983' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.075902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224005 [ RunTime:0.028480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57985841 LIMIT 5 [ RunTime:0.013661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985841 ORDER BY `minOrder` ASC [ RunTime:0.005311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57985841 ORDER BY `unit` DESC [ RunTime:0.003413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57985841 LIMIT 2 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985841 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='1055979' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055979' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032851s ]
SELECT `id` FROM `stock` WHERE `id` <> 57985841 AND `partno` = '1055979' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.048711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775119 [ RunTime:0.008082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57985507 LIMIT 5 [ RunTime:0.018777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985507 ORDER BY `minOrder` ASC [ RunTime:0.011413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57985507 ORDER BY `unit` DESC [ RunTime:0.019315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57985507 LIMIT 2 [ RunTime:0.032220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985507 ORDER BY `minOrder` ASC [ RunTime:0.025728s ]
select * from pdf where partno='1055908' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055908' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012546s ]
SELECT `id` FROM `stock` WHERE `id` <> 57985507 AND `partno` = '1055908' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982018 [ RunTime:0.020625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57984717 LIMIT 5 [ RunTime:0.021474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57984717 ORDER BY `minOrder` ASC [ RunTime:0.042714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57984717 ORDER BY `unit` DESC [ RunTime:0.002937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57984717 LIMIT 2 [ RunTime:0.009943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57984717 ORDER BY `minOrder` ASC [ RunTime:0.000768s ]
select * from pdf where partno='1055982' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055982' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006861s ]
SELECT `id` FROM `stock` WHERE `id` <> 57984717 AND `partno` = '1055982' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266291 [ RunTime:0.000643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57984645 LIMIT 5 [ RunTime:0.007118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57984645 ORDER BY `minOrder` ASC [ RunTime:0.011543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57984645 ORDER BY `unit` DESC [ RunTime:0.009503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57984645 LIMIT 2 [ RunTime:0.000807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57984645 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
select * from pdf where partno='1055972' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055972' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001648s ]
SELECT `id` FROM `stock` WHERE `id` <> 57984645 AND `partno` = '1055972' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049047 [ RunTime:0.010371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57984033 LIMIT 5 [ RunTime:0.008337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57984033 ORDER BY `minOrder` ASC [ RunTime:0.002992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57984033 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57984033 LIMIT 2 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57984033 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='1055953' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055953' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000527s ]
SELECT `id` FROM `stock` WHERE `id` <> 57984033 AND `partno` = '1055953' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223120 [ RunTime:0.008072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57982832 LIMIT 5 [ RunTime:0.006688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57982832 ORDER BY `minOrder` ASC [ RunTime:0.019472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57982832 ORDER BY `unit` DESC [ RunTime:0.008939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57982832 LIMIT 2 [ RunTime:0.037637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57982832 ORDER BY `minOrder` ASC [ RunTime:0.007816s ]
select * from pdf where partno='1055973' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055973' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011344s ]
SELECT `id` FROM `stock` WHERE `id` <> 57982832 AND `partno` = '1055973' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.024584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772620 [ RunTime:0.004995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57981225 LIMIT 5 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57981225 ORDER BY `minOrder` ASC [ RunTime:0.001820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57981225 ORDER BY `unit` DESC [ RunTime:0.014479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57981225 LIMIT 2 [ RunTime:0.029300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57981225 ORDER BY `minOrder` ASC [ RunTime:0.000645s ]
select * from pdf where partno='1055974' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055974' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005377s ]
SELECT `id` FROM `stock` WHERE `id` <> 57981225 AND `partno` = '1055974' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223184 [ RunTime:0.004573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57981090 LIMIT 5 [ RunTime:0.012348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57981090 ORDER BY `minOrder` ASC [ RunTime:0.013027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57981090 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57981090 LIMIT 2 [ RunTime:0.003255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57981090 ORDER BY `minOrder` ASC [ RunTime:0.015926s ]
select * from pdf where partno='1055905' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1055905' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007246s ]
SELECT `id` FROM `stock` WHERE `id` <> 57981090 AND `partno` = '1055905' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15223163 [ RunTime:0.015073s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015925s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019308s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005114s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014430s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008955s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015813s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016739s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10559%' OR `brand` LIKE '10559%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006961s ]