SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002150s ]
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 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008031s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852862 LIMIT 5 [ RunTime:0.000811s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852862 ORDER BY `minOrder` ASC [ RunTime:0.000450s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19852862 ORDER BY `unit` DESC [ RunTime:0.000322s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19852862 LIMIT 2 [ RunTime:0.000313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852862 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
select * from pdf where partno='TMMH-110-01-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851690 LIMIT 5 [ RunTime:0.000893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851690 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851690 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851690 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851690 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='TMMH-110-01-L-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192049 LIMIT 5 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192049 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16192049 ORDER BY `unit` DESC [ RunTime:0.000314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16192049 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192049 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='TMMH-110-01-L-DV-ES' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19827848 LIMIT 5 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19827848 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19827848 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19827848 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19827848 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='TMMH-110-01-L-D-015' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19826769 LIMIT 5 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19826769 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19826769 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19826769 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19826769 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='TMMH-110-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810814 LIMIT 5 [ RunTime:0.000898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810814 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19810814 ORDER BY `unit` DESC [ RunTime:0.000389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19810814 LIMIT 2 [ RunTime:0.000386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810814 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19807821 LIMIT 5 [ RunTime:0.000941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19807821 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19807821 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19807821 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19807821 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19805575 LIMIT 5 [ RunTime:0.001473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19805575 ORDER BY `minOrder` ASC [ RunTime:0.000943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19805575 ORDER BY `unit` DESC [ RunTime:0.000786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19805575 LIMIT 2 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19805575 ORDER BY `minOrder` ASC [ RunTime:0.000833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19798282 LIMIT 5 [ RunTime:0.001360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19798282 ORDER BY `minOrder` ASC [ RunTime:0.000940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19798282 ORDER BY `unit` DESC [ RunTime:0.000778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19798282 LIMIT 2 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19798282 ORDER BY `minOrder` ASC [ RunTime:0.000815s ]
select * from pdf where partno='TMMH-110-01-L-DV-A-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19795415 LIMIT 5 [ RunTime:0.003888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19795415 ORDER BY `minOrder` ASC [ RunTime:0.000823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19795415 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19795415 LIMIT 2 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19795415 ORDER BY `minOrder` ASC [ RunTime:0.000814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786644 LIMIT 5 [ RunTime:0.001306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786644 ORDER BY `minOrder` ASC [ RunTime:0.000798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19786644 ORDER BY `unit` DESC [ RunTime:0.000748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19786644 LIMIT 2 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786644 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19751315 LIMIT 5 [ RunTime:0.001201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19751315 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19751315 ORDER BY `unit` DESC [ RunTime:0.000715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19751315 LIMIT 2 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19751315 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16216799 LIMIT 5 [ RunTime:0.001361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16216799 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16216799 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16216799 LIMIT 2 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16216799 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16216086 LIMIT 5 [ RunTime:0.001073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16216086 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16216086 ORDER BY `unit` DESC [ RunTime:0.000697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16216086 LIMIT 2 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16216086 ORDER BY `minOrder` ASC [ RunTime:0.000777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16214452 LIMIT 5 [ RunTime:0.001296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214452 ORDER BY `minOrder` ASC [ RunTime:0.000760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16214452 ORDER BY `unit` DESC [ RunTime:0.000698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16214452 LIMIT 2 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214452 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
select * from pdf where partno='TMMH-110-01-L-DV-M' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16203269 LIMIT 5 [ RunTime:0.001223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16203269 ORDER BY `minOrder` ASC [ RunTime:0.000923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16203269 ORDER BY `unit` DESC [ RunTime:0.000822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16203269 LIMIT 2 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16203269 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16186645 LIMIT 5 [ RunTime:0.001050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186645 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16186645 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16186645 LIMIT 2 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186645 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
select * from pdf where partno='TMMH-110-01-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15485198 LIMIT 5 [ RunTime:0.001202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15485198 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15485198 ORDER BY `unit` DESC [ RunTime:0.000569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15485198 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15485198 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12774243 LIMIT 5 [ RunTime:0.001062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12774243 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12774243 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12774243 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12774243 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
select * from pdf where partno='TMMH-110-01-L-DV-EL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12737942 LIMIT 5 [ RunTime:0.001088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12737942 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12737942 ORDER BY `unit` DESC [ RunTime:0.000571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12737942 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12737942 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
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 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001662s ]
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 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66300325 LIMIT 5 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66300325 ORDER BY `minOrder` ASC [ RunTime:0.000873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66300325 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66300325 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66300325 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='TMMH-110-01-L-DV-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000715s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000544s ]
SELECT `id` FROM `stock` WHERE `id` <> 66300325 AND `partno` = 'TMMH-110-01-L-DV-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66353317 LIMIT 5 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66353317 ORDER BY `minOrder` ASC [ RunTime:0.000980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66353317 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66353317 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66353317 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='TMMH-110-01-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000671s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000490s ]
SELECT `id` FROM `stock` WHERE `id` <> 66353317 AND `partno` = 'TMMH-110-01-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852862 [ RunTime:0.000543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66351327 LIMIT 5 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66351327 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66351327 ORDER BY `unit` DESC [ RunTime:0.000496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66351327 LIMIT 2 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66351327 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='TMMH-110-01-L-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-D-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000559s ]
SELECT `id` FROM `stock` WHERE `id` <> 66351327 AND `partno` = 'TMMH-110-01-L-D-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851690 [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66391008 LIMIT 5 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66391008 ORDER BY `minOrder` ASC [ RunTime:0.000885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66391008 ORDER BY `unit` DESC [ RunTime:0.000476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66391008 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66391008 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='TMMH-110-01-L-DV-ES' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-ES' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000819s ]
SELECT `id` FROM `stock` WHERE `id` <> 66391008 AND `partno` = 'TMMH-110-01-L-DV-ES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192049 [ RunTime:0.000812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66480017 LIMIT 5 [ RunTime:0.000763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66480017 ORDER BY `minOrder` ASC [ RunTime:0.000962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66480017 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66480017 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66480017 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
select * from pdf where partno='TMMH-110-01-L-D-RA-ES' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-D-RA-ES' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000633s ]
SELECT `id` FROM `stock` WHERE `id` <> 66480017 AND `partno` = 'TMMH-110-01-L-D-RA-ES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571272 [ RunTime:0.000940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66477871 LIMIT 5 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66477871 ORDER BY `minOrder` ASC [ RunTime:0.000870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66477871 ORDER BY `unit` DESC [ RunTime:0.000430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66477871 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66477871 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='TMMH-110-01-L-DV-ES-A-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-ES-A-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000546s ]
SELECT `id` FROM `stock` WHERE `id` <> 66477871 AND `partno` = 'TMMH-110-01-L-DV-ES-A-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19805575 [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66474369 LIMIT 5 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66474369 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66474369 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66474369 LIMIT 2 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66474369 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='TMMH-110-01-L-DV-EBC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-EBC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000522s ]
SELECT `id` FROM `stock` WHERE `id` <> 66474369 AND `partno` = 'TMMH-110-01-L-DV-EBC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15485198 [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66474363 LIMIT 5 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66474363 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66474363 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66474363 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66474363 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='TMMH-110-01-L-DV-EPC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-EPC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000498s ]
SELECT `id` FROM `stock` WHERE `id` <> 66474363 AND `partno` = 'TMMH-110-01-L-DV-EPC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16216799 [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66473999 LIMIT 5 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66473999 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66473999 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66473999 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66473999 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='TMMH-110-01-L-DV-ES-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-ES-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000526s ]
SELECT `id` FROM `stock` WHERE `id` <> 66473999 AND `partno` = 'TMMH-110-01-L-DV-ES-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19807821 [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66472633 LIMIT 5 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66472633 ORDER BY `minOrder` ASC [ RunTime:0.001418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66472633 ORDER BY `unit` DESC [ RunTime:0.000420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66472633 LIMIT 2 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66472633 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='TMMH-110-01-L-DV-EC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-EC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000532s ]
SELECT `id` FROM `stock` WHERE `id` <> 66472633 AND `partno` = 'TMMH-110-01-L-DV-EC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16216086 [ RunTime:0.000581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66472183 LIMIT 5 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66472183 ORDER BY `minOrder` ASC [ RunTime:0.001584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66472183 ORDER BY `unit` DESC [ RunTime:0.000474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66472183 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66472183 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
select * from pdf where partno='TMMH-110-01-L-DV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000546s ]
SELECT `id` FROM `stock` WHERE `id` <> 66472183 AND `partno` = 'TMMH-110-01-L-DV-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810814 [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66469048 LIMIT 5 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66469048 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66469048 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66469048 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66469048 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
select * from pdf where partno='TMMH-110-01-L-DV-M' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-M' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000607s ]
SELECT `id` FROM `stock` WHERE `id` <> 66469048 AND `partno` = 'TMMH-110-01-L-DV-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16214452 [ RunTime:0.000651s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66464979 LIMIT 5 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66464979 ORDER BY `minOrder` ASC [ RunTime:0.000825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66464979 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66464979 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66464979 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='TMMH-110-01-L-D-RA-001' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-D-RA-001' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000586s ]
SELECT `id` FROM `stock` WHERE `id` <> 66464979 AND `partno` = 'TMMH-110-01-L-D-RA-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786644 [ RunTime:0.000713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66464185 LIMIT 5 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66464185 ORDER BY `minOrder` ASC [ RunTime:0.001198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66464185 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66464185 LIMIT 2 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66464185 ORDER BY `minOrder` ASC [ RunTime:0.000757s ]
select * from pdf where partno='TMMH-110-01-L-D-EA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-D-EA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000843s ]
SELECT `id` FROM `stock` WHERE `id` <> 66464185 AND `partno` = 'TMMH-110-01-L-D-EA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16203269 [ RunTime:0.000686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66463698 LIMIT 5 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66463698 ORDER BY `minOrder` ASC [ RunTime:0.001063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66463698 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66463698 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66463698 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
select * from pdf where partno='TMMH-110-01-L-DV-A-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-A-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000823s ]
SELECT `id` FROM `stock` WHERE `id` <> 66463698 AND `partno` = 'TMMH-110-01-L-DV-A-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19798282 [ RunTime:0.000753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66461335 LIMIT 5 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66461335 ORDER BY `minOrder` ASC [ RunTime:0.001244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66461335 ORDER BY `unit` DESC [ RunTime:0.000705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66461335 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66461335 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
select * from pdf where partno='TMMH-110-01-L-DV-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000870s ]
SELECT `id` FROM `stock` WHERE `id` <> 66461335 AND `partno` = 'TMMH-110-01-L-DV-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66460717 LIMIT 5 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66460717 ORDER BY `minOrder` ASC [ RunTime:0.001198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66460717 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66460717 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66460717 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
select * from pdf where partno='TMMH-110-01-L-DV-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000714s ]
SELECT `id` FROM `stock` WHERE `id` <> 66460717 AND `partno` = 'TMMH-110-01-L-DV-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19795415 [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66373326 LIMIT 5 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66373326 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66373326 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66373326 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66373326 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='TMMH-110-01-L-D-ES' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-D-ES' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000484s ]
SELECT `id` FROM `stock` WHERE `id` <> 66373326 AND `partno` = 'TMMH-110-01-L-D-ES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12737942 [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66371494 LIMIT 5 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66371494 ORDER BY `minOrder` ASC [ RunTime:0.000911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66371494 ORDER BY `unit` DESC [ RunTime:0.000498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66371494 LIMIT 2 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66371494 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='TMMH-110-01-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000893s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000717s ]
SELECT `id` FROM `stock` WHERE `id` <> 66371494 AND `partno` = 'TMMH-110-01-L-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16186645 [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66363606 LIMIT 5 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66363606 ORDER BY `minOrder` ASC [ RunTime:0.001828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66363606 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66363606 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66363606 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='TMMH-110-01-L-D-EL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMMH-110-01-L-D-EL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000647s ]
SELECT `id` FROM `stock` WHERE `id` <> 66363606 AND `partno` = 'TMMH-110-01-L-D-EL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19751315 [ RunTime:0.000516s ]
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 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001274s ]
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 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001003s ]
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 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000918s ]
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 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000953s ]
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 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001105s ]
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 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000952s ]
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 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001168s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TMMH-110-01-L-D%' OR `brand` LIKE 'TMMH-110-01-L-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001863s ]