SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003228s ]
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 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014274s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19811301 LIMIT 5 [ RunTime:0.029831s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19811301 ORDER BY `minOrder` ASC [ RunTime:0.005668s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19811301 ORDER BY `unit` DESC [ RunTime:0.015128s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19811301 LIMIT 2 [ RunTime:0.018865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19811301 ORDER BY `minOrder` ASC [ RunTime:0.012932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19804220 LIMIT 5 [ RunTime:0.027002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19804220 ORDER BY `minOrder` ASC [ RunTime:0.044637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19804220 ORDER BY `unit` DESC [ RunTime:0.075608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19804220 LIMIT 2 [ RunTime:0.089473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19804220 ORDER BY `minOrder` ASC [ RunTime:0.038391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19801594 LIMIT 5 [ RunTime:0.069225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801594 ORDER BY `minOrder` ASC [ RunTime:0.074110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19801594 ORDER BY `unit` DESC [ RunTime:0.043580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19801594 LIMIT 2 [ RunTime:0.092527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801594 ORDER BY `minOrder` ASC [ RunTime:0.032024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19799862 LIMIT 5 [ RunTime:0.089706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19799862 ORDER BY `minOrder` ASC [ RunTime:0.116879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19799862 ORDER BY `unit` DESC [ RunTime:0.032189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19799862 LIMIT 2 [ RunTime:0.021587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19799862 ORDER BY `minOrder` ASC [ RunTime:0.035044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19796639 LIMIT 5 [ RunTime:0.007069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796639 ORDER BY `minOrder` ASC [ RunTime:0.022839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19796639 ORDER BY `unit` DESC [ RunTime:0.033827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19796639 LIMIT 2 [ RunTime:0.084546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796639 ORDER BY `minOrder` ASC [ RunTime:0.011848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16214554 LIMIT 5 [ RunTime:0.045026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214554 ORDER BY `minOrder` ASC [ RunTime:0.030575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16214554 ORDER BY `unit` DESC [ RunTime:0.019412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16214554 LIMIT 2 [ RunTime:0.064445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214554 ORDER BY `minOrder` ASC [ RunTime:0.034682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12773162 LIMIT 5 [ RunTime:0.022053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12773162 ORDER BY `minOrder` ASC [ RunTime:0.019975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12773162 ORDER BY `unit` DESC [ RunTime:0.102333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12773162 LIMIT 2 [ RunTime:0.103240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12773162 ORDER BY `minOrder` ASC [ RunTime:0.017838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11569574 LIMIT 5 [ RunTime:0.084361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11569574 ORDER BY `minOrder` ASC [ RunTime:0.050314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11569574 ORDER BY `unit` DESC [ RunTime:0.022252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11569574 LIMIT 2 [ RunTime:0.065493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11569574 ORDER BY `minOrder` ASC [ RunTime:0.014119s ]
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 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025988s ]
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 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52836960 LIMIT 5 [ RunTime:0.022416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52836960 ORDER BY `minOrder` ASC [ RunTime:0.007805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52836960 ORDER BY `unit` DESC [ RunTime:0.014489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52836960 LIMIT 2 [ RunTime:0.021720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52836960 ORDER BY `minOrder` ASC [ RunTime:0.021674s ]
select * from pdf where partno='FTSH-115-02-F-DV-EP' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018754s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-EP' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004699s ]
SELECT `id` FROM `stock` WHERE `id` <> 52836960 AND `partno` = 'FTSH-115-02-F-DV-EP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52830597 LIMIT 5 [ RunTime:0.008101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52830597 ORDER BY `minOrder` ASC [ RunTime:0.004518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52830597 ORDER BY `unit` DESC [ RunTime:0.022367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52830597 LIMIT 2 [ RunTime:0.003207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52830597 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
select * from pdf where partno='FTSH-115-02-F-DV-ES-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-ES-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012772s ]
SELECT `id` FROM `stock` WHERE `id` <> 52830597 AND `partno` = 'FTSH-115-02-F-DV-ES-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52830591 LIMIT 5 [ RunTime:0.012038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52830591 ORDER BY `minOrder` ASC [ RunTime:0.012580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52830591 ORDER BY `unit` DESC [ RunTime:0.040862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52830591 LIMIT 2 [ RunTime:0.053520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52830591 ORDER BY `minOrder` ASC [ RunTime:0.032262s ]
select * from pdf where partno='FTSH-115-02-F-DV-ES-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-ES-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026379s ]
SELECT `id` FROM `stock` WHERE `id` <> 52830591 AND `partno` = 'FTSH-115-02-F-DV-ES-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.038837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11569574 [ RunTime:0.033253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52827905 LIMIT 5 [ RunTime:0.004522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52827905 ORDER BY `minOrder` ASC [ RunTime:0.026668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52827905 ORDER BY `unit` DESC [ RunTime:0.035342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52827905 LIMIT 2 [ RunTime:0.003124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52827905 ORDER BY `minOrder` ASC [ RunTime:0.028239s ]
select * from pdf where partno='FTSH-115-02-F-DV-ES-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-ES-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.028269s ]
SELECT `id` FROM `stock` WHERE `id` <> 52827905 AND `partno` = 'FTSH-115-02-F-DV-ES-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.032857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52824155 LIMIT 5 [ RunTime:0.104374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52824155 ORDER BY `minOrder` ASC [ RunTime:0.076182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52824155 ORDER BY `unit` DESC [ RunTime:0.020760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52824155 LIMIT 2 [ RunTime:0.017244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52824155 ORDER BY `minOrder` ASC [ RunTime:0.016173s ]
select * from pdf where partno='FTSH-115-02-F-DV-ES' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.047098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-ES' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.043484s ]
SELECT `id` FROM `stock` WHERE `id` <> 52824155 AND `partno` = 'FTSH-115-02-F-DV-ES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.100748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52820335 LIMIT 5 [ RunTime:0.052592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52820335 ORDER BY `minOrder` ASC [ RunTime:0.030972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52820335 ORDER BY `unit` DESC [ RunTime:0.020471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52820335 LIMIT 2 [ RunTime:0.030597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52820335 ORDER BY `minOrder` ASC [ RunTime:0.019118s ]
select * from pdf where partno='FTSH-115-02-F-DV-A-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-A-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032191s ]
SELECT `id` FROM `stock` WHERE `id` <> 52820335 AND `partno` = 'FTSH-115-02-F-DV-A-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.047001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52820236 LIMIT 5 [ RunTime:0.012216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52820236 ORDER BY `minOrder` ASC [ RunTime:0.023551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52820236 ORDER BY `unit` DESC [ RunTime:0.032751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52820236 LIMIT 2 [ RunTime:0.007390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52820236 ORDER BY `minOrder` ASC [ RunTime:0.020834s ]
select * from pdf where partno='FTSH-115-02-F-DV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011780s ]
SELECT `id` FROM `stock` WHERE `id` <> 52820236 AND `partno` = 'FTSH-115-02-F-DV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19811301 [ RunTime:0.014377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52816506 LIMIT 5 [ RunTime:0.004502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52816506 ORDER BY `minOrder` ASC [ RunTime:0.002235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52816506 ORDER BY `unit` DESC [ RunTime:0.003537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52816506 LIMIT 2 [ RunTime:0.004093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52816506 ORDER BY `minOrder` ASC [ RunTime:0.005623s ]
select * from pdf where partno='FTSH-115-02-F-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.032872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006374s ]
SELECT `id` FROM `stock` WHERE `id` <> 52816506 AND `partno` = 'FTSH-115-02-F-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16214554 [ RunTime:0.003553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52815916 LIMIT 5 [ RunTime:0.003917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52815916 ORDER BY `minOrder` ASC [ RunTime:0.026991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52815916 ORDER BY `unit` DESC [ RunTime:0.029097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52815916 LIMIT 2 [ RunTime:0.005290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52815916 ORDER BY `minOrder` ASC [ RunTime:0.006867s ]
select * from pdf where partno='FTSH-115-02-F-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009009s ]
SELECT `id` FROM `stock` WHERE `id` <> 52815916 AND `partno` = 'FTSH-115-02-F-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19801594 [ RunTime:0.010545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52815108 LIMIT 5 [ RunTime:0.011286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52815108 ORDER BY `minOrder` ASC [ RunTime:0.018192s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52815108 ORDER BY `unit` DESC [ RunTime:0.003728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52815108 LIMIT 2 [ RunTime:0.006496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52815108 ORDER BY `minOrder` ASC [ RunTime:0.012569s ]
select * from pdf where partno='FTSH-115-02-F-DV-ES-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-ES-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008585s ]
SELECT `id` FROM `stock` WHERE `id` <> 52815108 AND `partno` = 'FTSH-115-02-F-DV-ES-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.054473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19799862 [ RunTime:0.003772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52811553 LIMIT 5 [ RunTime:0.009517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52811553 ORDER BY `minOrder` ASC [ RunTime:0.008599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52811553 ORDER BY `unit` DESC [ RunTime:0.009554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52811553 LIMIT 2 [ RunTime:0.010390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52811553 ORDER BY `minOrder` ASC [ RunTime:0.005072s ]
select * from pdf where partno='FTSH-115-02-F-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002781s ]
SELECT `id` FROM `stock` WHERE `id` <> 52811553 AND `partno` = 'FTSH-115-02-F-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19804220 [ RunTime:0.000794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52810852 LIMIT 5 [ RunTime:0.000916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52810852 ORDER BY `minOrder` ASC [ RunTime:0.004232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52810852 ORDER BY `unit` DESC [ RunTime:0.021537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52810852 LIMIT 2 [ RunTime:0.012928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52810852 ORDER BY `minOrder` ASC [ RunTime:0.003908s ]
select * from pdf where partno='FTSH-115-02-F-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-02-F-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006094s ]
SELECT `id` FROM `stock` WHERE `id` <> 52810852 AND `partno` = 'FTSH-115-02-F-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19796639 [ RunTime:0.004626s ]
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 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023171s ]
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 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019378s ]
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 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012121s ]
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 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011542s ]
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 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021534s ]
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 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013411s ]
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 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008470s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-115-02-F-DV%' OR `brand` LIKE 'FTSH-115-02-F-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020528s ]