SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001885s ]
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 '11130%' OR `brand` LIKE '11130%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016340s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526418 LIMIT 5 [ RunTime:0.024049s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526418 ORDER BY `minOrder` ASC [ RunTime:0.013848s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526418 ORDER BY `unit` DESC [ RunTime:0.036102s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526418 LIMIT 2 [ RunTime:0.015664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526418 ORDER BY `minOrder` ASC [ RunTime:0.014065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19029856 LIMIT 5 [ RunTime:0.030998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19029856 ORDER BY `minOrder` ASC [ RunTime:0.028098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19029856 ORDER BY `unit` DESC [ RunTime:0.009115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19029856 LIMIT 2 [ RunTime:0.024561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19029856 ORDER BY `minOrder` ASC [ RunTime:0.014052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001771 LIMIT 5 [ RunTime:0.063997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001771 ORDER BY `minOrder` ASC [ RunTime:0.081181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001771 ORDER BY `unit` DESC [ RunTime:0.034705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001771 LIMIT 2 [ RunTime:0.018613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001771 ORDER BY `minOrder` ASC [ RunTime:0.014600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001766 LIMIT 5 [ RunTime:0.032536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001766 ORDER BY `minOrder` ASC [ RunTime:0.025896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001766 ORDER BY `unit` DESC [ RunTime:0.033909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001766 LIMIT 2 [ RunTime:0.023133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001766 ORDER BY `minOrder` ASC [ RunTime:0.038784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001765 LIMIT 5 [ RunTime:0.044929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001765 ORDER BY `minOrder` ASC [ RunTime:0.041705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001765 ORDER BY `unit` DESC [ RunTime:0.037268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001765 LIMIT 2 [ RunTime:0.034947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001765 ORDER BY `minOrder` ASC [ RunTime:0.012791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001763 LIMIT 5 [ RunTime:0.012179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001763 ORDER BY `minOrder` ASC [ RunTime:0.004732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001763 ORDER BY `unit` DESC [ RunTime:0.025127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001763 LIMIT 2 [ RunTime:0.028646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001763 ORDER BY `minOrder` ASC [ RunTime:0.002567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001762 LIMIT 5 [ RunTime:0.004476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001762 ORDER BY `minOrder` ASC [ RunTime:0.026885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001762 ORDER BY `unit` DESC [ RunTime:0.005632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001762 LIMIT 2 [ RunTime:0.009333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001762 ORDER BY `minOrder` ASC [ RunTime:0.000935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001759 LIMIT 5 [ RunTime:0.015722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001759 ORDER BY `minOrder` ASC [ RunTime:0.014939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001759 ORDER BY `unit` DESC [ RunTime:0.011739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001759 LIMIT 2 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001759 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001755 LIMIT 5 [ RunTime:0.004021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001755 ORDER BY `minOrder` ASC [ RunTime:0.015543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001755 ORDER BY `unit` DESC [ RunTime:0.014213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001755 LIMIT 2 [ RunTime:0.019162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001755 ORDER BY `minOrder` ASC [ RunTime:0.006336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001754 LIMIT 5 [ RunTime:0.006713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001754 ORDER BY `minOrder` ASC [ RunTime:0.003675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001754 ORDER BY `unit` DESC [ RunTime:0.012564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001754 LIMIT 2 [ RunTime:0.020235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001754 ORDER BY `minOrder` ASC [ RunTime:0.011807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001749 LIMIT 5 [ RunTime:0.022454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001749 ORDER BY `minOrder` ASC [ RunTime:0.016534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001749 ORDER BY `unit` DESC [ RunTime:0.024535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001749 LIMIT 2 [ RunTime:0.037305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001749 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001742 LIMIT 5 [ RunTime:0.001275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001742 ORDER BY `minOrder` ASC [ RunTime:0.006602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001742 ORDER BY `unit` DESC [ RunTime:0.003113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001742 LIMIT 2 [ RunTime:0.005215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001742 ORDER BY `minOrder` ASC [ RunTime:0.004476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001741 LIMIT 5 [ RunTime:0.010087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001741 ORDER BY `minOrder` ASC [ RunTime:0.010573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001741 ORDER BY `unit` DESC [ RunTime:0.011796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001741 LIMIT 2 [ RunTime:0.013242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001741 ORDER BY `minOrder` ASC [ RunTime:0.010739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18988371 LIMIT 5 [ RunTime:0.005134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18988371 ORDER BY `minOrder` ASC [ RunTime:0.004119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18988371 ORDER BY `unit` DESC [ RunTime:0.000420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18988371 LIMIT 2 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18988371 ORDER BY `minOrder` ASC [ RunTime:0.004023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836178 LIMIT 5 [ RunTime:0.021911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836178 ORDER BY `minOrder` ASC [ RunTime:0.001132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836178 ORDER BY `unit` DESC [ RunTime:0.006315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836178 LIMIT 2 [ RunTime:0.005419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836178 ORDER BY `minOrder` ASC [ RunTime:0.015838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835481 LIMIT 5 [ RunTime:0.008713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835481 ORDER BY `minOrder` ASC [ RunTime:0.012705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835481 ORDER BY `unit` DESC [ RunTime:0.006425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835481 LIMIT 2 [ RunTime:0.012737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835481 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835261 LIMIT 5 [ RunTime:0.000890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835261 ORDER BY `minOrder` ASC [ RunTime:0.005358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835261 ORDER BY `unit` DESC [ RunTime:0.015142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835261 LIMIT 2 [ RunTime:0.010083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835261 ORDER BY `minOrder` ASC [ RunTime:0.015022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835260 LIMIT 5 [ RunTime:0.000776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835260 ORDER BY `minOrder` ASC [ RunTime:0.013055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835260 ORDER BY `unit` DESC [ RunTime:0.007642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835260 LIMIT 2 [ RunTime:0.012721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835260 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18834965 LIMIT 5 [ RunTime:0.006435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18834965 ORDER BY `minOrder` ASC [ RunTime:0.016775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18834965 ORDER BY `unit` DESC [ RunTime:0.008678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18834965 LIMIT 2 [ RunTime:0.028783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18834965 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18832111 LIMIT 5 [ RunTime:0.004745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832111 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18832111 ORDER BY `unit` DESC [ RunTime:0.000781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18832111 LIMIT 2 [ RunTime:0.009736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832111 ORDER BY `minOrder` ASC [ RunTime:0.009408s ]
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 '11130%' OR `brand` LIKE '11130%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009917s ]
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 '11130%' OR `brand` LIKE '11130%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64807700 LIMIT 5 [ RunTime:0.013915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807700 ORDER BY `minOrder` ASC [ RunTime:0.018004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64807700 ORDER BY `unit` DESC [ RunTime:0.009493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64807700 LIMIT 2 [ RunTime:0.007660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64807700 ORDER BY `minOrder` ASC [ RunTime:0.015019s ]
select * from pdf where partno='1113040' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010374s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113040' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007109s ]
SELECT `id` FROM `stock` WHERE `id` <> 64807700 AND `partno` = '1113040' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17010872 [ RunTime:0.012441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64806113 LIMIT 5 [ RunTime:0.004336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806113 ORDER BY `minOrder` ASC [ RunTime:0.006540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64806113 ORDER BY `unit` DESC [ RunTime:0.006440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64806113 LIMIT 2 [ RunTime:0.003401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64806113 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
select * from pdf where partno='1113097' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113097' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011931s ]
SELECT `id` FROM `stock` WHERE `id` <> 64806113 AND `partno` = '1113097' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774256 [ RunTime:0.002174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64800640 LIMIT 5 [ RunTime:0.002489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800640 ORDER BY `minOrder` ASC [ RunTime:0.013941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64800640 ORDER BY `unit` DESC [ RunTime:0.001347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64800640 LIMIT 2 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64800640 ORDER BY `minOrder` ASC [ RunTime:0.001703s ]
select * from pdf where partno='1113039' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113039' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006555s ]
SELECT `id` FROM `stock` WHERE `id` <> 64800640 AND `partno` = '1113039' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18770914 [ RunTime:0.006460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64460139 LIMIT 5 [ RunTime:0.009151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64460139 ORDER BY `minOrder` ASC [ RunTime:0.004446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64460139 ORDER BY `unit` DESC [ RunTime:0.000624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64460139 LIMIT 2 [ RunTime:0.002443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64460139 ORDER BY `minOrder` ASC [ RunTime:0.008962s ]
select * from pdf where partno='1113064' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113064' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003168s ]
SELECT `id` FROM `stock` WHERE `id` <> 64460139 AND `partno` = '1113064' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12197125 [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64459149 LIMIT 5 [ RunTime:0.014159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64459149 ORDER BY `minOrder` ASC [ RunTime:0.008880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64459149 ORDER BY `unit` DESC [ RunTime:0.007099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64459149 LIMIT 2 [ RunTime:0.002547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64459149 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='1113087' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001756s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113087' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000405s ]
SELECT `id` FROM `stock` WHERE `id` <> 64459149 AND `partno` = '1113087' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013788 [ RunTime:0.002425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64457104 LIMIT 5 [ RunTime:0.008163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64457104 ORDER BY `minOrder` ASC [ RunTime:0.005605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64457104 ORDER BY `unit` DESC [ RunTime:0.005862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64457104 LIMIT 2 [ RunTime:0.003584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64457104 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
select * from pdf where partno='1113027' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113027' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003867s ]
SELECT `id` FROM `stock` WHERE `id` <> 64457104 AND `partno` = '1113027' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021267 [ RunTime:0.000756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64456556 LIMIT 5 [ RunTime:0.003682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64456556 ORDER BY `minOrder` ASC [ RunTime:0.005884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64456556 ORDER BY `unit` DESC [ RunTime:0.002748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64456556 LIMIT 2 [ RunTime:0.001528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64456556 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='1113026' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113026' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000627s ]
SELECT `id` FROM `stock` WHERE `id` <> 64456556 AND `partno` = '1113026' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836178 [ RunTime:0.001689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64454486 LIMIT 5 [ RunTime:0.001693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64454486 ORDER BY `minOrder` ASC [ RunTime:0.005281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64454486 ORDER BY `unit` DESC [ RunTime:0.013842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64454486 LIMIT 2 [ RunTime:0.003527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64454486 ORDER BY `minOrder` ASC [ RunTime:0.002292s ]
select * from pdf where partno='1113086' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113086' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002449s ]
SELECT `id` FROM `stock` WHERE `id` <> 64454486 AND `partno` = '1113086' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835481 [ RunTime:0.001021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64454270 LIMIT 5 [ RunTime:0.007260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64454270 ORDER BY `minOrder` ASC [ RunTime:0.005736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64454270 ORDER BY `unit` DESC [ RunTime:0.001817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64454270 LIMIT 2 [ RunTime:0.003351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64454270 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='1113024' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113024' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006983s ]
SELECT `id` FROM `stock` WHERE `id` <> 64454270 AND `partno` = '1113024' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835261 [ RunTime:0.006592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64454269 LIMIT 5 [ RunTime:0.000739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64454269 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64454269 ORDER BY `unit` DESC [ RunTime:0.007430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64454269 LIMIT 2 [ RunTime:0.012458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64454269 ORDER BY `minOrder` ASC [ RunTime:0.006681s ]
select * from pdf where partno='1113085' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113085' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003350s ]
SELECT `id` FROM `stock` WHERE `id` <> 64454269 AND `partno` = '1113085' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835260 [ RunTime:0.002596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64454225 LIMIT 5 [ RunTime:0.004549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64454225 ORDER BY `minOrder` ASC [ RunTime:0.006119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64454225 ORDER BY `unit` DESC [ RunTime:0.013462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64454225 LIMIT 2 [ RunTime:0.000778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64454225 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='1113023' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113023' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011582s ]
SELECT `id` FROM `stock` WHERE `id` <> 64454225 AND `partno` = '1113023' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18834965 [ RunTime:0.015327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64454099 LIMIT 5 [ RunTime:0.007625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64454099 ORDER BY `minOrder` ASC [ RunTime:0.030579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64454099 ORDER BY `unit` DESC [ RunTime:0.010348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64454099 LIMIT 2 [ RunTime:0.011993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64454099 ORDER BY `minOrder` ASC [ RunTime:0.006859s ]
select * from pdf where partno='1113083' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1113083' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002549s ]
SELECT `id` FROM `stock` WHERE `id` <> 64454099 AND `partno` = '1113083' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16012547 [ RunTime:0.007271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64065227 LIMIT 5 [ RunTime:0.009099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64065227 ORDER BY `minOrder` ASC [ RunTime:0.006929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64065227 ORDER BY `unit` DESC [ RunTime:0.015527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64065227 LIMIT 2 [ RunTime:0.002449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64065227 ORDER BY `minOrder` ASC [ RunTime:0.009628s ]
select * from pdf where partno='111300120700' and brandshort='Murrplastik Systems, Inc.' limit 1 [ RunTime:0.004330s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '111300120700' OR `brand` LIKE 'Murrplastik Systems, Inc.%' ) ) LIMIT 1 [ RunTime:0.002847s ]
SELECT `id` FROM `stock` WHERE `id` <> 64065227 AND `partno` = '111300120700' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrplastik systems, inc.%' ) [ RunTime:0.014199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18832111 [ RunTime:0.004519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63479383 LIMIT 5 [ RunTime:0.013493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479383 ORDER BY `minOrder` ASC [ RunTime:0.036592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63479383 ORDER BY `unit` DESC [ RunTime:0.016437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63479383 LIMIT 2 [ RunTime:0.031561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479383 ORDER BY `minOrder` ASC [ RunTime:0.003185s ]
select * from pdf where partno='11130204' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.021612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11130204' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.019282s ]
SELECT `id` FROM `stock` WHERE `id` <> 63479383 AND `partno` = '11130204' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.017941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63479306 LIMIT 5 [ RunTime:0.008528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479306 ORDER BY `minOrder` ASC [ RunTime:0.005086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63479306 ORDER BY `unit` DESC [ RunTime:0.028879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63479306 LIMIT 2 [ RunTime:0.004808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479306 ORDER BY `minOrder` ASC [ RunTime:0.008808s ]
select * from pdf where partno='11130203' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.046660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11130203' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.007189s ]
SELECT `id` FROM `stock` WHERE `id` <> 63479306 AND `partno` = '11130203' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.012268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63479292 LIMIT 5 [ RunTime:0.014192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479292 ORDER BY `minOrder` ASC [ RunTime:0.030199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63479292 ORDER BY `unit` DESC [ RunTime:0.015605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63479292 LIMIT 2 [ RunTime:0.006025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479292 ORDER BY `minOrder` ASC [ RunTime:0.009278s ]
select * from pdf where partno='11130220' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.009203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11130220' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.010309s ]
SELECT `id` FROM `stock` WHERE `id` <> 63479292 AND `partno` = '11130220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.016080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63479291 LIMIT 5 [ RunTime:0.008506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479291 ORDER BY `minOrder` ASC [ RunTime:0.014364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63479291 ORDER BY `unit` DESC [ RunTime:0.010016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63479291 LIMIT 2 [ RunTime:0.015120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479291 ORDER BY `minOrder` ASC [ RunTime:0.009080s ]
select * from pdf where partno='11130202' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.008755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11130202' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.009937s ]
SELECT `id` FROM `stock` WHERE `id` <> 63479291 AND `partno` = '11130202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.010028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63479288 LIMIT 5 [ RunTime:0.012512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479288 ORDER BY `minOrder` ASC [ RunTime:0.016809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63479288 ORDER BY `unit` DESC [ RunTime:0.008377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63479288 LIMIT 2 [ RunTime:0.008593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479288 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
select * from pdf where partno='11130260' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.002591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11130260' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.003661s ]
SELECT `id` FROM `stock` WHERE `id` <> 63479288 AND `partno` = '11130260' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.002865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63479278 LIMIT 5 [ RunTime:0.000969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479278 ORDER BY `minOrder` ASC [ RunTime:0.003953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63479278 ORDER BY `unit` DESC [ RunTime:0.023015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63479278 LIMIT 2 [ RunTime:0.011810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479278 ORDER BY `minOrder` ASC [ RunTime:0.007075s ]
select * from pdf where partno='11130205' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.008307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11130205' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.009315s ]
SELECT `id` FROM `stock` WHERE `id` <> 63479278 AND `partno` = '11130205' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.007607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63479204 LIMIT 5 [ RunTime:0.006976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479204 ORDER BY `minOrder` ASC [ RunTime:0.013183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63479204 ORDER BY `unit` DESC [ RunTime:0.022974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63479204 LIMIT 2 [ RunTime:0.010815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63479204 ORDER BY `minOrder` ASC [ RunTime:0.002291s ]
select * from pdf where partno='11130290' and brandshort='Hoffman Enclosures, Inc.' limit 1 [ RunTime:0.000895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11130290' OR `brand` LIKE 'Hoffman Enclosures, Inc.%' ) ) LIMIT 1 [ RunTime:0.000693s ]
SELECT `id` FROM `stock` WHERE `id` <> 63479204 AND `partno` = '11130290' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hoffman enclosures, inc.%' ) [ RunTime:0.011545s ]
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 '11130%' OR `brand` LIKE '11130%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004833s ]
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 '11130%' OR `brand` LIKE '11130%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008536s ]
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 '11130%' OR `brand` LIKE '11130%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001015s ]
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 '11130%' OR `brand` LIKE '11130%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005977s ]
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 '11130%' OR `brand` LIKE '11130%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000903s ]
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 '11130%' OR `brand` LIKE '11130%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005859s ]
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 '11130%' OR `brand` LIKE '11130%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001049s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '11130%' OR `brand` LIKE '11130%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021966s ]