SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001296s ]
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 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003780s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12671173 LIMIT 5 [ RunTime:0.000532s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12671173 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12671173 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12671173 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12671173 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='CLP-106-02-L-D-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684780 LIMIT 5 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684780 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12684780 ORDER BY `unit` DESC [ RunTime:0.000526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12684780 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684780 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684253 LIMIT 5 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684253 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12684253 ORDER BY `unit` DESC [ RunTime:0.000578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12684253 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684253 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683257 LIMIT 5 [ RunTime:0.001013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683257 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12683257 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12683257 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683257 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681189 LIMIT 5 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681189 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12681189 ORDER BY `unit` DESC [ RunTime:0.000487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12681189 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681189 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680876 LIMIT 5 [ RunTime:0.000793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680876 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12680876 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12680876 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680876 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680392 LIMIT 5 [ RunTime:0.000775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680392 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12680392 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12680392 LIMIT 2 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680392 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679628 LIMIT 5 [ RunTime:0.000900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679628 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12679628 ORDER BY `unit` DESC [ RunTime:0.000492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12679628 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679628 ORDER BY `minOrder` ASC [ RunTime:0.000619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679028 LIMIT 5 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679028 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12679028 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12679028 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679028 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12677880 LIMIT 5 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12677880 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12677880 ORDER BY `unit` DESC [ RunTime:0.000565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12677880 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12677880 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663094 LIMIT 5 [ RunTime:0.001189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663094 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12663094 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12663094 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12663094 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11531354 LIMIT 5 [ RunTime:0.000942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11531354 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11531354 ORDER BY `unit` DESC [ RunTime:0.000586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11531354 LIMIT 2 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11531354 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517688 LIMIT 5 [ RunTime:0.000877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11517688 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11517688 ORDER BY `unit` DESC [ RunTime:0.000398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11517688 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11517688 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
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 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001368s ]
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 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66639906 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66639906 ORDER BY `minOrder` ASC [ RunTime:0.001460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66639906 ORDER BY `unit` DESC [ RunTime:0.000524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66639906 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66639906 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
select * from pdf where partno='CLP-106-02-L-D-BE-A-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000567s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002327s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-A-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000768s ]
SELECT `id` FROM `stock` WHERE `id` <> 66639906 AND `partno` = 'CLP-106-02-L-D-BE-A-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66639905 LIMIT 5 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66639905 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66639905 ORDER BY `unit` DESC [ RunTime:0.000584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66639905 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66639905 ORDER BY `minOrder` ASC [ RunTime:0.000608s ]
select * from pdf where partno='CLP-106-02-L-D-BE-PA-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-PA-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000712s ]
SELECT `id` FROM `stock` WHERE `id` <> 66639905 AND `partno` = 'CLP-106-02-L-D-BE-PA-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66638237 LIMIT 5 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66638237 ORDER BY `minOrder` ASC [ RunTime:0.001112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66638237 ORDER BY `unit` DESC [ RunTime:0.000566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66638237 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66638237 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
select * from pdf where partno='CLP-106-02-L-D-BE-A-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-A-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000786s ]
SELECT `id` FROM `stock` WHERE `id` <> 66638237 AND `partno` = 'CLP-106-02-L-D-BE-A-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66634829 LIMIT 5 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66634829 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66634829 ORDER BY `unit` DESC [ RunTime:0.000604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66634829 LIMIT 2 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66634829 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
select * from pdf where partno='CLP-106-02-L-D-BE-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000768s ]
SELECT `id` FROM `stock` WHERE `id` <> 66634829 AND `partno` = 'CLP-106-02-L-D-BE-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66630242 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66630242 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66630242 ORDER BY `unit` DESC [ RunTime:0.000603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66630242 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66630242 ORDER BY `minOrder` ASC [ RunTime:0.000662s ]
select * from pdf where partno='CLP-106-02-L-D-BE-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000730s ]
SELECT `id` FROM `stock` WHERE `id` <> 66630242 AND `partno` = 'CLP-106-02-L-D-BE-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66627094 LIMIT 5 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66627094 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66627094 ORDER BY `unit` DESC [ RunTime:0.000591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66627094 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66627094 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
select * from pdf where partno='CLP-106-02-L-D-BE-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000732s ]
SELECT `id` FROM `stock` WHERE `id` <> 66627094 AND `partno` = 'CLP-106-02-L-D-BE-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684780 [ RunTime:0.000700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66625715 LIMIT 5 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66625715 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66625715 ORDER BY `unit` DESC [ RunTime:0.000591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66625715 LIMIT 2 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66625715 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
select * from pdf where partno='CLP-106-02-L-D-BE-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000760s ]
SELECT `id` FROM `stock` WHERE `id` <> 66625715 AND `partno` = 'CLP-106-02-L-D-BE-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684253 [ RunTime:0.000675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66623205 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66623205 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66623205 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66623205 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66623205 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
select * from pdf where partno='CLP-106-02-L-D-BE-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000771s ]
SELECT `id` FROM `stock` WHERE `id` <> 66623205 AND `partno` = 'CLP-106-02-L-D-BE-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683257 [ RunTime:0.000700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66621770 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66621770 ORDER BY `minOrder` ASC [ RunTime:0.001169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66621770 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66621770 LIMIT 2 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66621770 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
select * from pdf where partno='CLP-106-02-L-D-BE-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000736s ]
SELECT `id` FROM `stock` WHERE `id` <> 66621770 AND `partno` = 'CLP-106-02-L-D-BE-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11531354 [ RunTime:0.000673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66618966 LIMIT 5 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66618966 ORDER BY `minOrder` ASC [ RunTime:0.001106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66618966 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66618966 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66618966 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
select * from pdf where partno='CLP-106-02-L-D-BE-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000746s ]
SELECT `id` FROM `stock` WHERE `id` <> 66618966 AND `partno` = 'CLP-106-02-L-D-BE-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680876 [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66618399 LIMIT 5 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66618399 ORDER BY `minOrder` ASC [ RunTime:0.000805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66618399 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66618399 LIMIT 2 [ RunTime:0.000573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66618399 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
select * from pdf where partno='CLP-106-02-L-D-BE-PA-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-PA-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000734s ]
SELECT `id` FROM `stock` WHERE `id` <> 66618399 AND `partno` = 'CLP-106-02-L-D-BE-PA-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681189 [ RunTime:0.000671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66617891 LIMIT 5 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66617891 ORDER BY `minOrder` ASC [ RunTime:0.001002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66617891 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66617891 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66617891 ORDER BY `minOrder` ASC [ RunTime:0.000644s ]
select * from pdf where partno='CLP-106-02-L-D-BE-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000797s ]
SELECT `id` FROM `stock` WHERE `id` <> 66617891 AND `partno` = 'CLP-106-02-L-D-BE-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680392 [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66616633 LIMIT 5 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66616633 ORDER BY `minOrder` ASC [ RunTime:0.001106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66616633 ORDER BY `unit` DESC [ RunTime:0.000604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66616633 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66616633 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
select * from pdf where partno='CLP-106-02-L-D-BE-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000753s ]
SELECT `id` FROM `stock` WHERE `id` <> 66616633 AND `partno` = 'CLP-106-02-L-D-BE-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679628 [ RunTime:0.000690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66616631 LIMIT 5 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66616631 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66616631 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66616631 LIMIT 2 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66616631 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
select * from pdf where partno='CLP-106-02-L-D-BE-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000731s ]
SELECT `id` FROM `stock` WHERE `id` <> 66616631 AND `partno` = 'CLP-106-02-L-D-BE-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66616149 LIMIT 5 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66616149 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66616149 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66616149 LIMIT 2 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66616149 ORDER BY `minOrder` ASC [ RunTime:0.000640s ]
select * from pdf where partno='CLP-106-02-L-D-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000741s ]
SELECT `id` FROM `stock` WHERE `id` <> 66616149 AND `partno` = 'CLP-106-02-L-D-BE-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679028 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66615148 LIMIT 5 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66615148 ORDER BY `minOrder` ASC [ RunTime:0.000705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66615148 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66615148 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66615148 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
select * from pdf where partno='CLP-106-02-L-D-BE-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000747s ]
SELECT `id` FROM `stock` WHERE `id` <> 66615148 AND `partno` = 'CLP-106-02-L-D-BE-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66613795 LIMIT 5 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66613795 ORDER BY `minOrder` ASC [ RunTime:0.000817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66613795 ORDER BY `unit` DESC [ RunTime:0.000586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66613795 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66613795 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
select * from pdf where partno='CLP-106-02-L-D-BE-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000733s ]
SELECT `id` FROM `stock` WHERE `id` <> 66613795 AND `partno` = 'CLP-106-02-L-D-BE-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12677880 [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66573993 LIMIT 5 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66573993 ORDER BY `minOrder` ASC [ RunTime:0.001069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66573993 ORDER BY `unit` DESC [ RunTime:0.000594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66573993 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66573993 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
select * from pdf where partno='CLP-106-02-L-D-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000811s ]
SELECT `id` FROM `stock` WHERE `id` <> 66573993 AND `partno` = 'CLP-106-02-L-D-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12663094 [ RunTime:0.000690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66573899 LIMIT 5 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66573899 ORDER BY `minOrder` ASC [ RunTime:0.000662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66573899 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66573899 LIMIT 2 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66573899 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
select * from pdf where partno='CLP-106-02-L-D-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000631s ]
SELECT `id` FROM `stock` WHERE `id` <> 66573899 AND `partno` = 'CLP-106-02-L-D-BE-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517688 [ RunTime:0.000713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66559794 LIMIT 5 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66559794 ORDER BY `minOrder` ASC [ RunTime:0.000849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66559794 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66559794 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66559794 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
select * from pdf where partno='CLP-106-02-L-D-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLP-106-02-L-D-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000768s ]
SELECT `id` FROM `stock` WHERE `id` <> 66559794 AND `partno` = 'CLP-106-02-L-D-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12671173 [ RunTime:0.000630s ]
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 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001287s ]
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 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000973s ]
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 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001381s ]
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 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000965s ]
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 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001001s ]
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 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000951s ]
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 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001229s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CLP-106-02-L-D-BE%' OR `brand` LIKE 'CLP-106-02-L-D-BE%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001189s ]