SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002379s ]
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 '10914%' OR `brand` LIKE '10914%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032936s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065617 LIMIT 5 [ RunTime:0.010923s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065617 ORDER BY `minOrder` ASC [ RunTime:0.019314s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065617 ORDER BY `unit` DESC [ RunTime:0.016640s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065617 LIMIT 2 [ RunTime:0.008291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065617 ORDER BY `minOrder` ASC [ RunTime:0.005962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512290 LIMIT 5 [ RunTime:0.008814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512290 ORDER BY `minOrder` ASC [ RunTime:0.040437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19512290 ORDER BY `unit` DESC [ RunTime:0.018431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19512290 LIMIT 2 [ RunTime:0.040530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19512290 ORDER BY `minOrder` ASC [ RunTime:0.019487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520709 LIMIT 5 [ RunTime:0.024710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520709 ORDER BY `minOrder` ASC [ RunTime:0.044440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12520709 ORDER BY `unit` DESC [ RunTime:0.046516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12520709 LIMIT 2 [ RunTime:0.004447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520709 ORDER BY `minOrder` ASC [ RunTime:0.017800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12199125 LIMIT 5 [ RunTime:0.007366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12199125 ORDER BY `minOrder` ASC [ RunTime:0.015087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12199125 ORDER BY `unit` DESC [ RunTime:0.000463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12199125 LIMIT 2 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12199125 ORDER BY `minOrder` ASC [ RunTime:0.002604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207945 LIMIT 5 [ RunTime:0.001877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207945 ORDER BY `minOrder` ASC [ RunTime:0.003949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11207945 ORDER BY `unit` DESC [ RunTime:0.006536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11207945 LIMIT 2 [ RunTime:0.011202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207945 ORDER BY `minOrder` ASC [ RunTime:0.003689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981154 LIMIT 5 [ RunTime:0.000893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981154 ORDER BY `minOrder` ASC [ RunTime:0.013667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981154 ORDER BY `unit` DESC [ RunTime:0.010551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981154 LIMIT 2 [ RunTime:0.002032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981154 ORDER BY `minOrder` ASC [ RunTime:0.001515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979666 LIMIT 5 [ RunTime:0.011489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979666 ORDER BY `minOrder` ASC [ RunTime:0.010621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18979666 ORDER BY `unit` DESC [ RunTime:0.004564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18979666 LIMIT 2 [ RunTime:0.003927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18979666 ORDER BY `minOrder` ASC [ RunTime:0.005493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797047 LIMIT 5 [ RunTime:0.011588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797047 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18797047 ORDER BY `unit` DESC [ RunTime:0.008770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18797047 LIMIT 2 [ RunTime:0.010645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18797047 ORDER BY `minOrder` ASC [ RunTime:0.006275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775573 LIMIT 5 [ RunTime:0.004085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775573 ORDER BY `minOrder` ASC [ RunTime:0.006705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18775573 ORDER BY `unit` DESC [ RunTime:0.016028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18775573 LIMIT 2 [ RunTime:0.004925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18775573 ORDER BY `minOrder` ASC [ RunTime:0.007258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774759 LIMIT 5 [ RunTime:0.004073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774759 ORDER BY `minOrder` ASC [ RunTime:0.004351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774759 ORDER BY `unit` DESC [ RunTime:0.020417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774759 LIMIT 2 [ RunTime:0.005535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774759 ORDER BY `minOrder` ASC [ RunTime:0.004858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774197 LIMIT 5 [ RunTime:0.010367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774197 ORDER BY `minOrder` ASC [ RunTime:0.005007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18774197 ORDER BY `unit` DESC [ RunTime:0.010531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18774197 LIMIT 2 [ RunTime:0.007398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18774197 ORDER BY `minOrder` ASC [ RunTime:0.003286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771880 LIMIT 5 [ RunTime:0.002126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771880 ORDER BY `minOrder` ASC [ RunTime:0.001445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18771880 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18771880 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771880 ORDER BY `minOrder` ASC [ RunTime:0.006988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049262 LIMIT 5 [ RunTime:0.011732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049262 ORDER BY `minOrder` ASC [ RunTime:0.006527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17049262 ORDER BY `unit` DESC [ RunTime:0.005392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17049262 LIMIT 2 [ RunTime:0.001648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049262 ORDER BY `minOrder` ASC [ RunTime:0.001942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16382000 LIMIT 5 [ RunTime:0.011381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16382000 ORDER BY `minOrder` ASC [ RunTime:0.009234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16382000 ORDER BY `unit` DESC [ RunTime:0.017821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16382000 LIMIT 2 [ RunTime:0.002300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16382000 ORDER BY `minOrder` ASC [ RunTime:0.005219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14256143 LIMIT 5 [ RunTime:0.007958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14256143 ORDER BY `minOrder` ASC [ RunTime:0.010899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14256143 ORDER BY `unit` DESC [ RunTime:0.005583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14256143 LIMIT 2 [ RunTime:0.005401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14256143 ORDER BY `minOrder` ASC [ RunTime:0.008942s ]
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 '10914%' OR `brand` LIKE '10914%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017393s ]
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 '10914%' OR `brand` LIKE '10914%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50743691 LIMIT 5 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50743691 ORDER BY `minOrder` ASC [ RunTime:0.000971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50743691 ORDER BY `unit` DESC [ RunTime:0.010564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50743691 LIMIT 2 [ RunTime:0.006821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50743691 ORDER BY `minOrder` ASC [ RunTime:0.009161s ]
select * from pdf where partno='10914CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.005696s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10914CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000936s ]
SELECT `id` FROM `stock` WHERE `id` <> 50743691 AND `partno` = '10914CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065617 [ RunTime:0.000608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147479 LIMIT 5 [ RunTime:0.006220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147479 ORDER BY `minOrder` ASC [ RunTime:0.005673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147479 ORDER BY `unit` DESC [ RunTime:0.000750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147479 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147479 ORDER BY `minOrder` ASC [ RunTime:0.000619s ]
select * from pdf where partno='10914CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10914CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000282s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147479 AND `partno` = '10914CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065617 [ RunTime:0.000236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57307957 LIMIT 5 [ RunTime:0.000237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57307957 ORDER BY `minOrder` ASC [ RunTime:0.001090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57307957 ORDER BY `unit` DESC [ RunTime:0.000277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57307957 LIMIT 2 [ RunTime:0.000237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57307957 ORDER BY `minOrder` ASC [ RunTime:0.000236s ]
select * from pdf where partno='1091420' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091420' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000238s ]
SELECT `id` FROM `stock` WHERE `id` <> 57307957 AND `partno` = '1091420' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207945 [ RunTime:0.000240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57307956 LIMIT 5 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57307956 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57307956 ORDER BY `unit` DESC [ RunTime:0.001389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57307956 LIMIT 2 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57307956 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='1091418' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091418' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000246s ]
SELECT `id` FROM `stock` WHERE `id` <> 57307956 AND `partno` = '1091418' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12199125 [ RunTime:0.000251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57210807 LIMIT 5 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57210807 ORDER BY `minOrder` ASC [ RunTime:0.001196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57210807 ORDER BY `unit` DESC [ RunTime:0.000796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57210807 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57210807 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='10914' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.000862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10914' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.002983s ]
SELECT `id` FROM `stock` WHERE `id` <> 57210807 AND `partno` = '10914' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19512290 [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56485817 LIMIT 5 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56485817 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56485817 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56485817 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56485817 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='1091423' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091423' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000349s ]
SELECT `id` FROM `stock` WHERE `id` <> 56485817 AND `partno` = '1091423' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520709 [ RunTime:0.002493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60369717 LIMIT 5 [ RunTime:0.002083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60369717 ORDER BY `minOrder` ASC [ RunTime:0.002430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60369717 ORDER BY `unit` DESC [ RunTime:0.000672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60369717 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60369717 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='1091431' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091431' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57987492 LIMIT 5 [ RunTime:0.001518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57987492 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57987492 ORDER BY `unit` DESC [ RunTime:0.001609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57987492 LIMIT 2 [ RunTime:0.004909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57987492 ORDER BY `minOrder` ASC [ RunTime:0.000938s ]
select * from pdf where partno='1091414' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091414' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000908s ]
SELECT `id` FROM `stock` WHERE `id` <> 57987492 AND `partno` = '1091414' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18775573 [ RunTime:0.000487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57986837 LIMIT 5 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986837 ORDER BY `minOrder` ASC [ RunTime:0.007647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57986837 ORDER BY `unit` DESC [ RunTime:0.001947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57986837 LIMIT 2 [ RunTime:0.004463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986837 ORDER BY `minOrder` ASC [ RunTime:0.001683s ]
select * from pdf where partno='1091416' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091416' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001337s ]
SELECT `id` FROM `stock` WHERE `id` <> 57986837 AND `partno` = '1091416' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774759 [ RunTime:0.001488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57985633 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985633 ORDER BY `minOrder` ASC [ RunTime:0.000919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57985633 ORDER BY `unit` DESC [ RunTime:0.000554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57985633 LIMIT 2 [ RunTime:0.005540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985633 ORDER BY `minOrder` ASC [ RunTime:0.006556s ]
select * from pdf where partno='1091447' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001105s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091447' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000893s ]
SELECT `id` FROM `stock` WHERE `id` <> 57985633 AND `partno` = '1091447' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18774197 [ RunTime:0.000811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57981296 LIMIT 5 [ RunTime:0.001762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57981296 ORDER BY `minOrder` ASC [ RunTime:0.001532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57981296 ORDER BY `unit` DESC [ RunTime:0.000588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57981296 LIMIT 2 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57981296 ORDER BY `minOrder` ASC [ RunTime:0.004006s ]
select * from pdf where partno='1091448' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091448' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004312s ]
SELECT `id` FROM `stock` WHERE `id` <> 57981296 AND `partno` = '1091448' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771880 [ RunTime:0.019012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57973269 LIMIT 5 [ RunTime:0.004010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57973269 ORDER BY `minOrder` ASC [ RunTime:0.012701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57973269 ORDER BY `unit` DESC [ RunTime:0.005426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57973269 LIMIT 2 [ RunTime:0.009197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57973269 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='1091456' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091456' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020161s ]
SELECT `id` FROM `stock` WHERE `id` <> 57973269 AND `partno` = '1091456' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18797047 [ RunTime:0.002528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56385596 LIMIT 5 [ RunTime:0.002873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56385596 ORDER BY `minOrder` ASC [ RunTime:0.010877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56385596 ORDER BY `unit` DESC [ RunTime:0.009722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56385596 LIMIT 2 [ RunTime:0.003212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56385596 ORDER BY `minOrder` ASC [ RunTime:0.001426s ]
select * from pdf where partno='1091498' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091498' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004700s ]
SELECT `id` FROM `stock` WHERE `id` <> 56385596 AND `partno` = '1091498' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049262 [ RunTime:0.001786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56384526 LIMIT 5 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56384526 ORDER BY `minOrder` ASC [ RunTime:0.001968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56384526 ORDER BY `unit` DESC [ RunTime:0.000267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56384526 LIMIT 2 [ RunTime:0.003050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56384526 ORDER BY `minOrder` ASC [ RunTime:0.005659s ]
select * from pdf where partno='1091424' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091424' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007511s ]
SELECT `id` FROM `stock` WHERE `id` <> 56384526 AND `partno` = '1091424' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981154 [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56383347 LIMIT 5 [ RunTime:0.002022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56383347 ORDER BY `minOrder` ASC [ RunTime:0.011886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56383347 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56383347 LIMIT 2 [ RunTime:0.002386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56383347 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='1091449' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091449' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002172s ]
SELECT `id` FROM `stock` WHERE `id` <> 56383347 AND `partno` = '1091449' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18979666 [ RunTime:0.003715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49514717 LIMIT 5 [ RunTime:0.002733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49514717 ORDER BY `minOrder` ASC [ RunTime:0.003083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49514717 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49514717 LIMIT 2 [ RunTime:0.006164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49514717 ORDER BY `minOrder` ASC [ RunTime:0.011880s ]
select * from pdf where partno='1091458' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091458' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001526s ]
SELECT `id` FROM `stock` WHERE `id` <> 49514717 AND `partno` = '1091458' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14256143 [ RunTime:0.000530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36708387 LIMIT 5 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36708387 ORDER BY `minOrder` ASC [ RunTime:0.001154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36708387 ORDER BY `unit` DESC [ RunTime:0.001401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36708387 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36708387 ORDER BY `minOrder` ASC [ RunTime:0.000169s ]
select * from pdf where partno='1091458' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1091458' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000197s ]
SELECT `id` FROM `stock` WHERE `id` <> 36708387 AND `partno` = '1091458' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14256143 [ RunTime:0.000221s ]
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 '10914%' OR `brand` LIKE '10914%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001989s ]
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 '10914%' OR `brand` LIKE '10914%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007311s ]
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 '10914%' OR `brand` LIKE '10914%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012590s ]
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 '10914%' OR `brand` LIKE '10914%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004447s ]
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 '10914%' OR `brand` LIKE '10914%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009350s ]
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 '10914%' OR `brand` LIKE '10914%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009399s ]
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 '10914%' OR `brand` LIKE '10914%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016136s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10914%' OR `brand` LIKE '10914%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021217s ]