SHOW FULL COLUMNS FROM `stock` [ RunTime:0.009723s ]
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 '9767%' OR `brand` LIKE '9767%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029264s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4575 LIMIT 5 [ RunTime:0.036068s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4575 ORDER BY `minOrder` ASC [ RunTime:0.018553s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4575 ORDER BY `unit` DESC [ RunTime:0.039930s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.044010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4575 LIMIT 2 [ RunTime:0.028639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4575 ORDER BY `minOrder` ASC [ RunTime:0.008075s ]
select * from pdf where partno='9767-22-10' and brandshort='AMPHENOL INDUSTRIAL' limit 1 [ RunTime:0.023672s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9767-22-10' OR `brand` LIKE 'AMPHENOL INDUSTRIAL%' ) ) LIMIT 1 [ RunTime:0.003412s ]
SELECT `id` FROM `stock` WHERE `id` <> 4575 AND `partno` = '9767-22-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol industrial%' ) [ RunTime:0.047993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431880 LIMIT 5 [ RunTime:0.059620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431880 ORDER BY `minOrder` ASC [ RunTime:0.037128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431880 ORDER BY `unit` DESC [ RunTime:0.045580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431880 LIMIT 2 [ RunTime:0.022666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431880 ORDER BY `minOrder` ASC [ RunTime:0.006112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431353 LIMIT 5 [ RunTime:0.020597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431353 ORDER BY `minOrder` ASC [ RunTime:0.056478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431353 ORDER BY `unit` DESC [ RunTime:0.031841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431353 LIMIT 2 [ RunTime:0.051753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431353 ORDER BY `minOrder` ASC [ RunTime:0.055382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431208 LIMIT 5 [ RunTime:0.043743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431208 ORDER BY `minOrder` ASC [ RunTime:0.091410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16431208 ORDER BY `unit` DESC [ RunTime:0.034858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16431208 LIMIT 2 [ RunTime:0.087051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16431208 ORDER BY `minOrder` ASC [ RunTime:0.038127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417559 LIMIT 5 [ RunTime:0.040799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417559 ORDER BY `minOrder` ASC [ RunTime:0.060906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417559 ORDER BY `unit` DESC [ RunTime:0.061528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417559 LIMIT 2 [ RunTime:0.029749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417559 ORDER BY `minOrder` ASC [ RunTime:0.049278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417402 LIMIT 5 [ RunTime:0.014906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417402 ORDER BY `minOrder` ASC [ RunTime:0.020000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417402 ORDER BY `unit` DESC [ RunTime:0.029349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417402 LIMIT 2 [ RunTime:0.041705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417402 ORDER BY `minOrder` ASC [ RunTime:0.048007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417315 LIMIT 5 [ RunTime:0.042753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417315 ORDER BY `minOrder` ASC [ RunTime:0.012724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417315 ORDER BY `unit` DESC [ RunTime:0.015044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417315 LIMIT 2 [ RunTime:0.004364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417315 ORDER BY `minOrder` ASC [ RunTime:0.003245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417314 LIMIT 5 [ RunTime:0.047505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417314 ORDER BY `minOrder` ASC [ RunTime:0.047775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417314 ORDER BY `unit` DESC [ RunTime:0.034726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417314 LIMIT 2 [ RunTime:0.023300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417314 ORDER BY `minOrder` ASC [ RunTime:0.016320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382505 LIMIT 5 [ RunTime:0.004042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382505 ORDER BY `minOrder` ASC [ RunTime:0.017587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382505 ORDER BY `unit` DESC [ RunTime:0.004170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382505 LIMIT 2 [ RunTime:0.017471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382505 ORDER BY `minOrder` ASC [ RunTime:0.003015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382504 LIMIT 5 [ RunTime:0.032011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382504 ORDER BY `minOrder` ASC [ RunTime:0.019467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14382504 ORDER BY `unit` DESC [ RunTime:0.017398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14382504 LIMIT 2 [ RunTime:0.034948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14382504 ORDER BY `minOrder` ASC [ RunTime:0.002904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13547186 LIMIT 5 [ RunTime:0.034161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13547186 ORDER BY `minOrder` ASC [ RunTime:0.002023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13547186 ORDER BY `unit` DESC [ RunTime:0.035284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13547186 LIMIT 2 [ RunTime:0.021949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13547186 ORDER BY `minOrder` ASC [ RunTime:0.010045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13547046 LIMIT 5 [ RunTime:0.026260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13547046 ORDER BY `minOrder` ASC [ RunTime:0.020709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13547046 ORDER BY `unit` DESC [ RunTime:0.003868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13547046 LIMIT 2 [ RunTime:0.013075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13547046 ORDER BY `minOrder` ASC [ RunTime:0.006203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13546967 LIMIT 5 [ RunTime:0.032257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13546967 ORDER BY `minOrder` ASC [ RunTime:0.035443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13546967 ORDER BY `unit` DESC [ RunTime:0.030947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13546967 LIMIT 2 [ RunTime:0.042557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13546967 ORDER BY `minOrder` ASC [ RunTime:0.001657s ]
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 '9767%' OR `brand` LIKE '9767%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021245s ]
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 '9767%' OR `brand` LIKE '9767%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63149393 LIMIT 5 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149393 ORDER BY `minOrder` ASC [ RunTime:0.005863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63149393 ORDER BY `unit` DESC [ RunTime:0.004228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63149393 LIMIT 2 [ RunTime:0.007941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63149393 ORDER BY `minOrder` ASC [ RunTime:0.012635s ]
select * from pdf where partno='97679.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.046746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97679.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.018953s ]
SELECT `id` FROM `stock` WHERE `id` <> 63149393 AND `partno` = '97679.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.007721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431880 [ RunTime:0.018190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146964 LIMIT 5 [ RunTime:0.020622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146964 ORDER BY `minOrder` ASC [ RunTime:0.015091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146964 ORDER BY `unit` DESC [ RunTime:0.030383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146964 LIMIT 2 [ RunTime:0.023601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146964 ORDER BY `minOrder` ASC [ RunTime:0.004633s ]
select * from pdf where partno='97678.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.000705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97678.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.020449s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146964 AND `partno` = '97678.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.026090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431353 [ RunTime:0.054959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146963 LIMIT 5 [ RunTime:0.036949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146963 ORDER BY `minOrder` ASC [ RunTime:0.034810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146963 ORDER BY `unit` DESC [ RunTime:0.038687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146963 LIMIT 2 [ RunTime:0.029471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146963 ORDER BY `minOrder` ASC [ RunTime:0.014730s ]
select * from pdf where partno='97677.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.005592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97677.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.017428s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146963 AND `partno` = '97677.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.036102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13547186 [ RunTime:0.020475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146962 LIMIT 5 [ RunTime:0.024440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146962 ORDER BY `minOrder` ASC [ RunTime:0.000837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146962 ORDER BY `unit` DESC [ RunTime:0.022776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146962 LIMIT 2 [ RunTime:0.044302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146962 ORDER BY `minOrder` ASC [ RunTime:0.013753s ]
select * from pdf where partno='97676.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.010149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97676.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.022413s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146962 AND `partno` = '97676.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.034629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417559 [ RunTime:0.017405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146458 LIMIT 5 [ RunTime:0.011313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146458 ORDER BY `minOrder` ASC [ RunTime:0.036699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146458 ORDER BY `unit` DESC [ RunTime:0.019054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146458 LIMIT 2 [ RunTime:0.019302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146458 ORDER BY `minOrder` ASC [ RunTime:0.017568s ]
select * from pdf where partno='97675.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.014942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97675.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.010537s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146458 AND `partno` = '97675.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.035081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417402 [ RunTime:0.018750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146457 LIMIT 5 [ RunTime:0.065131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146457 ORDER BY `minOrder` ASC [ RunTime:0.064642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146457 ORDER BY `unit` DESC [ RunTime:0.065242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146457 LIMIT 2 [ RunTime:0.032272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146457 ORDER BY `minOrder` ASC [ RunTime:0.049928s ]
select * from pdf where partno='97674.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.119044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97674.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.218861s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146457 AND `partno` = '97674.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.049496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13547046 [ RunTime:0.076386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146456 LIMIT 5 [ RunTime:0.062188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146456 ORDER BY `minOrder` ASC [ RunTime:0.048944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146456 ORDER BY `unit` DESC [ RunTime:0.051295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146456 LIMIT 2 [ RunTime:0.091412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146456 ORDER BY `minOrder` ASC [ RunTime:0.028944s ]
select * from pdf where partno='97673.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.040655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97673.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.061695s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146456 AND `partno` = '97673.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.083373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16431208 [ RunTime:0.034424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146116 LIMIT 5 [ RunTime:0.062010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146116 ORDER BY `minOrder` ASC [ RunTime:0.089235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146116 ORDER BY `unit` DESC [ RunTime:0.092707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146116 LIMIT 2 [ RunTime:0.043254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146116 ORDER BY `minOrder` ASC [ RunTime:0.044757s ]
select * from pdf where partno='97672.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.071839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97672.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.163959s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146116 AND `partno` = '97672.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.121891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13546967 [ RunTime:0.094866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146115 LIMIT 5 [ RunTime:0.028107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146115 ORDER BY `minOrder` ASC [ RunTime:0.052769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146115 ORDER BY `unit` DESC [ RunTime:0.106109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146115 LIMIT 2 [ RunTime:0.143442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146115 ORDER BY `minOrder` ASC [ RunTime:0.048325s ]
select * from pdf where partno='97671.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.042447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97671.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.068008s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146115 AND `partno` = '97671.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.177601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417315 [ RunTime:0.047360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63146114 LIMIT 5 [ RunTime:0.091934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146114 ORDER BY `minOrder` ASC [ RunTime:0.076641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63146114 ORDER BY `unit` DESC [ RunTime:0.046836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63146114 LIMIT 2 [ RunTime:0.028481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63146114 ORDER BY `minOrder` ASC [ RunTime:0.021461s ]
select * from pdf where partno='97670.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.047818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '97670.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.052132s ]
SELECT `id` FROM `stock` WHERE `id` <> 63146114 AND `partno` = '97670.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.048001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417314 [ RunTime:0.010453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63143291 LIMIT 5 [ RunTime:0.007637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63143291 ORDER BY `minOrder` ASC [ RunTime:0.004441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63143291 ORDER BY `unit` DESC [ RunTime:0.006606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63143291 LIMIT 2 [ RunTime:0.028821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63143291 ORDER BY `minOrder` ASC [ RunTime:0.029882s ]
select * from pdf where partno='9767' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.031164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9767' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.018444s ]
SELECT `id` FROM `stock` WHERE `id` <> 63143291 AND `partno` = '9767' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.012413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63031972 LIMIT 5 [ RunTime:0.082787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63031972 ORDER BY `minOrder` ASC [ RunTime:0.063652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63031972 ORDER BY `unit` DESC [ RunTime:0.152468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63031972 LIMIT 2 [ RunTime:0.070930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63031972 ORDER BY `minOrder` ASC [ RunTime:0.033705s ]
select * from pdf where partno='9767 060500' and brandshort='Belden Inc.' limit 1 [ RunTime:0.049981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9767 060500' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.039927s ]
SELECT `id` FROM `stock` WHERE `id` <> 63031972 AND `partno` = '9767 060500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.087895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382504 [ RunTime:0.089009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63031971 LIMIT 5 [ RunTime:0.092999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63031971 ORDER BY `minOrder` ASC [ RunTime:0.124673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63031971 ORDER BY `unit` DESC [ RunTime:0.067765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63031971 LIMIT 2 [ RunTime:0.083076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63031971 ORDER BY `minOrder` ASC [ RunTime:0.093920s ]
select * from pdf where partno='9767 0601000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.095783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9767 0601000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.051958s ]
SELECT `id` FROM `stock` WHERE `id` <> 63031971 AND `partno` = '9767 0601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.114093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14382505 [ RunTime:0.100334s ]
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 '9767%' OR `brand` LIKE '9767%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.071603s ]
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 '9767%' OR `brand` LIKE '9767%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039675s ]
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 '9767%' OR `brand` LIKE '9767%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052852s ]
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 '9767%' OR `brand` LIKE '9767%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.101212s ]
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 '9767%' OR `brand` LIKE '9767%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064198s ]
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 '9767%' OR `brand` LIKE '9767%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.117845s ]
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 '9767%' OR `brand` LIKE '9767%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018840s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '9767%' OR `brand` LIKE '9767%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.055512s ]