SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002249s ]
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-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040162s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773430 LIMIT 5 [ RunTime:0.046791s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773430 ORDER BY `minOrder` ASC [ RunTime:0.016523s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19773430 ORDER BY `unit` DESC [ RunTime:0.008536s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19773430 LIMIT 2 [ RunTime:0.005968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773430 ORDER BY `minOrder` ASC [ RunTime:0.000989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19763688 LIMIT 5 [ RunTime:0.073407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19763688 ORDER BY `minOrder` ASC [ RunTime:0.034763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19763688 ORDER BY `unit` DESC [ RunTime:0.011961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19763688 LIMIT 2 [ RunTime:0.005389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19763688 ORDER BY `minOrder` ASC [ RunTime:0.013634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494494 LIMIT 5 [ RunTime:0.029297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494494 ORDER BY `minOrder` ASC [ RunTime:0.021914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15494494 ORDER BY `unit` DESC [ RunTime:0.015359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15494494 LIMIT 2 [ RunTime:0.008226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494494 ORDER BY `minOrder` ASC [ RunTime:0.010286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852840 LIMIT 5 [ RunTime:0.030110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852840 ORDER BY `minOrder` ASC [ RunTime:0.027521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19852840 ORDER BY `unit` DESC [ RunTime:0.004033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19852840 LIMIT 2 [ RunTime:0.019871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19852840 ORDER BY `minOrder` ASC [ RunTime:0.026043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19796243 LIMIT 5 [ RunTime:0.025387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796243 ORDER BY `minOrder` ASC [ RunTime:0.019179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19796243 ORDER BY `unit` DESC [ RunTime:0.013229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19796243 LIMIT 2 [ RunTime:0.037448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796243 ORDER BY `minOrder` ASC [ RunTime:0.022689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16210864 LIMIT 5 [ RunTime:0.017864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16210864 ORDER BY `minOrder` ASC [ RunTime:0.059996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16210864 ORDER BY `unit` DESC [ RunTime:0.026938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16210864 LIMIT 2 [ RunTime:0.008843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16210864 ORDER BY `minOrder` ASC [ RunTime:0.002746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15484420 LIMIT 5 [ RunTime:0.011503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15484420 ORDER BY `minOrder` ASC [ RunTime:0.008894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15484420 ORDER BY `unit` DESC [ RunTime:0.010308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15484420 LIMIT 2 [ RunTime:0.021534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15484420 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15483496 LIMIT 5 [ RunTime:0.016395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15483496 ORDER BY `minOrder` ASC [ RunTime:0.009914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15483496 ORDER BY `unit` DESC [ RunTime:0.008359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15483496 LIMIT 2 [ RunTime:0.006796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15483496 ORDER BY `minOrder` ASC [ RunTime:0.002914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12777096 LIMIT 5 [ RunTime:0.004701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12777096 ORDER BY `minOrder` ASC [ RunTime:0.017972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12777096 ORDER BY `unit` DESC [ RunTime:0.023689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12777096 LIMIT 2 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12777096 ORDER BY `minOrder` ASC [ RunTime:0.001806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12776818 LIMIT 5 [ RunTime:0.016673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12776818 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12776818 ORDER BY `unit` DESC [ RunTime:0.001391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12776818 LIMIT 2 [ RunTime:0.006865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12776818 ORDER BY `minOrder` ASC [ RunTime:0.037374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12776509 LIMIT 5 [ RunTime:0.013952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12776509 ORDER BY `minOrder` ASC [ RunTime:0.002001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12776509 ORDER BY `unit` DESC [ RunTime:0.000567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12776509 LIMIT 2 [ RunTime:0.002963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12776509 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
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-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006346s ]
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-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59446982 LIMIT 5 [ RunTime:0.001384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446982 ORDER BY `minOrder` ASC [ RunTime:0.020897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59446982 ORDER BY `unit` DESC [ RunTime:0.004272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59446982 LIMIT 2 [ RunTime:0.002038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59446982 ORDER BY `minOrder` ASC [ RunTime:0.012325s ]
select * from pdf where partno='TSM-110-02-S-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004330s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007494s ]
SELECT `id` FROM `stock` WHERE `id` <> 59446982 AND `partno` = 'TSM-110-02-S-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773430 [ RunTime:0.005219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59541100 LIMIT 5 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541100 ORDER BY `minOrder` ASC [ RunTime:0.004987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59541100 ORDER BY `unit` DESC [ RunTime:0.009216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59541100 LIMIT 2 [ RunTime:0.013632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541100 ORDER BY `minOrder` ASC [ RunTime:0.001977s ]
select * from pdf where partno='TSM-110-02-S-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002959s ]
SELECT `id` FROM `stock` WHERE `id` <> 59541100 AND `partno` = 'TSM-110-02-S-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19763688 [ RunTime:0.008638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59541487 LIMIT 5 [ RunTime:0.001240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541487 ORDER BY `minOrder` ASC [ RunTime:0.012425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59541487 ORDER BY `unit` DESC [ RunTime:0.013970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59541487 LIMIT 2 [ RunTime:0.005360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59541487 ORDER BY `minOrder` ASC [ RunTime:0.006760s ]
select * from pdf where partno='TSM-110-02-S-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.038583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006959s ]
SELECT `id` FROM `stock` WHERE `id` <> 59541487 AND `partno` = 'TSM-110-02-S-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494494 [ RunTime:0.000830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59542627 LIMIT 5 [ RunTime:0.011637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59542627 ORDER BY `minOrder` ASC [ RunTime:0.016879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59542627 ORDER BY `unit` DESC [ RunTime:0.006429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59542627 LIMIT 2 [ RunTime:0.008184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59542627 ORDER BY `minOrder` ASC [ RunTime:0.004658s ]
select * from pdf where partno='TSM-110-02-S-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008670s ]
SELECT `id` FROM `stock` WHERE `id` <> 59542627 AND `partno` = 'TSM-110-02-S-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19852840 [ RunTime:0.001936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59495455 LIMIT 5 [ RunTime:0.009037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59495455 ORDER BY `minOrder` ASC [ RunTime:0.031498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59495455 ORDER BY `unit` DESC [ RunTime:0.008092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59495455 LIMIT 2 [ RunTime:0.003462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59495455 ORDER BY `minOrder` ASC [ RunTime:0.009225s ]
select * from pdf where partno='TSM-110-02-S-DV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001344s ]
SELECT `id` FROM `stock` WHERE `id` <> 59495455 AND `partno` = 'TSM-110-02-S-DV-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12777096 [ RunTime:0.000884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59683663 LIMIT 5 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59683663 ORDER BY `minOrder` ASC [ RunTime:0.003776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59683663 ORDER BY `unit` DESC [ RunTime:0.023243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59683663 LIMIT 2 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59683663 ORDER BY `minOrder` ASC [ RunTime:0.003727s ]
select * from pdf where partno='TSM-110-02-S-DV-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV-LC-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013514s ]
SELECT `id` FROM `stock` WHERE `id` <> 59683663 AND `partno` = 'TSM-110-02-S-DV-LC-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15483496 [ RunTime:0.019870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59679089 LIMIT 5 [ RunTime:0.003185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59679089 ORDER BY `minOrder` ASC [ RunTime:0.003201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59679089 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59679089 LIMIT 2 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59679089 ORDER BY `minOrder` ASC [ RunTime:0.008059s ]
select * from pdf where partno='TSM-110-02-S-DV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003932s ]
SELECT `id` FROM `stock` WHERE `id` <> 59679089 AND `partno` = 'TSM-110-02-S-DV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15484420 [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59678991 LIMIT 5 [ RunTime:0.002269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59678991 ORDER BY `minOrder` ASC [ RunTime:0.017229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59678991 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59678991 LIMIT 2 [ RunTime:0.023002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59678991 ORDER BY `minOrder` ASC [ RunTime:0.002016s ]
select * from pdf where partno='TSM-110-02-S-DV-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003951s ]
SELECT `id` FROM `stock` WHERE `id` <> 59678991 AND `partno` = 'TSM-110-02-S-DV-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16210864 [ RunTime:0.017678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59672558 LIMIT 5 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59672558 ORDER BY `minOrder` ASC [ RunTime:0.006517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59672558 ORDER BY `unit` DESC [ RunTime:0.009291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59672558 LIMIT 2 [ RunTime:0.004495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59672558 ORDER BY `minOrder` ASC [ RunTime:0.004020s ]
select * from pdf where partno='TSM-110-02-S-DV-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006491s ]
SELECT `id` FROM `stock` WHERE `id` <> 59672558 AND `partno` = 'TSM-110-02-S-DV-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19796243 [ RunTime:0.016937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59495084 LIMIT 5 [ RunTime:0.020195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59495084 ORDER BY `minOrder` ASC [ RunTime:0.023825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59495084 ORDER BY `unit` DESC [ RunTime:0.009221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59495084 LIMIT 2 [ RunTime:0.014404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59495084 ORDER BY `minOrder` ASC [ RunTime:0.015191s ]
select * from pdf where partno='TSM-110-02-S-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016770s ]
SELECT `id` FROM `stock` WHERE `id` <> 59495084 AND `partno` = 'TSM-110-02-S-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12776818 [ RunTime:0.008457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59494556 LIMIT 5 [ RunTime:0.012656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59494556 ORDER BY `minOrder` ASC [ RunTime:0.034322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59494556 ORDER BY `unit` DESC [ RunTime:0.010325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59494556 LIMIT 2 [ RunTime:0.012763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59494556 ORDER BY `minOrder` ASC [ RunTime:0.005956s ]
select * from pdf where partno='TSM-110-02-S-DV-004' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-110-02-S-DV-004' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032430s ]
SELECT `id` FROM `stock` WHERE `id` <> 59494556 AND `partno` = 'TSM-110-02-S-DV-004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12776509 [ RunTime:0.003578s ]
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-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005697s ]
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-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016858s ]
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-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017464s ]
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-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026616s ]
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-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019730s ]
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-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015221s ]
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-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027551s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TSM-110-02-S-DV%' OR `brand` LIKE 'TSM-110-02-S-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019087s ]