SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001697s ]
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 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016373s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764009 LIMIT 5 [ RunTime:0.014840s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12764009 ORDER BY `minOrder` ASC [ RunTime:0.017408s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12764009 ORDER BY `unit` DESC [ RunTime:0.017499s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12764009 LIMIT 2 [ RunTime:0.024488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12764009 ORDER BY `minOrder` ASC [ RunTime:0.025187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763837 LIMIT 5 [ RunTime:0.048105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763837 ORDER BY `minOrder` ASC [ RunTime:0.020471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12763837 ORDER BY `unit` DESC [ RunTime:0.008018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12763837 LIMIT 2 [ RunTime:0.024753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763837 ORDER BY `minOrder` ASC [ RunTime:0.017227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763806 LIMIT 5 [ RunTime:0.022270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763806 ORDER BY `minOrder` ASC [ RunTime:0.008531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12763806 ORDER BY `unit` DESC [ RunTime:0.015061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12763806 LIMIT 2 [ RunTime:0.019421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763806 ORDER BY `minOrder` ASC [ RunTime:0.011599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762255 LIMIT 5 [ RunTime:0.026996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762255 ORDER BY `minOrder` ASC [ RunTime:0.051682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12762255 ORDER BY `unit` DESC [ RunTime:0.051480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12762255 LIMIT 2 [ RunTime:0.020782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12762255 ORDER BY `minOrder` ASC [ RunTime:0.018496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12750275 LIMIT 5 [ RunTime:0.019452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12750275 ORDER BY `minOrder` ASC [ RunTime:0.017231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12750275 ORDER BY `unit` DESC [ RunTime:0.010306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12750275 LIMIT 2 [ RunTime:0.013663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12750275 ORDER BY `minOrder` ASC [ RunTime:0.008682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12746326 LIMIT 5 [ RunTime:0.006268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12746326 ORDER BY `minOrder` ASC [ RunTime:0.001478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12746326 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12746326 LIMIT 2 [ RunTime:0.001890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12746326 ORDER BY `minOrder` ASC [ RunTime:0.007485s ]
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 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001562s ]
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 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59737217 LIMIT 5 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737217 ORDER BY `minOrder` ASC [ RunTime:0.003022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59737217 ORDER BY `unit` DESC [ RunTime:0.001840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59737217 LIMIT 2 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737217 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
select * from pdf where partno='EHF-110-01-SM-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010593s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000696s ]
SELECT `id` FROM `stock` WHERE `id` <> 59737217 AND `partno` = 'EHF-110-01-SM-D-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59736962 LIMIT 5 [ RunTime:0.004890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736962 ORDER BY `minOrder` ASC [ RunTime:0.004535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59736962 ORDER BY `unit` DESC [ RunTime:0.001238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59736962 LIMIT 2 [ RunTime:0.000936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736962 ORDER BY `minOrder` ASC [ RunTime:0.004305s ]
select * from pdf where partno='EHF-110-01-SM-D-SM-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-SM-LC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001978s ]
SELECT `id` FROM `stock` WHERE `id` <> 59736962 AND `partno` = 'EHF-110-01-SM-D-SM-LC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59736908 LIMIT 5 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736908 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59736908 ORDER BY `unit` DESC [ RunTime:0.013495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59736908 LIMIT 2 [ RunTime:0.002391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736908 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='EHF-110-01-SM-D-SM-12-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-SM-12-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001030s ]
SELECT `id` FROM `stock` WHERE `id` <> 59736908 AND `partno` = 'EHF-110-01-SM-D-SM-12-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59736624 LIMIT 5 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736624 ORDER BY `minOrder` ASC [ RunTime:0.008852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59736624 ORDER BY `unit` DESC [ RunTime:0.006104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59736624 LIMIT 2 [ RunTime:0.002363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736624 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='EHF-110-01-SM-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-SM-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000802s ]
SELECT `id` FROM `stock` WHERE `id` <> 59736624 AND `partno` = 'EHF-110-01-SM-D-SM-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764009 [ RunTime:0.003214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59736235 LIMIT 5 [ RunTime:0.001955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736235 ORDER BY `minOrder` ASC [ RunTime:0.001264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59736235 ORDER BY `unit` DESC [ RunTime:0.000632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59736235 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736235 ORDER BY `minOrder` ASC [ RunTime:0.003032s ]
select * from pdf where partno='EHF-110-01-SM-D-SM-01' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-SM-01' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002967s ]
SELECT `id` FROM `stock` WHERE `id` <> 59736235 AND `partno` = 'EHF-110-01-SM-D-SM-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763837 [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59736162 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736162 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59736162 ORDER BY `unit` DESC [ RunTime:0.004366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59736162 LIMIT 2 [ RunTime:0.003010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736162 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='EHF-110-01-SM-D-SM-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-SM-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000936s ]
SELECT `id` FROM `stock` WHERE `id` <> 59736162 AND `partno` = 'EHF-110-01-SM-D-SM-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59736160 LIMIT 5 [ RunTime:0.001205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736160 ORDER BY `minOrder` ASC [ RunTime:0.003691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59736160 ORDER BY `unit` DESC [ RunTime:0.003504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59736160 LIMIT 2 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59736160 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='EHF-110-01-SM-D-SM-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-SM-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000770s ]
SELECT `id` FROM `stock` WHERE `id` <> 59736160 AND `partno` = 'EHF-110-01-SM-D-SM-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763806 [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59734369 LIMIT 5 [ RunTime:0.006183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59734369 ORDER BY `minOrder` ASC [ RunTime:0.003941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59734369 ORDER BY `unit` DESC [ RunTime:0.000662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59734369 LIMIT 2 [ RunTime:0.010345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59734369 ORDER BY `minOrder` ASC [ RunTime:0.003100s ]
select * from pdf where partno='EHF-110-01-SM-D-SM-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-SM-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003354s ]
SELECT `id` FROM `stock` WHERE `id` <> 59734369 AND `partno` = 'EHF-110-01-SM-D-SM-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59732435 LIMIT 5 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732435 ORDER BY `minOrder` ASC [ RunTime:0.001885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59732435 ORDER BY `unit` DESC [ RunTime:0.000680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59732435 LIMIT 2 [ RunTime:0.000589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59732435 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='EHF-110-01-SM-D-02' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-02' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002967s ]
SELECT `id` FROM `stock` WHERE `id` <> 59732435 AND `partno` = 'EHF-110-01-SM-D-02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12762255 [ RunTime:0.003978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59711731 LIMIT 5 [ RunTime:0.001700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59711731 ORDER BY `minOrder` ASC [ RunTime:0.002098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59711731 ORDER BY `unit` DESC [ RunTime:0.000736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59711731 LIMIT 2 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59711731 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='EHF-110-01-SM-D-SM-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-SM-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002418s ]
SELECT `id` FROM `stock` WHERE `id` <> 59711731 AND `partno` = 'EHF-110-01-SM-D-SM-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59709277 LIMIT 5 [ RunTime:0.004143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709277 ORDER BY `minOrder` ASC [ RunTime:0.002488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59709277 ORDER BY `unit` DESC [ RunTime:0.002418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59709277 LIMIT 2 [ RunTime:0.000948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59709277 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='EHF-110-01-SM-D-SM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-SM' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010211s ]
SELECT `id` FROM `stock` WHERE `id` <> 59709277 AND `partno` = 'EHF-110-01-SM-D-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12750275 [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59704537 LIMIT 5 [ RunTime:0.005017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59704537 ORDER BY `minOrder` ASC [ RunTime:0.003040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59704537 ORDER BY `unit` DESC [ RunTime:0.002441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59704537 LIMIT 2 [ RunTime:0.000733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59704537 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='EHF-110-01-SM-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013112s ]
SELECT `id` FROM `stock` WHERE `id` <> 59704537 AND `partno` = 'EHF-110-01-SM-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59702190 LIMIT 5 [ RunTime:0.002064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702190 ORDER BY `minOrder` ASC [ RunTime:0.001755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59702190 ORDER BY `unit` DESC [ RunTime:0.000734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59702190 LIMIT 2 [ RunTime:0.000587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59702190 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='EHF-110-01-SM-D-01' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHF-110-01-SM-D-01' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002664s ]
SELECT `id` FROM `stock` WHERE `id` <> 59702190 AND `partno` = 'EHF-110-01-SM-D-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12746326 [ RunTime:0.000702s ]
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 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014501s ]
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 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001578s ]
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 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001342s ]
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 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004581s ]
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 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003133s ]
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 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001606s ]
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 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002973s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'EHF-110-01-SM-D%' OR `brand` LIKE 'EHF-110-01-SM-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002747s ]