SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002689s ]
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=5KP15CA&search=1' [ RunTime:0.008767s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002201s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002855s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003570s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000951s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001456s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.012436s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001813s ]
SELECT * FROM `stock_search` WHERE `partno` = '5KP15CA' LIMIT 1 [ RunTime:0.025495s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-17 11:18:16' WHERE `partno` = '5KP15CA' [ RunTime:0.009325s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001809s ]
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 '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031956s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914213 LIMIT 5 [ RunTime:0.020088s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914213 ORDER BY `minOrder` ASC [ RunTime:0.022696s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.041278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13914213 ORDER BY `unit` DESC [ RunTime:0.046474s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13914213 LIMIT 2 [ RunTime:0.024888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914213 ORDER BY `minOrder` ASC [ RunTime:0.014655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661873 LIMIT 5 [ RunTime:0.024109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661873 ORDER BY `minOrder` ASC [ RunTime:0.029101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661873 ORDER BY `unit` DESC [ RunTime:0.032866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661873 LIMIT 2 [ RunTime:0.009091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661873 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904438 LIMIT 5 [ RunTime:0.020650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904438 ORDER BY `minOrder` ASC [ RunTime:0.031457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904438 ORDER BY `unit` DESC [ RunTime:0.012587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904438 LIMIT 2 [ RunTime:0.033734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904438 ORDER BY `minOrder` ASC [ RunTime:0.014171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800347 LIMIT 5 [ RunTime:0.022647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800347 ORDER BY `minOrder` ASC [ RunTime:0.013842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800347 ORDER BY `unit` DESC [ RunTime:0.013118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800347 LIMIT 2 [ RunTime:0.025159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800347 ORDER BY `minOrder` ASC [ RunTime:0.007532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678472 LIMIT 5 [ RunTime:0.010230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678472 ORDER BY `minOrder` ASC [ RunTime:0.019682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678472 ORDER BY `unit` DESC [ RunTime:0.007341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678472 LIMIT 2 [ RunTime:0.014610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678472 ORDER BY `minOrder` ASC [ RunTime:0.026993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663168 LIMIT 5 [ RunTime:0.020639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663168 ORDER BY `minOrder` ASC [ RunTime:0.016690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663168 ORDER BY `unit` DESC [ RunTime:0.015451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663168 LIMIT 2 [ RunTime:0.016185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663168 ORDER BY `minOrder` ASC [ RunTime:0.024791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821538 LIMIT 5 [ RunTime:0.101052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821538 ORDER BY `minOrder` ASC [ RunTime:0.074882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14821538 ORDER BY `unit` DESC [ RunTime:0.026350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14821538 LIMIT 2 [ RunTime:0.038546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14821538 ORDER BY `minOrder` ASC [ RunTime:0.036214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820912 LIMIT 5 [ RunTime:0.013407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820912 ORDER BY `minOrder` ASC [ RunTime:0.026516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820912 ORDER BY `unit` DESC [ RunTime:0.019780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820912 LIMIT 2 [ RunTime:0.005314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820912 ORDER BY `minOrder` ASC [ RunTime:0.005301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820310 LIMIT 5 [ RunTime:0.004756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820310 ORDER BY `minOrder` ASC [ RunTime:0.007441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820310 ORDER BY `unit` DESC [ RunTime:0.015238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820310 LIMIT 2 [ RunTime:0.019556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820310 ORDER BY `minOrder` ASC [ RunTime:0.008315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925010 LIMIT 5 [ RunTime:0.003652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925010 ORDER BY `minOrder` ASC [ RunTime:0.007974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13925010 ORDER BY `unit` DESC [ RunTime:0.005051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13925010 LIMIT 2 [ RunTime:0.013484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925010 ORDER BY `minOrder` ASC [ RunTime:0.004699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924834 LIMIT 5 [ RunTime:0.015697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924834 ORDER BY `minOrder` ASC [ RunTime:0.002111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924834 ORDER BY `unit` DESC [ RunTime:0.002181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924834 LIMIT 2 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924834 ORDER BY `minOrder` ASC [ RunTime:0.001919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922443 LIMIT 5 [ RunTime:0.004523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922443 ORDER BY `minOrder` ASC [ RunTime:0.009040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13922443 ORDER BY `unit` DESC [ RunTime:0.003205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13922443 LIMIT 2 [ RunTime:0.011624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922443 ORDER BY `minOrder` ASC [ RunTime:0.005402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921568 LIMIT 5 [ RunTime:0.003247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921568 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921568 ORDER BY `unit` DESC [ RunTime:0.007050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921568 LIMIT 2 [ RunTime:0.001056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921568 ORDER BY `minOrder` ASC [ RunTime:0.003317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920364 LIMIT 5 [ RunTime:0.011200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920364 ORDER BY `minOrder` ASC [ RunTime:0.008539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13920364 ORDER BY `unit` DESC [ RunTime:0.013297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13920364 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920364 ORDER BY `minOrder` ASC [ RunTime:0.000250s ]
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 '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001781s ]
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 '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42108983 LIMIT 5 [ RunTime:0.000759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42108983 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42108983 ORDER BY `unit` DESC [ RunTime:0.002514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42108983 LIMIT 2 [ RunTime:0.002855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42108983 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
select * from pdf where partno='5KP15CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002030s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000806s ]
SELECT `id` FROM `stock` WHERE `id` <> 42108983 AND `partno` = '5KP15CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.014338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914213 [ RunTime:0.001848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136408 LIMIT 5 [ RunTime:0.005012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136408 ORDER BY `minOrder` ASC [ RunTime:0.007034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136408 ORDER BY `unit` DESC [ RunTime:0.000452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136408 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136408 ORDER BY `minOrder` ASC [ RunTime:0.000234s ]
select * from pdf where partno='5KP15CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.000798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.005776s ]
SELECT `id` FROM `stock` WHERE `id` <> 42136408 AND `partno` = '5KP15CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.009693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904438 [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42172481 LIMIT 5 [ RunTime:0.018162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42172481 ORDER BY `minOrder` ASC [ RunTime:0.004078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42172481 ORDER BY `unit` DESC [ RunTime:0.003865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42172481 LIMIT 2 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42172481 ORDER BY `minOrder` ASC [ RunTime:0.002771s ]
select * from pdf where partno='5KP15CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.011005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42156874 LIMIT 5 [ RunTime:0.007168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156874 ORDER BY `minOrder` ASC [ RunTime:0.000684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42156874 ORDER BY `unit` DESC [ RunTime:0.007631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42156874 LIMIT 2 [ RunTime:0.002447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42156874 ORDER BY `minOrder` ASC [ RunTime:0.002934s ]
select * from pdf where partno='5KP15CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.008944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.004048s ]
SELECT `id` FROM `stock` WHERE `id` <> 42156874 AND `partno` = '5KP15CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.021661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661873 [ RunTime:0.001752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414638 LIMIT 5 [ RunTime:0.012016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414638 ORDER BY `minOrder` ASC [ RunTime:0.007143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414638 ORDER BY `unit` DESC [ RunTime:0.000935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414638 LIMIT 2 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414638 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
select * from pdf where partno='5KP15CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.007520s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414638 AND `partno` = '5KP15CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.003748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925010 [ RunTime:0.000756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42411266 LIMIT 5 [ RunTime:0.019926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42411266 ORDER BY `minOrder` ASC [ RunTime:0.008214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42411266 ORDER BY `unit` DESC [ RunTime:0.029092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42411266 LIMIT 2 [ RunTime:0.013815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42411266 ORDER BY `minOrder` ASC [ RunTime:0.013457s ]
select * from pdf where partno='5KP15CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.010253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.013619s ]
SELECT `id` FROM `stock` WHERE `id` <> 42411266 AND `partno` = '5KP15CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.025618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924834 [ RunTime:0.006021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42318585 LIMIT 5 [ RunTime:0.008742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42318585 ORDER BY `minOrder` ASC [ RunTime:0.026073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42318585 ORDER BY `unit` DESC [ RunTime:0.014584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42318585 LIMIT 2 [ RunTime:0.034741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42318585 ORDER BY `minOrder` ASC [ RunTime:0.002950s ]
select * from pdf where partno='5KP15CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.004677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.011904s ]
SELECT `id` FROM `stock` WHERE `id` <> 42318585 AND `partno` = '5KP15CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.014296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820912 [ RunTime:0.004277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42314331 LIMIT 5 [ RunTime:0.032565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42314331 ORDER BY `minOrder` ASC [ RunTime:0.033487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42314331 ORDER BY `unit` DESC [ RunTime:0.014286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42314331 LIMIT 2 [ RunTime:0.042599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42314331 ORDER BY `minOrder` ASC [ RunTime:0.023570s ]
select * from pdf where partno='5KP15CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.025012s ]
SELECT `id` FROM `stock` WHERE `id` <> 42314331 AND `partno` = '5KP15CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.026966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922443 [ RunTime:0.032544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42299448 LIMIT 5 [ RunTime:0.025678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299448 ORDER BY `minOrder` ASC [ RunTime:0.012972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42299448 ORDER BY `unit` DESC [ RunTime:0.036939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42299448 LIMIT 2 [ RunTime:0.018459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299448 ORDER BY `minOrder` ASC [ RunTime:0.007427s ]
select * from pdf where partno='5KP15CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.023649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.006991s ]
SELECT `id` FROM `stock` WHERE `id` <> 42299448 AND `partno` = '5KP15CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.004270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820310 [ RunTime:0.009485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42298108 LIMIT 5 [ RunTime:0.041804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42298108 ORDER BY `minOrder` ASC [ RunTime:0.051098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42298108 ORDER BY `unit` DESC [ RunTime:0.011642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42298108 LIMIT 2 [ RunTime:0.018385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42298108 ORDER BY `minOrder` ASC [ RunTime:0.017639s ]
select * from pdf where partno='5KP15CA-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.012277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.010059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295806 LIMIT 5 [ RunTime:0.014632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295806 ORDER BY `minOrder` ASC [ RunTime:0.028621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295806 ORDER BY `unit` DESC [ RunTime:0.008478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295806 LIMIT 2 [ RunTime:0.031952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295806 ORDER BY `minOrder` ASC [ RunTime:0.003045s ]
select * from pdf where partno='5KP15CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.024038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.010035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295748 LIMIT 5 [ RunTime:0.021043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295748 ORDER BY `minOrder` ASC [ RunTime:0.035264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295748 ORDER BY `unit` DESC [ RunTime:0.021615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295748 LIMIT 2 [ RunTime:0.027833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295748 ORDER BY `minOrder` ASC [ RunTime:0.001105s ]
select * from pdf where partno='5KP15CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.005710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.036391s ]
SELECT `id` FROM `stock` WHERE `id` <> 42295748 AND `partno` = '5KP15CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.034123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14821538 [ RunTime:0.000684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42291632 LIMIT 5 [ RunTime:0.013323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291632 ORDER BY `minOrder` ASC [ RunTime:0.033087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42291632 ORDER BY `unit` DESC [ RunTime:0.031039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42291632 LIMIT 2 [ RunTime:0.045913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291632 ORDER BY `minOrder` ASC [ RunTime:0.036173s ]
select * from pdf where partno='5KP15CA-AQ' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.013180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA-AQ' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.019936s ]
SELECT `id` FROM `stock` WHERE `id` <> 42291632 AND `partno` = '5KP15CA-AQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.026364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920364 [ RunTime:0.056325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42157255 LIMIT 5 [ RunTime:0.055979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42157255 ORDER BY `minOrder` ASC [ RunTime:0.095900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42157255 ORDER BY `unit` DESC [ RunTime:0.047647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42157255 LIMIT 2 [ RunTime:0.023432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42157255 ORDER BY `minOrder` ASC [ RunTime:0.003624s ]
select * from pdf where partno='5KP15CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.021928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP15CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.048730s ]
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 '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025166s ]
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 '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023906s ]
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 '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042176s ]
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 '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020883s ]
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 '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053350s ]
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 '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055848s ]
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 '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050334s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5KP15CA%' OR `brand` LIKE '5KP15CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.034587s ]