SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002582s ]
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 '60391%' OR `brand` LIKE '60391%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033492s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.021891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237766 LIMIT 5 [ RunTime:0.053076s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237766 ORDER BY `minOrder` ASC [ RunTime:0.014688s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12237766 ORDER BY `unit` DESC [ RunTime:0.046724s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12237766 LIMIT 2 [ RunTime:0.007035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237766 ORDER BY `minOrder` ASC [ RunTime:0.006354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200621 LIMIT 5 [ RunTime:0.030500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200621 ORDER BY `minOrder` ASC [ RunTime:0.008893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200621 ORDER BY `unit` DESC [ RunTime:0.030249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200621 LIMIT 2 [ RunTime:0.058569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200621 ORDER BY `minOrder` ASC [ RunTime:0.020684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784239 LIMIT 5 [ RunTime:0.075109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784239 ORDER BY `minOrder` ASC [ RunTime:0.016783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784239 ORDER BY `unit` DESC [ RunTime:0.038272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784239 LIMIT 2 [ RunTime:0.028033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784239 ORDER BY `minOrder` ASC [ RunTime:0.018213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19270449 LIMIT 5 [ RunTime:0.082509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270449 ORDER BY `minOrder` ASC [ RunTime:0.058179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19270449 ORDER BY `unit` DESC [ RunTime:0.056526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19270449 LIMIT 2 [ RunTime:0.030258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19270449 ORDER BY `minOrder` ASC [ RunTime:0.018745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18822198 LIMIT 5 [ RunTime:0.074129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822198 ORDER BY `minOrder` ASC [ RunTime:0.024876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18822198 ORDER BY `unit` DESC [ RunTime:0.023650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18822198 LIMIT 2 [ RunTime:0.028858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822198 ORDER BY `minOrder` ASC [ RunTime:0.004091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18822174 LIMIT 5 [ RunTime:0.019643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822174 ORDER BY `minOrder` ASC [ RunTime:0.019932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18822174 ORDER BY `unit` DESC [ RunTime:0.037465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18822174 LIMIT 2 [ RunTime:0.009980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822174 ORDER BY `minOrder` ASC [ RunTime:0.001678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18822113 LIMIT 5 [ RunTime:0.005466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822113 ORDER BY `minOrder` ASC [ RunTime:0.010569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18822113 ORDER BY `unit` DESC [ RunTime:0.006105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18822113 LIMIT 2 [ RunTime:0.011178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18822113 ORDER BY `minOrder` ASC [ RunTime:0.005507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18818330 LIMIT 5 [ RunTime:0.028771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18818330 ORDER BY `minOrder` ASC [ RunTime:0.017789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18818330 ORDER BY `unit` DESC [ RunTime:0.007670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18818330 LIMIT 2 [ RunTime:0.014153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18818330 ORDER BY `minOrder` ASC [ RunTime:0.006157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18817969 LIMIT 5 [ RunTime:0.009142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18817969 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18817969 ORDER BY `unit` DESC [ RunTime:0.009537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18817969 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18817969 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816377 LIMIT 5 [ RunTime:0.012273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816377 ORDER BY `minOrder` ASC [ RunTime:0.006770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18816377 ORDER BY `unit` DESC [ RunTime:0.020516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18816377 LIMIT 2 [ RunTime:0.020909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816377 ORDER BY `minOrder` ASC [ RunTime:0.006007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816233 LIMIT 5 [ RunTime:0.009507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816233 ORDER BY `minOrder` ASC [ RunTime:0.002421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18816233 ORDER BY `unit` DESC [ RunTime:0.000573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18816233 LIMIT 2 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816233 ORDER BY `minOrder` ASC [ RunTime:0.001460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18813760 LIMIT 5 [ RunTime:0.000882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18813760 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18813760 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18813760 LIMIT 2 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18813760 ORDER BY `minOrder` ASC [ RunTime:0.000662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18813753 LIMIT 5 [ RunTime:0.001539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18813753 ORDER BY `minOrder` ASC [ RunTime:0.000891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18813753 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18813753 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18813753 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780386 LIMIT 5 [ RunTime:0.000979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780386 ORDER BY `minOrder` ASC [ RunTime:0.002765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18780386 ORDER BY `unit` DESC [ RunTime:0.003744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18780386 LIMIT 2 [ RunTime:0.006987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18780386 ORDER BY `minOrder` ASC [ RunTime:0.006319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777343 LIMIT 5 [ RunTime:0.004309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777343 ORDER BY `minOrder` ASC [ RunTime:0.001714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777343 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777343 LIMIT 2 [ RunTime:0.002326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777343 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017647 LIMIT 5 [ RunTime:0.003591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017647 ORDER BY `minOrder` ASC [ RunTime:0.004503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17017647 ORDER BY `unit` DESC [ RunTime:0.001731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17017647 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017647 ORDER BY `minOrder` ASC [ RunTime:0.002331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17016996 LIMIT 5 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17016996 ORDER BY `minOrder` ASC [ RunTime:0.001317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17016996 ORDER BY `unit` DESC [ RunTime:0.006548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17016996 LIMIT 2 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17016996 ORDER BY `minOrder` ASC [ RunTime:0.000214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011576 LIMIT 5 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011576 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17011576 ORDER BY `unit` DESC [ RunTime:0.000269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17011576 LIMIT 2 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011576 ORDER BY `minOrder` ASC [ RunTime:0.000198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011575 LIMIT 5 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011575 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17011575 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17011575 LIMIT 2 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011575 ORDER BY `minOrder` ASC [ RunTime:0.005417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15362133 LIMIT 5 [ RunTime:0.008060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15362133 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15362133 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15362133 LIMIT 2 [ RunTime:0.000739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15362133 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
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 '60391%' OR `brand` LIKE '60391%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003624s ]
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 '60391%' OR `brand` LIKE '60391%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212610 LIMIT 5 [ RunTime:0.000862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212610 ORDER BY `minOrder` ASC [ RunTime:0.001027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212610 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212610 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212610 ORDER BY `minOrder` ASC [ RunTime:0.001229s ]
select * from pdf where partno='6039156' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001530s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039156' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006761s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212610 AND `partno` = '6039156' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237766 [ RunTime:0.002111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212403 LIMIT 5 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212403 ORDER BY `minOrder` ASC [ RunTime:0.002113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212403 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212403 LIMIT 2 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212403 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='6039158' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039158' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001470s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212403 AND `partno` = '6039158' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335578 LIMIT 5 [ RunTime:0.001237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335578 ORDER BY `minOrder` ASC [ RunTime:0.000791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335578 ORDER BY `unit` DESC [ RunTime:0.000801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335578 LIMIT 2 [ RunTime:0.002207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335578 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='6039102' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039102' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003929s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335578 AND `partno` = '6039102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200621 [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63345649 LIMIT 5 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345649 ORDER BY `minOrder` ASC [ RunTime:0.001554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63345649 ORDER BY `unit` DESC [ RunTime:0.000322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63345649 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63345649 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
select * from pdf where partno='6039101' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039101' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000305s ]
SELECT `id` FROM `stock` WHERE `id` <> 63345649 AND `partno` = '6039101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784239 [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64716260 LIMIT 5 [ RunTime:0.013698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64716260 ORDER BY `minOrder` ASC [ RunTime:0.001143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64716260 ORDER BY `unit` DESC [ RunTime:0.000398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64716260 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64716260 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
select * from pdf where partno='6039114' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039114' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000606s ]
SELECT `id` FROM `stock` WHERE `id` <> 64716260 AND `partno` = '6039114' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18818330 [ RunTime:0.001861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64715645 LIMIT 5 [ RunTime:0.002109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64715645 ORDER BY `minOrder` ASC [ RunTime:0.002726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64715645 ORDER BY `unit` DESC [ RunTime:0.002913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64715645 LIMIT 2 [ RunTime:0.014084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64715645 ORDER BY `minOrder` ASC [ RunTime:0.003757s ]
select * from pdf where partno='6039135' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039135' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001736s ]
SELECT `id` FROM `stock` WHERE `id` <> 64715645 AND `partno` = '6039135' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18817969 [ RunTime:0.004610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64714948 LIMIT 5 [ RunTime:0.001379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64714948 ORDER BY `minOrder` ASC [ RunTime:0.000983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64714948 ORDER BY `unit` DESC [ RunTime:0.000664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64714948 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64714948 ORDER BY `minOrder` ASC [ RunTime:0.002405s ]
select * from pdf where partno='6039115' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039115' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000783s ]
SELECT `id` FROM `stock` WHERE `id` <> 64714948 AND `partno` = '6039115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017647 [ RunTime:0.008562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64714584 LIMIT 5 [ RunTime:0.002550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64714584 ORDER BY `minOrder` ASC [ RunTime:0.001020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64714584 ORDER BY `unit` DESC [ RunTime:0.007858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64714584 LIMIT 2 [ RunTime:0.002117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64714584 ORDER BY `minOrder` ASC [ RunTime:0.008684s ]
select * from pdf where partno='6039110' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039110' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003610s ]
SELECT `id` FROM `stock` WHERE `id` <> 64714584 AND `partno` = '6039110' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232090 [ RunTime:0.011459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64714314 LIMIT 5 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64714314 ORDER BY `minOrder` ASC [ RunTime:0.003138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64714314 ORDER BY `unit` DESC [ RunTime:0.012243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64714314 LIMIT 2 [ RunTime:0.001555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64714314 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='6039123' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039123' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004551s ]
SELECT `id` FROM `stock` WHERE `id` <> 64714314 AND `partno` = '6039123' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232064 [ RunTime:0.002583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64712422 LIMIT 5 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64712422 ORDER BY `minOrder` ASC [ RunTime:0.000950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64712422 ORDER BY `unit` DESC [ RunTime:0.004693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64712422 LIMIT 2 [ RunTime:0.002096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64712422 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
select * from pdf where partno='6039175' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039175' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001023s ]
SELECT `id` FROM `stock` WHERE `id` <> 64712422 AND `partno` = '6039175' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816377 [ RunTime:0.002838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64712090 LIMIT 5 [ RunTime:0.001247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64712090 ORDER BY `minOrder` ASC [ RunTime:0.010737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64712090 ORDER BY `unit` DESC [ RunTime:0.001023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64712090 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64712090 ORDER BY `minOrder` ASC [ RunTime:0.005558s ]
select * from pdf where partno='6039138' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039138' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005674s ]
SELECT `id` FROM `stock` WHERE `id` <> 64712090 AND `partno` = '6039138' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816233 [ RunTime:0.000717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64709258 LIMIT 5 [ RunTime:0.014866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64709258 ORDER BY `minOrder` ASC [ RunTime:0.009761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64709258 ORDER BY `unit` DESC [ RunTime:0.003460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64709258 LIMIT 2 [ RunTime:0.009304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64709258 ORDER BY `minOrder` ASC [ RunTime:0.002238s ]
select * from pdf where partno='6039105' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039105' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005528s ]
SELECT `id` FROM `stock` WHERE `id` <> 64709258 AND `partno` = '6039105' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231594 [ RunTime:0.000999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64708359 LIMIT 5 [ RunTime:0.002036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708359 ORDER BY `minOrder` ASC [ RunTime:0.002159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64708359 ORDER BY `unit` DESC [ RunTime:0.001351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64708359 LIMIT 2 [ RunTime:0.004687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708359 ORDER BY `minOrder` ASC [ RunTime:0.000267s ]
select * from pdf where partno='6039106' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039106' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001932s ]
SELECT `id` FROM `stock` WHERE `id` <> 64708359 AND `partno` = '6039106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231429 [ RunTime:0.007101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64708228 LIMIT 5 [ RunTime:0.001794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708228 ORDER BY `minOrder` ASC [ RunTime:0.005234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64708228 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64708228 LIMIT 2 [ RunTime:0.007893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64708228 ORDER BY `minOrder` ASC [ RunTime:0.004196s ]
select * from pdf where partno='6039173' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039173' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012927s ]
SELECT `id` FROM `stock` WHERE `id` <> 64708228 AND `partno` = '6039173' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17016996 [ RunTime:0.003842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64707550 LIMIT 5 [ RunTime:0.003393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64707550 ORDER BY `minOrder` ASC [ RunTime:0.015978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64707550 ORDER BY `unit` DESC [ RunTime:0.001878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64707550 LIMIT 2 [ RunTime:0.014136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64707550 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='6039111' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039111' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017427s ]
SELECT `id` FROM `stock` WHERE `id` <> 64707550 AND `partno` = '6039111' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231283 [ RunTime:0.003237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64707539 LIMIT 5 [ RunTime:0.016940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64707539 ORDER BY `minOrder` ASC [ RunTime:0.014960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64707539 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64707539 LIMIT 2 [ RunTime:0.000473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64707539 ORDER BY `minOrder` ASC [ RunTime:0.007056s ]
select * from pdf where partno='6039109' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.024815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039109' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028066s ]
SELECT `id` FROM `stock` WHERE `id` <> 64707539 AND `partno` = '6039109' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18813760 [ RunTime:0.022928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64707532 LIMIT 5 [ RunTime:0.008253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64707532 ORDER BY `minOrder` ASC [ RunTime:0.010444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64707532 ORDER BY `unit` DESC [ RunTime:0.004382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64707532 LIMIT 2 [ RunTime:0.029793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64707532 ORDER BY `minOrder` ASC [ RunTime:0.007798s ]
select * from pdf where partno='6039190' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039190' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021883s ]
SELECT `id` FROM `stock` WHERE `id` <> 64707532 AND `partno` = '6039190' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.031817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18813753 [ RunTime:0.004781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64640281 LIMIT 5 [ RunTime:0.004239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64640281 ORDER BY `minOrder` ASC [ RunTime:0.014578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64640281 ORDER BY `unit` DESC [ RunTime:0.004577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64640281 LIMIT 2 [ RunTime:0.027969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64640281 ORDER BY `minOrder` ASC [ RunTime:0.028991s ]
select * from pdf where partno='6039157' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039157' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005817s ]
SELECT `id` FROM `stock` WHERE `id` <> 64640281 AND `partno` = '6039157' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777343 [ RunTime:0.011575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64522792 LIMIT 5 [ RunTime:0.022342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64522792 ORDER BY `minOrder` ASC [ RunTime:0.021270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64522792 ORDER BY `unit` DESC [ RunTime:0.009042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64522792 LIMIT 2 [ RunTime:0.008685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64522792 ORDER BY `minOrder` ASC [ RunTime:0.014777s ]
select * from pdf where partno='60391' and brandshort='Brady Corporation' limit 1 [ RunTime:0.014670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60391' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002803s ]
SELECT `id` FROM `stock` WHERE `id` <> 64522792 AND `partno` = '60391' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553071 [ RunTime:0.003158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63346135 LIMIT 5 [ RunTime:0.025258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346135 ORDER BY `minOrder` ASC [ RunTime:0.026617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63346135 ORDER BY `unit` DESC [ RunTime:0.044837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63346135 LIMIT 2 [ RunTime:0.023472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63346135 ORDER BY `minOrder` ASC [ RunTime:0.003045s ]
select * from pdf where partno='6039100' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6039100' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021230s ]
SELECT `id` FROM `stock` WHERE `id` <> 63346135 AND `partno` = '6039100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18780386 [ RunTime:0.013577s ]
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 '60391%' OR `brand` LIKE '60391%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005350s ]
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 '60391%' OR `brand` LIKE '60391%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030078s ]
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 '60391%' OR `brand` LIKE '60391%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026455s ]
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 '60391%' OR `brand` LIKE '60391%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016226s ]
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 '60391%' OR `brand` LIKE '60391%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015753s ]
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 '60391%' OR `brand` LIKE '60391%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014378s ]
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 '60391%' OR `brand` LIKE '60391%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016722s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60391%' OR `brand` LIKE '60391%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008814s ]