SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002557s ]
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 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004307s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17176249 LIMIT 5 [ RunTime:0.003469s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17176249 ORDER BY `minOrder` ASC [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17176249 ORDER BY `unit` DESC [ RunTime:0.001349s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17176249 LIMIT 2 [ RunTime:0.003105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17176249 ORDER BY `minOrder` ASC [ RunTime:0.005065s ]
select * from pdf where partno='LP098F23IET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.004349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17176047 LIMIT 5 [ RunTime:0.004527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17176047 ORDER BY `minOrder` ASC [ RunTime:0.006804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17176047 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17176047 LIMIT 2 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17176047 ORDER BY `minOrder` ASC [ RunTime:0.000226s ]
select * from pdf where partno='LP098F35IDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17176046 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17176046 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17176046 ORDER BY `unit` DESC [ RunTime:0.011954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17176046 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17176046 ORDER BY `minOrder` ASC [ RunTime:0.001223s ]
select * from pdf where partno='LP098F33CDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.008009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17176045 LIMIT 5 [ RunTime:0.001022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17176045 ORDER BY `minOrder` ASC [ RunTime:0.004919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17176045 ORDER BY `unit` DESC [ RunTime:0.000299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17176045 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17176045 ORDER BY `minOrder` ASC [ RunTime:0.000203s ]
select * from pdf where partno='LP098F23CET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12290846 LIMIT 5 [ RunTime:0.002275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12290846 ORDER BY `minOrder` ASC [ RunTime:0.004499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12290846 ORDER BY `unit` DESC [ RunTime:0.002518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12290846 LIMIT 2 [ RunTime:0.001626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12290846 ORDER BY `minOrder` ASC [ RunTime:0.000183s ]
select * from pdf where partno='LP098F33IET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12290845 LIMIT 5 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12290845 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12290845 ORDER BY `unit` DESC [ RunTime:0.000302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12290845 LIMIT 2 [ RunTime:0.001730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12290845 ORDER BY `minOrder` ASC [ RunTime:0.000212s ]
select * from pdf where partno='LP098F33IDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.001058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12290844 LIMIT 5 [ RunTime:0.004520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12290844 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12290844 ORDER BY `unit` DESC [ RunTime:0.000187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12290844 LIMIT 2 [ RunTime:0.000259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12290844 ORDER BY `minOrder` ASC [ RunTime:0.001570s ]
select * from pdf where partno='LP098F23IDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12290643 LIMIT 5 [ RunTime:0.000920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12290643 ORDER BY `minOrder` ASC [ RunTime:0.000684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12290643 ORDER BY `unit` DESC [ RunTime:0.002292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12290643 LIMIT 2 [ RunTime:0.006238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12290643 ORDER BY `minOrder` ASC [ RunTime:0.001886s ]
select * from pdf where partno='LP098F35IET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11267477 LIMIT 5 [ RunTime:0.006077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11267477 ORDER BY `minOrder` ASC [ RunTime:0.001557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11267477 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11267477 LIMIT 2 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11267477 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
select * from pdf where partno='LP098F35CET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.003123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11267476 LIMIT 5 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11267476 ORDER BY `minOrder` ASC [ RunTime:0.000767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11267476 ORDER BY `unit` DESC [ RunTime:0.000642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11267476 LIMIT 2 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11267476 ORDER BY `minOrder` ASC [ RunTime:0.002706s ]
select * from pdf where partno='LP098F35CDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11267475 LIMIT 5 [ RunTime:0.001068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11267475 ORDER BY `minOrder` ASC [ RunTime:0.006664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11267475 ORDER BY `unit` DESC [ RunTime:0.002608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11267475 LIMIT 2 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11267475 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
select * from pdf where partno='LP098F33CET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11267474 LIMIT 5 [ RunTime:0.002651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11267474 ORDER BY `minOrder` ASC [ RunTime:0.001359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11267474 ORDER BY `unit` DESC [ RunTime:0.002520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11267474 LIMIT 2 [ RunTime:0.001168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11267474 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
select * from pdf where partno='LP098F23CDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000826s ]
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 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001069s ]
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 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58347341 LIMIT 5 [ RunTime:0.000559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58347341 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58347341 ORDER BY `unit` DESC [ RunTime:0.021410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58347341 LIMIT 2 [ RunTime:0.008905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58347341 ORDER BY `minOrder` ASC [ RunTime:0.005023s ]
select * from pdf where partno='LP09' and brandshort='Altech Corporation' limit 1 [ RunTime:0.012242s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP09' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.000941s ]
SELECT `id` FROM `stock` WHERE `id` <> 58347341 AND `partno` = 'LP09' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.015361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42849236 LIMIT 5 [ RunTime:0.009156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42849236 ORDER BY `minOrder` ASC [ RunTime:0.014517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42849236 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42849236 LIMIT 2 [ RunTime:0.008359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42849236 ORDER BY `minOrder` ASC [ RunTime:0.004398s ]
select * from pdf where partno='LP098F35IDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F35IDT' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.016071s ]
SELECT `id` FROM `stock` WHERE `id` <> 42849236 AND `partno` = 'LP098F35IDT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.000964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17176047 [ RunTime:0.002647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42811463 LIMIT 5 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42811463 ORDER BY `minOrder` ASC [ RunTime:0.016947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42811463 ORDER BY `unit` DESC [ RunTime:0.016287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42811463 LIMIT 2 [ RunTime:0.004205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42811463 ORDER BY `minOrder` ASC [ RunTime:0.001088s ]
select * from pdf where partno='LP098F35CET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.002961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F35CET' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.000893s ]
SELECT `id` FROM `stock` WHERE `id` <> 42811463 AND `partno` = 'LP098F35CET' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.005650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11267477 [ RunTime:0.005203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42811462 LIMIT 5 [ RunTime:0.003676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42811462 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42811462 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42811462 LIMIT 2 [ RunTime:0.003332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42811462 ORDER BY `minOrder` ASC [ RunTime:0.006999s ]
select * from pdf where partno='LP098F33CET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F33CET' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.006663s ]
SELECT `id` FROM `stock` WHERE `id` <> 42811462 AND `partno` = 'LP098F33CET' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.002990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11267475 [ RunTime:0.005871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42666727 LIMIT 5 [ RunTime:0.006690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42666727 ORDER BY `minOrder` ASC [ RunTime:0.026155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42666727 ORDER BY `unit` DESC [ RunTime:0.003571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42666727 LIMIT 2 [ RunTime:0.001779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42666727 ORDER BY `minOrder` ASC [ RunTime:0.004476s ]
select * from pdf where partno='LP098F35CDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F35CDT' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.004694s ]
SELECT `id` FROM `stock` WHERE `id` <> 42666727 AND `partno` = 'LP098F35CDT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.008111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11267476 [ RunTime:0.031531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42666726 LIMIT 5 [ RunTime:0.012661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42666726 ORDER BY `minOrder` ASC [ RunTime:0.009653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42666726 ORDER BY `unit` DESC [ RunTime:0.022714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42666726 LIMIT 2 [ RunTime:0.016116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42666726 ORDER BY `minOrder` ASC [ RunTime:0.006359s ]
select * from pdf where partno='LP098F33CDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F33CDT' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.001548s ]
SELECT `id` FROM `stock` WHERE `id` <> 42666726 AND `partno` = 'LP098F33CDT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.008339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17176046 [ RunTime:0.000757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42650427 LIMIT 5 [ RunTime:0.006523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42650427 ORDER BY `minOrder` ASC [ RunTime:0.014470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42650427 ORDER BY `unit` DESC [ RunTime:0.000826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42650427 LIMIT 2 [ RunTime:0.001470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42650427 ORDER BY `minOrder` ASC [ RunTime:0.010534s ]
select * from pdf where partno='LP098F33IDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F33IDT' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.004567s ]
SELECT `id` FROM `stock` WHERE `id` <> 42650427 AND `partno` = 'LP098F33IDT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.002910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12290845 [ RunTime:0.001972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42650426 LIMIT 5 [ RunTime:0.004604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42650426 ORDER BY `minOrder` ASC [ RunTime:0.008941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42650426 ORDER BY `unit` DESC [ RunTime:0.002299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42650426 LIMIT 2 [ RunTime:0.003017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42650426 ORDER BY `minOrder` ASC [ RunTime:0.005797s ]
select * from pdf where partno='LP098F23IET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F23IET' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.011439s ]
SELECT `id` FROM `stock` WHERE `id` <> 42650426 AND `partno` = 'LP098F23IET' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.001623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17176249 [ RunTime:0.003422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42650294 LIMIT 5 [ RunTime:0.003688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42650294 ORDER BY `minOrder` ASC [ RunTime:0.007077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42650294 ORDER BY `unit` DESC [ RunTime:0.017013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42650294 LIMIT 2 [ RunTime:0.003649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42650294 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='LP098F35IET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F35IET' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.000922s ]
SELECT `id` FROM `stock` WHERE `id` <> 42650294 AND `partno` = 'LP098F35IET' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.002111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12290643 [ RunTime:0.011150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42650293 LIMIT 5 [ RunTime:0.016671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42650293 ORDER BY `minOrder` ASC [ RunTime:0.006193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42650293 ORDER BY `unit` DESC [ RunTime:0.003740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42650293 LIMIT 2 [ RunTime:0.013226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42650293 ORDER BY `minOrder` ASC [ RunTime:0.022212s ]
select * from pdf where partno='LP098F23CDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F23CDT' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.004881s ]
SELECT `id` FROM `stock` WHERE `id` <> 42650293 AND `partno` = 'LP098F23CDT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.005813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11267474 [ RunTime:0.013055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42631667 LIMIT 5 [ RunTime:0.007921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42631667 ORDER BY `minOrder` ASC [ RunTime:0.004180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42631667 ORDER BY `unit` DESC [ RunTime:0.000812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42631667 LIMIT 2 [ RunTime:0.002013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42631667 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
select * from pdf where partno='LP098F23IDT' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.005591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F23IDT' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.007591s ]
SELECT `id` FROM `stock` WHERE `id` <> 42631667 AND `partno` = 'LP098F23IDT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.001125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12290844 [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42625660 LIMIT 5 [ RunTime:0.004443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42625660 ORDER BY `minOrder` ASC [ RunTime:0.015197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42625660 ORDER BY `unit` DESC [ RunTime:0.001480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42625660 LIMIT 2 [ RunTime:0.002835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42625660 ORDER BY `minOrder` ASC [ RunTime:0.001654s ]
select * from pdf where partno='LP098F33IET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.002993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F33IET' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.008548s ]
SELECT `id` FROM `stock` WHERE `id` <> 42625660 AND `partno` = 'LP098F33IET' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.001938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12290846 [ RunTime:0.009334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42620401 LIMIT 5 [ RunTime:0.003050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42620401 ORDER BY `minOrder` ASC [ RunTime:0.010574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42620401 ORDER BY `unit` DESC [ RunTime:0.008841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42620401 LIMIT 2 [ RunTime:0.006340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42620401 ORDER BY `minOrder` ASC [ RunTime:0.000602s ]
select * from pdf where partno='LP098F23CET' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.000608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LP098F23CET' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.001819s ]
SELECT `id` FROM `stock` WHERE `id` <> 42620401 AND `partno` = 'LP098F23CET' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.001525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17176045 [ RunTime:0.001766s ]
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 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001480s ]
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 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003588s ]
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 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003777s ]
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 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001859s ]
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 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002219s ]
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 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007075s ]
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 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011491s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'LP09%' OR `brand` LIKE 'LP09%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001369s ]