SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003262s ]
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 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021202s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16212779 LIMIT 5 [ RunTime:0.040935s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212779 ORDER BY `minOrder` ASC [ RunTime:0.018319s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16212779 ORDER BY `unit` DESC [ RunTime:0.036229s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16212779 LIMIT 2 [ RunTime:0.016032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212779 ORDER BY `minOrder` ASC [ RunTime:0.012409s ]
select * from pdf where partno='FTS-112-02-F-DV-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19808744 LIMIT 5 [ RunTime:0.049782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19808744 ORDER BY `minOrder` ASC [ RunTime:0.061057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19808744 ORDER BY `unit` DESC [ RunTime:0.015528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19808744 LIMIT 2 [ RunTime:0.039941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19808744 ORDER BY `minOrder` ASC [ RunTime:0.014510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19803372 LIMIT 5 [ RunTime:0.027201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19803372 ORDER BY `minOrder` ASC [ RunTime:0.041529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19803372 ORDER BY `unit` DESC [ RunTime:0.039014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19803372 LIMIT 2 [ RunTime:0.047844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19803372 ORDER BY `minOrder` ASC [ RunTime:0.008221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786845 LIMIT 5 [ RunTime:0.020020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786845 ORDER BY `minOrder` ASC [ RunTime:0.036392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19786845 ORDER BY `unit` DESC [ RunTime:0.030729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19786845 LIMIT 2 [ RunTime:0.067609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786845 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16212913 LIMIT 5 [ RunTime:0.017702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212913 ORDER BY `minOrder` ASC [ RunTime:0.008857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16212913 ORDER BY `unit` DESC [ RunTime:0.022364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16212913 LIMIT 2 [ RunTime:0.038247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16212913 ORDER BY `minOrder` ASC [ RunTime:0.019085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209976 LIMIT 5 [ RunTime:0.025183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209976 ORDER BY `minOrder` ASC [ RunTime:0.007577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16209976 ORDER BY `unit` DESC [ RunTime:0.003667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16209976 LIMIT 2 [ RunTime:0.011738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209976 ORDER BY `minOrder` ASC [ RunTime:0.017155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16205511 LIMIT 5 [ RunTime:0.004970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205511 ORDER BY `minOrder` ASC [ RunTime:0.011284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16205511 ORDER BY `unit` DESC [ RunTime:0.015652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16205511 LIMIT 2 [ RunTime:0.015611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16205511 ORDER BY `minOrder` ASC [ RunTime:0.013953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15483220 LIMIT 5 [ RunTime:0.020351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15483220 ORDER BY `minOrder` ASC [ RunTime:0.031707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15483220 ORDER BY `unit` DESC [ RunTime:0.022312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15483220 LIMIT 2 [ RunTime:0.036276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15483220 ORDER BY `minOrder` ASC [ RunTime:0.041332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12737587 LIMIT 5 [ RunTime:0.012738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12737587 ORDER BY `minOrder` ASC [ RunTime:0.025685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12737587 ORDER BY `unit` DESC [ RunTime:0.026124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12737587 LIMIT 2 [ RunTime:0.030974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12737587 ORDER BY `minOrder` ASC [ RunTime:0.018117s ]
select * from pdf where partno='FTS-112-02-F-DV-S-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005983s ]
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 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022905s ]
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 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52812881 LIMIT 5 [ RunTime:0.005214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52812881 ORDER BY `minOrder` ASC [ RunTime:0.005511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52812881 ORDER BY `unit` DESC [ RunTime:0.014369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52812881 LIMIT 2 [ RunTime:0.005114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52812881 ORDER BY `minOrder` ASC [ RunTime:0.012723s ]
select * from pdf where partno='FTS-112-02-F-DV-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000543s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001261s ]
SELECT `id` FROM `stock` WHERE `id` <> 52812881 AND `partno` = 'FTS-112-02-F-DV-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16212779 [ RunTime:0.009314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52818086 LIMIT 5 [ RunTime:0.002056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52818086 ORDER BY `minOrder` ASC [ RunTime:0.001974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52818086 ORDER BY `unit` DESC [ RunTime:0.007588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52818086 LIMIT 2 [ RunTime:0.005423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52818086 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='FTS-112-02-F-DV-S-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-S-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003410s ]
SELECT `id` FROM `stock` WHERE `id` <> 52818086 AND `partno` = 'FTS-112-02-F-DV-S-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16212913 [ RunTime:0.003186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52817954 LIMIT 5 [ RunTime:0.004268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52817954 ORDER BY `minOrder` ASC [ RunTime:0.001143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52817954 ORDER BY `unit` DESC [ RunTime:0.000632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52817954 LIMIT 2 [ RunTime:0.003679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52817954 ORDER BY `minOrder` ASC [ RunTime:0.003854s ]
select * from pdf where partno='FTS-112-02-F-DV-S-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-S-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008510s ]
SELECT `id` FROM `stock` WHERE `id` <> 52817954 AND `partno` = 'FTS-112-02-F-DV-S-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52816866 LIMIT 5 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52816866 ORDER BY `minOrder` ASC [ RunTime:0.003861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52816866 ORDER BY `unit` DESC [ RunTime:0.008667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52816866 LIMIT 2 [ RunTime:0.010901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52816866 ORDER BY `minOrder` ASC [ RunTime:0.020839s ]
select * from pdf where partno='FTS-112-02-F-DV-S-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-S-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005785s ]
SELECT `id` FROM `stock` WHERE `id` <> 52816866 AND `partno` = 'FTS-112-02-F-DV-S-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12737587 [ RunTime:0.009435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52813020 LIMIT 5 [ RunTime:0.006184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52813020 ORDER BY `minOrder` ASC [ RunTime:0.006969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52813020 ORDER BY `unit` DESC [ RunTime:0.021876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52813020 LIMIT 2 [ RunTime:0.002400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52813020 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
select * from pdf where partno='FTS-112-02-F-DV-SA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-SA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009583s ]
SELECT `id` FROM `stock` WHERE `id` <> 52813020 AND `partno` = 'FTS-112-02-F-DV-SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19808744 [ RunTime:0.007304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52808636 LIMIT 5 [ RunTime:0.000902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52808636 ORDER BY `minOrder` ASC [ RunTime:0.013219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52808636 ORDER BY `unit` DESC [ RunTime:0.013969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52808636 LIMIT 2 [ RunTime:0.017843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52808636 ORDER BY `minOrder` ASC [ RunTime:0.019795s ]
select * from pdf where partno='FTS-112-02-F-DV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000950s ]
SELECT `id` FROM `stock` WHERE `id` <> 52808636 AND `partno` = 'FTS-112-02-F-DV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52804361 LIMIT 5 [ RunTime:0.018490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52804361 ORDER BY `minOrder` ASC [ RunTime:0.005058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52804361 ORDER BY `unit` DESC [ RunTime:0.023463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52804361 LIMIT 2 [ RunTime:0.003742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52804361 ORDER BY `minOrder` ASC [ RunTime:0.018792s ]
select * from pdf where partno='FTS-112-02-F-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005425s ]
SELECT `id` FROM `stock` WHERE `id` <> 52804361 AND `partno` = 'FTS-112-02-F-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19803372 [ RunTime:0.021631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52804173 LIMIT 5 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52804173 ORDER BY `minOrder` ASC [ RunTime:0.004332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52804173 ORDER BY `unit` DESC [ RunTime:0.003617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52804173 LIMIT 2 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52804173 ORDER BY `minOrder` ASC [ RunTime:0.004086s ]
select * from pdf where partno='FTS-112-02-F-DV-A-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-A-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005310s ]
SELECT `id` FROM `stock` WHERE `id` <> 52804173 AND `partno` = 'FTS-112-02-F-DV-A-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52803407 LIMIT 5 [ RunTime:0.014075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52803407 ORDER BY `minOrder` ASC [ RunTime:0.018282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52803407 ORDER BY `unit` DESC [ RunTime:0.001399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52803407 LIMIT 2 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52803407 ORDER BY `minOrder` ASC [ RunTime:0.002187s ]
select * from pdf where partno='FTS-112-02-F-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006905s ]
SELECT `id` FROM `stock` WHERE `id` <> 52803407 AND `partno` = 'FTS-112-02-F-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.035754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15483220 [ RunTime:0.010950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52798636 LIMIT 5 [ RunTime:0.017505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52798636 ORDER BY `minOrder` ASC [ RunTime:0.015130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52798636 ORDER BY `unit` DESC [ RunTime:0.035451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52798636 LIMIT 2 [ RunTime:0.019405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52798636 ORDER BY `minOrder` ASC [ RunTime:0.015431s ]
select * from pdf where partno='FTS-112-02-F-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004307s ]
SELECT `id` FROM `stock` WHERE `id` <> 52798636 AND `partno` = 'FTS-112-02-F-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209976 [ RunTime:0.011826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52798330 LIMIT 5 [ RunTime:0.001706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52798330 ORDER BY `minOrder` ASC [ RunTime:0.003065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52798330 ORDER BY `unit` DESC [ RunTime:0.008370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52798330 LIMIT 2 [ RunTime:0.010337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52798330 ORDER BY `minOrder` ASC [ RunTime:0.005854s ]
select * from pdf where partno='FTS-112-02-F-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019931s ]
SELECT `id` FROM `stock` WHERE `id` <> 52798330 AND `partno` = 'FTS-112-02-F-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16205511 [ RunTime:0.013853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52795135 LIMIT 5 [ RunTime:0.001370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52795135 ORDER BY `minOrder` ASC [ RunTime:0.001557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52795135 ORDER BY `unit` DESC [ RunTime:0.016308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52795135 LIMIT 2 [ RunTime:0.008178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52795135 ORDER BY `minOrder` ASC [ RunTime:0.001999s ]
select * from pdf where partno='FTS-112-02-F-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-112-02-F-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012811s ]
SELECT `id` FROM `stock` WHERE `id` <> 52795135 AND `partno` = 'FTS-112-02-F-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786845 [ RunTime:0.007081s ]
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 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013021s ]
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 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010429s ]
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 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013981s ]
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 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009072s ]
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 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017579s ]
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 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010125s ]
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 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004400s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTS-112-02-F-DV%' OR `brand` LIKE 'FTS-112-02-F-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009613s ]