SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002015s ]
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=4747&search=1' [ RunTime:0.002824s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002135s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010980s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001842s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.001629s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001668s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009643s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001540s ]
SELECT * FROM `stock_search` WHERE `partno` = '4747' LIMIT 1 [ RunTime:0.027121s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-18 03:19:49' WHERE `partno` = '4747' [ RunTime:0.018554s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001617s ]
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 '4747%' OR `brand` LIKE '4747%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063279s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13355965 LIMIT 5 [ RunTime:0.075712s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13355965 ORDER BY `minOrder` ASC [ RunTime:0.030323s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.031682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13355965 ORDER BY `unit` DESC [ RunTime:0.016194s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13355965 LIMIT 2 [ RunTime:0.045588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13355965 ORDER BY `minOrder` ASC [ RunTime:0.006074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13466446 LIMIT 5 [ RunTime:0.080181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13466446 ORDER BY `minOrder` ASC [ RunTime:0.027395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13466446 ORDER BY `unit` DESC [ RunTime:0.050753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13466446 LIMIT 2 [ RunTime:0.064469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13466446 ORDER BY `minOrder` ASC [ RunTime:0.024076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702500 LIMIT 5 [ RunTime:0.042459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702500 ORDER BY `minOrder` ASC [ RunTime:0.076667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702500 ORDER BY `unit` DESC [ RunTime:0.039240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702500 LIMIT 2 [ RunTime:0.028951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702500 ORDER BY `minOrder` ASC [ RunTime:0.003981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682433 LIMIT 5 [ RunTime:0.019645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682433 ORDER BY `minOrder` ASC [ RunTime:0.026356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682433 ORDER BY `unit` DESC [ RunTime:0.028269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682433 LIMIT 2 [ RunTime:0.007742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682433 ORDER BY `minOrder` ASC [ RunTime:0.006255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19575359 LIMIT 5 [ RunTime:0.017547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19575359 ORDER BY `minOrder` ASC [ RunTime:0.006196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19575359 ORDER BY `unit` DESC [ RunTime:0.002380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19575359 LIMIT 2 [ RunTime:0.009730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19575359 ORDER BY `minOrder` ASC [ RunTime:0.005697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19575039 LIMIT 5 [ RunTime:0.009626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19575039 ORDER BY `minOrder` ASC [ RunTime:0.042081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19575039 ORDER BY `unit` DESC [ RunTime:0.030886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19575039 LIMIT 2 [ RunTime:0.005759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19575039 ORDER BY `minOrder` ASC [ RunTime:0.027922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18933594 LIMIT 5 [ RunTime:0.007370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18933594 ORDER BY `minOrder` ASC [ RunTime:0.018688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18933594 ORDER BY `unit` DESC [ RunTime:0.002407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18933594 LIMIT 2 [ RunTime:0.000855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18933594 ORDER BY `minOrder` ASC [ RunTime:0.002157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17758188 LIMIT 5 [ RunTime:0.012123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17758188 ORDER BY `minOrder` ASC [ RunTime:0.024965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17758188 ORDER BY `unit` DESC [ RunTime:0.031914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17758188 LIMIT 2 [ RunTime:0.018864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17758188 ORDER BY `minOrder` ASC [ RunTime:0.007312s ]
select * from pdf where partno='47473R5' and brandshort='Knowles Johanson Manufacturing' limit 1 [ RunTime:0.016592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17005777 LIMIT 5 [ RunTime:0.000996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005777 ORDER BY `minOrder` ASC [ RunTime:0.006405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17005777 ORDER BY `unit` DESC [ RunTime:0.006137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17005777 LIMIT 2 [ RunTime:0.013835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005777 ORDER BY `minOrder` ASC [ RunTime:0.010781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16391985 LIMIT 5 [ RunTime:0.002563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16391985 ORDER BY `minOrder` ASC [ RunTime:0.007164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16391985 ORDER BY `unit` DESC [ RunTime:0.017774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16391985 LIMIT 2 [ RunTime:0.002791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16391985 ORDER BY `minOrder` ASC [ RunTime:0.007058s ]
select * from pdf where partno='47470SC' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.030179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147791 LIMIT 5 [ RunTime:0.032225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147791 ORDER BY `minOrder` ASC [ RunTime:0.003053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16147791 ORDER BY `unit` DESC [ RunTime:0.016034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16147791 LIMIT 2 [ RunTime:0.018690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16147791 ORDER BY `minOrder` ASC [ RunTime:0.018234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14982083 LIMIT 5 [ RunTime:0.017697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14982083 ORDER BY `minOrder` ASC [ RunTime:0.011806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14982083 ORDER BY `unit` DESC [ RunTime:0.033596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14982083 LIMIT 2 [ RunTime:0.044756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14982083 ORDER BY `minOrder` ASC [ RunTime:0.055053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14340316 LIMIT 5 [ RunTime:0.019380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14340316 ORDER BY `minOrder` ASC [ RunTime:0.045549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14340316 ORDER BY `unit` DESC [ RunTime:0.039142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14340316 LIMIT 2 [ RunTime:0.017767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14340316 ORDER BY `minOrder` ASC [ RunTime:0.025665s ]
select * from pdf where partno='47471SC' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.041799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14339470 LIMIT 5 [ RunTime:0.040624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14339470 ORDER BY `minOrder` ASC [ RunTime:0.008575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14339470 ORDER BY `unit` DESC [ RunTime:0.035511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14339470 LIMIT 2 [ RunTime:0.040752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14339470 ORDER BY `minOrder` ASC [ RunTime:0.025613s ]
select * from pdf where partno='47470C' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.055281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458653 LIMIT 5 [ RunTime:0.022156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458653 ORDER BY `minOrder` ASC [ RunTime:0.044574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13458653 ORDER BY `unit` DESC [ RunTime:0.038684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13458653 LIMIT 2 [ RunTime:0.084374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13458653 ORDER BY `minOrder` ASC [ RunTime:0.038958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13457871 LIMIT 5 [ RunTime:0.081024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457871 ORDER BY `minOrder` ASC [ RunTime:0.030522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13457871 ORDER BY `unit` DESC [ RunTime:0.049454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13457871 LIMIT 2 [ RunTime:0.088760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13457871 ORDER BY `minOrder` ASC [ RunTime:0.057863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12701535 LIMIT 5 [ RunTime:0.046142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12701535 ORDER BY `minOrder` ASC [ RunTime:0.049803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12701535 ORDER BY `unit` DESC [ RunTime:0.083140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12701535 LIMIT 2 [ RunTime:0.080676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12701535 ORDER BY `minOrder` ASC [ RunTime:0.058687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11569266 LIMIT 5 [ RunTime:0.039255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11569266 ORDER BY `minOrder` ASC [ RunTime:0.077796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11569266 ORDER BY `unit` DESC [ RunTime:0.037501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11569266 LIMIT 2 [ RunTime:0.082451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11569266 ORDER BY `minOrder` ASC [ RunTime:0.064669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10854906 LIMIT 5 [ RunTime:0.165789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10854906 ORDER BY `minOrder` ASC [ RunTime:0.108398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10854906 ORDER BY `unit` DESC [ RunTime:0.081190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10854906 LIMIT 2 [ RunTime:0.059800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10854906 ORDER BY `minOrder` ASC [ RunTime:0.049739s ]
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 '4747%' OR `brand` LIKE '4747%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.078307s ]
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 '4747%' OR `brand` LIKE '4747%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.106929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64122768 LIMIT 5 [ RunTime:0.046315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64122768 ORDER BY `minOrder` ASC [ RunTime:0.109603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64122768 ORDER BY `unit` DESC [ RunTime:0.084147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64122768 LIMIT 2 [ RunTime:0.073807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64122768 ORDER BY `minOrder` ASC [ RunTime:0.177281s ]
select * from pdf where partno='4747.0000' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.092650s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4747.0000' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.066843s ]
SELECT `id` FROM `stock` WHERE `id` <> 64122768 AND `partno` = '4747.0000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.041100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13355965 [ RunTime:0.119962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58540625 LIMIT 5 [ RunTime:0.088475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540625 ORDER BY `minOrder` ASC [ RunTime:0.109169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58540625 ORDER BY `unit` DESC [ RunTime:0.102513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58540625 LIMIT 2 [ RunTime:0.199652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540625 ORDER BY `minOrder` ASC [ RunTime:0.056830s ]
select * from pdf where partno='4747' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.048487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4747' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.024663s ]
SELECT `id` FROM `stock` WHERE `id` <> 58540625 AND `partno` = '4747' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.063403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702500 [ RunTime:0.084484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61143820 LIMIT 5 [ RunTime:0.030708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61143820 ORDER BY `minOrder` ASC [ RunTime:0.115111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61143820 ORDER BY `unit` DESC [ RunTime:0.070287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61143820 LIMIT 2 [ RunTime:0.018734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61143820 ORDER BY `minOrder` ASC [ RunTime:0.051601s ]
select * from pdf where partno='474771-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.018391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '474771-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.049362s ]
SELECT `id` FROM `stock` WHERE `id` <> 61143820 AND `partno` = '474771-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.143991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10854906 [ RunTime:0.093371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58298493 LIMIT 5 [ RunTime:0.076707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298493 ORDER BY `minOrder` ASC [ RunTime:0.052275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58298493 ORDER BY `unit` DESC [ RunTime:0.024312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58298493 LIMIT 2 [ RunTime:0.038262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298493 ORDER BY `minOrder` ASC [ RunTime:0.036314s ]
select * from pdf where partno='4747' and brandshort='Pololu' limit 1 [ RunTime:0.024399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4747' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.043090s ]
SELECT `id` FROM `stock` WHERE `id` <> 58298493 AND `partno` = '4747' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.031741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13466446 [ RunTime:0.043179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61914328 LIMIT 5 [ RunTime:0.055032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914328 ORDER BY `minOrder` ASC [ RunTime:0.064608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61914328 ORDER BY `unit` DESC [ RunTime:0.039863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61914328 LIMIT 2 [ RunTime:0.023586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914328 ORDER BY `minOrder` ASC [ RunTime:0.036784s ]
select * from pdf where partno='47474' and brandshort='Amphenol Times Microwave Systems' limit 1 [ RunTime:0.055177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47474' OR `brand` LIKE 'Amphenol Times Microwave Systems%' ) ) LIMIT 1 [ RunTime:0.036147s ]
SELECT `id` FROM `stock` WHERE `id` <> 61914328 AND `partno` = '47474' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol times microwave systems%' ) [ RunTime:0.025342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682433 [ RunTime:0.023016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64521837 LIMIT 5 [ RunTime:0.060270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521837 ORDER BY `minOrder` ASC [ RunTime:0.045804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64521837 ORDER BY `unit` DESC [ RunTime:0.042451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64521837 LIMIT 2 [ RunTime:0.017217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64521837 ORDER BY `minOrder` ASC [ RunTime:0.007214s ]
select * from pdf where partno='47479' and brandshort='Brady Corporation' limit 1 [ RunTime:0.038846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47479' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.044476s ]
SELECT `id` FROM `stock` WHERE `id` <> 64521837 AND `partno` = '47479' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.019623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13458653 [ RunTime:0.066610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623272 LIMIT 5 [ RunTime:0.007040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623272 ORDER BY `minOrder` ASC [ RunTime:0.037042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623272 ORDER BY `unit` DESC [ RunTime:0.021140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623272 LIMIT 2 [ RunTime:0.052709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623272 ORDER BY `minOrder` ASC [ RunTime:0.026104s ]
select * from pdf where partno='4747.7' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.021152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4747.7' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.013177s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623272 AND `partno` = '4747.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.028984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59353305 LIMIT 5 [ RunTime:0.020244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59353305 ORDER BY `minOrder` ASC [ RunTime:0.035449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59353305 ORDER BY `unit` DESC [ RunTime:0.042396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59353305 LIMIT 2 [ RunTime:0.013714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59353305 ORDER BY `minOrder` ASC [ RunTime:0.013303s ]
select * from pdf where partno='474782-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.022714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '474782-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.031139s ]
SELECT `id` FROM `stock` WHERE `id` <> 59353305 AND `partno` = '474782-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.046516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16147791 [ RunTime:0.025182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59353162 LIMIT 5 [ RunTime:0.038967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59353162 ORDER BY `minOrder` ASC [ RunTime:0.048351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59353162 ORDER BY `unit` DESC [ RunTime:0.045440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59353162 LIMIT 2 [ RunTime:0.011057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59353162 ORDER BY `minOrder` ASC [ RunTime:0.039283s ]
select * from pdf where partno='474788-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.038397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '474788-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.029328s ]
SELECT `id` FROM `stock` WHERE `id` <> 59353162 AND `partno` = '474788-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.023359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19575359 [ RunTime:0.026188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59353023 LIMIT 5 [ RunTime:0.022662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59353023 ORDER BY `minOrder` ASC [ RunTime:0.059886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59353023 ORDER BY `unit` DESC [ RunTime:0.047669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59353023 LIMIT 2 [ RunTime:0.018951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59353023 ORDER BY `minOrder` ASC [ RunTime:0.012896s ]
select * from pdf where partno='474786-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.016675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '474786-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.008229s ]
SELECT `id` FROM `stock` WHERE `id` <> 59353023 AND `partno` = '474786-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.045916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19575039 [ RunTime:0.014579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58041618 LIMIT 5 [ RunTime:0.006803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041618 ORDER BY `minOrder` ASC [ RunTime:0.023395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58041618 ORDER BY `unit` DESC [ RunTime:0.014872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58041618 LIMIT 2 [ RunTime:0.036186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041618 ORDER BY `minOrder` ASC [ RunTime:0.001100s ]
select * from pdf where partno='47473' and brandshort='Knowles Johanson Manufacturing' limit 1 [ RunTime:0.012701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47473' OR `brand` LIKE 'Knowles Johanson Manufacturing%' ) ) LIMIT 1 [ RunTime:0.026696s ]
SELECT `id` FROM `stock` WHERE `id` <> 58041618 AND `partno` = '47473' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%knowles johanson manufacturing%' ) [ RunTime:0.035174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14982083 [ RunTime:0.037068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58041529 LIMIT 5 [ RunTime:0.014275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041529 ORDER BY `minOrder` ASC [ RunTime:0.006720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58041529 ORDER BY `unit` DESC [ RunTime:0.009110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58041529 LIMIT 2 [ RunTime:0.008524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58041529 ORDER BY `minOrder` ASC [ RunTime:0.001474s ]
select * from pdf where partno='47473R5' and brandshort='Knowles Johanson Manufacturing' limit 1 [ RunTime:0.003493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47473R5' OR `brand` LIKE 'Knowles Johanson Manufacturing%' ) ) LIMIT 1 [ RunTime:0.008501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40546846 LIMIT 5 [ RunTime:0.023351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546846 ORDER BY `minOrder` ASC [ RunTime:0.023980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40546846 ORDER BY `unit` DESC [ RunTime:0.018253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40546846 LIMIT 2 [ RunTime:0.013234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546846 ORDER BY `minOrder` ASC [ RunTime:0.014043s ]
select * from pdf where partno='47470C' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.010189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47470C' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.003106s ]
SELECT `id` FROM `stock` WHERE `id` <> 40546846 AND `partno` = '47470C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata power solutions inc.%' ) [ RunTime:0.016931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14339470 [ RunTime:0.025293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40546010 LIMIT 5 [ RunTime:0.018426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546010 ORDER BY `minOrder` ASC [ RunTime:0.025284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40546010 ORDER BY `unit` DESC [ RunTime:0.046611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40546010 LIMIT 2 [ RunTime:0.027135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546010 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
select * from pdf where partno='47471SC' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.006490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47471SC' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.023575s ]
SELECT `id` FROM `stock` WHERE `id` <> 40546010 AND `partno` = '47471SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata power solutions inc.%' ) [ RunTime:0.018140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14340316 [ RunTime:0.040774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40546009 LIMIT 5 [ RunTime:0.020130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546009 ORDER BY `minOrder` ASC [ RunTime:0.042452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40546009 ORDER BY `unit` DESC [ RunTime:0.062186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40546009 LIMIT 2 [ RunTime:0.014443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40546009 ORDER BY `minOrder` ASC [ RunTime:0.017944s ]
select * from pdf where partno='47470SC' and brandshort='Murata Power Solutions Inc.' limit 1 [ RunTime:0.012229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47470SC' OR `brand` LIKE 'Murata Power Solutions Inc.%' ) ) LIMIT 1 [ RunTime:0.036137s ]
SELECT `id` FROM `stock` WHERE `id` <> 40546009 AND `partno` = '47470SC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata power solutions inc.%' ) [ RunTime:0.031415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16391985 [ RunTime:0.017120s ]
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 '4747%' OR `brand` LIKE '4747%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013455s ]
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 '4747%' OR `brand` LIKE '4747%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030025s ]
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 '4747%' OR `brand` LIKE '4747%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042091s ]
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 '4747%' OR `brand` LIKE '4747%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043956s ]
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 '4747%' OR `brand` LIKE '4747%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046563s ]
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 '4747%' OR `brand` LIKE '4747%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021701s ]
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 '4747%' OR `brand` LIKE '4747%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048411s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4747%' OR `brand` LIKE '4747%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.066238s ]