SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001125s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.34' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=1590l&search=1' [ RunTime:0.004257s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001631s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001091s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001920s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.34' ) [ RunTime:0.000481s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001217s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000424s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002411s ]
SELECT * FROM `stock_search` WHERE `partno` = '1590l' LIMIT 1 [ RunTime:0.000967s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-10-26 22:42:41' WHERE `partno` = '1590l' [ RunTime:0.003832s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001532s ]
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 '1590l%' OR `brand` LIKE '1590l%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004518s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15273895 LIMIT 5 [ RunTime:0.000998s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15273895 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15273895 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15273895 LIMIT 2 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15273895 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034442 LIMIT 5 [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034442 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034442 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034442 LIMIT 2 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034442 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036483 LIMIT 5 [ RunTime:0.004682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036483 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19036483 ORDER BY `unit` DESC [ RunTime:0.000535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19036483 LIMIT 2 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036483 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036480 LIMIT 5 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036480 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19036480 ORDER BY `unit` DESC [ RunTime:0.000453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19036480 LIMIT 2 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036480 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19030048 LIMIT 5 [ RunTime:0.000952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19030048 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19030048 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19030048 LIMIT 2 [ RunTime:0.000518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19030048 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
select * from pdf where partno='1590L' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.002391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19023895 LIMIT 5 [ RunTime:0.003664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19023895 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19023895 ORDER BY `unit` DESC [ RunTime:0.000321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19023895 LIMIT 2 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19023895 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277062 LIMIT 5 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277062 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15277062 ORDER BY `unit` DESC [ RunTime:0.000300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15277062 LIMIT 2 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277062 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18996467 LIMIT 5 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996467 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18996467 ORDER BY `unit` DESC [ RunTime:0.000288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18996467 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996467 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='1590LBGASKET' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19031905 LIMIT 5 [ RunTime:0.002403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19031905 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19031905 ORDER BY `unit` DESC [ RunTime:0.000300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19031905 LIMIT 2 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19031905 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032531 LIMIT 5 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032531 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19032531 ORDER BY `unit` DESC [ RunTime:0.000287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19032531 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19032531 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
select * from pdf where partno='1590LF' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19031303 LIMIT 5 [ RunTime:0.001570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19031303 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19031303 ORDER BY `unit` DESC [ RunTime:0.000283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19031303 LIMIT 2 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19031303 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='1590LBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035265 LIMIT 5 [ RunTime:0.002832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035265 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19035265 ORDER BY `unit` DESC [ RunTime:0.000283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19035265 LIMIT 2 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035265 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035015 LIMIT 5 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035015 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19035015 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19035015 LIMIT 2 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035015 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
select * from pdf where partno='1590LGY' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035369 LIMIT 5 [ RunTime:0.002705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035369 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19035369 ORDER BY `unit` DESC [ RunTime:0.000284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19035369 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19035369 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277240 LIMIT 5 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277240 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15277240 ORDER BY `unit` DESC [ RunTime:0.000316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15277240 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277240 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277164 LIMIT 5 [ RunTime:0.001427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277164 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15277164 ORDER BY `unit` DESC [ RunTime:0.000281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15277164 LIMIT 2 [ RunTime:0.000256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15277164 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037776 LIMIT 5 [ RunTime:0.000894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037776 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19037776 ORDER BY `unit` DESC [ RunTime:0.000262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19037776 LIMIT 2 [ RunTime:0.000254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19037776 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18996075 LIMIT 5 [ RunTime:0.001310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996075 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18996075 ORDER BY `unit` DESC [ RunTime:0.000288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18996075 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996075 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='1590LLBGASKET' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18996049 LIMIT 5 [ RunTime:0.000447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996049 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18996049 ORDER BY `unit` DESC [ RunTime:0.000308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18996049 LIMIT 2 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18996049 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060591 LIMIT 5 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060591 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17060591 ORDER BY `unit` DESC [ RunTime:0.000284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17060591 LIMIT 2 [ RunTime:0.000271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060591 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
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 '1590l%' OR `brand` LIKE '1590l%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71752476 LIMIT 5 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71752476 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71752476 ORDER BY `unit` DESC [ RunTime:0.000302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71752476 LIMIT 2 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71752476 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
select * from pdf where partno='1590lbflbk' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001971s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590lbflbk' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000427s ]
SELECT `id` FROM `stock` WHERE `id` <> 71752476 AND `partno` = '1590lbflbk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.001235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036480 [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71752778 LIMIT 5 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71752778 ORDER BY `minOrder` ASC [ RunTime:0.001595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71752778 ORDER BY `unit` DESC [ RunTime:0.000229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71752778 LIMIT 2 [ RunTime:0.000220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71752778 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
select * from pdf where partno='1590lbfl' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.002228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590lbfl' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000289s ]
SELECT `id` FROM `stock` WHERE `id` <> 71752778 AND `partno` = '1590lbfl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.003410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034442 [ RunTime:0.000250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71752777 LIMIT 5 [ RunTime:0.000212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71752777 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71752777 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71752777 LIMIT 2 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71752777 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
select * from pdf where partno='1590lbbk' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590lbbk' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000545s ]
SELECT `id` FROM `stock` WHERE `id` <> 71752777 AND `partno` = '1590lbbk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277062 [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71752779 LIMIT 5 [ RunTime:0.000512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71752779 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71752779 ORDER BY `unit` DESC [ RunTime:0.000465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71752779 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71752779 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='1590llb' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590llb' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000627s ]
SELECT `id` FROM `stock` WHERE `id` <> 71752779 AND `partno` = '1590llb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19023895 [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71752493 LIMIT 5 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71752493 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71752493 ORDER BY `unit` DESC [ RunTime:0.000406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71752493 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71752493 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='1590l' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590l' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000596s ]
SELECT `id` FROM `stock` WHERE `id` <> 71752493 AND `partno` = '1590l' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19030048 [ RunTime:0.000551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71753043 LIMIT 5 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71753043 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71753043 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71753043 LIMIT 2 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71753043 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
select * from pdf where partno='1590llbfl' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590llbfl' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000608s ]
SELECT `id` FROM `stock` WHERE `id` <> 71753043 AND `partno` = '1590llbfl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.002335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060591 [ RunTime:0.000542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71753042 LIMIT 5 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71753042 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71753042 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71753042 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71753042 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='1590llbbk' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590llbbk' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000602s ]
SELECT `id` FROM `stock` WHERE `id` <> 71753042 AND `partno` = '1590llbbk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036483 [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71747774 LIMIT 5 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71747774 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71747774 ORDER BY `unit` DESC [ RunTime:0.000477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71747774 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71747774 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='1590lbgasket' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590lbgasket' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000500s ]
SELECT `id` FROM `stock` WHERE `id` <> 71747774 AND `partno` = '1590lbgasket' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18996467 [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71753403 LIMIT 5 [ RunTime:0.000468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71753403 ORDER BY `minOrder` ASC [ RunTime:0.001233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71753403 ORDER BY `unit` DESC [ RunTime:0.000479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71753403 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71753403 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
select * from pdf where partno='1590llbflbk' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590llbflbk' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000599s ]
SELECT `id` FROM `stock` WHERE `id` <> 71753403 AND `partno` = '1590llbflbk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037776 [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71753041 LIMIT 5 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71753041 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71753041 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71753041 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71753041 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='1590lbfbk' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590lbfbk' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000559s ]
SELECT `id` FROM `stock` WHERE `id` <> 71753041 AND `partno` = '1590lbfbk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035265 [ RunTime:0.000519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32222891 LIMIT 5 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32222891 ORDER BY `minOrder` ASC [ RunTime:0.001142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32222891 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32222891 LIMIT 2 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32222891 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='1590llbf' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000333s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590llbf' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000518s ]
SELECT `id` FROM `stock` WHERE `id` <> 32222891 AND `partno` = '1590llbf' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277240 [ RunTime:0.000499s ]
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 '1590l%' OR `brand` LIKE '1590l%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70202474 LIMIT 5 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70202474 ORDER BY `minOrder` ASC [ RunTime:0.001002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70202474 ORDER BY `unit` DESC [ RunTime:0.000465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70202474 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70202474 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
select * from pdf where partno='1590LB' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LB' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000599s ]
SELECT `id` FROM `stock` WHERE `id` <> 70202474 AND `partno` = '1590LB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15273895 [ RunTime:0.000511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70202826 LIMIT 5 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70202826 ORDER BY `minOrder` ASC [ RunTime:0.002957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70202826 ORDER BY `unit` DESC [ RunTime:0.000460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70202826 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70202826 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='1590L' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590L' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000587s ]
SELECT `id` FROM `stock` WHERE `id` <> 70202826 AND `partno` = '1590L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19030048 [ RunTime:0.000450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70202815 LIMIT 5 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70202815 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70202815 ORDER BY `unit` DESC [ RunTime:0.000384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70202815 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70202815 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='1590LBFL' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LBFL' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000593s ]
SELECT `id` FROM `stock` WHERE `id` <> 70202815 AND `partno` = '1590LBFL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034442 [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70202882 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70202882 ORDER BY `minOrder` ASC [ RunTime:0.001014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70202882 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70202882 LIMIT 2 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70202882 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='1590LBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LBK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000568s ]
SELECT `id` FROM `stock` WHERE `id` <> 70202882 AND `partno` = '1590LBK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19031303 [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70202799 LIMIT 5 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70202799 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70202799 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70202799 LIMIT 2 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70202799 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='1590LLB' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LLB' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000620s ]
SELECT `id` FROM `stock` WHERE `id` <> 70202799 AND `partno` = '1590LLB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19023895 [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70204918 LIMIT 5 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70204918 ORDER BY `minOrder` ASC [ RunTime:0.001143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70204918 ORDER BY `unit` DESC [ RunTime:0.000394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70204918 LIMIT 2 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70204918 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='1590LBBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LBBK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000473s ]
SELECT `id` FROM `stock` WHERE `id` <> 70204918 AND `partno` = '1590LBBK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277062 [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70204910 LIMIT 5 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70204910 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70204910 ORDER BY `unit` DESC [ RunTime:0.000368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70204910 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70204910 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='1590LBFLBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LBFLBK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000457s ]
SELECT `id` FROM `stock` WHERE `id` <> 70204910 AND `partno` = '1590LBFLBK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036480 [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70232581 LIMIT 5 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70232581 ORDER BY `minOrder` ASC [ RunTime:0.000839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70232581 ORDER BY `unit` DESC [ RunTime:0.000346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70232581 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70232581 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='1590LBGASKET' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LBGASKET' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000463s ]
SELECT `id` FROM `stock` WHERE `id` <> 70232581 AND `partno` = '1590LBGASKET' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18996467 [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70205842 LIMIT 5 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70205842 ORDER BY `minOrder` ASC [ RunTime:0.000848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70205842 ORDER BY `unit` DESC [ RunTime:0.000373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70205842 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70205842 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='1590LLBBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LLBBK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000465s ]
SELECT `id` FROM `stock` WHERE `id` <> 70205842 AND `partno` = '1590LLBBK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036483 [ RunTime:0.000388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70206185 LIMIT 5 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70206185 ORDER BY `minOrder` ASC [ RunTime:0.000924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70206185 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70206185 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70206185 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='1590LF' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LF' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000482s ]
SELECT `id` FROM `stock` WHERE `id` <> 70206185 AND `partno` = '1590LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19032531 [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70206061 LIMIT 5 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70206061 ORDER BY `minOrder` ASC [ RunTime:0.000815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70206061 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70206061 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70206061 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='1590LBF' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LBF' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000464s ]
SELECT `id` FROM `stock` WHERE `id` <> 70206061 AND `partno` = '1590LBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19031905 [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70216116 LIMIT 5 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70216116 ORDER BY `minOrder` ASC [ RunTime:0.000917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70216116 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70216116 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70216116 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
select * from pdf where partno='1590LGY' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LGY' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000463s ]
SELECT `id` FROM `stock` WHERE `id` <> 70216116 AND `partno` = '1590LGY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035015 [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70215541 LIMIT 5 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70215541 ORDER BY `minOrder` ASC [ RunTime:0.002861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70215541 ORDER BY `unit` DESC [ RunTime:0.000378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70215541 LIMIT 2 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70215541 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='1590LBGY' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LBGY' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000472s ]
SELECT `id` FROM `stock` WHERE `id` <> 70215541 AND `partno` = '1590LBGY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277164 [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70211614 LIMIT 5 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70211614 ORDER BY `minOrder` ASC [ RunTime:0.003385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70211614 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70211614 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70211614 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='1590LBFBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LBFBK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000485s ]
SELECT `id` FROM `stock` WHERE `id` <> 70211614 AND `partno` = '1590LBFBK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035265 [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70211547 LIMIT 5 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70211547 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70211547 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70211547 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70211547 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='1590LLBF' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LLBF' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000478s ]
SELECT `id` FROM `stock` WHERE `id` <> 70211547 AND `partno` = '1590LLBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15277240 [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70216021 LIMIT 5 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70216021 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70216021 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70216021 LIMIT 2 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70216021 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='1590LLBFLBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LLBFLBK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000471s ]
SELECT `id` FROM `stock` WHERE `id` <> 70216021 AND `partno` = '1590LLBFLBK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037776 [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70215147 LIMIT 5 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70215147 ORDER BY `minOrder` ASC [ RunTime:0.000576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70215147 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70215147 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70215147 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='1590LLBFL' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LLBFL' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000465s ]
SELECT `id` FROM `stock` WHERE `id` <> 70215147 AND `partno` = '1590LLBFL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060591 [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70211772 LIMIT 5 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70211772 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70211772 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70211772 LIMIT 2 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70211772 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='1590LLBFBK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1590LLBFBK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000476s ]
SELECT `id` FROM `stock` WHERE `id` <> 70211772 AND `partno` = '1590LLBFBK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19035369 [ RunTime:0.000387s ]
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 '1590l%' OR `brand` LIKE '1590l%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000810s ]
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 '1590l%' OR `brand` LIKE '1590l%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000759s ]
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 '1590l%' OR `brand` LIKE '1590l%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000738s ]
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 '1590l%' OR `brand` LIKE '1590l%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000685s ]
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 '1590l%' OR `brand` LIKE '1590l%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000686s ]
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 '1590l%' OR `brand` LIKE '1590l%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000682s ]
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 '1590l%' OR `brand` LIKE '1590l%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000764s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1590l%' OR `brand` LIKE '1590l%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000881s ]