SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002184s ]
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 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009470s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12707168 LIMIT 5 [ RunTime:0.009644s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.029325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12707168 ORDER BY `minOrder` ASC [ RunTime:0.013940s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12707168 ORDER BY `unit` DESC [ RunTime:0.027759s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12707168 LIMIT 2 [ RunTime:0.013594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12707168 ORDER BY `minOrder` ASC [ RunTime:0.027007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12703468 LIMIT 5 [ RunTime:0.032362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12703468 ORDER BY `minOrder` ASC [ RunTime:0.022533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12703468 ORDER BY `unit` DESC [ RunTime:0.028234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12703468 LIMIT 2 [ RunTime:0.039308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12703468 ORDER BY `minOrder` ASC [ RunTime:0.013318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12699406 LIMIT 5 [ RunTime:0.033529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12699406 ORDER BY `minOrder` ASC [ RunTime:0.077514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12699406 ORDER BY `unit` DESC [ RunTime:0.053124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12699406 LIMIT 2 [ RunTime:0.061719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12699406 ORDER BY `minOrder` ASC [ RunTime:0.042508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12698552 LIMIT 5 [ RunTime:0.024836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12698552 ORDER BY `minOrder` ASC [ RunTime:0.116150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12698552 ORDER BY `unit` DESC [ RunTime:0.093797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12698552 LIMIT 2 [ RunTime:0.043736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12698552 ORDER BY `minOrder` ASC [ RunTime:0.084369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12655592 LIMIT 5 [ RunTime:0.088942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12655592 ORDER BY `minOrder` ASC [ RunTime:0.094915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12655592 ORDER BY `unit` DESC [ RunTime:0.026248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12655592 LIMIT 2 [ RunTime:0.009360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12655592 ORDER BY `minOrder` ASC [ RunTime:0.053030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12635615 LIMIT 5 [ RunTime:0.049360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12635615 ORDER BY `minOrder` ASC [ RunTime:0.018619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12635615 ORDER BY `unit` DESC [ RunTime:0.064963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12635615 LIMIT 2 [ RunTime:0.061410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12635615 ORDER BY `minOrder` ASC [ RunTime:0.027081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11512228 LIMIT 5 [ RunTime:0.097396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11512228 ORDER BY `minOrder` ASC [ RunTime:0.122978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11512228 ORDER BY `unit` DESC [ RunTime:0.057772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11512228 LIMIT 2 [ RunTime:0.038808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11512228 ORDER BY `minOrder` ASC [ RunTime:0.022307s ]
select * from pdf where partno='CLM-115-02-H-D-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.036760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11512202 LIMIT 5 [ RunTime:0.064854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11512202 ORDER BY `minOrder` ASC [ RunTime:0.055760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11512202 ORDER BY `unit` DESC [ RunTime:0.042070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11512202 LIMIT 2 [ RunTime:0.031369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11512202 ORDER BY `minOrder` ASC [ RunTime:0.018302s ]
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 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039942s ]
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 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59893324 LIMIT 5 [ RunTime:0.050844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59893324 ORDER BY `minOrder` ASC [ RunTime:0.009143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59893324 ORDER BY `unit` DESC [ RunTime:0.040624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59893324 LIMIT 2 [ RunTime:0.020847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59893324 ORDER BY `minOrder` ASC [ RunTime:0.023350s ]
select * from pdf where partno='CLM-115-02-H-D-BE-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029374s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-BE-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032126s ]
SELECT `id` FROM `stock` WHERE `id` <> 59893324 AND `partno` = 'CLM-115-02-H-D-BE-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.041129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12655592 [ RunTime:0.016073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59892884 LIMIT 5 [ RunTime:0.021454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59892884 ORDER BY `minOrder` ASC [ RunTime:0.039138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59892884 ORDER BY `unit` DESC [ RunTime:0.018974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59892884 LIMIT 2 [ RunTime:0.041627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59892884 ORDER BY `minOrder` ASC [ RunTime:0.016156s ]
select * from pdf where partno='CLM-115-02-H-D-BE-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-BE-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.053015s ]
SELECT `id` FROM `stock` WHERE `id` <> 59892884 AND `partno` = 'CLM-115-02-H-D-BE-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.041171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59892881 LIMIT 5 [ RunTime:0.048614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59892881 ORDER BY `minOrder` ASC [ RunTime:0.006552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59892881 ORDER BY `unit` DESC [ RunTime:0.030419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59892881 LIMIT 2 [ RunTime:0.023996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59892881 ORDER BY `minOrder` ASC [ RunTime:0.031280s ]
select * from pdf where partno='CLM-115-02-H-D-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027092s ]
SELECT `id` FROM `stock` WHERE `id` <> 59892881 AND `partno` = 'CLM-115-02-H-D-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59891246 LIMIT 5 [ RunTime:0.010304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59891246 ORDER BY `minOrder` ASC [ RunTime:0.027587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59891246 ORDER BY `unit` DESC [ RunTime:0.004811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59891246 LIMIT 2 [ RunTime:0.015129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59891246 ORDER BY `minOrder` ASC [ RunTime:0.002678s ]
select * from pdf where partno='CLM-115-02-H-D-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003601s ]
SELECT `id` FROM `stock` WHERE `id` <> 59891246 AND `partno` = 'CLM-115-02-H-D-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59889969 LIMIT 5 [ RunTime:0.007798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59889969 ORDER BY `minOrder` ASC [ RunTime:0.018244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59889969 ORDER BY `unit` DESC [ RunTime:0.016970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59889969 LIMIT 2 [ RunTime:0.006590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59889969 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
select * from pdf where partno='CLM-115-02-H-D-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.035136s ]
SELECT `id` FROM `stock` WHERE `id` <> 59889969 AND `partno` = 'CLM-115-02-H-D-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11512228 [ RunTime:0.003439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59889846 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59889846 ORDER BY `minOrder` ASC [ RunTime:0.001779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59889846 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59889846 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59889846 ORDER BY `minOrder` ASC [ RunTime:0.005474s ]
select * from pdf where partno='CLM-115-02-H-D-BE-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-BE-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011003s ]
SELECT `id` FROM `stock` WHERE `id` <> 59889846 AND `partno` = 'CLM-115-02-H-D-BE-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.048577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11512202 [ RunTime:0.015584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59886192 LIMIT 5 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59886192 ORDER BY `minOrder` ASC [ RunTime:0.023154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59886192 ORDER BY `unit` DESC [ RunTime:0.011971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59886192 LIMIT 2 [ RunTime:0.012907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59886192 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
select * from pdf where partno='CLM-115-02-H-D-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032093s ]
SELECT `id` FROM `stock` WHERE `id` <> 59886192 AND `partno` = 'CLM-115-02-H-D-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59886157 LIMIT 5 [ RunTime:0.016026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59886157 ORDER BY `minOrder` ASC [ RunTime:0.032402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59886157 ORDER BY `unit` DESC [ RunTime:0.053168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59886157 LIMIT 2 [ RunTime:0.046732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59886157 ORDER BY `minOrder` ASC [ RunTime:0.033064s ]
select * from pdf where partno='CLM-115-02-H-D-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.067154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.069802s ]
SELECT `id` FROM `stock` WHERE `id` <> 59886157 AND `partno` = 'CLM-115-02-H-D-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.044090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59880634 LIMIT 5 [ RunTime:0.053293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59880634 ORDER BY `minOrder` ASC [ RunTime:0.031747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59880634 ORDER BY `unit` DESC [ RunTime:0.020638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59880634 LIMIT 2 [ RunTime:0.037001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59880634 ORDER BY `minOrder` ASC [ RunTime:0.028354s ]
select * from pdf where partno='CLM-115-02-H-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.058861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.035187s ]
SELECT `id` FROM `stock` WHERE `id` <> 59880634 AND `partno` = 'CLM-115-02-H-D-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.055248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59877622 LIMIT 5 [ RunTime:0.027549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877622 ORDER BY `minOrder` ASC [ RunTime:0.044192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59877622 ORDER BY `unit` DESC [ RunTime:0.035834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59877622 LIMIT 2 [ RunTime:0.059948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877622 ORDER BY `minOrder` ASC [ RunTime:0.043849s ]
select * from pdf where partno='CLM-115-02-H-D-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.046152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.047360s ]
SELECT `id` FROM `stock` WHERE `id` <> 59877622 AND `partno` = 'CLM-115-02-H-D-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59866950 LIMIT 5 [ RunTime:0.021053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59866950 ORDER BY `minOrder` ASC [ RunTime:0.065827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59866950 ORDER BY `unit` DESC [ RunTime:0.026674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59866950 LIMIT 2 [ RunTime:0.043217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59866950 ORDER BY `minOrder` ASC [ RunTime:0.013819s ]
select * from pdf where partno='CLM-115-02-H-D-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.035510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021383s ]
SELECT `id` FROM `stock` WHERE `id` <> 59866950 AND `partno` = 'CLM-115-02-H-D-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.040531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59866056 LIMIT 5 [ RunTime:0.022006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59866056 ORDER BY `minOrder` ASC [ RunTime:0.036744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59866056 ORDER BY `unit` DESC [ RunTime:0.041205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59866056 LIMIT 2 [ RunTime:0.032388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59866056 ORDER BY `minOrder` ASC [ RunTime:0.017060s ]
select * from pdf where partno='CLM-115-02-H-D-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.036336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.034340s ]
SELECT `id` FROM `stock` WHERE `id` <> 59866056 AND `partno` = 'CLM-115-02-H-D-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.091669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12707168 [ RunTime:0.034006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59865990 LIMIT 5 [ RunTime:0.048257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59865990 ORDER BY `minOrder` ASC [ RunTime:0.052117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59865990 ORDER BY `unit` DESC [ RunTime:0.040619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59865990 LIMIT 2 [ RunTime:0.044886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59865990 ORDER BY `minOrder` ASC [ RunTime:0.009384s ]
select * from pdf where partno='CLM-115-02-H-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022982s ]
SELECT `id` FROM `stock` WHERE `id` <> 59865990 AND `partno` = 'CLM-115-02-H-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12635615 [ RunTime:0.024631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59862018 LIMIT 5 [ RunTime:0.036808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59862018 ORDER BY `minOrder` ASC [ RunTime:0.022750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59862018 ORDER BY `unit` DESC [ RunTime:0.001895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59862018 LIMIT 2 [ RunTime:0.014117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59862018 ORDER BY `minOrder` ASC [ RunTime:0.007458s ]
select * from pdf where partno='CLM-115-02-H-D-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011096s ]
SELECT `id` FROM `stock` WHERE `id` <> 59862018 AND `partno` = 'CLM-115-02-H-D-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59859657 LIMIT 5 [ RunTime:0.041954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59859657 ORDER BY `minOrder` ASC [ RunTime:0.035358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59859657 ORDER BY `unit` DESC [ RunTime:0.056401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59859657 LIMIT 2 [ RunTime:0.009160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59859657 ORDER BY `minOrder` ASC [ RunTime:0.019452s ]
select * from pdf where partno='CLM-115-02-H-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.044362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.074447s ]
SELECT `id` FROM `stock` WHERE `id` <> 59859657 AND `partno` = 'CLM-115-02-H-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.086078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12703468 [ RunTime:0.037520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59853802 LIMIT 5 [ RunTime:0.082066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59853802 ORDER BY `minOrder` ASC [ RunTime:0.023537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59853802 ORDER BY `unit` DESC [ RunTime:0.010637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59853802 LIMIT 2 [ RunTime:0.051595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59853802 ORDER BY `minOrder` ASC [ RunTime:0.065109s ]
select * from pdf where partno='CLM-115-02-H-D-A-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-A-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.060659s ]
SELECT `id` FROM `stock` WHERE `id` <> 59853802 AND `partno` = 'CLM-115-02-H-D-A-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.047389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59850659 LIMIT 5 [ RunTime:0.064256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59850659 ORDER BY `minOrder` ASC [ RunTime:0.055454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59850659 ORDER BY `unit` DESC [ RunTime:0.025203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59850659 LIMIT 2 [ RunTime:0.055601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59850659 ORDER BY `minOrder` ASC [ RunTime:0.020449s ]
select * from pdf where partno='CLM-115-02-H-D-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.045005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.051906s ]
SELECT `id` FROM `stock` WHERE `id` <> 59850659 AND `partno` = 'CLM-115-02-H-D-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.029283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12699406 [ RunTime:0.044236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59849986 LIMIT 5 [ RunTime:0.035975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59849986 ORDER BY `minOrder` ASC [ RunTime:0.024730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59849986 ORDER BY `unit` DESC [ RunTime:0.024589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59849986 LIMIT 2 [ RunTime:0.058433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59849986 ORDER BY `minOrder` ASC [ RunTime:0.026175s ]
select * from pdf where partno='CLM-115-02-H-D-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025214s ]
SELECT `id` FROM `stock` WHERE `id` <> 59849986 AND `partno` = 'CLM-115-02-H-D-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.025527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12698552 [ RunTime:0.023058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59845708 LIMIT 5 [ RunTime:0.072254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59845708 ORDER BY `minOrder` ASC [ RunTime:0.024475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59845708 ORDER BY `unit` DESC [ RunTime:0.021160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59845708 LIMIT 2 [ RunTime:0.047124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59845708 ORDER BY `minOrder` ASC [ RunTime:0.014235s ]
select * from pdf where partno='CLM-115-02-H-D-A-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-115-02-H-D-A-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.062520s ]
SELECT `id` FROM `stock` WHERE `id` <> 59845708 AND `partno` = 'CLM-115-02-H-D-A-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.057261s ]
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 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013181s ]
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 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039823s ]
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 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023388s ]
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 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049068s ]
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 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070270s ]
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 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037597s ]
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 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032789s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CLM-115-02-H-D%' OR `brand` LIKE 'CLM-115-02-H-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.046068s ]