SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002734s ]
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=PH50&search=1' [ RunTime:0.002904s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002666s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002101s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002372s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.003792s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003004s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002956s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002101s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PH50' LIMIT 1 [ RunTime:0.007207s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-17 00:37:47' WHERE `partno` = 'PH50' [ RunTime:0.004007s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002109s ]
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 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015996s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18990319 LIMIT 5 [ RunTime:0.008512s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18990319 ORDER BY `minOrder` ASC [ RunTime:0.053443s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18990319 ORDER BY `unit` DESC [ RunTime:0.008713s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18990319 LIMIT 2 [ RunTime:0.034979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18990319 ORDER BY `minOrder` ASC [ RunTime:0.004217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14762946 LIMIT 5 [ RunTime:0.014401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14762946 ORDER BY `minOrder` ASC [ RunTime:0.019086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14762946 ORDER BY `unit` DESC [ RunTime:0.057988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14762946 LIMIT 2 [ RunTime:0.062026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14762946 ORDER BY `minOrder` ASC [ RunTime:0.090585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16653670 LIMIT 5 [ RunTime:0.053367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653670 ORDER BY `minOrder` ASC [ RunTime:0.028374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16653670 ORDER BY `unit` DESC [ RunTime:0.023849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16653670 LIMIT 2 [ RunTime:0.043687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653670 ORDER BY `minOrder` ASC [ RunTime:0.005663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16653669 LIMIT 5 [ RunTime:0.034226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653669 ORDER BY `minOrder` ASC [ RunTime:0.028627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16653669 ORDER BY `unit` DESC [ RunTime:0.048197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16653669 LIMIT 2 [ RunTime:0.057615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653669 ORDER BY `minOrder` ASC [ RunTime:0.042015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16653668 LIMIT 5 [ RunTime:0.045603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653668 ORDER BY `minOrder` ASC [ RunTime:0.052350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16653668 ORDER BY `unit` DESC [ RunTime:0.036313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16653668 LIMIT 2 [ RunTime:0.060658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653668 ORDER BY `minOrder` ASC [ RunTime:0.032673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16653667 LIMIT 5 [ RunTime:0.043439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653667 ORDER BY `minOrder` ASC [ RunTime:0.058909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16653667 ORDER BY `unit` DESC [ RunTime:0.025802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16653667 LIMIT 2 [ RunTime:0.009856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653667 ORDER BY `minOrder` ASC [ RunTime:0.007816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16653666 LIMIT 5 [ RunTime:0.007884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653666 ORDER BY `minOrder` ASC [ RunTime:0.024027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16653666 ORDER BY `unit` DESC [ RunTime:0.011773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16653666 LIMIT 2 [ RunTime:0.019109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653666 ORDER BY `minOrder` ASC [ RunTime:0.004627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16653665 LIMIT 5 [ RunTime:0.003258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653665 ORDER BY `minOrder` ASC [ RunTime:0.020992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16653665 ORDER BY `unit` DESC [ RunTime:0.022303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16653665 LIMIT 2 [ RunTime:0.014266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16653665 ORDER BY `minOrder` ASC [ RunTime:0.001322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652241 LIMIT 5 [ RunTime:0.004479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652241 ORDER BY `minOrder` ASC [ RunTime:0.005677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652241 ORDER BY `unit` DESC [ RunTime:0.001002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652241 LIMIT 2 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652241 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652134 LIMIT 5 [ RunTime:0.009478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652134 ORDER BY `minOrder` ASC [ RunTime:0.013253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16652134 ORDER BY `unit` DESC [ RunTime:0.031814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16652134 LIMIT 2 [ RunTime:0.011049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16652134 ORDER BY `minOrder` ASC [ RunTime:0.004221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16645344 LIMIT 5 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16645344 ORDER BY `minOrder` ASC [ RunTime:0.006099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16645344 ORDER BY `unit` DESC [ RunTime:0.000588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16645344 LIMIT 2 [ RunTime:0.001529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16645344 ORDER BY `minOrder` ASC [ RunTime:0.035720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16645343 LIMIT 5 [ RunTime:0.002585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16645343 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16645343 ORDER BY `unit` DESC [ RunTime:0.000237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16645343 LIMIT 2 [ RunTime:0.000211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16645343 ORDER BY `minOrder` ASC [ RunTime:0.000224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14792179 LIMIT 5 [ RunTime:0.001117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14792179 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14792179 ORDER BY `unit` DESC [ RunTime:0.005681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14792179 LIMIT 2 [ RunTime:0.008820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14792179 ORDER BY `minOrder` ASC [ RunTime:0.004577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14792178 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14792178 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14792178 ORDER BY `unit` DESC [ RunTime:0.001532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14792178 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14792178 ORDER BY `minOrder` ASC [ RunTime:0.000250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14791101 LIMIT 5 [ RunTime:0.000763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14791101 ORDER BY `minOrder` ASC [ RunTime:0.004016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14791101 ORDER BY `unit` DESC [ RunTime:0.018007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14791101 LIMIT 2 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14791101 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14790438 LIMIT 5 [ RunTime:0.000920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790438 ORDER BY `minOrder` ASC [ RunTime:0.010613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14790438 ORDER BY `unit` DESC [ RunTime:0.003002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14790438 LIMIT 2 [ RunTime:0.005825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14790438 ORDER BY `minOrder` ASC [ RunTime:0.004597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14762947 LIMIT 5 [ RunTime:0.018599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14762947 ORDER BY `minOrder` ASC [ RunTime:0.005415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14762947 ORDER BY `unit` DESC [ RunTime:0.020936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14762947 LIMIT 2 [ RunTime:0.003137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14762947 ORDER BY `minOrder` ASC [ RunTime:0.027222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13897586 LIMIT 5 [ RunTime:0.016457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13897586 ORDER BY `minOrder` ASC [ RunTime:0.018816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13897586 ORDER BY `unit` DESC [ RunTime:0.010559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13897586 LIMIT 2 [ RunTime:0.005760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13897586 ORDER BY `minOrder` ASC [ RunTime:0.000913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13897585 LIMIT 5 [ RunTime:0.008263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13897585 ORDER BY `minOrder` ASC [ RunTime:0.016268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13897585 ORDER BY `unit` DESC [ RunTime:0.015957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13897585 LIMIT 2 [ RunTime:0.001313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13897585 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13897584 LIMIT 5 [ RunTime:0.001001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13897584 ORDER BY `minOrder` ASC [ RunTime:0.002958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13897584 ORDER BY `unit` DESC [ RunTime:0.003462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13897584 LIMIT 2 [ RunTime:0.010098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13897584 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
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 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011312s ]
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 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58592841 LIMIT 5 [ RunTime:0.007916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58592841 ORDER BY `minOrder` ASC [ RunTime:0.005600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58592841 ORDER BY `unit` DESC [ RunTime:0.009935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58592841 LIMIT 2 [ RunTime:0.004099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58592841 ORDER BY `minOrder` ASC [ RunTime:0.001979s ]
select * from pdf where partno='PH50' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.006971s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH50' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.016748s ]
SELECT `id` FROM `stock` WHERE `id` <> 58592841 AND `partno` = 'PH50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.015771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18990319 [ RunTime:0.013617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64362316 LIMIT 5 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64362316 ORDER BY `minOrder` ASC [ RunTime:0.000778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64362316 ORDER BY `unit` DESC [ RunTime:0.003000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64362316 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64362316 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
select * from pdf where partno='PH50A280-48' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.004381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH50A280-48' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.006546s ]
SELECT `id` FROM `stock` WHERE `id` <> 64362316 AND `partno` = 'PH50A280-48' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.004081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16645344 [ RunTime:0.008803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64362315 LIMIT 5 [ RunTime:0.002074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64362315 ORDER BY `minOrder` ASC [ RunTime:0.003319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64362315 ORDER BY `unit` DESC [ RunTime:0.007184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64362315 LIMIT 2 [ RunTime:0.007844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64362315 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
select * from pdf where partno='PH50A280-12' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.000691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH50A280-12' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.000844s ]
SELECT `id` FROM `stock` WHERE `id` <> 64362315 AND `partno` = 'PH50A280-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16645343 [ RunTime:0.000539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64361373 LIMIT 5 [ RunTime:0.007240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64361373 ORDER BY `minOrder` ASC [ RunTime:0.019084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64361373 ORDER BY `unit` DESC [ RunTime:0.004226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64361373 LIMIT 2 [ RunTime:0.018696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64361373 ORDER BY `minOrder` ASC [ RunTime:0.012796s ]
select * from pdf where partno='PH50S280-15' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.021485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH50S280-15' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.003796s ]
SELECT `id` FROM `stock` WHERE `id` <> 64361373 AND `partno` = 'PH50S280-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.010903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13888485 [ RunTime:0.008613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64317546 LIMIT 5 [ RunTime:0.004625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64317546 ORDER BY `minOrder` ASC [ RunTime:0.003717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64317546 ORDER BY `unit` DESC [ RunTime:0.005085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64317546 LIMIT 2 [ RunTime:0.013981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64317546 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
select * from pdf where partno='PH50A280-5' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.001387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH50A280-5' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.001717s ]
SELECT `id` FROM `stock` WHERE `id` <> 64317546 AND `partno` = 'PH50A280-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.001273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14762946 [ RunTime:0.004590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64315096 LIMIT 5 [ RunTime:0.005126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64315096 ORDER BY `minOrder` ASC [ RunTime:0.011288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64315096 ORDER BY `unit` DESC [ RunTime:0.001000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64315096 LIMIT 2 [ RunTime:0.001205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64315096 ORDER BY `minOrder` ASC [ RunTime:0.000576s ]
select * from pdf where partno='PH50A280-24' and brandshort='TDK-Lambda' limit 1 [ RunTime:0.001432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH50A280-24' OR `brand` LIKE 'TDK-Lambda%' ) ) LIMIT 1 [ RunTime:0.003630s ]
SELECT `id` FROM `stock` WHERE `id` <> 64315096 AND `partno` = 'PH50A280-24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tdk-lambda%' ) [ RunTime:0.003970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14762947 [ RunTime:0.001456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63175788 LIMIT 5 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63175788 ORDER BY `minOrder` ASC [ RunTime:0.003484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63175788 ORDER BY `unit` DESC [ RunTime:0.006978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63175788 LIMIT 2 [ RunTime:0.002379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63175788 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
select * from pdf where partno='PH50060' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.001690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH50060' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.000881s ]
SELECT `id` FROM `stock` WHERE `id` <> 63175788 AND `partno` = 'PH50060' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.000825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63175684 LIMIT 5 [ RunTime:0.014414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63175684 ORDER BY `minOrder` ASC [ RunTime:0.009174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63175684 ORDER BY `unit` DESC [ RunTime:0.001066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63175684 LIMIT 2 [ RunTime:0.007000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63175684 ORDER BY `minOrder` ASC [ RunTime:0.007131s ]
select * from pdf where partno='PH5016' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.002257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH5016' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.006909s ]
SELECT `id` FROM `stock` WHERE `id` <> 63175684 AND `partno` = 'PH5016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.008658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63175581 LIMIT 5 [ RunTime:0.010973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63175581 ORDER BY `minOrder` ASC [ RunTime:0.015672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63175581 ORDER BY `unit` DESC [ RunTime:0.012095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63175581 LIMIT 2 [ RunTime:0.008020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63175581 ORDER BY `minOrder` ASC [ RunTime:0.009574s ]
select * from pdf where partno='PH5011' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.012251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH5011' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.001077s ]
SELECT `id` FROM `stock` WHERE `id` <> 63175581 AND `partno` = 'PH5011' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.020926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44070084 LIMIT 5 [ RunTime:0.004614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44070084 ORDER BY `minOrder` ASC [ RunTime:0.002162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44070084 ORDER BY `unit` DESC [ RunTime:0.006643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44070084 LIMIT 2 [ RunTime:0.003802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44070084 ORDER BY `minOrder` ASC [ RunTime:0.009772s ]
select * from pdf where partno='PH5030ALS,115' and brandshort='NXP USA Inc.' limit 1 [ RunTime:0.021605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH5030ALS,115' OR `brand` LIKE 'NXP USA Inc.%' ) ) LIMIT 1 [ RunTime:0.008643s ]
SELECT `id` FROM `stock` WHERE `id` <> 44070084 AND `partno` = 'PH5030ALS,115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nxp usa inc.%' ) [ RunTime:0.006385s ]
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 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028568s ]
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 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036554s ]
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 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032029s ]
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 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032103s ]
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 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027290s ]
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 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017954s ]
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 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32122955 LIMIT 5 [ RunTime:0.010422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32122955 ORDER BY `minOrder` ASC [ RunTime:0.057076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32122955 ORDER BY `unit` DESC [ RunTime:0.005257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32122955 LIMIT 2 [ RunTime:0.023874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32122955 ORDER BY `minOrder` ASC [ RunTime:0.025429s ]
select * from pdf where partno='PH50V100M8X11' and brandshort='JIERR' limit 1 [ RunTime:0.023567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH50V100M8X11' OR `brand` LIKE 'JIERR(捷而瑞)%' ) ) LIMIT 1 [ RunTime:0.033921s ]
SELECT `id` FROM `stock` WHERE `id` <> 32122955 AND `partno` = 'PH50V100M8X11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jierr%' ) [ RunTime:0.011331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32138486 [ RunTime:0.019723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32138486 LIMIT 5 [ RunTime:0.027639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32138486 ORDER BY `minOrder` ASC [ RunTime:0.054312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32138486 ORDER BY `unit` DESC [ RunTime:0.027887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32138486 LIMIT 2 [ RunTime:0.014313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32138486 ORDER BY `minOrder` ASC [ RunTime:0.007192s ]
select * from pdf where partno='PH50V100M8X11' and brandshort='JIERR' limit 1 [ RunTime:0.006078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PH50V100M8X11' OR `brand` LIKE 'JIERR(捷而瑞)%' ) ) LIMIT 1 [ RunTime:0.008503s ]
SELECT `id` FROM `stock` WHERE `id` <> 32138486 AND `partno` = 'PH50V100M8X11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jierr%' ) [ RunTime:0.045621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32122955 [ RunTime:0.012676s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PH50%' OR `brand` LIKE 'PH50%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016215s ]