SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001866s ]
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=5KP6.5CA&search=1' [ RunTime:0.015380s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.004056s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.021622s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001633s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.020497s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002115s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.020426s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001935s ]
SELECT * FROM `stock_search` WHERE `partno` = '5KP6.5CA' LIMIT 1 [ RunTime:0.029828s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-17 22:10:10' WHERE `partno` = '5KP6.5CA' [ RunTime:0.024049s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001777s ]
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 '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.112082s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799296 LIMIT 5 [ RunTime:0.041390s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.077320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799296 ORDER BY `minOrder` ASC [ RunTime:0.124515s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.077767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799296 ORDER BY `unit` DESC [ RunTime:0.093517s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799296 LIMIT 2 [ RunTime:0.089220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799296 ORDER BY `minOrder` ASC [ RunTime:0.016066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800361 LIMIT 5 [ RunTime:0.031690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800361 ORDER BY `minOrder` ASC [ RunTime:0.032328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800361 ORDER BY `unit` DESC [ RunTime:0.089554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800361 LIMIT 2 [ RunTime:0.037924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800361 ORDER BY `minOrder` ASC [ RunTime:0.009139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16682644 LIMIT 5 [ RunTime:0.023331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16682644 ORDER BY `minOrder` ASC [ RunTime:0.043835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16682644 ORDER BY `unit` DESC [ RunTime:0.033109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16682644 LIMIT 2 [ RunTime:0.081854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16682644 ORDER BY `minOrder` ASC [ RunTime:0.042446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680186 LIMIT 5 [ RunTime:0.070063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680186 ORDER BY `minOrder` ASC [ RunTime:0.040568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680186 ORDER BY `unit` DESC [ RunTime:0.053837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680186 LIMIT 2 [ RunTime:0.043600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680186 ORDER BY `minOrder` ASC [ RunTime:0.002235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676965 LIMIT 5 [ RunTime:0.052208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676965 ORDER BY `minOrder` ASC [ RunTime:0.029879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676965 ORDER BY `unit` DESC [ RunTime:0.029130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676965 LIMIT 2 [ RunTime:0.049851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676965 ORDER BY `minOrder` ASC [ RunTime:0.061898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820321 LIMIT 5 [ RunTime:0.039686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820321 ORDER BY `minOrder` ASC [ RunTime:0.056407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820321 ORDER BY `unit` DESC [ RunTime:0.028284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820321 LIMIT 2 [ RunTime:0.031388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820321 ORDER BY `minOrder` ASC [ RunTime:0.017194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820068 LIMIT 5 [ RunTime:0.021248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820068 ORDER BY `minOrder` ASC [ RunTime:0.011065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820068 ORDER BY `unit` DESC [ RunTime:0.008826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820068 LIMIT 2 [ RunTime:0.009860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820068 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925002 LIMIT 5 [ RunTime:0.000921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925002 ORDER BY `minOrder` ASC [ RunTime:0.009715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13925002 ORDER BY `unit` DESC [ RunTime:0.002731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13925002 LIMIT 2 [ RunTime:0.008905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925002 ORDER BY `minOrder` ASC [ RunTime:0.007083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924794 LIMIT 5 [ RunTime:0.007197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924794 ORDER BY `minOrder` ASC [ RunTime:0.010402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924794 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924794 LIMIT 2 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924794 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922981 LIMIT 5 [ RunTime:0.002895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922981 ORDER BY `minOrder` ASC [ RunTime:0.018576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13922981 ORDER BY `unit` DESC [ RunTime:0.005289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13922981 LIMIT 2 [ RunTime:0.012333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922981 ORDER BY `minOrder` ASC [ RunTime:0.005319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922559 LIMIT 5 [ RunTime:0.006565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922559 ORDER BY `minOrder` ASC [ RunTime:0.010855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13922559 ORDER BY `unit` DESC [ RunTime:0.003262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13922559 LIMIT 2 [ RunTime:0.006110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922559 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921322 LIMIT 5 [ RunTime:0.002557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921322 ORDER BY `minOrder` ASC [ RunTime:0.001180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921322 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921322 LIMIT 2 [ RunTime:0.003199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921322 ORDER BY `minOrder` ASC [ RunTime:0.005189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920888 LIMIT 5 [ RunTime:0.000875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920888 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13920888 ORDER BY `unit` DESC [ RunTime:0.000526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13920888 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920888 ORDER BY `minOrder` ASC [ RunTime:0.003852s ]
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 '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140799 LIMIT 5 [ RunTime:0.001086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140799 ORDER BY `minOrder` ASC [ RunTime:0.010246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140799 ORDER BY `unit` DESC [ RunTime:0.011979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140799 LIMIT 2 [ RunTime:0.007712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140799 ORDER BY `minOrder` ASC [ RunTime:0.010893s ]
select * from pdf where partno='5kp6.5ca' and brandshort='littelfuse' limit 1 [ RunTime:0.006568s ]
select foldpath,foldpath2,filename from pdf_file where id=393626 limit 1 [ RunTime:0.021059s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5kp6.5ca' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.014775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51025916 LIMIT 5 [ RunTime:0.003145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025916 ORDER BY `minOrder` ASC [ RunTime:0.015814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51025916 ORDER BY `unit` DESC [ RunTime:0.013767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51025916 LIMIT 2 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025916 ORDER BY `minOrder` ASC [ RunTime:0.002848s ]
select * from pdf where partno='5kp6.5ca' and brandshort='littelfuse' limit 1 [ RunTime:0.000338s ]
select foldpath,foldpath2,filename from pdf_file where id=393626 limit 1 [ RunTime:0.000194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5kp6.5ca' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.000244s ]
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 '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136404 LIMIT 5 [ RunTime:0.001284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136404 ORDER BY `minOrder` ASC [ RunTime:0.001492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136404 ORDER BY `unit` DESC [ RunTime:0.001640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136404 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136404 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='5KP6.5CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.010392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.008049s ]
SELECT `id` FROM `stock` WHERE `id` <> 42136404 AND `partno` = '5KP6.5CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.010147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799296 [ RunTime:0.000756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42164367 LIMIT 5 [ RunTime:0.001395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164367 ORDER BY `minOrder` ASC [ RunTime:0.026388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42164367 ORDER BY `unit` DESC [ RunTime:0.047122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42164367 LIMIT 2 [ RunTime:0.012663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164367 ORDER BY `minOrder` ASC [ RunTime:0.007235s ]
select * from pdf where partno='5KP6.5CA' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.002840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.004740s ]
SELECT `id` FROM `stock` WHERE `id` <> 42164367 AND `partno` = '5KP6.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.003329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170877 LIMIT 5 [ RunTime:0.008487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170877 ORDER BY `minOrder` ASC [ RunTime:0.001137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170877 ORDER BY `unit` DESC [ RunTime:0.000702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170877 LIMIT 2 [ RunTime:0.008133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170877 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='5KP6.5CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.022715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.006744s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170877 AND `partno` = '5KP6.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.013525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16682644 [ RunTime:0.022022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414616 LIMIT 5 [ RunTime:0.014321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414616 ORDER BY `minOrder` ASC [ RunTime:0.016605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414616 ORDER BY `unit` DESC [ RunTime:0.014603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414616 LIMIT 2 [ RunTime:0.003823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414616 ORDER BY `minOrder` ASC [ RunTime:0.001412s ]
select * from pdf where partno='5KP6.5CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000889s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414616 AND `partno` = '5KP6.5CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.013290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925002 [ RunTime:0.005224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42411244 LIMIT 5 [ RunTime:0.002023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42411244 ORDER BY `minOrder` ASC [ RunTime:0.001011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42411244 ORDER BY `unit` DESC [ RunTime:0.012652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42411244 LIMIT 2 [ RunTime:0.003711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42411244 ORDER BY `minOrder` ASC [ RunTime:0.007553s ]
select * from pdf where partno='5KP6.5CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.015971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.016949s ]
SELECT `id` FROM `stock` WHERE `id` <> 42411244 AND `partno` = '5KP6.5CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.038412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924794 [ RunTime:0.018420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42319602 LIMIT 5 [ RunTime:0.021730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42319602 ORDER BY `minOrder` ASC [ RunTime:0.035939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42319602 ORDER BY `unit` DESC [ RunTime:0.027699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42319602 LIMIT 2 [ RunTime:0.045328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42319602 ORDER BY `minOrder` ASC [ RunTime:0.025949s ]
select * from pdf where partno='5KP6.5CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.046823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.045042s ]
SELECT `id` FROM `stock` WHERE `id` <> 42319602 AND `partno` = '5KP6.5CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.072353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922559 [ RunTime:0.053867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42315481 LIMIT 5 [ RunTime:0.016455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42315481 ORDER BY `minOrder` ASC [ RunTime:0.055465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42315481 ORDER BY `unit` DESC [ RunTime:0.135457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42315481 LIMIT 2 [ RunTime:0.011030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42315481 ORDER BY `minOrder` ASC [ RunTime:0.077761s ]
select * from pdf where partno='5KP6.5CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.127812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.034303s ]
SELECT `id` FROM `stock` WHERE `id` <> 42315481 AND `partno` = '5KP6.5CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.109301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680186 [ RunTime:0.083656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42299497 LIMIT 5 [ RunTime:0.071897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299497 ORDER BY `minOrder` ASC [ RunTime:0.074700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42299497 ORDER BY `unit` DESC [ RunTime:0.101182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42299497 LIMIT 2 [ RunTime:0.078452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299497 ORDER BY `minOrder` ASC [ RunTime:0.048779s ]
select * from pdf where partno='5KP6.5CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.093873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.034200s ]
SELECT `id` FROM `stock` WHERE `id` <> 42299497 AND `partno` = '5KP6.5CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.116990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820321 [ RunTime:0.032383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42297858 LIMIT 5 [ RunTime:0.085889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297858 ORDER BY `minOrder` ASC [ RunTime:0.058610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42297858 ORDER BY `unit` DESC [ RunTime:0.027918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42297858 LIMIT 2 [ RunTime:0.055083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297858 ORDER BY `minOrder` ASC [ RunTime:0.054893s ]
select * from pdf where partno='5KP6.5CA-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.047759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.035707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42297854 LIMIT 5 [ RunTime:0.038027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297854 ORDER BY `minOrder` ASC [ RunTime:0.033379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42297854 ORDER BY `unit` DESC [ RunTime:0.031474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42297854 LIMIT 2 [ RunTime:0.033701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297854 ORDER BY `minOrder` ASC [ RunTime:0.030638s ]
select * from pdf where partno='5KP6.5CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.015199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.033251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295831 LIMIT 5 [ RunTime:0.016887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295831 ORDER BY `minOrder` ASC [ RunTime:0.051879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295831 ORDER BY `unit` DESC [ RunTime:0.020991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295831 LIMIT 2 [ RunTime:0.005463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295831 ORDER BY `minOrder` ASC [ RunTime:0.028706s ]
select * from pdf where partno='5KP6.5CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.033523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.019553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295497 LIMIT 5 [ RunTime:0.019089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295497 ORDER BY `minOrder` ASC [ RunTime:0.016183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295497 ORDER BY `unit` DESC [ RunTime:0.008053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295497 LIMIT 2 [ RunTime:0.012591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295497 ORDER BY `minOrder` ASC [ RunTime:0.023889s ]
select * from pdf where partno='5KP6.5CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.022786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.022696s ]
SELECT `id` FROM `stock` WHERE `id` <> 42295497 AND `partno` = '5KP6.5CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.020337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922981 [ RunTime:0.002837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42284938 LIMIT 5 [ RunTime:0.013530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284938 ORDER BY `minOrder` ASC [ RunTime:0.019036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42284938 ORDER BY `unit` DESC [ RunTime:0.007891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42284938 LIMIT 2 [ RunTime:0.004406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284938 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='5KP6.5CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.003531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.009584s ]
SELECT `id` FROM `stock` WHERE `id` <> 42284938 AND `partno` = '5KP6.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.015484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676965 [ RunTime:0.005738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42179366 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42179366 ORDER BY `minOrder` ASC [ RunTime:0.003095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42179366 ORDER BY `unit` DESC [ RunTime:0.019224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42179366 LIMIT 2 [ RunTime:0.014067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42179366 ORDER BY `minOrder` ASC [ RunTime:0.003677s ]
select * from pdf where partno='5KP6.5CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.001674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007108s ]
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 '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003268s ]
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 '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042558s ]
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 '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018273s ]
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 '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013251s ]
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 '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002646s ]
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 '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001028s ]
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 '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011360s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5KP6.5CA%' OR `brand` LIKE '5KP6.5CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006863s ]