SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001841s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=SMCJ200C&search=1' [ RunTime:0.006669s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001682s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000504s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001502s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001466s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002632s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ200C' LIMIT 1 [ RunTime:0.005257s ]
UPDATE `stock_search` SET `count` = 13 , `updatetime` = '2026-08-20 17:56:30' WHERE `partno` = 'SMCJ200C' [ RunTime:0.007640s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001404s ]
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 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052012s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920854 LIMIT 5 [ RunTime:0.013025s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920854 ORDER BY `minOrder` ASC [ RunTime:0.009914s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13920854 ORDER BY `unit` DESC [ RunTime:0.014231s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13920854 LIMIT 2 [ RunTime:0.008759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920854 ORDER BY `minOrder` ASC [ RunTime:0.012595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912243 LIMIT 5 [ RunTime:0.015275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912243 ORDER BY `minOrder` ASC [ RunTime:0.003920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912243 ORDER BY `unit` DESC [ RunTime:0.021083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912243 LIMIT 2 [ RunTime:0.008262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912243 ORDER BY `minOrder` ASC [ RunTime:0.010482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819699 LIMIT 5 [ RunTime:0.019013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819699 ORDER BY `minOrder` ASC [ RunTime:0.006629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819699 ORDER BY `unit` DESC [ RunTime:0.016285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819699 LIMIT 2 [ RunTime:0.007417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819699 ORDER BY `minOrder` ASC [ RunTime:0.011216s ]
select * from pdf where partno='SMCJ200CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.020784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801130 LIMIT 5 [ RunTime:0.002758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801130 ORDER BY `minOrder` ASC [ RunTime:0.000648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801130 ORDER BY `unit` DESC [ RunTime:0.011254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801130 LIMIT 2 [ RunTime:0.004803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801130 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691096 LIMIT 5 [ RunTime:0.009522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691096 ORDER BY `minOrder` ASC [ RunTime:0.007534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691096 ORDER BY `unit` DESC [ RunTime:0.009238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691096 LIMIT 2 [ RunTime:0.008893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691096 ORDER BY `minOrder` ASC [ RunTime:0.003862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678731 LIMIT 5 [ RunTime:0.009086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678731 ORDER BY `minOrder` ASC [ RunTime:0.001330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678731 ORDER BY `unit` DESC [ RunTime:0.003266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678731 LIMIT 2 [ RunTime:0.004753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678731 ORDER BY `minOrder` ASC [ RunTime:0.001805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674319 LIMIT 5 [ RunTime:0.002955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674319 ORDER BY `minOrder` ASC [ RunTime:0.003659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674319 ORDER BY `unit` DESC [ RunTime:0.002366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674319 LIMIT 2 [ RunTime:0.001346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674319 ORDER BY `minOrder` ASC [ RunTime:0.003314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673012 LIMIT 5 [ RunTime:0.002502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673012 ORDER BY `minOrder` ASC [ RunTime:0.002961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673012 ORDER BY `unit` DESC [ RunTime:0.000360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673012 LIMIT 2 [ RunTime:0.003848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673012 ORDER BY `minOrder` ASC [ RunTime:0.002686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827648 LIMIT 5 [ RunTime:0.000951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827648 ORDER BY `minOrder` ASC [ RunTime:0.003518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827648 ORDER BY `unit` DESC [ RunTime:0.004043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827648 LIMIT 2 [ RunTime:0.001097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827648 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='SMCJ200C' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.001492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819620 LIMIT 5 [ RunTime:0.001697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819620 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819620 ORDER BY `unit` DESC [ RunTime:0.000447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819620 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819620 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814827 LIMIT 5 [ RunTime:0.000787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814827 ORDER BY `minOrder` ASC [ RunTime:0.006495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814827 ORDER BY `unit` DESC [ RunTime:0.002998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814827 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814827 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812136 LIMIT 5 [ RunTime:0.002497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812136 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812136 ORDER BY `unit` DESC [ RunTime:0.001328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812136 LIMIT 2 [ RunTime:0.001054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812136 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811255 LIMIT 5 [ RunTime:0.000772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811255 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811255 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811255 LIMIT 2 [ RunTime:0.001868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811255 ORDER BY `minOrder` ASC [ RunTime:0.002489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804671 LIMIT 5 [ RunTime:0.007338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804671 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14804671 ORDER BY `unit` DESC [ RunTime:0.004352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14804671 LIMIT 2 [ RunTime:0.010083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14804671 ORDER BY `minOrder` ASC [ RunTime:0.000866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917442 LIMIT 5 [ RunTime:0.009729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917442 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917442 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917442 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917442 ORDER BY `minOrder` ASC [ RunTime:0.005863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917141 LIMIT 5 [ RunTime:0.003432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917141 ORDER BY `minOrder` ASC [ RunTime:0.000750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917141 ORDER BY `unit` DESC [ RunTime:0.007169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917141 LIMIT 2 [ RunTime:0.001762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917141 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915097 LIMIT 5 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915097 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915097 ORDER BY `unit` DESC [ RunTime:0.002206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915097 LIMIT 2 [ RunTime:0.004537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915097 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
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 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141039 LIMIT 5 [ RunTime:0.002791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141039 ORDER BY `minOrder` ASC [ RunTime:0.002653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141039 ORDER BY `unit` DESC [ RunTime:0.007545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141039 LIMIT 2 [ RunTime:0.002980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141039 ORDER BY `minOrder` ASC [ RunTime:0.001389s ]
select * from pdf where partno='smcj200ca/tr13' and brandshort='yageo' limit 1 [ RunTime:0.002101s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj200ca/tr13' OR `brand` LIKE 'yageo%' ) ) LIMIT 1 [ RunTime:0.016730s ]
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 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114716 LIMIT 5 [ RunTime:0.000815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114716 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114716 ORDER BY `unit` DESC [ RunTime:0.001460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114716 LIMIT 2 [ RunTime:0.023879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114716 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
select * from pdf where partno='SMCJ200CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.002553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42096097 LIMIT 5 [ RunTime:0.013192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42096097 ORDER BY `minOrder` ASC [ RunTime:0.003507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42096097 ORDER BY `unit` DESC [ RunTime:0.000599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42096097 LIMIT 2 [ RunTime:0.012235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42096097 ORDER BY `minOrder` ASC [ RunTime:0.004437s ]
select * from pdf where partno='SMCJ200CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000659s ]
SELECT `id` FROM `stock` WHERE `id` <> 42096097 AND `partno` = 'SMCJ200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.002316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819699 [ RunTime:0.006372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42106800 LIMIT 5 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106800 ORDER BY `minOrder` ASC [ RunTime:0.000979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42106800 ORDER BY `unit` DESC [ RunTime:0.005152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42106800 LIMIT 2 [ RunTime:0.003837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106800 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
select * from pdf where partno='SMCJ200CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.000512s ]
SELECT `id` FROM `stock` WHERE `id` <> 42106800 AND `partno` = 'SMCJ200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912243 [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42153380 LIMIT 5 [ RunTime:0.001070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153380 ORDER BY `minOrder` ASC [ RunTime:0.006090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42153380 ORDER BY `unit` DESC [ RunTime:0.023224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42153380 LIMIT 2 [ RunTime:0.004547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42153380 ORDER BY `minOrder` ASC [ RunTime:0.019037s ]
select * from pdf where partno='SMCJ200CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.006455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009459s ]
SELECT `id` FROM `stock` WHERE `id` <> 42153380 AND `partno` = 'SMCJ200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.009873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801130 [ RunTime:0.009874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42155864 LIMIT 5 [ RunTime:0.009023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155864 ORDER BY `minOrder` ASC [ RunTime:0.040929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42155864 ORDER BY `unit` DESC [ RunTime:0.009152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42155864 LIMIT 2 [ RunTime:0.010314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42155864 ORDER BY `minOrder` ASC [ RunTime:0.004340s ]
select * from pdf where partno='SMCJ200CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.041710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.023659s ]
SELECT `id` FROM `stock` WHERE `id` <> 42155864 AND `partno` = 'SMCJ200CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.017433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691096 [ RunTime:0.016877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42143426 LIMIT 5 [ RunTime:0.002938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143426 ORDER BY `minOrder` ASC [ RunTime:0.011098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42143426 ORDER BY `unit` DESC [ RunTime:0.041464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42143426 LIMIT 2 [ RunTime:0.043867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42143426 ORDER BY `minOrder` ASC [ RunTime:0.005474s ]
select * from pdf where partno='SMCJ200CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.024675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.016577s ]
SELECT `id` FROM `stock` WHERE `id` <> 42143426 AND `partno` = 'SMCJ200CA-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.014918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14804671 [ RunTime:0.016416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42296490 LIMIT 5 [ RunTime:0.017804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296490 ORDER BY `minOrder` ASC [ RunTime:0.016472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42296490 ORDER BY `unit` DESC [ RunTime:0.039329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42296490 LIMIT 2 [ RunTime:0.016253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296490 ORDER BY `minOrder` ASC [ RunTime:0.005340s ]
select * from pdf where partno='SMCJ200CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.009626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.003477s ]
SELECT `id` FROM `stock` WHERE `id` <> 42296490 AND `partno` = 'SMCJ200CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.039943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819620 [ RunTime:0.019916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42296489 LIMIT 5 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296489 ORDER BY `minOrder` ASC [ RunTime:0.003293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42296489 ORDER BY `unit` DESC [ RunTime:0.011581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42296489 LIMIT 2 [ RunTime:0.015026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296489 ORDER BY `minOrder` ASC [ RunTime:0.003788s ]
select * from pdf where partno='SMCJ200CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.013022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.020518s ]
SELECT `id` FROM `stock` WHERE `id` <> 42296489 AND `partno` = 'SMCJ200CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.053089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678731 [ RunTime:0.043782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42270072 LIMIT 5 [ RunTime:0.034652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270072 ORDER BY `minOrder` ASC [ RunTime:0.039877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42270072 ORDER BY `unit` DESC [ RunTime:0.045512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42270072 LIMIT 2 [ RunTime:0.048186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42270072 ORDER BY `minOrder` ASC [ RunTime:0.014332s ]
select * from pdf where partno='SMCJ200CAH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.044955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CAH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.045829s ]
SELECT `id` FROM `stock` WHERE `id` <> 42270072 AND `partno` = 'SMCJ200CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.038917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917141 [ RunTime:0.029375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267626 LIMIT 5 [ RunTime:0.095744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267626 ORDER BY `minOrder` ASC [ RunTime:0.050152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267626 ORDER BY `unit` DESC [ RunTime:0.047162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267626 LIMIT 2 [ RunTime:0.039215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267626 ORDER BY `minOrder` ASC [ RunTime:0.037663s ]
select * from pdf where partno='SMCJ200CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.030541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.048176s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267626 AND `partno` = 'SMCJ200CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.031819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917442 [ RunTime:0.056905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42259660 LIMIT 5 [ RunTime:0.042163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259660 ORDER BY `minOrder` ASC [ RunTime:0.021784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42259660 ORDER BY `unit` DESC [ RunTime:0.039363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42259660 LIMIT 2 [ RunTime:0.045715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259660 ORDER BY `minOrder` ASC [ RunTime:0.030331s ]
select * from pdf where partno='SMCJ200CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.020442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.018385s ]
SELECT `id` FROM `stock` WHERE `id` <> 42259660 AND `partno` = 'SMCJ200CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.020534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674319 [ RunTime:0.036236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42236425 LIMIT 5 [ RunTime:0.018276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236425 ORDER BY `minOrder` ASC [ RunTime:0.049388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42236425 ORDER BY `unit` DESC [ RunTime:0.044982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42236425 LIMIT 2 [ RunTime:0.013425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236425 ORDER BY `minOrder` ASC [ RunTime:0.024846s ]
select * from pdf where partno='SMCJ200CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.009830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.021381s ]
SELECT `id` FROM `stock` WHERE `id` <> 42236425 AND `partno` = 'SMCJ200CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.028352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812136 [ RunTime:0.038945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42229518 LIMIT 5 [ RunTime:0.007993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42229518 ORDER BY `minOrder` ASC [ RunTime:0.010016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42229518 ORDER BY `unit` DESC [ RunTime:0.014207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42229518 LIMIT 2 [ RunTime:0.015744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42229518 ORDER BY `minOrder` ASC [ RunTime:0.005888s ]
select * from pdf where partno='SMCJ200CA-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.013079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.017936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42228915 LIMIT 5 [ RunTime:0.018876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228915 ORDER BY `minOrder` ASC [ RunTime:0.056981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42228915 ORDER BY `unit` DESC [ RunTime:0.046860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42228915 LIMIT 2 [ RunTime:0.030677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228915 ORDER BY `minOrder` ASC [ RunTime:0.009678s ]
select * from pdf where partno='SMCJ200CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.040943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.018625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222592 LIMIT 5 [ RunTime:0.042872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222592 ORDER BY `minOrder` ASC [ RunTime:0.067082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222592 ORDER BY `unit` DESC [ RunTime:0.031052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222592 LIMIT 2 [ RunTime:0.040845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222592 ORDER BY `minOrder` ASC [ RunTime:0.020756s ]
select * from pdf where partno='SMCJ200CA/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.020145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CA/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.052906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42181109 LIMIT 5 [ RunTime:0.059637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42181109 ORDER BY `minOrder` ASC [ RunTime:0.031418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42181109 ORDER BY `unit` DESC [ RunTime:0.036433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42181109 LIMIT 2 [ RunTime:0.046427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42181109 ORDER BY `minOrder` ASC [ RunTime:0.005856s ]
select * from pdf where partno='SMCJ200CAQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.040674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ200CAQ-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.076102s ]
SELECT `id` FROM `stock` WHERE `id` <> 42181109 AND `partno` = 'SMCJ200CAQ-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.043559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814827 [ RunTime:0.017629s ]
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 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066746s ]
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 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.080646s ]
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 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015163s ]
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 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029872s ]
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 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043264s ]
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 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058762s ]
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 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034432s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMCJ200C%' OR `brand` LIKE 'SMCJ200C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.046059s ]