SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003453s ]
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 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057977s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489066 LIMIT 5 [ RunTime:0.016015s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489066 ORDER BY `minOrder` ASC [ RunTime:0.030593s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15489066 ORDER BY `unit` DESC [ RunTime:0.010369s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15489066 LIMIT 2 [ RunTime:0.032231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489066 ORDER BY `minOrder` ASC [ RunTime:0.048311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191277 LIMIT 5 [ RunTime:0.054319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191277 ORDER BY `minOrder` ASC [ RunTime:0.077212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16191277 ORDER BY `unit` DESC [ RunTime:0.075059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16191277 LIMIT 2 [ RunTime:0.082656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191277 ORDER BY `minOrder` ASC [ RunTime:0.025048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16184421 LIMIT 5 [ RunTime:0.037709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16184421 ORDER BY `minOrder` ASC [ RunTime:0.036490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16184421 ORDER BY `unit` DESC [ RunTime:0.039672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16184421 LIMIT 2 [ RunTime:0.014049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16184421 ORDER BY `minOrder` ASC [ RunTime:0.037295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15474480 LIMIT 5 [ RunTime:0.027680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15474480 ORDER BY `minOrder` ASC [ RunTime:0.031020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15474480 ORDER BY `unit` DESC [ RunTime:0.016775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15474480 LIMIT 2 [ RunTime:0.026439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15474480 ORDER BY `minOrder` ASC [ RunTime:0.002888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852728 LIMIT 5 [ RunTime:0.001998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852728 ORDER BY `minOrder` ASC [ RunTime:0.003128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19852728 ORDER BY `unit` DESC [ RunTime:0.005962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19852728 LIMIT 2 [ RunTime:0.006705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852728 ORDER BY `minOrder` ASC [ RunTime:0.001917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19819247 LIMIT 5 [ RunTime:0.004049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19819247 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19819247 ORDER BY `unit` DESC [ RunTime:0.004754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19819247 LIMIT 2 [ RunTime:0.007197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19819247 ORDER BY `minOrder` ASC [ RunTime:0.004083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19790582 LIMIT 5 [ RunTime:0.009082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19790582 ORDER BY `minOrder` ASC [ RunTime:0.002983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19790582 ORDER BY `unit` DESC [ RunTime:0.002286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19790582 LIMIT 2 [ RunTime:0.009829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19790582 ORDER BY `minOrder` ASC [ RunTime:0.008216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19752432 LIMIT 5 [ RunTime:0.007687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19752432 ORDER BY `minOrder` ASC [ RunTime:0.013635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19752432 ORDER BY `unit` DESC [ RunTime:0.000806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19752432 LIMIT 2 [ RunTime:0.001797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19752432 ORDER BY `minOrder` ASC [ RunTime:0.004058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19748471 LIMIT 5 [ RunTime:0.020146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19748471 ORDER BY `minOrder` ASC [ RunTime:0.012698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19748471 ORDER BY `unit` DESC [ RunTime:0.006177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19748471 LIMIT 2 [ RunTime:0.006922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19748471 ORDER BY `minOrder` ASC [ RunTime:0.002425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16220693 LIMIT 5 [ RunTime:0.008434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220693 ORDER BY `minOrder` ASC [ RunTime:0.022163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16220693 ORDER BY `unit` DESC [ RunTime:0.001753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16220693 LIMIT 2 [ RunTime:0.008814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220693 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16220240 LIMIT 5 [ RunTime:0.001332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220240 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16220240 ORDER BY `unit` DESC [ RunTime:0.010244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16220240 LIMIT 2 [ RunTime:0.013273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220240 ORDER BY `minOrder` ASC [ RunTime:0.002000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182968 LIMIT 5 [ RunTime:0.006232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182968 ORDER BY `minOrder` ASC [ RunTime:0.010301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16182968 ORDER BY `unit` DESC [ RunTime:0.010404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16182968 LIMIT 2 [ RunTime:0.006697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182968 ORDER BY `minOrder` ASC [ RunTime:0.004389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486875 LIMIT 5 [ RunTime:0.003192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486875 ORDER BY `minOrder` ASC [ RunTime:0.021541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15486875 ORDER BY `unit` DESC [ RunTime:0.029756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15486875 LIMIT 2 [ RunTime:0.003858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486875 ORDER BY `minOrder` ASC [ RunTime:0.007788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478865 LIMIT 5 [ RunTime:0.009838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478865 ORDER BY `minOrder` ASC [ RunTime:0.009081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15478865 ORDER BY `unit` DESC [ RunTime:0.010605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15478865 LIMIT 2 [ RunTime:0.006831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478865 ORDER BY `minOrder` ASC [ RunTime:0.015996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12734873 LIMIT 5 [ RunTime:0.010499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12734873 ORDER BY `minOrder` ASC [ RunTime:0.027727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12734873 ORDER BY `unit` DESC [ RunTime:0.018728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12734873 LIMIT 2 [ RunTime:0.012223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12734873 ORDER BY `minOrder` ASC [ RunTime:0.003156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12730474 LIMIT 5 [ RunTime:0.014587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12730474 ORDER BY `minOrder` ASC [ RunTime:0.038506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12730474 ORDER BY `unit` DESC [ RunTime:0.012378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12730474 LIMIT 2 [ RunTime:0.010375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12730474 ORDER BY `minOrder` ASC [ RunTime:0.010886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12725364 LIMIT 5 [ RunTime:0.042415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12725364 ORDER BY `minOrder` ASC [ RunTime:0.036300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12725364 ORDER BY `unit` DESC [ RunTime:0.001744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12725364 LIMIT 2 [ RunTime:0.008412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12725364 ORDER BY `minOrder` ASC [ RunTime:0.016886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11563010 LIMIT 5 [ RunTime:0.015827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11563010 ORDER BY `minOrder` ASC [ RunTime:0.007055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11563010 ORDER BY `unit` DESC [ RunTime:0.036092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11563010 LIMIT 2 [ RunTime:0.033485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11563010 ORDER BY `minOrder` ASC [ RunTime:0.014445s ]
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 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058993s ]
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 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59438919 LIMIT 5 [ RunTime:0.030216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438919 ORDER BY `minOrder` ASC [ RunTime:0.016984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59438919 ORDER BY `unit` DESC [ RunTime:0.025685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59438919 LIMIT 2 [ RunTime:0.037668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438919 ORDER BY `minOrder` ASC [ RunTime:0.011682s ]
select * from pdf where partno='TSM-108-01-L-SV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037582s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.040737s ]
SELECT `id` FROM `stock` WHERE `id` <> 59438919 AND `partno` = 'TSM-108-01-L-SV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.052914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489066 [ RunTime:0.009041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59540188 LIMIT 5 [ RunTime:0.048415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540188 ORDER BY `minOrder` ASC [ RunTime:0.026855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59540188 ORDER BY `unit` DESC [ RunTime:0.009124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59540188 LIMIT 2 [ RunTime:0.023723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540188 ORDER BY `minOrder` ASC [ RunTime:0.049578s ]
select * from pdf where partno='TSM-108-01-L-SV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027729s ]
SELECT `id` FROM `stock` WHERE `id` <> 59540188 AND `partno` = 'TSM-108-01-L-SV-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.048309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16184421 [ RunTime:0.147715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59438167 LIMIT 5 [ RunTime:0.107480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438167 ORDER BY `minOrder` ASC [ RunTime:0.098395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59438167 ORDER BY `unit` DESC [ RunTime:0.032871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59438167 LIMIT 2 [ RunTime:0.048741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438167 ORDER BY `minOrder` ASC [ RunTime:0.023874s ]
select * from pdf where partno='TSM-108-01-L-SV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.049134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.056925s ]
SELECT `id` FROM `stock` WHERE `id` <> 59438167 AND `partno` = 'TSM-108-01-L-SV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191277 [ RunTime:0.083336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59444201 LIMIT 5 [ RunTime:0.035747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59444201 ORDER BY `minOrder` ASC [ RunTime:0.015880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59444201 ORDER BY `unit` DESC [ RunTime:0.025994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59444201 LIMIT 2 [ RunTime:0.058400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59444201 ORDER BY `minOrder` ASC [ RunTime:0.033657s ]
select * from pdf where partno='TSM-108-01-L-SV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.023569s ]
SELECT `id` FROM `stock` WHERE `id` <> 59444201 AND `partno` = 'TSM-108-01-L-SV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.035399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15474480 [ RunTime:0.010595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59655542 LIMIT 5 [ RunTime:0.001404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59655542 ORDER BY `minOrder` ASC [ RunTime:0.036445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59655542 ORDER BY `unit` DESC [ RunTime:0.041558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59655542 LIMIT 2 [ RunTime:0.024338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59655542 ORDER BY `minOrder` ASC [ RunTime:0.018609s ]
select * from pdf where partno='TSM-108-01-L-SV-LC-007-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-LC-007-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.034643s ]
SELECT `id` FROM `stock` WHERE `id` <> 59655542 AND `partno` = 'TSM-108-01-L-SV-LC-007-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19790582 [ RunTime:0.026346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59641451 LIMIT 5 [ RunTime:0.025855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59641451 ORDER BY `minOrder` ASC [ RunTime:0.016857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59641451 ORDER BY `unit` DESC [ RunTime:0.047334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59641451 LIMIT 2 [ RunTime:0.032368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59641451 ORDER BY `minOrder` ASC [ RunTime:0.012537s ]
select * from pdf where partno='TSM-108-01-L-SV-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.039093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-LC-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.041971s ]
SELECT `id` FROM `stock` WHERE `id` <> 59641451 AND `partno` = 'TSM-108-01-L-SV-LC-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12734873 [ RunTime:0.029652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59640851 LIMIT 5 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59640851 ORDER BY `minOrder` ASC [ RunTime:0.032374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59640851 ORDER BY `unit` DESC [ RunTime:0.037121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59640851 LIMIT 2 [ RunTime:0.002699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59640851 ORDER BY `minOrder` ASC [ RunTime:0.005727s ]
select * from pdf where partno='TSM-108-01-L-SV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.039821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.062852s ]
SELECT `id` FROM `stock` WHERE `id` <> 59640851 AND `partno` = 'TSM-108-01-L-SV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.072789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478865 [ RunTime:0.044595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59638519 LIMIT 5 [ RunTime:0.077628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59638519 ORDER BY `minOrder` ASC [ RunTime:0.039102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59638519 ORDER BY `unit` DESC [ RunTime:0.042319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59638519 LIMIT 2 [ RunTime:0.044456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59638519 ORDER BY `minOrder` ASC [ RunTime:0.009928s ]
select * from pdf where partno='TSM-108-01-L-SV-LC-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.035302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-LC-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022062s ]
SELECT `id` FROM `stock` WHERE `id` <> 59638519 AND `partno` = 'TSM-108-01-L-SV-LC-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.035130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59628088 LIMIT 5 [ RunTime:0.011322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59628088 ORDER BY `minOrder` ASC [ RunTime:0.019533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59628088 ORDER BY `unit` DESC [ RunTime:0.009784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59628088 LIMIT 2 [ RunTime:0.007050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59628088 ORDER BY `minOrder` ASC [ RunTime:0.022922s ]
select * from pdf where partno='TSM-108-01-L-SV-P-005-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-P-005-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018128s ]
SELECT `id` FROM `stock` WHERE `id` <> 59628088 AND `partno` = 'TSM-108-01-L-SV-P-005-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12730474 [ RunTime:0.026049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59624243 LIMIT 5 [ RunTime:0.028434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59624243 ORDER BY `minOrder` ASC [ RunTime:0.070068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59624243 ORDER BY `unit` DESC [ RunTime:0.073976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59624243 LIMIT 2 [ RunTime:0.024853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59624243 ORDER BY `minOrder` ASC [ RunTime:0.030161s ]
select * from pdf where partno='TSM-108-01-L-SV-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.041913s ]
SELECT `id` FROM `stock` WHERE `id` <> 59624243 AND `partno` = 'TSM-108-01-L-SV-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.044381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11563010 [ RunTime:0.051275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59619272 LIMIT 5 [ RunTime:0.013105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59619272 ORDER BY `minOrder` ASC [ RunTime:0.039824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59619272 ORDER BY `unit` DESC [ RunTime:0.046674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59619272 LIMIT 2 [ RunTime:0.025887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59619272 ORDER BY `minOrder` ASC [ RunTime:0.003034s ]
select * from pdf where partno='TSM-108-01-L-SV-005-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-005-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.044071s ]
SELECT `id` FROM `stock` WHERE `id` <> 59619272 AND `partno` = 'TSM-108-01-L-SV-005-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12725364 [ RunTime:0.009417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59614959 LIMIT 5 [ RunTime:0.024645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59614959 ORDER BY `minOrder` ASC [ RunTime:0.010901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59614959 ORDER BY `unit` DESC [ RunTime:0.010708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59614959 LIMIT 2 [ RunTime:0.009147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59614959 ORDER BY `minOrder` ASC [ RunTime:0.007162s ]
select * from pdf where partno='TSM-108-01-L-SV-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.048151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027286s ]
SELECT `id` FROM `stock` WHERE `id` <> 59614959 AND `partno` = 'TSM-108-01-L-SV-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59559705 LIMIT 5 [ RunTime:0.017823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59559705 ORDER BY `minOrder` ASC [ RunTime:0.026817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59559705 ORDER BY `unit` DESC [ RunTime:0.019688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59559705 LIMIT 2 [ RunTime:0.045381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59559705 ORDER BY `minOrder` ASC [ RunTime:0.015416s ]
select * from pdf where partno='TSM-108-01-L-SV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.040290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021583s ]
SELECT `id` FROM `stock` WHERE `id` <> 59559705 AND `partno` = 'TSM-108-01-L-SV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19752432 [ RunTime:0.021946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59550048 LIMIT 5 [ RunTime:0.042652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59550048 ORDER BY `minOrder` ASC [ RunTime:0.048771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59550048 ORDER BY `unit` DESC [ RunTime:0.040492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59550048 LIMIT 2 [ RunTime:0.050365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59550048 ORDER BY `minOrder` ASC [ RunTime:0.022693s ]
select * from pdf where partno='TSM-108-01-L-SV-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.054251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.037327s ]
SELECT `id` FROM `stock` WHERE `id` <> 59550048 AND `partno` = 'TSM-108-01-L-SV-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.061347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19748471 [ RunTime:0.054595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59549169 LIMIT 5 [ RunTime:0.049346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59549169 ORDER BY `minOrder` ASC [ RunTime:0.042593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59549169 ORDER BY `unit` DESC [ RunTime:0.030748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59549169 LIMIT 2 [ RunTime:0.027915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59549169 ORDER BY `minOrder` ASC [ RunTime:0.017298s ]
select * from pdf where partno='TSM-108-01-L-SV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032550s ]
SELECT `id` FROM `stock` WHERE `id` <> 59549169 AND `partno` = 'TSM-108-01-L-SV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.040019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182968 [ RunTime:0.027796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59542465 LIMIT 5 [ RunTime:0.041621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59542465 ORDER BY `minOrder` ASC [ RunTime:0.017364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59542465 ORDER BY `unit` DESC [ RunTime:0.029678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59542465 LIMIT 2 [ RunTime:0.026003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59542465 ORDER BY `minOrder` ASC [ RunTime:0.016065s ]
select * from pdf where partno='TSM-108-01-L-SV-005-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-005-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018774s ]
SELECT `id` FROM `stock` WHERE `id` <> 59542465 AND `partno` = 'TSM-108-01-L-SV-005-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852728 [ RunTime:0.069640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59478567 LIMIT 5 [ RunTime:0.008011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59478567 ORDER BY `minOrder` ASC [ RunTime:0.053217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59478567 ORDER BY `unit` DESC [ RunTime:0.039591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59478567 LIMIT 2 [ RunTime:0.038239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59478567 ORDER BY `minOrder` ASC [ RunTime:0.003642s ]
select * from pdf where partno='TSM-108-01-L-SV-005-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-005-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021925s ]
SELECT `id` FROM `stock` WHERE `id` <> 59478567 AND `partno` = 'TSM-108-01-L-SV-005-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.053042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16220693 [ RunTime:0.019632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59476651 LIMIT 5 [ RunTime:0.021087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59476651 ORDER BY `minOrder` ASC [ RunTime:0.019864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59476651 ORDER BY `unit` DESC [ RunTime:0.026661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59476651 LIMIT 2 [ RunTime:0.032697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59476651 ORDER BY `minOrder` ASC [ RunTime:0.006615s ]
select * from pdf where partno='TSM-108-01-L-SV-005' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-005' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.033134s ]
SELECT `id` FROM `stock` WHERE `id` <> 59476651 AND `partno` = 'TSM-108-01-L-SV-005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16220240 [ RunTime:0.034407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59476650 LIMIT 5 [ RunTime:0.031849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59476650 ORDER BY `minOrder` ASC [ RunTime:0.043479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59476650 ORDER BY `unit` DESC [ RunTime:0.042003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59476650 LIMIT 2 [ RunTime:0.034610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59476650 ORDER BY `minOrder` ASC [ RunTime:0.018951s ]
select * from pdf where partno='TSM-108-01-L-SV-002' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-002' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.039482s ]
SELECT `id` FROM `stock` WHERE `id` <> 59476650 AND `partno` = 'TSM-108-01-L-SV-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.068671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19819247 [ RunTime:0.054502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59476625 LIMIT 5 [ RunTime:0.026485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59476625 ORDER BY `minOrder` ASC [ RunTime:0.066098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59476625 ORDER BY `unit` DESC [ RunTime:0.054851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59476625 LIMIT 2 [ RunTime:0.052865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59476625 ORDER BY `minOrder` ASC [ RunTime:0.021754s ]
select * from pdf where partno='TSM-108-01-L-SV-003' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.052647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-108-01-L-SV-003' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.051587s ]
SELECT `id` FROM `stock` WHERE `id` <> 59476625 AND `partno` = 'TSM-108-01-L-SV-003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486875 [ RunTime:0.022223s ]
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 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056656s ]
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 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046530s ]
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 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031147s ]
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 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019930s ]
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 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045525s ]
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 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056904s ]
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 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045653s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TSM-108-01-L-SV%' OR `brand` LIKE 'TSM-108-01-L-SV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.028732s ]