SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002434s ]
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 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034390s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323117 LIMIT 5 [ RunTime:0.015568s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323117 ORDER BY `minOrder` ASC [ RunTime:0.007278s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13323117 ORDER BY `unit` DESC [ RunTime:0.008272s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13323117 LIMIT 2 [ RunTime:0.025564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323117 ORDER BY `minOrder` ASC [ RunTime:0.023193s ]
select * from pdf where partno='BS11BL04X08RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.032476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583124 LIMIT 5 [ RunTime:0.038072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583124 ORDER BY `minOrder` ASC [ RunTime:0.028752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19583124 ORDER BY `unit` DESC [ RunTime:0.008495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19583124 LIMIT 2 [ RunTime:0.015314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19583124 ORDER BY `minOrder` ASC [ RunTime:0.007600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20146185 LIMIT 5 [ RunTime:0.029588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146185 ORDER BY `minOrder` ASC [ RunTime:0.033903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20146185 ORDER BY `unit` DESC [ RunTime:0.052877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20146185 LIMIT 2 [ RunTime:0.027881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146185 ORDER BY `minOrder` ASC [ RunTime:0.003545s ]
select * from pdf where partno='BS170FTA' and brandshort='UMW' limit 1 [ RunTime:0.026007s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS170FTA' OR `brand` LIKE 'UMW(友台半导体)%' ) ) LIMIT 1 [ RunTime:0.003394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441500 LIMIT 5 [ RunTime:0.017862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441500 ORDER BY `minOrder` ASC [ RunTime:0.030774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15441500 ORDER BY `unit` DESC [ RunTime:0.021691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15441500 LIMIT 2 [ RunTime:0.004694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15441500 ORDER BY `minOrder` ASC [ RunTime:0.003792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584060 LIMIT 5 [ RunTime:0.011046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584060 ORDER BY `minOrder` ASC [ RunTime:0.003376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584060 ORDER BY `unit` DESC [ RunTime:0.004421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584060 LIMIT 2 [ RunTime:0.001392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584060 ORDER BY `minOrder` ASC [ RunTime:0.027081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046195 LIMIT 5 [ RunTime:0.019727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046195 ORDER BY `minOrder` ASC [ RunTime:0.016237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12046195 ORDER BY `unit` DESC [ RunTime:0.006699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12046195 LIMIT 2 [ RunTime:0.004049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046195 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
select * from pdf where partno='BS10CL06X12RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.003306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584045 LIMIT 5 [ RunTime:0.001530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584045 ORDER BY `minOrder` ASC [ RunTime:0.000944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584045 ORDER BY `unit` DESC [ RunTime:0.000788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584045 LIMIT 2 [ RunTime:0.002533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584045 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046120 LIMIT 5 [ RunTime:0.001183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046120 ORDER BY `minOrder` ASC [ RunTime:0.014520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12046120 ORDER BY `unit` DESC [ RunTime:0.001304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12046120 LIMIT 2 [ RunTime:0.002741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046120 ORDER BY `minOrder` ASC [ RunTime:0.005509s ]
select * from pdf where partno='BS18BL10X20RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.001500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323216 LIMIT 5 [ RunTime:0.001453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323216 ORDER BY `minOrder` ASC [ RunTime:0.003675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13323216 ORDER BY `unit` DESC [ RunTime:0.000759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13323216 LIMIT 2 [ RunTime:0.008997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323216 ORDER BY `minOrder` ASC [ RunTime:0.021900s ]
select * from pdf where partno='BS12BL06X12RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.001130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388823 LIMIT 5 [ RunTime:0.001261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388823 ORDER BY `minOrder` ASC [ RunTime:0.005884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13388823 ORDER BY `unit` DESC [ RunTime:0.004325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13388823 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388823 ORDER BY `minOrder` ASC [ RunTime:0.002025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323289 LIMIT 5 [ RunTime:0.013563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323289 ORDER BY `minOrder` ASC [ RunTime:0.024611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13323289 ORDER BY `unit` DESC [ RunTime:0.006740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13323289 LIMIT 2 [ RunTime:0.012110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323289 ORDER BY `minOrder` ASC [ RunTime:0.007319s ]
select * from pdf where partno='BS15BR08X16RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.008442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323262 LIMIT 5 [ RunTime:0.009871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323262 ORDER BY `minOrder` ASC [ RunTime:0.009110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13323262 ORDER BY `unit` DESC [ RunTime:0.005391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13323262 LIMIT 2 [ RunTime:0.004258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323262 ORDER BY `minOrder` ASC [ RunTime:0.005948s ]
select * from pdf where partno='BS19BR02X02RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.014527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 133 LIMIT 5 [ RunTime:0.009216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 133 ORDER BY `minOrder` ASC [ RunTime:0.011159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 133 ORDER BY `unit` DESC [ RunTime:0.013559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 133 LIMIT 2 [ RunTime:0.019711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 133 ORDER BY `minOrder` ASC [ RunTime:0.009054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS170' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.021631s ]
SELECT `id` FROM `stock` WHERE `id` <> 133 AND `partno` = 'BS170' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.013799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44044026 [ RunTime:0.015430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274783 LIMIT 5 [ RunTime:0.017950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274783 ORDER BY `minOrder` ASC [ RunTime:0.004912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14274783 ORDER BY `unit` DESC [ RunTime:0.017328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14274783 LIMIT 2 [ RunTime:0.020709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274783 ORDER BY `minOrder` ASC [ RunTime:0.010959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046201 LIMIT 5 [ RunTime:0.026291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046201 ORDER BY `minOrder` ASC [ RunTime:0.021590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12046201 ORDER BY `unit` DESC [ RunTime:0.033513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12046201 LIMIT 2 [ RunTime:0.037918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046201 ORDER BY `minOrder` ASC [ RunTime:0.005489s ]
select * from pdf where partno='BS15CL04X08RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.009229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323290 LIMIT 5 [ RunTime:0.004521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323290 ORDER BY `minOrder` ASC [ RunTime:0.008818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13323290 ORDER BY `unit` DESC [ RunTime:0.005575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13323290 LIMIT 2 [ RunTime:0.032284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13323290 ORDER BY `minOrder` ASC [ RunTime:0.007019s ]
select * from pdf where partno='BS17BR06X12RB' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.010361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7406 LIMIT 5 [ RunTime:0.021949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7406 ORDER BY `minOrder` ASC [ RunTime:0.012930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7406 ORDER BY `unit` DESC [ RunTime:0.013628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7406 LIMIT 2 [ RunTime:0.008373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7406 ORDER BY `minOrder` ASC [ RunTime:0.002033s ]
select * from pdf where partno='BS170-D26Z' and brandshort='ONSEMI' limit 1 [ RunTime:0.006494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS170-D26Z' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.018696s ]
SELECT `id` FROM `stock` WHERE `id` <> 7406 AND `partno` = 'BS170-D26Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.006455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44045967 [ RunTime:0.002462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14456 LIMIT 5 [ RunTime:0.005792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14456 ORDER BY `minOrder` ASC [ RunTime:0.012324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14456 ORDER BY `unit` DESC [ RunTime:0.007723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14456 LIMIT 2 [ RunTime:0.021342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14456 ORDER BY `minOrder` ASC [ RunTime:0.007156s ]
select * from pdf where partno='BS170F' and brandshort='DIODES INC.' limit 1 [ RunTime:0.006198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS170F' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.015922s ]
SELECT `id` FROM `stock` WHERE `id` <> 14456 AND `partno` = 'BS170F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes inc.%' ) [ RunTime:0.011598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388722 LIMIT 5 [ RunTime:0.023494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388722 ORDER BY `minOrder` ASC [ RunTime:0.002706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13388722 ORDER BY `unit` DESC [ RunTime:0.005639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13388722 LIMIT 2 [ RunTime:0.002771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388722 ORDER BY `minOrder` ASC [ RunTime:0.002924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046247 LIMIT 5 [ RunTime:0.002406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046247 ORDER BY `minOrder` ASC [ RunTime:0.002836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12046247 ORDER BY `unit` DESC [ RunTime:0.004616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12046247 LIMIT 2 [ RunTime:0.002926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046247 ORDER BY `minOrder` ASC [ RunTime:0.005800s ]
select * from pdf where partno='BS10BL06X12RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.011342s ]
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 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140347 LIMIT 5 [ RunTime:0.022179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140347 ORDER BY `minOrder` ASC [ RunTime:0.005568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140347 ORDER BY `unit` DESC [ RunTime:0.000801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140347 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140347 ORDER BY `minOrder` ASC [ RunTime:0.003761s ]
select * from pdf where partno='bs100645u' and brandshort='panduit' limit 1 [ RunTime:0.012950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bs100645u' OR `brand` LIKE 'panduit%' ) ) LIMIT 1 [ RunTime:0.012126s ]
SELECT `id` FROM `stock` WHERE `id` <> 51140347 AND `partno` = 'bs100645u' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit%' ) [ RunTime:0.011355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19010236 [ RunTime:0.019813s ]
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 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44056076 LIMIT 5 [ RunTime:0.027184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44056076 ORDER BY `minOrder` ASC [ RunTime:0.018906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44056076 ORDER BY `unit` DESC [ RunTime:0.012174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44056076 LIMIT 2 [ RunTime:0.011394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44056076 ORDER BY `minOrder` ASC [ RunTime:0.017750s ]
select * from pdf where partno='BS170-D26Z' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.009524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS170-D26Z' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.015558s ]
SELECT `id` FROM `stock` WHERE `id` <> 44056076 AND `partno` = 'BS170-D26Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.015149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63359257 LIMIT 5 [ RunTime:0.008032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63359257 ORDER BY `minOrder` ASC [ RunTime:0.015096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63359257 ORDER BY `unit` DESC [ RunTime:0.013413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63359257 LIMIT 2 [ RunTime:0.009518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63359257 ORDER BY `minOrder` ASC [ RunTime:0.006867s ]
select * from pdf where partno='BS11BL04X08RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.006283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS11BL04X08RP' OR `brand` LIKE 'Bumper Specialties Inc.%' ) ) LIMIT 1 [ RunTime:0.002532s ]
SELECT `id` FROM `stock` WHERE `id` <> 63359257 AND `partno` = 'BS11BL04X08RP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bumper specialties inc.%' ) [ RunTime:0.012752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323117 [ RunTime:0.010821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44044026 LIMIT 5 [ RunTime:0.018148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44044026 ORDER BY `minOrder` ASC [ RunTime:0.016447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44044026 ORDER BY `unit` DESC [ RunTime:0.002616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44044026 LIMIT 2 [ RunTime:0.022090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44044026 ORDER BY `minOrder` ASC [ RunTime:0.001745s ]
select * from pdf where partno='BS170' and brandshort='onsemi' limit 1 [ RunTime:0.014642s ]
select foldpath,foldpath2,filename from pdf_file where id=97637 limit 1 [ RunTime:0.007200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS170' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.024441s ]
SELECT `id` FROM `stock` WHERE `id` <> 44044026 AND `partno` = 'BS170' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.007004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 133 [ RunTime:0.003265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63359234 LIMIT 5 [ RunTime:0.009162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63359234 ORDER BY `minOrder` ASC [ RunTime:0.003433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63359234 ORDER BY `unit` DESC [ RunTime:0.000758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63359234 LIMIT 2 [ RunTime:0.005304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63359234 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
select * from pdf where partno='BS18BL10X20RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.000723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS18BL10X20RP' OR `brand` LIKE 'Bumper Specialties Inc.%' ) ) LIMIT 1 [ RunTime:0.000851s ]
SELECT `id` FROM `stock` WHERE `id` <> 63359234 AND `partno` = 'BS18BL10X20RP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bumper specialties inc.%' ) [ RunTime:0.001583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046120 [ RunTime:0.000694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44044360 LIMIT 5 [ RunTime:0.006778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44044360 ORDER BY `minOrder` ASC [ RunTime:0.001305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44044360 ORDER BY `unit` DESC [ RunTime:0.014342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44044360 LIMIT 2 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44044360 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='BS107P' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.001563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS107P' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.006033s ]
SELECT `id` FROM `stock` WHERE `id` <> 44044360 AND `partno` = 'BS107P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348201 LIMIT 5 [ RunTime:0.004016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348201 ORDER BY `minOrder` ASC [ RunTime:0.001437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348201 ORDER BY `unit` DESC [ RunTime:0.010799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348201 LIMIT 2 [ RunTime:0.018168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348201 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
select * from pdf where partno='BS14-M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.013581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS14-M' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.004501s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348201 AND `partno` = 'BS14-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.005037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584045 [ RunTime:0.000938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348066 LIMIT 5 [ RunTime:0.008447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348066 ORDER BY `minOrder` ASC [ RunTime:0.013111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348066 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348066 LIMIT 2 [ RunTime:0.003555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348066 ORDER BY `minOrder` ASC [ RunTime:0.004237s ]
select * from pdf where partno='BS18-M' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS18-M' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.002782s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348066 AND `partno` = 'BS18-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.031865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19583124 [ RunTime:0.014806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44045967 LIMIT 5 [ RunTime:0.017869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44045967 ORDER BY `minOrder` ASC [ RunTime:0.015143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44045967 ORDER BY `unit` DESC [ RunTime:0.004348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44045967 LIMIT 2 [ RunTime:0.008854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44045967 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
select * from pdf where partno='BS170-D26Z' and brandshort='onsemi' limit 1 [ RunTime:0.000709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS170-D26Z' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.024620s ]
SELECT `id` FROM `stock` WHERE `id` <> 44045967 AND `partno` = 'BS170-D26Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.006779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7406 [ RunTime:0.002917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104352 LIMIT 5 [ RunTime:0.003481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104352 ORDER BY `minOrder` ASC [ RunTime:0.005223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104352 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104352 LIMIT 2 [ RunTime:0.006626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104352 ORDER BY `minOrder` ASC [ RunTime:0.001227s ]
select * from pdf where partno='BS12I' and brandshort='MPD Memory Protection Devices' limit 1 [ RunTime:0.005308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS12I' OR `brand` LIKE 'MPD (Memory Protection Devices)%' ) ) LIMIT 1 [ RunTime:0.007091s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104352 AND `partno` = 'BS12I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mpd%' ) [ RunTime:0.010788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274085 [ RunTime:0.008103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63359327 LIMIT 5 [ RunTime:0.006028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63359327 ORDER BY `minOrder` ASC [ RunTime:0.016586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63359327 ORDER BY `unit` DESC [ RunTime:0.001433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63359327 LIMIT 2 [ RunTime:0.001829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63359327 ORDER BY `minOrder` ASC [ RunTime:0.000984s ]
select * from pdf where partno='BS12BL06X12RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.002751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS12BL06X12RP' OR `brand` LIKE 'Bumper Specialties Inc.%' ) ) LIMIT 1 [ RunTime:0.009203s ]
SELECT `id` FROM `stock` WHERE `id` <> 63359327 AND `partno` = 'BS12BL06X12RP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bumper specialties inc.%' ) [ RunTime:0.015973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323216 [ RunTime:0.008536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44057509 LIMIT 5 [ RunTime:0.016223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44057509 ORDER BY `minOrder` ASC [ RunTime:0.015591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44057509 ORDER BY `unit` DESC [ RunTime:0.011294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44057509 LIMIT 2 [ RunTime:0.007924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44057509 ORDER BY `minOrder` ASC [ RunTime:0.030844s ]
select * from pdf where partno='BS170-D74Z' and brandshort='onsemi' limit 1 [ RunTime:0.005090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS170-D74Z' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.036683s ]
SELECT `id` FROM `stock` WHERE `id` <> 44057509 AND `partno` = 'BS170-D74Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.011136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58105062 LIMIT 5 [ RunTime:0.017544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58105062 ORDER BY `minOrder` ASC [ RunTime:0.007059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58105062 ORDER BY `unit` DESC [ RunTime:0.002419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58105062 LIMIT 2 [ RunTime:0.007798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58105062 ORDER BY `minOrder` ASC [ RunTime:0.015413s ]
select * from pdf where partno='BS12I-22' and brandshort='MPD Memory Protection Devices' limit 1 [ RunTime:0.011182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS12I-22' OR `brand` LIKE 'MPD (Memory Protection Devices)%' ) ) LIMIT 1 [ RunTime:0.012356s ]
SELECT `id` FROM `stock` WHERE `id` <> 58105062 AND `partno` = 'BS12I-22' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mpd%' ) [ RunTime:0.005990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274092 [ RunTime:0.018725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44045896 LIMIT 5 [ RunTime:0.033635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44045896 ORDER BY `minOrder` ASC [ RunTime:0.008115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44045896 ORDER BY `unit` DESC [ RunTime:0.000749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44045896 LIMIT 2 [ RunTime:0.017324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44045896 ORDER BY `minOrder` ASC [ RunTime:0.031189s ]
select * from pdf where partno='BS170-D27Z' and brandshort='onsemi' limit 1 [ RunTime:0.017278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS170-D27Z' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.010129s ]
SELECT `id` FROM `stock` WHERE `id` <> 44045896 AND `partno` = 'BS170-D27Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.019257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44046669 LIMIT 5 [ RunTime:0.035395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44046669 ORDER BY `minOrder` ASC [ RunTime:0.012097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44046669 ORDER BY `unit` DESC [ RunTime:0.020294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44046669 LIMIT 2 [ RunTime:0.015750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44046669 ORDER BY `minOrder` ASC [ RunTime:0.004337s ]
select * from pdf where partno='BS107PSTZ' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.010817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS107PSTZ' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.005044s ]
SELECT `id` FROM `stock` WHERE `id` <> 44046669 AND `partno` = 'BS107PSTZ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.011223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104763 LIMIT 5 [ RunTime:0.008145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104763 ORDER BY `minOrder` ASC [ RunTime:0.002376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104763 ORDER BY `unit` DESC [ RunTime:0.009826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104763 LIMIT 2 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104763 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
select * from pdf where partno='BS12I-HD-24AWG' and brandshort='MPD Memory Protection Devices' limit 1 [ RunTime:0.004333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS12I-HD-24AWG' OR `brand` LIKE 'MPD (Memory Protection Devices)%' ) ) LIMIT 1 [ RunTime:0.003882s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104763 AND `partno` = 'BS12I-HD-24AWG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mpd%' ) [ RunTime:0.013258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274783 [ RunTime:0.004056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63359238 LIMIT 5 [ RunTime:0.000973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63359238 ORDER BY `minOrder` ASC [ RunTime:0.005073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63359238 ORDER BY `unit` DESC [ RunTime:0.001255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63359238 LIMIT 2 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63359238 ORDER BY `minOrder` ASC [ RunTime:0.003382s ]
select * from pdf where partno='BS18CL05X10RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.004976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS18CL05X10RP' OR `brand` LIKE 'Bumper Specialties Inc.%' ) ) LIMIT 1 [ RunTime:0.026473s ]
SELECT `id` FROM `stock` WHERE `id` <> 63359238 AND `partno` = 'BS18CL05X10RP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bumper specialties inc.%' ) [ RunTime:0.021917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323302 [ RunTime:0.029530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63359481 LIMIT 5 [ RunTime:0.009900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63359481 ORDER BY `minOrder` ASC [ RunTime:0.010504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63359481 ORDER BY `unit` DESC [ RunTime:0.011320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63359481 LIMIT 2 [ RunTime:0.006986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63359481 ORDER BY `minOrder` ASC [ RunTime:0.005959s ]
select * from pdf where partno='BS15BR08X16RP' and brandshort='Bumper Specialties Inc.' limit 1 [ RunTime:0.006052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS15BR08X16RP' OR `brand` LIKE 'Bumper Specialties Inc.%' ) ) LIMIT 1 [ RunTime:0.008345s ]
SELECT `id` FROM `stock` WHERE `id` <> 63359481 AND `partno` = 'BS15BR08X16RP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bumper specialties inc.%' ) [ RunTime:0.005789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13323289 [ RunTime:0.018055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58105052 LIMIT 5 [ RunTime:0.006870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58105052 ORDER BY `minOrder` ASC [ RunTime:0.040249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58105052 ORDER BY `unit` DESC [ RunTime:0.016876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58105052 LIMIT 2 [ RunTime:0.008961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58105052 ORDER BY `minOrder` ASC [ RunTime:0.006911s ]
select * from pdf where partno='BS12I-MC' and brandshort='MPD Memory Protection Devices' limit 1 [ RunTime:0.004623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS12I-MC' OR `brand` LIKE 'MPD (Memory Protection Devices)%' ) ) LIMIT 1 [ RunTime:0.000810s ]
SELECT `id` FROM `stock` WHERE `id` <> 58105052 AND `partno` = 'BS12I-MC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mpd%' ) [ RunTime:0.000657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388722 [ RunTime:0.001573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44046688 LIMIT 5 [ RunTime:0.007124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44046688 ORDER BY `minOrder` ASC [ RunTime:0.013331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44046688 ORDER BY `unit` DESC [ RunTime:0.017212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44046688 LIMIT 2 [ RunTime:0.005007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44046688 ORDER BY `minOrder` ASC [ RunTime:0.008447s ]
select * from pdf where partno='BS170P' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.027652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS170P' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002130s ]
SELECT `id` FROM `stock` WHERE `id` <> 44046688 AND `partno` = 'BS170P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.001029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59348233 LIMIT 5 [ RunTime:0.013894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348233 ORDER BY `minOrder` ASC [ RunTime:0.003206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59348233 ORDER BY `unit` DESC [ RunTime:0.009030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59348233 LIMIT 2 [ RunTime:0.015151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59348233 ORDER BY `minOrder` ASC [ RunTime:0.005241s ]
select * from pdf where partno='BS18-C' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BS18-C' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.016217s ]
SELECT `id` FROM `stock` WHERE `id` <> 59348233 AND `partno` = 'BS18-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.014774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15441500 [ RunTime:0.013412s ]
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 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007176s ]
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 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008303s ]
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 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009528s ]
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 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001854s ]
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 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007067s ]
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 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003756s ]
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 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005951s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BS1%' OR `brand` LIKE 'BS1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023968s ]