SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002379s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=4825&search=1' [ RunTime:0.001980s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001956s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000475s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003425s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000452s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002184s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002292s ]
SELECT * FROM `stock_search` WHERE `partno` = '4825' LIMIT 1 [ RunTime:0.003094s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-16 06:33:49' WHERE `partno` = '4825' [ RunTime:0.003630s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001449s ]
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 '4825%' OR `brand` LIKE '4825%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025510s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609507 LIMIT 5 [ RunTime:0.006444s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609507 ORDER BY `minOrder` ASC [ RunTime:0.012144s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609507 ORDER BY `unit` DESC [ RunTime:0.002901s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609507 LIMIT 2 [ RunTime:0.007453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609507 ORDER BY `minOrder` ASC [ RunTime:0.006504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481483 LIMIT 5 [ RunTime:0.018688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481483 ORDER BY `minOrder` ASC [ RunTime:0.013813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481483 ORDER BY `unit` DESC [ RunTime:0.009089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481483 LIMIT 2 [ RunTime:0.006541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481483 ORDER BY `minOrder` ASC [ RunTime:0.004743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609870 LIMIT 5 [ RunTime:0.021961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609870 ORDER BY `minOrder` ASC [ RunTime:0.011169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609870 ORDER BY `unit` DESC [ RunTime:0.004629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609870 LIMIT 2 [ RunTime:0.019704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609870 ORDER BY `minOrder` ASC [ RunTime:0.017398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039832 LIMIT 5 [ RunTime:0.008616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039832 ORDER BY `minOrder` ASC [ RunTime:0.015717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12039832 ORDER BY `unit` DESC [ RunTime:0.006839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12039832 LIMIT 2 [ RunTime:0.011010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12039832 ORDER BY `minOrder` ASC [ RunTime:0.004895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610691 LIMIT 5 [ RunTime:0.008186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610691 ORDER BY `minOrder` ASC [ RunTime:0.005728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610691 ORDER BY `unit` DESC [ RunTime:0.004093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610691 LIMIT 2 [ RunTime:0.002298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610691 ORDER BY `minOrder` ASC [ RunTime:0.007285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610725 LIMIT 5 [ RunTime:0.006906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610725 ORDER BY `minOrder` ASC [ RunTime:0.009299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610725 ORDER BY `unit` DESC [ RunTime:0.012322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610725 LIMIT 2 [ RunTime:0.012011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610725 ORDER BY `minOrder` ASC [ RunTime:0.002281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14349149 LIMIT 5 [ RunTime:0.003436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14349149 ORDER BY `minOrder` ASC [ RunTime:0.002830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14349149 ORDER BY `unit` DESC [ RunTime:0.006015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14349149 LIMIT 2 [ RunTime:0.005155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14349149 ORDER BY `minOrder` ASC [ RunTime:0.007457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17007303 LIMIT 5 [ RunTime:0.006159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17007303 ORDER BY `minOrder` ASC [ RunTime:0.001813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17007303 ORDER BY `unit` DESC [ RunTime:0.004045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17007303 LIMIT 2 [ RunTime:0.002104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17007303 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459319 LIMIT 5 [ RunTime:0.003055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459319 ORDER BY `minOrder` ASC [ RunTime:0.006874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459319 ORDER BY `unit` DESC [ RunTime:0.003545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459319 LIMIT 2 [ RunTime:0.002801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459319 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459314 LIMIT 5 [ RunTime:0.000529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459314 ORDER BY `minOrder` ASC [ RunTime:0.001611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459314 ORDER BY `unit` DESC [ RunTime:0.000920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459314 LIMIT 2 [ RunTime:0.003739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459314 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459295 LIMIT 5 [ RunTime:0.001573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459295 ORDER BY `minOrder` ASC [ RunTime:0.001477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459295 ORDER BY `unit` DESC [ RunTime:0.001640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459295 LIMIT 2 [ RunTime:0.003188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459295 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13374446 LIMIT 5 [ RunTime:0.001146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13374446 ORDER BY `minOrder` ASC [ RunTime:0.001799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13374446 ORDER BY `unit` DESC [ RunTime:0.000694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13374446 LIMIT 2 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13374446 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
select * from pdf where partno='4825' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.001768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612386 LIMIT 5 [ RunTime:0.002944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612386 ORDER BY `minOrder` ASC [ RunTime:0.001504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612386 ORDER BY `unit` DESC [ RunTime:0.001223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612386 LIMIT 2 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612386 ORDER BY `minOrder` ASC [ RunTime:0.001115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612385 LIMIT 5 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612385 ORDER BY `minOrder` ASC [ RunTime:0.001850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612385 ORDER BY `unit` DESC [ RunTime:0.001550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612385 LIMIT 2 [ RunTime:0.003305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612385 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612384 LIMIT 5 [ RunTime:0.000857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612384 ORDER BY `minOrder` ASC [ RunTime:0.000851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612384 ORDER BY `unit` DESC [ RunTime:0.000723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612384 LIMIT 2 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612384 ORDER BY `minOrder` ASC [ RunTime:0.001227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612378 LIMIT 5 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612378 ORDER BY `minOrder` ASC [ RunTime:0.001533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612378 ORDER BY `unit` DESC [ RunTime:0.001595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612378 LIMIT 2 [ RunTime:0.002032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612378 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612377 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612377 ORDER BY `minOrder` ASC [ RunTime:0.002543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612377 ORDER BY `unit` DESC [ RunTime:0.001266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612377 LIMIT 2 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612377 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611875 LIMIT 5 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611875 ORDER BY `minOrder` ASC [ RunTime:0.002536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12611875 ORDER BY `unit` DESC [ RunTime:0.002055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12611875 LIMIT 2 [ RunTime:0.000980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611875 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12016386 LIMIT 5 [ RunTime:0.000930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12016386 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12016386 ORDER BY `unit` DESC [ RunTime:0.000441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12016386 LIMIT 2 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12016386 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11483384 LIMIT 5 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483384 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11483384 ORDER BY `unit` DESC [ RunTime:0.000648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11483384 LIMIT 2 [ RunTime:0.001263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11483384 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
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 '4825%' OR `brand` LIKE '4825%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257998 LIMIT 5 [ RunTime:0.005227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257998 ORDER BY `minOrder` ASC [ RunTime:0.004113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257998 ORDER BY `unit` DESC [ RunTime:0.000999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257998 LIMIT 2 [ RunTime:0.003153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257998 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
select * from pdf where partno='48258-0002' and brandshort='molex' limit 1 [ RunTime:0.004096s ]
select foldpath,foldpath2,filename from pdf_file where id=766215 limit 1 [ RunTime:0.003377s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48258-0002' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.007172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257997 LIMIT 5 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257997 ORDER BY `minOrder` ASC [ RunTime:0.000952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257997 ORDER BY `unit` DESC [ RunTime:0.000526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257997 LIMIT 2 [ RunTime:0.001559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257997 ORDER BY `minOrder` ASC [ RunTime:0.001279s ]
select * from pdf where partno='48258-0001' and brandshort='molex' limit 1 [ RunTime:0.000706s ]
select foldpath,foldpath2,filename from pdf_file where id=766214 limit 1 [ RunTime:0.000577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48258-0001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.005006s ]
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 '4825%' OR `brand` LIKE '4825%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344495 LIMIT 5 [ RunTime:0.002093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344495 ORDER BY `minOrder` ASC [ RunTime:0.001042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344495 ORDER BY `unit` DESC [ RunTime:0.000280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344495 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344495 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='48254-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48254-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000292s ]
SELECT `id` FROM `stock` WHERE `id` <> 60344495 AND `partno` = '48254-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609507 [ RunTime:0.000265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344721 LIMIT 5 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344721 ORDER BY `minOrder` ASC [ RunTime:0.009918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344721 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344721 LIMIT 2 [ RunTime:0.000359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344721 ORDER BY `minOrder` ASC [ RunTime:0.001086s ]
select * from pdf where partno='48257-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48257-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004816s ]
SELECT `id` FROM `stock` WHERE `id` <> 60344721 AND `partno` = '48257-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481483 [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344513 LIMIT 5 [ RunTime:0.001310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344513 ORDER BY `minOrder` ASC [ RunTime:0.000918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344513 ORDER BY `unit` DESC [ RunTime:0.001981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344513 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344513 ORDER BY `minOrder` ASC [ RunTime:0.000959s ]
select * from pdf where partno='48251-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48251-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000448s ]
SELECT `id` FROM `stock` WHERE `id` <> 60344513 AND `partno` = '48251-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610691 [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63392263 LIMIT 5 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392263 ORDER BY `minOrder` ASC [ RunTime:0.003282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63392263 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63392263 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63392263 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='4825' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4825' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.003829s ]
SELECT `id` FROM `stock` WHERE `id` <> 63392263 AND `partno` = '4825' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.002484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12039832 [ RunTime:0.004469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58297881 LIMIT 5 [ RunTime:0.003422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297881 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58297881 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58297881 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58297881 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='4825' and brandshort='Pololu' limit 1 [ RunTime:0.000493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4825' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.000416s ]
SELECT `id` FROM `stock` WHERE `id` <> 58297881 AND `partno` = '4825' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14349149 [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623348 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623348 ORDER BY `minOrder` ASC [ RunTime:0.001071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623348 ORDER BY `unit` DESC [ RunTime:0.004027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623348 LIMIT 2 [ RunTime:0.002722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623348 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
select * from pdf where partno='4825.7' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4825.7' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000795s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623348 AND `partno` = '4825.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.001333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60349374 LIMIT 5 [ RunTime:0.001276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60349374 ORDER BY `minOrder` ASC [ RunTime:0.004092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60349374 ORDER BY `unit` DESC [ RunTime:0.002733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60349374 LIMIT 2 [ RunTime:0.000591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60349374 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='48255-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48255-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.002716s ]
SELECT `id` FROM `stock` WHERE `id` <> 60349374 AND `partno` = '48255-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60349373 LIMIT 5 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60349373 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60349373 ORDER BY `unit` DESC [ RunTime:0.000599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60349373 LIMIT 2 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60349373 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='48256-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48256-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.005239s ]
SELECT `id` FROM `stock` WHERE `id` <> 60349373 AND `partno` = '48256-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60349261 LIMIT 5 [ RunTime:0.001961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60349261 ORDER BY `minOrder` ASC [ RunTime:0.004251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60349261 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60349261 LIMIT 2 [ RunTime:0.001612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60349261 ORDER BY `minOrder` ASC [ RunTime:0.000956s ]
select * from pdf where partno='48253-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48253-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.001804s ]
SELECT `id` FROM `stock` WHERE `id` <> 60349261 AND `partno` = '48253-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.001903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611875 [ RunTime:0.000766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60348871 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60348871 ORDER BY `minOrder` ASC [ RunTime:0.001734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60348871 ORDER BY `unit` DESC [ RunTime:0.000430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60348871 LIMIT 2 [ RunTime:0.001208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60348871 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
select * from pdf where partno='48250-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48250-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000416s ]
SELECT `id` FROM `stock` WHERE `id` <> 60348871 AND `partno` = '48250-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482935 [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60347123 LIMIT 5 [ RunTime:0.002238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60347123 ORDER BY `minOrder` ASC [ RunTime:0.005613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60347123 ORDER BY `unit` DESC [ RunTime:0.004855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60347123 LIMIT 2 [ RunTime:0.001569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60347123 ORDER BY `minOrder` ASC [ RunTime:0.004817s ]
select * from pdf where partno='48258-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48258-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000462s ]
SELECT `id` FROM `stock` WHERE `id` <> 60347123 AND `partno` = '48258-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.002134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610725 [ RunTime:0.001818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60347113 LIMIT 5 [ RunTime:0.000843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60347113 ORDER BY `minOrder` ASC [ RunTime:0.001847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60347113 ORDER BY `unit` DESC [ RunTime:0.004328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60347113 LIMIT 2 [ RunTime:0.001704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60347113 ORDER BY `minOrder` ASC [ RunTime:0.002132s ]
select * from pdf where partno='48252-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.002553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48252-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.009750s ]
SELECT `id` FROM `stock` WHERE `id` <> 60347113 AND `partno` = '48252-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.004605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609870 [ RunTime:0.001247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32551079 LIMIT 5 [ RunTime:0.005618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32551079 ORDER BY `minOrder` ASC [ RunTime:0.004364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32551079 ORDER BY `unit` DESC [ RunTime:0.001795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32551079 LIMIT 2 [ RunTime:0.002723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32551079 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
select * from pdf where partno='48258001' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48258001' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001674s ]
SELECT `id` FROM `stock` WHERE `id` <> 32551079 AND `partno` = '48258001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32374474 LIMIT 5 [ RunTime:0.004028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32374474 ORDER BY `minOrder` ASC [ RunTime:0.006751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32374474 ORDER BY `unit` DESC [ RunTime:0.004872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32374474 LIMIT 2 [ RunTime:0.002161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32374474 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='48254' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.001602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48254' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.000989s ]
SELECT `id` FROM `stock` WHERE `id` <> 32374474 AND `partno` = '48254' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.001478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12016386 [ RunTime:0.004036s ]
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 '4825%' OR `brand` LIKE '4825%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001327s ]
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 '4825%' OR `brand` LIKE '4825%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001541s ]
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 '4825%' OR `brand` LIKE '4825%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004627s ]
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 '4825%' OR `brand` LIKE '4825%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005657s ]
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 '4825%' OR `brand` LIKE '4825%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001397s ]
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 '4825%' OR `brand` LIKE '4825%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001920s ]
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 '4825%' OR `brand` LIKE '4825%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002005s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4825%' OR `brand` LIKE '4825%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001335s ]