SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002358s ]
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 '20328%' OR `brand` LIKE '20328%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005857s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207441 LIMIT 5 [ RunTime:0.000944s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207441 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11207441 ORDER BY `unit` DESC [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11207441 LIMIT 2 [ RunTime:0.002379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207441 ORDER BY `minOrder` ASC [ RunTime:0.003078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237760 LIMIT 5 [ RunTime:0.000820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237760 ORDER BY `minOrder` ASC [ RunTime:0.009534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12237760 ORDER BY `unit` DESC [ RunTime:0.004064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12237760 LIMIT 2 [ RunTime:0.003825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237760 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207557 LIMIT 5 [ RunTime:0.002980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207557 ORDER BY `minOrder` ASC [ RunTime:0.007510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11207557 ORDER BY `unit` DESC [ RunTime:0.001440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11207557 LIMIT 2 [ RunTime:0.001028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207557 ORDER BY `minOrder` ASC [ RunTime:0.011317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16500066 LIMIT 5 [ RunTime:0.001193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16500066 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16500066 ORDER BY `unit` DESC [ RunTime:0.012084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16500066 LIMIT 2 [ RunTime:0.007589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16500066 ORDER BY `minOrder` ASC [ RunTime:0.006419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14708159 LIMIT 5 [ RunTime:0.003308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14708159 ORDER BY `minOrder` ASC [ RunTime:0.006322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14708159 ORDER BY `unit` DESC [ RunTime:0.020468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14708159 LIMIT 2 [ RunTime:0.018801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14708159 ORDER BY `minOrder` ASC [ RunTime:0.004888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308107 LIMIT 5 [ RunTime:0.003173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308107 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13308107 ORDER BY `unit` DESC [ RunTime:0.000268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13308107 LIMIT 2 [ RunTime:0.005529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13308107 ORDER BY `minOrder` ASC [ RunTime:0.009542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13285410 LIMIT 5 [ RunTime:0.012945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13285410 ORDER BY `minOrder` ASC [ RunTime:0.008790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13285410 ORDER BY `unit` DESC [ RunTime:0.022326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13285410 LIMIT 2 [ RunTime:0.006898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13285410 ORDER BY `minOrder` ASC [ RunTime:0.001980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198931 LIMIT 5 [ RunTime:0.001102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198931 ORDER BY `minOrder` ASC [ RunTime:0.005029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12198931 ORDER BY `unit` DESC [ RunTime:0.004198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12198931 LIMIT 2 [ RunTime:0.002075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198931 ORDER BY `minOrder` ASC [ RunTime:0.002703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198891 LIMIT 5 [ RunTime:0.001442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198891 ORDER BY `minOrder` ASC [ RunTime:0.002240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12198891 ORDER BY `unit` DESC [ RunTime:0.010526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12198891 LIMIT 2 [ RunTime:0.007650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12198891 ORDER BY `minOrder` ASC [ RunTime:0.004830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207739 LIMIT 5 [ RunTime:0.002868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207739 ORDER BY `minOrder` ASC [ RunTime:0.012404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11207739 ORDER BY `unit` DESC [ RunTime:0.020663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11207739 LIMIT 2 [ RunTime:0.004206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207739 ORDER BY `minOrder` ASC [ RunTime:0.004879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207722 LIMIT 5 [ RunTime:0.024038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207722 ORDER BY `minOrder` ASC [ RunTime:0.002406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11207722 ORDER BY `unit` DESC [ RunTime:0.001488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11207722 LIMIT 2 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207722 ORDER BY `minOrder` ASC [ RunTime:0.002840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207718 LIMIT 5 [ RunTime:0.002382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207718 ORDER BY `minOrder` ASC [ RunTime:0.007529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11207718 ORDER BY `unit` DESC [ RunTime:0.007763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11207718 LIMIT 2 [ RunTime:0.014861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207718 ORDER BY `minOrder` ASC [ RunTime:0.003114s ]
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 '20328%' OR `brand` LIKE '20328%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004162s ]
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 '20328%' OR `brand` LIKE '20328%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64811912 LIMIT 5 [ RunTime:0.009200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811912 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64811912 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64811912 LIMIT 2 [ RunTime:0.001894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811912 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='2032807' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032807' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000463s ]
SELECT `id` FROM `stock` WHERE `id` <> 64811912 AND `partno` = '2032807' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207441 [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64812070 LIMIT 5 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812070 ORDER BY `minOrder` ASC [ RunTime:0.001074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64812070 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64812070 LIMIT 2 [ RunTime:0.003667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812070 ORDER BY `minOrder` ASC [ RunTime:0.001952s ]
select * from pdf where partno='2032856' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032856' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003242s ]
SELECT `id` FROM `stock` WHERE `id` <> 64812070 AND `partno` = '2032856' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207557 [ RunTime:0.003398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63214217 LIMIT 5 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63214217 ORDER BY `minOrder` ASC [ RunTime:0.004041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63214217 ORDER BY `unit` DESC [ RunTime:0.000703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63214217 LIMIT 2 [ RunTime:0.002259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63214217 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='2032837' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032837' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003079s ]
SELECT `id` FROM `stock` WHERE `id` <> 63214217 AND `partno` = '2032837' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237760 [ RunTime:0.000757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64812667 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812667 ORDER BY `minOrder` ASC [ RunTime:0.001852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64812667 ORDER BY `unit` DESC [ RunTime:0.008923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64812667 LIMIT 2 [ RunTime:0.006551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812667 ORDER BY `minOrder` ASC [ RunTime:0.005661s ]
select * from pdf where partno='2032860' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032860' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006171s ]
SELECT `id` FROM `stock` WHERE `id` <> 64812667 AND `partno` = '2032860' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198931 [ RunTime:0.010892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64812650 LIMIT 5 [ RunTime:0.002670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812650 ORDER BY `minOrder` ASC [ RunTime:0.006628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64812650 ORDER BY `unit` DESC [ RunTime:0.001403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64812650 LIMIT 2 [ RunTime:0.004696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812650 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
select * from pdf where partno='2032861' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032861' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004410s ]
SELECT `id` FROM `stock` WHERE `id` <> 64812650 AND `partno` = '2032861' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207739 [ RunTime:0.003352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64812614 LIMIT 5 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812614 ORDER BY `minOrder` ASC [ RunTime:0.002972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64812614 ORDER BY `unit` DESC [ RunTime:0.019712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64812614 LIMIT 2 [ RunTime:0.016656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812614 ORDER BY `minOrder` ASC [ RunTime:0.005535s ]
select * from pdf where partno='2032858' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.030097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032858' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014730s ]
SELECT `id` FROM `stock` WHERE `id` <> 64812614 AND `partno` = '2032858' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207722 [ RunTime:0.002731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64812595 LIMIT 5 [ RunTime:0.002143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812595 ORDER BY `minOrder` ASC [ RunTime:0.006340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64812595 ORDER BY `unit` DESC [ RunTime:0.016944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64812595 LIMIT 2 [ RunTime:0.019955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812595 ORDER BY `minOrder` ASC [ RunTime:0.001723s ]
select * from pdf where partno='2032857' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032857' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001899s ]
SELECT `id` FROM `stock` WHERE `id` <> 64812595 AND `partno` = '2032857' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207718 [ RunTime:0.024031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64812574 LIMIT 5 [ RunTime:0.002231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812574 ORDER BY `minOrder` ASC [ RunTime:0.011237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64812574 ORDER BY `unit` DESC [ RunTime:0.005494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64812574 LIMIT 2 [ RunTime:0.005228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64812574 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
select * from pdf where partno='2032859' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032859' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003108s ]
SELECT `id` FROM `stock` WHERE `id` <> 64812574 AND `partno` = '2032859' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198891 [ RunTime:0.000689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62447830 LIMIT 5 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62447830 ORDER BY `minOrder` ASC [ RunTime:0.002953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62447830 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62447830 LIMIT 2 [ RunTime:0.006481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62447830 ORDER BY `minOrder` ASC [ RunTime:0.007538s ]
select * from pdf where partno='2032808-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032808-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000424s ]
SELECT `id` FROM `stock` WHERE `id` <> 62447830 AND `partno` = '2032808-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13308107 [ RunTime:0.007551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62415699 LIMIT 5 [ RunTime:0.006196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62415699 ORDER BY `minOrder` ASC [ RunTime:0.013855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62415699 ORDER BY `unit` DESC [ RunTime:0.013198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62415699 LIMIT 2 [ RunTime:0.005785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62415699 ORDER BY `minOrder` ASC [ RunTime:0.004488s ]
select * from pdf where partno='2032821' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032821' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005816s ]
SELECT `id` FROM `stock` WHERE `id` <> 62415699 AND `partno` = '2032821' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16500066 [ RunTime:0.004335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62165212 LIMIT 5 [ RunTime:0.009337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62165212 ORDER BY `minOrder` ASC [ RunTime:0.009768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62165212 ORDER BY `unit` DESC [ RunTime:0.006581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62165212 LIMIT 2 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62165212 ORDER BY `minOrder` ASC [ RunTime:0.001810s ]
select * from pdf where partno='2032809-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2032809-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009925s ]
SELECT `id` FROM `stock` WHERE `id` <> 62165212 AND `partno` = '2032809-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13285410 [ RunTime:0.002739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58203038 LIMIT 5 [ RunTime:0.011731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58203038 ORDER BY `minOrder` ASC [ RunTime:0.010180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58203038 ORDER BY `unit` DESC [ RunTime:0.006021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58203038 LIMIT 2 [ RunTime:0.001358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58203038 ORDER BY `minOrder` ASC [ RunTime:0.002415s ]
select * from pdf where partno='20328' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.000389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20328' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.002160s ]
SELECT `id` FROM `stock` WHERE `id` <> 58203038 AND `partno` = '20328' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.003073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58203037 LIMIT 5 [ RunTime:0.006184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58203037 ORDER BY `minOrder` ASC [ RunTime:0.003798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58203037 ORDER BY `unit` DESC [ RunTime:0.006512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58203037 LIMIT 2 [ RunTime:0.007750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58203037 ORDER BY `minOrder` ASC [ RunTime:0.006788s ]
select * from pdf where partno='20328R' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.010202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20328R' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.002536s ]
SELECT `id` FROM `stock` WHERE `id` <> 58203037 AND `partno` = '20328R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mersen usa newburyport-ma l.l.c.%' ) [ RunTime:0.006307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14708159 [ RunTime:0.008549s ]
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 '20328%' OR `brand` LIKE '20328%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005465s ]
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 '20328%' OR `brand` LIKE '20328%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001554s ]
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 '20328%' OR `brand` LIKE '20328%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006848s ]
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 '20328%' OR `brand` LIKE '20328%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001976s ]
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 '20328%' OR `brand` LIKE '20328%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002796s ]
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 '20328%' OR `brand` LIKE '20328%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008031s ]
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 '20328%' OR `brand` LIKE '20328%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002237s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20328%' OR `brand` LIKE '20328%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000862s ]