SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002971s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=69120&search=1' [ RunTime:0.008582s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002343s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000635s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003441s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.004768s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002057s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000623s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002211s ]
SELECT * FROM `stock_search` WHERE `partno` = '69120' LIMIT 1 [ RunTime:0.000903s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 08:11:32' WHERE `partno` = '69120' [ RunTime:0.006483s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001261s ]
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 '69120%' OR `brand` LIKE '69120%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005698s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11435204 LIMIT 5 [ RunTime:0.006078s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435204 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11435204 ORDER BY `unit` DESC [ RunTime:0.004162s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11435204 LIMIT 2 [ RunTime:0.001291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435204 ORDER BY `minOrder` ASC [ RunTime:0.002571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556112 LIMIT 5 [ RunTime:0.002671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556112 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556112 ORDER BY `unit` DESC [ RunTime:0.000418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556112 LIMIT 2 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556112 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544158 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544158 ORDER BY `minOrder` ASC [ RunTime:0.004646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12544158 ORDER BY `unit` DESC [ RunTime:0.001959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12544158 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12544158 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18729076 LIMIT 5 [ RunTime:0.008638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18729076 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18729076 ORDER BY `unit` DESC [ RunTime:0.009437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18729076 LIMIT 2 [ RunTime:0.004591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18729076 ORDER BY `minOrder` ASC [ RunTime:0.005496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842578 LIMIT 5 [ RunTime:0.008789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842578 ORDER BY `minOrder` ASC [ RunTime:0.006190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18842578 ORDER BY `unit` DESC [ RunTime:0.022677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18842578 LIMIT 2 [ RunTime:0.018190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18842578 ORDER BY `minOrder` ASC [ RunTime:0.022608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18844854 LIMIT 5 [ RunTime:0.005436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18844854 ORDER BY `minOrder` ASC [ RunTime:0.015038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18844854 ORDER BY `unit` DESC [ RunTime:0.025910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18844854 LIMIT 2 [ RunTime:0.019596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18844854 ORDER BY `minOrder` ASC [ RunTime:0.019255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210599 LIMIT 5 [ RunTime:0.012828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210599 ORDER BY `minOrder` ASC [ RunTime:0.017985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15210599 ORDER BY `unit` DESC [ RunTime:0.019128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15210599 LIMIT 2 [ RunTime:0.032051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210599 ORDER BY `minOrder` ASC [ RunTime:0.002323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556976 LIMIT 5 [ RunTime:0.005304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556976 ORDER BY `minOrder` ASC [ RunTime:0.008660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556976 ORDER BY `unit` DESC [ RunTime:0.011944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556976 LIMIT 2 [ RunTime:0.005278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556976 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='691201820002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11444089 LIMIT 5 [ RunTime:0.012664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11444089 ORDER BY `minOrder` ASC [ RunTime:0.011746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11444089 ORDER BY `unit` DESC [ RunTime:0.009905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11444089 LIMIT 2 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11444089 ORDER BY `minOrder` ASC [ RunTime:0.007500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11443710 LIMIT 5 [ RunTime:0.027021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11443710 ORDER BY `minOrder` ASC [ RunTime:0.014801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11443710 ORDER BY `unit` DESC [ RunTime:0.002488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11443710 LIMIT 2 [ RunTime:0.015937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11443710 ORDER BY `minOrder` ASC [ RunTime:0.012916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442628 LIMIT 5 [ RunTime:0.025455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442628 ORDER BY `minOrder` ASC [ RunTime:0.006265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11442628 ORDER BY `unit` DESC [ RunTime:0.006943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11442628 LIMIT 2 [ RunTime:0.014730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442628 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='691201620002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003356s ]
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 '69120%' OR `brand` LIKE '69120%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006056s ]
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 '69120%' OR `brand` LIKE '69120%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53739355 LIMIT 5 [ RunTime:0.006862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739355 ORDER BY `minOrder` ASC [ RunTime:0.005071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53739355 ORDER BY `unit` DESC [ RunTime:0.005153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53739355 LIMIT 2 [ RunTime:0.008678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53739355 ORDER BY `minOrder` ASC [ RunTime:0.001279s ]
select * from pdf where partno='691201620002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691201620002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.007110s ]
SELECT `id` FROM `stock` WHERE `id` <> 53739355 AND `partno` = '691201620002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.012218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442628 [ RunTime:0.009663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53741837 LIMIT 5 [ RunTime:0.009946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741837 ORDER BY `minOrder` ASC [ RunTime:0.005677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53741837 ORDER BY `unit` DESC [ RunTime:0.007783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53741837 LIMIT 2 [ RunTime:0.017118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741837 ORDER BY `minOrder` ASC [ RunTime:0.004047s ]
select * from pdf where partno='691201620001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691201620001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.019715s ]
SELECT `id` FROM `stock` WHERE `id` <> 53741837 AND `partno` = '691201620001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.032434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53741240 LIMIT 5 [ RunTime:0.016793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741240 ORDER BY `minOrder` ASC [ RunTime:0.017369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53741240 ORDER BY `unit` DESC [ RunTime:0.002518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53741240 LIMIT 2 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53741240 ORDER BY `minOrder` ASC [ RunTime:0.005659s ]
select * from pdf where partno='691201820001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.008371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691201820001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.012582s ]
SELECT `id` FROM `stock` WHERE `id` <> 53741240 AND `partno` = '691201820001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.007129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556112 [ RunTime:0.032042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53738587 LIMIT 5 [ RunTime:0.006511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53738587 ORDER BY `minOrder` ASC [ RunTime:0.006079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53738587 ORDER BY `unit` DESC [ RunTime:0.019173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53738587 LIMIT 2 [ RunTime:0.016579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53738587 ORDER BY `minOrder` ASC [ RunTime:0.004256s ]
select * from pdf where partno='691201520002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691201520002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004970s ]
SELECT `id` FROM `stock` WHERE `id` <> 53738587 AND `partno` = '691201520002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12544158 [ RunTime:0.030267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53737894 LIMIT 5 [ RunTime:0.010405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737894 ORDER BY `minOrder` ASC [ RunTime:0.008851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53737894 ORDER BY `unit` DESC [ RunTime:0.003723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53737894 LIMIT 2 [ RunTime:0.005438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53737894 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='691201720002S' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691201720002S' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.005151s ]
SELECT `id` FROM `stock` WHERE `id` <> 53737894 AND `partno` = '691201720002S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53738684 LIMIT 5 [ RunTime:0.001766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53738684 ORDER BY `minOrder` ASC [ RunTime:0.014214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53738684 ORDER BY `unit` DESC [ RunTime:0.009972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53738684 LIMIT 2 [ RunTime:0.007294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53738684 ORDER BY `minOrder` ASC [ RunTime:0.003935s ]
select * from pdf where partno='691201520003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.012239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691201520003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002160s ]
SELECT `id` FROM `stock` WHERE `id` <> 53738684 AND `partno` = '691201520003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11435204 [ RunTime:0.002600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57637410 LIMIT 5 [ RunTime:0.007502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57637410 ORDER BY `minOrder` ASC [ RunTime:0.006219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57637410 ORDER BY `unit` DESC [ RunTime:0.006681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57637410 LIMIT 2 [ RunTime:0.007479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57637410 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='69120055' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.002508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69120055' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.018111s ]
SELECT `id` FROM `stock` WHERE `id` <> 57637410 AND `partno` = '69120055' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.002873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18842578 [ RunTime:0.007092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51662978 LIMIT 5 [ RunTime:0.011133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51662978 ORDER BY `minOrder` ASC [ RunTime:0.010185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51662978 ORDER BY `unit` DESC [ RunTime:0.007262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51662978 LIMIT 2 [ RunTime:0.016094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51662978 ORDER BY `minOrder` ASC [ RunTime:0.018359s ]
select * from pdf where partno='69120-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.015159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69120-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.024018s ]
SELECT `id` FROM `stock` WHERE `id` <> 51662978 AND `partno` = '69120-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.017390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44627211 LIMIT 5 [ RunTime:0.001222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44627211 ORDER BY `minOrder` ASC [ RunTime:0.010754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44627211 ORDER BY `unit` DESC [ RunTime:0.018328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44627211 LIMIT 2 [ RunTime:0.006786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44627211 ORDER BY `minOrder` ASC [ RunTime:0.003324s ]
select * from pdf where partno='69120-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.006597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69120-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.004540s ]
SELECT `id` FROM `stock` WHERE `id` <> 44627211 AND `partno` = '69120-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.011054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18729076 [ RunTime:0.011481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33108810 LIMIT 5 [ RunTime:0.011365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33108810 ORDER BY `minOrder` ASC [ RunTime:0.028743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33108810 ORDER BY `unit` DESC [ RunTime:0.028062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33108810 LIMIT 2 [ RunTime:0.024697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33108810 ORDER BY `minOrder` ASC [ RunTime:0.030888s ]
select * from pdf where partno='69120-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69120-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000518s ]
SELECT `id` FROM `stock` WHERE `id` <> 33108810 AND `partno` = '69120-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.001215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18729076 [ RunTime:0.013183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57640811 LIMIT 5 [ RunTime:0.014897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57640811 ORDER BY `minOrder` ASC [ RunTime:0.008701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57640811 ORDER BY `unit` DESC [ RunTime:0.004178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57640811 LIMIT 2 [ RunTime:0.032769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57640811 ORDER BY `minOrder` ASC [ RunTime:0.004502s ]
select * from pdf where partno='69120068' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.006507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69120068' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.011390s ]
SELECT `id` FROM `stock` WHERE `id` <> 57640811 AND `partno` = '69120068' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.005188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18844854 [ RunTime:0.011537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53746517 LIMIT 5 [ RunTime:0.013932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53746517 ORDER BY `minOrder` ASC [ RunTime:0.029356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53746517 ORDER BY `unit` DESC [ RunTime:0.004914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53746517 LIMIT 2 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53746517 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='691201620101' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691201620101' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.029444s ]
SELECT `id` FROM `stock` WHERE `id` <> 53746517 AND `partno` = '691201620101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.031914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11444089 [ RunTime:0.012626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53745528 LIMIT 5 [ RunTime:0.005415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53745528 ORDER BY `minOrder` ASC [ RunTime:0.008399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53745528 ORDER BY `unit` DESC [ RunTime:0.006584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53745528 LIMIT 2 [ RunTime:0.008404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53745528 ORDER BY `minOrder` ASC [ RunTime:0.005726s ]
select * from pdf where partno='691201820101' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.007118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691201820101' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.018145s ]
SELECT `id` FROM `stock` WHERE `id` <> 53745528 AND `partno` = '691201820101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11443710 [ RunTime:0.011921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53743452 LIMIT 5 [ RunTime:0.002621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53743452 ORDER BY `minOrder` ASC [ RunTime:0.005291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53743452 ORDER BY `unit` DESC [ RunTime:0.008411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53743452 LIMIT 2 [ RunTime:0.006027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53743452 ORDER BY `minOrder` ASC [ RunTime:0.005111s ]
select * from pdf where partno='691201820002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.005146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691201820002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.014672s ]
SELECT `id` FROM `stock` WHERE `id` <> 53743452 AND `partno` = '691201820002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556976 [ RunTime:0.012132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53742872 LIMIT 5 [ RunTime:0.012003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53742872 ORDER BY `minOrder` ASC [ RunTime:0.005824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53742872 ORDER BY `unit` DESC [ RunTime:0.007131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53742872 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53742872 ORDER BY `minOrder` ASC [ RunTime:0.004372s ]
select * from pdf where partno='691201720003S' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.030819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '691201720003S' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.025402s ]
SELECT `id` FROM `stock` WHERE `id` <> 53742872 AND `partno` = '691201720003S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51674101 LIMIT 5 [ RunTime:0.004034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674101 ORDER BY `minOrder` ASC [ RunTime:0.022775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51674101 ORDER BY `unit` DESC [ RunTime:0.015174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51674101 LIMIT 2 [ RunTime:0.007322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51674101 ORDER BY `minOrder` ASC [ RunTime:0.001962s ]
select * from pdf where partno='69120-2' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.000958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69120-2' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.003724s ]
SELECT `id` FROM `stock` WHERE `id` <> 51674101 AND `partno` = '69120-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.001325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44636775 LIMIT 5 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44636775 ORDER BY `minOrder` ASC [ RunTime:0.005404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44636775 ORDER BY `unit` DESC [ RunTime:0.016115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44636775 LIMIT 2 [ RunTime:0.058673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44636775 ORDER BY `minOrder` ASC [ RunTime:0.008235s ]
select * from pdf where partno='69120-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.024656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69120-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.010071s ]
SELECT `id` FROM `stock` WHERE `id` <> 44636775 AND `partno` = '69120-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.016820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210599 [ RunTime:0.026647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33118995 LIMIT 5 [ RunTime:0.009834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33118995 ORDER BY `minOrder` ASC [ RunTime:0.021376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33118995 ORDER BY `unit` DESC [ RunTime:0.018994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33118995 LIMIT 2 [ RunTime:0.052057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33118995 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='69120-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69120-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.005463s ]
SELECT `id` FROM `stock` WHERE `id` <> 33118995 AND `partno` = '69120-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.008871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210599 [ RunTime:0.003655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32567293 LIMIT 5 [ RunTime:0.001720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32567293 ORDER BY `minOrder` ASC [ RunTime:0.001279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32567293 ORDER BY `unit` DESC [ RunTime:0.016773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32567293 LIMIT 2 [ RunTime:0.026258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32567293 ORDER BY `minOrder` ASC [ RunTime:0.000908s ]
select * from pdf where partno='69120' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.000971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '69120' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.002079s ]
SELECT `id` FROM `stock` WHERE `id` <> 32567293 AND `partno` = '69120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.000890s ]
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 '69120%' OR `brand` LIKE '69120%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003031s ]
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 '69120%' OR `brand` LIKE '69120%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010790s ]
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 '69120%' OR `brand` LIKE '69120%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010502s ]
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 '69120%' OR `brand` LIKE '69120%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009515s ]
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 '69120%' OR `brand` LIKE '69120%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008467s ]
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 '69120%' OR `brand` LIKE '69120%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017413s ]
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 '69120%' OR `brand` LIKE '69120%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008582s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '69120%' OR `brand` LIKE '69120%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014423s ]