SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002378s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.135' , `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=573&search=1' [ RunTime:0.003205s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001315s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002205s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001564s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.135' ) [ RunTime:0.000562s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001842s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000535s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001628s ]
SELECT * FROM `stock_search` WHERE `partno` = '573' LIMIT 1 [ RunTime:0.001951s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-09-18 11:30:12' WHERE `partno` = '573' [ RunTime:0.002873s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002330s ]
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 '573%' OR `brand` LIKE '573%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013993s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18602310 LIMIT 5 [ RunTime:0.000782s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18602310 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18602310 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18602310 LIMIT 2 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18602310 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
select * from pdf where partno='573100D00010G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.003959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344664 LIMIT 5 [ RunTime:0.000760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344664 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13344664 ORDER BY `unit` DESC [ RunTime:0.000311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13344664 LIMIT 2 [ RunTime:0.000281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344664 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18665252 LIMIT 5 [ RunTime:0.001311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18665252 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18665252 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18665252 LIMIT 2 [ RunTime:0.000274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18665252 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593450 LIMIT 5 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593450 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593450 ORDER BY `unit` DESC [ RunTime:0.000271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593450 LIMIT 2 [ RunTime:0.000264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593450 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2887 LIMIT 5 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2887 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2887 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2887 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2887 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573300D00010G' OR `brand` LIKE 'BOYD%' ) ) LIMIT 1 [ RunTime:0.000626s ]
SELECT `id` FROM `stock` WHERE `id` <> 2887 AND `partno` = '573300D00010G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd%' ) [ RunTime:0.000517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18602305 [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18602353 LIMIT 5 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18602353 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18602353 ORDER BY `unit` DESC [ RunTime:0.000300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18602353 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18602353 ORDER BY `minOrder` ASC [ RunTime:0.000295s ]
select * from pdf where partno='573100D00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18642126 LIMIT 5 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18642126 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18642126 ORDER BY `unit` DESC [ RunTime:0.000255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18642126 LIMIT 2 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18642126 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
select * from pdf where partno='573400D00010G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300752 LIMIT 5 [ RunTime:0.000560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300752 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300752 ORDER BY `unit` DESC [ RunTime:0.000328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300752 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300752 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
select * from pdf where partno='5739-0-18-15-12-27-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.002902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16976042 LIMIT 5 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16976042 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16976042 ORDER BY `unit` DESC [ RunTime:0.000284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16976042 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16976042 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16971089 LIMIT 5 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16971089 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16971089 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16971089 LIMIT 2 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16971089 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
select * from pdf where partno='573300D00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18602305 LIMIT 5 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18602305 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18602305 ORDER BY `unit` DESC [ RunTime:0.000292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18602305 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18602305 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
select * from pdf where partno='573300D00010G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16980572 LIMIT 5 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16980572 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16980572 ORDER BY `unit` DESC [ RunTime:0.000283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16980572 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16980572 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
select * from pdf where partno='573400D00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12566218 LIMIT 5 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12566218 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12566218 ORDER BY `unit` DESC [ RunTime:0.000235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12566218 LIMIT 2 [ RunTime:0.000227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12566218 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15261816 LIMIT 5 [ RunTime:0.000855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15261816 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15261816 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15261816 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15261816 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18961522 LIMIT 5 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961522 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18961522 ORDER BY `unit` DESC [ RunTime:0.000279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18961522 LIMIT 2 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961522 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
select * from pdf where partno='5732' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13427241 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13427241 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13427241 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13427241 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13427241 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982316 LIMIT 5 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982316 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982316 ORDER BY `unit` DESC [ RunTime:0.000277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982316 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982316 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705917 LIMIT 5 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705917 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18705917 ORDER BY `unit` DESC [ RunTime:0.000279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18705917 LIMIT 2 [ RunTime:0.000267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705917 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12003985 LIMIT 5 [ RunTime:0.000516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12003985 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12003985 ORDER BY `unit` DESC [ RunTime:0.000284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12003985 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12003985 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12393807 LIMIT 5 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12393807 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12393807 ORDER BY `unit` DESC [ RunTime:0.000276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12393807 LIMIT 2 [ RunTime:0.000280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12393807 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
select * from pdf where partno='5736' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000929s ]
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 '573%' OR `brand` LIKE '573%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32290307 LIMIT 5 [ RunTime:0.000509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290307 ORDER BY `minOrder` ASC [ RunTime:0.001012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32290307 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32290307 LIMIT 2 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32290307 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
select * from pdf where partno='573400d00000g' and brandshort='aavid' limit 1 [ RunTime:0.000997s ]
select foldpath,foldpath2,filename from pdf_file where id=1219110 limit 1 [ RunTime:0.000575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573400d00000g' OR `brand` LIKE 'aavid%' ) ) LIMIT 1 [ RunTime:0.000970s ]
SELECT `id` FROM `stock` WHERE `id` <> 32290307 AND `partno` = '573400d00000g' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aavid%' ) [ RunTime:0.000709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32235967 LIMIT 5 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235967 ORDER BY `minOrder` ASC [ RunTime:0.000825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32235967 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32235967 LIMIT 2 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32235967 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
select * from pdf where partno='5733' and brandshort='adafruit' limit 1 [ RunTime:0.000990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5733' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.001336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32284236 LIMIT 5 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284236 ORDER BY `minOrder` ASC [ RunTime:0.000996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32284236 ORDER BY `unit` DESC [ RunTime:0.000496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32284236 LIMIT 2 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284236 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
select * from pdf where partno='5738' and brandshort='pomona electronics' limit 1 [ RunTime:0.001095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5738' OR `brand` LIKE 'pomona electronics%' ) ) LIMIT 1 [ RunTime:0.001879s ]
SELECT `id` FROM `stock` WHERE `id` <> 32284236 AND `partno` = '5738' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.001001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13276392 [ RunTime:0.000835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081759 LIMIT 5 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081759 ORDER BY `minOrder` ASC [ RunTime:0.001006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51081759 ORDER BY `unit` DESC [ RunTime:0.000507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51081759 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081759 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='57380' and brandshort='murrelektronik' limit 1 [ RunTime:0.000791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '57380' OR `brand` LIKE 'murrelektronik%' ) ) LIMIT 1 [ RunTime:0.000685s ]
SELECT `id` FROM `stock` WHERE `id` <> 51081759 AND `partno` = '57380' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik%' ) [ RunTime:0.000940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32569904 [ RunTime:0.000516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212370 LIMIT 5 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212370 ORDER BY `minOrder` ASC [ RunTime:0.000997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212370 ORDER BY `unit` DESC [ RunTime:0.000527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212370 LIMIT 2 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212370 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
select * from pdf where partno='5730e' and brandshort='ohmite' limit 1 [ RunTime:0.000819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5730e' OR `brand` LIKE 'ohmite%' ) ) LIMIT 1 [ RunTime:0.003324s ]
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 '573%' OR `brand` LIKE '573%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43885933 LIMIT 5 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43885933 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43885933 ORDER BY `unit` DESC [ RunTime:0.000277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43885933 LIMIT 2 [ RunTime:0.000259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43885933 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='573300D00010G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573300D00010G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.000453s ]
SELECT `id` FROM `stock` WHERE `id` <> 43885933 AND `partno` = '573300D00010G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18602305 [ RunTime:0.000352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43885422 LIMIT 5 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43885422 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43885422 ORDER BY `unit` DESC [ RunTime:0.000272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43885422 LIMIT 2 [ RunTime:0.000263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43885422 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='573100D00010G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573100D00010G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.000624s ]
SELECT `id` FROM `stock` WHERE `id` <> 43885422 AND `partno` = '573100D00010G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.000512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18602310 [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43885225 LIMIT 5 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43885225 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43885225 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43885225 LIMIT 2 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43885225 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
select * from pdf where partno='573902B04000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.001364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573902B04000G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.000568s ]
SELECT `id` FROM `stock` WHERE `id` <> 43885225 AND `partno` = '573902B04000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.000562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18665252 [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67122560 LIMIT 5 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67122560 ORDER BY `minOrder` ASC [ RunTime:0.002016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67122560 ORDER BY `unit` DESC [ RunTime:0.000713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67122560 LIMIT 2 [ RunTime:0.000499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67122560 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
select * from pdf where partno='5731-0-00-15-00-00-03-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5731-0-00-15-00-00-03-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000603s ]
SELECT `id` FROM `stock` WHERE `id` <> 67122560 AND `partno` = '5731-0-00-15-00-00-03-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.000640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593450 [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43884275 LIMIT 5 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884275 ORDER BY `minOrder` ASC [ RunTime:0.003458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43884275 ORDER BY `unit` DESC [ RunTime:0.000723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43884275 LIMIT 2 [ RunTime:0.000832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884275 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
select * from pdf where partno='573300D00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000700s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573300D00000G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.000752s ]
SELECT `id` FROM `stock` WHERE `id` <> 43884275 AND `partno` = '573300D00000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.001038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16971089 [ RunTime:0.000831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43884604 LIMIT 5 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884604 ORDER BY `minOrder` ASC [ RunTime:0.003467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43884604 ORDER BY `unit` DESC [ RunTime:0.000531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43884604 LIMIT 2 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884604 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='573100D00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573100D00000G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.000586s ]
SELECT `id` FROM `stock` WHERE `id` <> 43884604 AND `partno` = '573100D00000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.000605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18602353 [ RunTime:0.000797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43884977 LIMIT 5 [ RunTime:0.000709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884977 ORDER BY `minOrder` ASC [ RunTime:0.001306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43884977 ORDER BY `unit` DESC [ RunTime:0.000722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43884977 LIMIT 2 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884977 ORDER BY `minOrder` ASC [ RunTime:0.000803s ]
select * from pdf where partno='573400D00010G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573400D00010G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.000931s ]
SELECT `id` FROM `stock` WHERE `id` <> 43884977 AND `partno` = '573400D00010G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.001067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18642126 [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43884929 LIMIT 5 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884929 ORDER BY `minOrder` ASC [ RunTime:0.000864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43884929 ORDER BY `unit` DESC [ RunTime:0.000459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43884929 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884929 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
select * from pdf where partno='573400D00000G' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.000735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573400D00000G' OR `brand` LIKE 'Boyd Laconia, LLC%' ) ) LIMIT 1 [ RunTime:0.000629s ]
SELECT `id` FROM `stock` WHERE `id` <> 43884929 AND `partno` = '573400D00000G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%boyd laconia, llc%' ) [ RunTime:0.001094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16980572 [ RunTime:0.000850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67125583 LIMIT 5 [ RunTime:0.000772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67125583 ORDER BY `minOrder` ASC [ RunTime:0.001342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67125583 ORDER BY `unit` DESC [ RunTime:0.000741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67125583 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67125583 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
select * from pdf where partno='5739-0-18-15-12-27-10-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5739-0-18-15-12-27-10-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000904s ]
SELECT `id` FROM `stock` WHERE `id` <> 67125583 AND `partno` = '5739-0-18-15-12-27-10-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.001004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300752 [ RunTime:0.000766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71326665 LIMIT 5 [ RunTime:0.000765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71326665 ORDER BY `minOrder` ASC [ RunTime:0.002239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71326665 ORDER BY `unit` DESC [ RunTime:0.000696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71326665 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71326665 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
select * from pdf where partno='5733' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5733' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000773s ]
SELECT `id` FROM `stock` WHERE `id` <> 71326665 AND `partno` = '5733' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12566218 [ RunTime:0.000779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64573926 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64573926 ORDER BY `minOrder` ASC [ RunTime:0.003683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64573926 ORDER BY `unit` DESC [ RunTime:0.000726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64573926 LIMIT 2 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64573926 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
select * from pdf where partno='573CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003667s ]
SELECT `id` FROM `stock` WHERE `id` <> 64573926 AND `partno` = '573CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344664 [ RunTime:0.000746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69975718 LIMIT 5 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69975718 ORDER BY `minOrder` ASC [ RunTime:0.001206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69975718 ORDER BY `unit` DESC [ RunTime:0.000593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69975718 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69975718 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
select * from pdf where partno='5734' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5734' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000719s ]
SELECT `id` FROM `stock` WHERE `id` <> 69975718 AND `partno` = '5734' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196041 [ RunTime:0.001064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65390127 LIMIT 5 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65390127 ORDER BY `minOrder` ASC [ RunTime:0.001121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65390127 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65390127 LIMIT 2 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65390127 ORDER BY `minOrder` ASC [ RunTime:0.000759s ]
select * from pdf where partno='5739' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5739' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000818s ]
SELECT `id` FROM `stock` WHERE `id` <> 65390127 AND `partno` = '5739' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12169615 [ RunTime:0.000937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69975719 LIMIT 5 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69975719 ORDER BY `minOrder` ASC [ RunTime:0.000759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69975719 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69975719 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69975719 ORDER BY `minOrder` ASC [ RunTime:0.000749s ]
select * from pdf where partno='5735' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5735' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000826s ]
SELECT `id` FROM `stock` WHERE `id` <> 69975719 AND `partno` = '5735' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982316 [ RunTime:0.000653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65390141 LIMIT 5 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65390141 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65390141 ORDER BY `unit` DESC [ RunTime:0.000625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65390141 LIMIT 2 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65390141 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
select * from pdf where partno='5730' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5730' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000877s ]
SELECT `id` FROM `stock` WHERE `id` <> 65390141 AND `partno` = '5730' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11185380 [ RunTime:0.002413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41425915 LIMIT 5 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41425915 ORDER BY `minOrder` ASC [ RunTime:0.001167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41425915 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41425915 LIMIT 2 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41425915 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
select * from pdf where partno='5731' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5731' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000940s ]
SELECT `id` FROM `stock` WHERE `id` <> 41425915 AND `partno` = '5731' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15261816 [ RunTime:0.000649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41425930 LIMIT 5 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41425930 ORDER BY `minOrder` ASC [ RunTime:0.000825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41425930 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41425930 LIMIT 2 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41425930 ORDER BY `minOrder` ASC [ RunTime:0.000742s ]
select * from pdf where partno='5732' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5732' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000789s ]
SELECT `id` FROM `stock` WHERE `id` <> 41425930 AND `partno` = '5732' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18961522 [ RunTime:0.000694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65373951 LIMIT 5 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65373951 ORDER BY `minOrder` ASC [ RunTime:0.001082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65373951 ORDER BY `unit` DESC [ RunTime:0.000631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65373951 LIMIT 2 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65373951 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
select * from pdf where partno='573E' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.000779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '573E' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.001264s ]
SELECT `id` FROM `stock` WHERE `id` <> 65373951 AND `partno` = '573E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.001034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705917 [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70311245 LIMIT 5 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70311245 ORDER BY `minOrder` ASC [ RunTime:0.001027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70311245 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70311245 LIMIT 2 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70311245 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
select * from pdf where partno='5739' and brandshort='Pomona Electronics' limit 1 [ RunTime:0.000963s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5739' OR `brand` LIKE 'Pomona Electronics%' ) ) LIMIT 1 [ RunTime:0.001467s ]
SELECT `id` FROM `stock` WHERE `id` <> 70311245 AND `partno` = '5739' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pomona electronics%' ) [ RunTime:0.002007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12003985 [ RunTime:0.000647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65283013 LIMIT 5 [ RunTime:0.000763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65283013 ORDER BY `minOrder` ASC [ RunTime:0.001208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65283013 ORDER BY `unit` DESC [ RunTime:0.000560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65283013 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65283013 ORDER BY `minOrder` ASC [ RunTime:0.000662s ]
select * from pdf where partno='5737' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5737' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000838s ]
SELECT `id` FROM `stock` WHERE `id` <> 65283013 AND `partno` = '5737' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000904s ]
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 '573%' OR `brand` LIKE '573%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001180s ]
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 '573%' OR `brand` LIKE '573%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001239s ]
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 '573%' OR `brand` LIKE '573%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001138s ]
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 '573%' OR `brand` LIKE '573%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001155s ]
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 '573%' OR `brand` LIKE '573%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001044s ]
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 '573%' OR `brand` LIKE '573%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001207s ]
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 '573%' OR `brand` LIKE '573%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001082s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '573%' OR `brand` LIKE '573%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002806s ]