SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002464s ]
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 '5643%' OR `brand` LIKE '5643%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027550s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11173784 LIMIT 5 [ RunTime:0.031622s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11173784 ORDER BY `minOrder` ASC [ RunTime:0.053389s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11173784 ORDER BY `unit` DESC [ RunTime:0.015878s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11173784 LIMIT 2 [ RunTime:0.013763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11173784 ORDER BY `minOrder` ASC [ RunTime:0.008802s ]
select * from pdf where partno='56430-501' and brandshort='Tark Thermal Solutions' limit 1 [ RunTime:0.019246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265153 LIMIT 5 [ RunTime:0.021597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265153 ORDER BY `minOrder` ASC [ RunTime:0.008391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17265153 ORDER BY `unit` DESC [ RunTime:0.026378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17265153 LIMIT 2 [ RunTime:0.070145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17265153 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336663 LIMIT 5 [ RunTime:0.016555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11336663 ORDER BY `minOrder` ASC [ RunTime:0.042260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11336663 ORDER BY `unit` DESC [ RunTime:0.033260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11336663 LIMIT 2 [ RunTime:0.016084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11336663 ORDER BY `minOrder` ASC [ RunTime:0.007866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12064169 LIMIT 5 [ RunTime:0.022222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12064169 ORDER BY `minOrder` ASC [ RunTime:0.025992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12064169 ORDER BY `unit` DESC [ RunTime:0.018910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12064169 LIMIT 2 [ RunTime:0.032808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12064169 ORDER BY `minOrder` ASC [ RunTime:0.033253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194093 LIMIT 5 [ RunTime:0.072030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194093 ORDER BY `minOrder` ASC [ RunTime:0.056852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11194093 ORDER BY `unit` DESC [ RunTime:0.026488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11194093 LIMIT 2 [ RunTime:0.017647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194093 ORDER BY `minOrder` ASC [ RunTime:0.030614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18866107 LIMIT 5 [ RunTime:0.048454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866107 ORDER BY `minOrder` ASC [ RunTime:0.087664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18866107 ORDER BY `unit` DESC [ RunTime:0.045454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18866107 LIMIT 2 [ RunTime:0.049306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18866107 ORDER BY `minOrder` ASC [ RunTime:0.006688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17510855 LIMIT 5 [ RunTime:0.035988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17510855 ORDER BY `minOrder` ASC [ RunTime:0.032438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17510855 ORDER BY `unit` DESC [ RunTime:0.054760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17510855 LIMIT 2 [ RunTime:0.019620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17510855 ORDER BY `minOrder` ASC [ RunTime:0.023779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026996 LIMIT 5 [ RunTime:0.034548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026996 ORDER BY `minOrder` ASC [ RunTime:0.031224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17026996 ORDER BY `unit` DESC [ RunTime:0.031390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17026996 LIMIT 2 [ RunTime:0.023729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026996 ORDER BY `minOrder` ASC [ RunTime:0.011559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026995 LIMIT 5 [ RunTime:0.018177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026995 ORDER BY `minOrder` ASC [ RunTime:0.008165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17026995 ORDER BY `unit` DESC [ RunTime:0.000801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17026995 LIMIT 2 [ RunTime:0.004551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026995 ORDER BY `minOrder` ASC [ RunTime:0.002188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523192 LIMIT 5 [ RunTime:0.012310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523192 ORDER BY `minOrder` ASC [ RunTime:0.013933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13523192 ORDER BY `unit` DESC [ RunTime:0.014517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13523192 LIMIT 2 [ RunTime:0.014482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13523192 ORDER BY `minOrder` ASC [ RunTime:0.002157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522865 LIMIT 5 [ RunTime:0.017001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522865 ORDER BY `minOrder` ASC [ RunTime:0.035700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13522865 ORDER BY `unit` DESC [ RunTime:0.016536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13522865 LIMIT 2 [ RunTime:0.006072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522865 ORDER BY `minOrder` ASC [ RunTime:0.003476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521938 LIMIT 5 [ RunTime:0.001667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521938 ORDER BY `minOrder` ASC [ RunTime:0.004075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13521938 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13521938 LIMIT 2 [ RunTime:0.001964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13521938 ORDER BY `minOrder` ASC [ RunTime:0.002262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12152487 LIMIT 5 [ RunTime:0.000927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12152487 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12152487 ORDER BY `unit` DESC [ RunTime:0.003387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12152487 LIMIT 2 [ RunTime:0.003506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12152487 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
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 '5643%' OR `brand` LIKE '5643%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32285981 LIMIT 5 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285981 ORDER BY `minOrder` ASC [ RunTime:0.011424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32285981 ORDER BY `unit` DESC [ RunTime:0.004307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32285981 LIMIT 2 [ RunTime:0.011630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285981 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='56430-501' and brandshort='tark thermal solutions' limit 1 [ RunTime:0.006637s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56430-501' OR `brand` LIKE 'tark thermal solutions%' ) ) LIMIT 1 [ RunTime:0.006438s ]
SELECT `id` FROM `stock` WHERE `id` <> 32285981 AND `partno` = '56430-501' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tark thermal solutions%' ) [ RunTime:0.021114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11173784 [ RunTime:0.001149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32285919 LIMIT 5 [ RunTime:0.010714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285919 ORDER BY `minOrder` ASC [ RunTime:0.007304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32285919 ORDER BY `unit` DESC [ RunTime:0.008845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32285919 LIMIT 2 [ RunTime:0.009460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32285919 ORDER BY `minOrder` ASC [ RunTime:0.008072s ]
select * from pdf where partno='56430-510' and brandshort='tark thermal solutions' limit 1 [ RunTime:0.036310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56430-510' OR `brand` LIKE 'tark thermal solutions%' ) ) LIMIT 1 [ RunTime:0.023054s ]
SELECT `id` FROM `stock` WHERE `id` <> 32285919 AND `partno` = '56430-510' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tark thermal solutions%' ) [ RunTime:0.001736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12152487 [ RunTime:0.002229s ]
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 '5643%' OR `brand` LIKE '5643%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57756041 LIMIT 5 [ RunTime:0.011464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756041 ORDER BY `minOrder` ASC [ RunTime:0.029279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57756041 ORDER BY `unit` DESC [ RunTime:0.008395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57756041 LIMIT 2 [ RunTime:0.001035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57756041 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='5643CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5643CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001608s ]
SELECT `id` FROM `stock` WHERE `id` <> 57756041 AND `partno` = '5643CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.017460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12064169 [ RunTime:0.034628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57242917 LIMIT 5 [ RunTime:0.043580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57242917 ORDER BY `minOrder` ASC [ RunTime:0.017429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57242917 ORDER BY `unit` DESC [ RunTime:0.018250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57242917 LIMIT 2 [ RunTime:0.041406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57242917 ORDER BY `minOrder` ASC [ RunTime:0.013265s ]
select * from pdf where partno='5643' and brandshort='Kitronik Ltd.' limit 1 [ RunTime:0.001144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5643' OR `brand` LIKE 'Kitronik Ltd.%' ) ) LIMIT 1 [ RunTime:0.047263s ]
SELECT `id` FROM `stock` WHERE `id` <> 57242917 AND `partno` = '5643' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%kitronik ltd.%' ) [ RunTime:0.015583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17265153 [ RunTime:0.016464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55435270 LIMIT 5 [ RunTime:0.034190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55435270 ORDER BY `minOrder` ASC [ RunTime:0.021614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55435270 ORDER BY `unit` DESC [ RunTime:0.008471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55435270 LIMIT 2 [ RunTime:0.014847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55435270 ORDER BY `minOrder` ASC [ RunTime:0.017413s ]
select * from pdf where partno='5643' and brandshort='Pololu' limit 1 [ RunTime:0.007758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5643' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.019650s ]
SELECT `id` FROM `stock` WHERE `id` <> 55435270 AND `partno` = '5643' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.024852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57241664 LIMIT 5 [ RunTime:0.030527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241664 ORDER BY `minOrder` ASC [ RunTime:0.030509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57241664 ORDER BY `unit` DESC [ RunTime:0.032060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57241664 LIMIT 2 [ RunTime:0.022405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57241664 ORDER BY `minOrder` ASC [ RunTime:0.012663s ]
select * from pdf where partno='5643' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.009642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5643' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.026715s ]
SELECT `id` FROM `stock` WHERE `id` <> 57241664 AND `partno` = '5643' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.063112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336663 [ RunTime:0.012313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51643967 LIMIT 5 [ RunTime:0.039525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51643967 ORDER BY `minOrder` ASC [ RunTime:0.021820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51643967 ORDER BY `unit` DESC [ RunTime:0.017888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51643967 LIMIT 2 [ RunTime:0.026878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51643967 ORDER BY `minOrder` ASC [ RunTime:0.003232s ]
select * from pdf where partno='56430-501' and brandshort='Tark Thermal Solutions' limit 1 [ RunTime:0.017092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56430-501' OR `brand` LIKE 'Tark Thermal Solutions%' ) ) LIMIT 1 [ RunTime:0.041387s ]
SELECT `id` FROM `stock` WHERE `id` <> 51643967 AND `partno` = '56430-501' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tark thermal solutions%' ) [ RunTime:0.032366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11173784 [ RunTime:0.015437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51683213 LIMIT 5 [ RunTime:0.010122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51683213 ORDER BY `minOrder` ASC [ RunTime:0.008300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51683213 ORDER BY `unit` DESC [ RunTime:0.012656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51683213 LIMIT 2 [ RunTime:0.032914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51683213 ORDER BY `minOrder` ASC [ RunTime:0.015686s ]
select * from pdf where partno='56430' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.016113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56430' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.014325s ]
SELECT `id` FROM `stock` WHERE `id` <> 51683213 AND `partno` = '56430' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.029491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194093 [ RunTime:0.004362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57696199 LIMIT 5 [ RunTime:0.006430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696199 ORDER BY `minOrder` ASC [ RunTime:0.023680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57696199 ORDER BY `unit` DESC [ RunTime:0.000854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57696199 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57696199 ORDER BY `minOrder` ASC [ RunTime:0.002836s ]
select * from pdf where partno='5643-II' and brandshort='Brady Corporation' limit 1 [ RunTime:0.005983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5643-II' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.017835s ]
SELECT `id` FROM `stock` WHERE `id` <> 57696199 AND `partno` = '5643-II' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.010667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13523192 [ RunTime:0.007309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695614 LIMIT 5 [ RunTime:0.013210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695614 ORDER BY `minOrder` ASC [ RunTime:0.030418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695614 ORDER BY `unit` DESC [ RunTime:0.013174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695614 LIMIT 2 [ RunTime:0.017947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695614 ORDER BY `minOrder` ASC [ RunTime:0.010551s ]
select * from pdf where partno='5643-I' and brandshort='Brady Corporation' limit 1 [ RunTime:0.030276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5643-I' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.018866s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695614 AND `partno` = '5643-I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.012792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522865 [ RunTime:0.014658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57694205 LIMIT 5 [ RunTime:0.021657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57694205 ORDER BY `minOrder` ASC [ RunTime:0.015193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57694205 ORDER BY `unit` DESC [ RunTime:0.008607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57694205 LIMIT 2 [ RunTime:0.016296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57694205 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
select * from pdf where partno='5643-O' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5643-O' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.014742s ]
SELECT `id` FROM `stock` WHERE `id` <> 57694205 AND `partno` = '5643-O' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13521938 [ RunTime:0.007566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57694117 LIMIT 5 [ RunTime:0.016897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57694117 ORDER BY `minOrder` ASC [ RunTime:0.039140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57694117 ORDER BY `unit` DESC [ RunTime:0.007549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57694117 LIMIT 2 [ RunTime:0.003563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57694117 ORDER BY `minOrder` ASC [ RunTime:0.007745s ]
select * from pdf where partno='5643-OO' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5643-OO' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003560s ]
SELECT `id` FROM `stock` WHERE `id` <> 57694117 AND `partno` = '5643-OO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.016784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51644754 LIMIT 5 [ RunTime:0.020595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51644754 ORDER BY `minOrder` ASC [ RunTime:0.005516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51644754 ORDER BY `unit` DESC [ RunTime:0.002515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51644754 LIMIT 2 [ RunTime:0.007510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51644754 ORDER BY `minOrder` ASC [ RunTime:0.002296s ]
select * from pdf where partno='56430-510' and brandshort='Tark Thermal Solutions' limit 1 [ RunTime:0.007767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56430-510' OR `brand` LIKE 'Tark Thermal Solutions%' ) ) LIMIT 1 [ RunTime:0.019279s ]
SELECT `id` FROM `stock` WHERE `id` <> 51644754 AND `partno` = '56430-510' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tark thermal solutions%' ) [ RunTime:0.011101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12152487 [ RunTime:0.004349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32646948 LIMIT 5 [ RunTime:0.009528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32646948 ORDER BY `minOrder` ASC [ RunTime:0.001334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32646948 ORDER BY `unit` DESC [ RunTime:0.020948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32646948 LIMIT 2 [ RunTime:0.022367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32646948 ORDER BY `minOrder` ASC [ RunTime:0.017223s ]
select * from pdf where partno='56436' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.013373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56436' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.008231s ]
SELECT `id` FROM `stock` WHERE `id` <> 32646948 AND `partno` = '56436' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.026638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32641441 LIMIT 5 [ RunTime:0.009913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32641441 ORDER BY `minOrder` ASC [ RunTime:0.010902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32641441 ORDER BY `unit` DESC [ RunTime:0.016681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32641441 LIMIT 2 [ RunTime:0.006436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32641441 ORDER BY `minOrder` ASC [ RunTime:0.005340s ]
select * from pdf where partno='56438' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.009498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56438' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.031787s ]
SELECT `id` FROM `stock` WHERE `id` <> 32641441 AND `partno` = '56438' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.047102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32638653 LIMIT 5 [ RunTime:0.013850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32638653 ORDER BY `minOrder` ASC [ RunTime:0.026187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32638653 ORDER BY `unit` DESC [ RunTime:0.011892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32638653 LIMIT 2 [ RunTime:0.011873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32638653 ORDER BY `minOrder` ASC [ RunTime:0.004180s ]
select * from pdf where partno='56439' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.018361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56439' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.007464s ]
SELECT `id` FROM `stock` WHERE `id` <> 32638653 AND `partno` = '56439' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.023471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32614876 LIMIT 5 [ RunTime:0.031242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32614876 ORDER BY `minOrder` ASC [ RunTime:0.039689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32614876 ORDER BY `unit` DESC [ RunTime:0.050043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32614876 LIMIT 2 [ RunTime:0.011216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32614876 ORDER BY `minOrder` ASC [ RunTime:0.008494s ]
select * from pdf where partno='56434' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.019361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56434' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.021310s ]
SELECT `id` FROM `stock` WHERE `id` <> 32614876 AND `partno` = '56434' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.030133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32608934 LIMIT 5 [ RunTime:0.065523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32608934 ORDER BY `minOrder` ASC [ RunTime:0.032801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32608934 ORDER BY `unit` DESC [ RunTime:0.064750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32608934 LIMIT 2 [ RunTime:0.052714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32608934 ORDER BY `minOrder` ASC [ RunTime:0.026995s ]
select * from pdf where partno='56435' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.060564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56435' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.018882s ]
SELECT `id` FROM `stock` WHERE `id` <> 32608934 AND `partno` = '56435' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.071681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32333886 LIMIT 5 [ RunTime:0.025489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32333886 ORDER BY `minOrder` ASC [ RunTime:0.041844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32333886 ORDER BY `unit` DESC [ RunTime:0.131585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32333886 LIMIT 2 [ RunTime:0.024823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32333886 ORDER BY `minOrder` ASC [ RunTime:0.036151s ]
select * from pdf where partno='56433' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.013208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56433' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.031528s ]
SELECT `id` FROM `stock` WHERE `id` <> 32333886 AND `partno` = '56433' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.025018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32333885 LIMIT 5 [ RunTime:0.018321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32333885 ORDER BY `minOrder` ASC [ RunTime:0.078544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32333885 ORDER BY `unit` DESC [ RunTime:0.015192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32333885 LIMIT 2 [ RunTime:0.034779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32333885 ORDER BY `minOrder` ASC [ RunTime:0.001411s ]
select * from pdf where partno='56432' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.036982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '56432' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.018499s ]
SELECT `id` FROM `stock` WHERE `id` <> 32333885 AND `partno` = '56432' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.031269s ]
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 '5643%' OR `brand` LIKE '5643%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032897s ]
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 '5643%' OR `brand` LIKE '5643%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028173s ]
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 '5643%' OR `brand` LIKE '5643%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044657s ]
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 '5643%' OR `brand` LIKE '5643%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065979s ]
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 '5643%' OR `brand` LIKE '5643%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040972s ]
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 '5643%' OR `brand` LIKE '5643%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075469s ]
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 '5643%' OR `brand` LIKE '5643%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018334s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5643%' OR `brand` LIKE '5643%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.045355s ]