SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001746s ]
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=5kp6.5ca&search=1' [ RunTime:0.019108s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001822s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.017943s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003466s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.026584s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002234s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001296s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002389s ]
SELECT * FROM `stock_search` WHERE `partno` = '5kp6.5ca' LIMIT 1 [ RunTime:0.045130s ]
UPDATE `stock_search` SET `count` = 12 , `updatetime` = '2026-08-19 13:29:35' WHERE `partno` = '5kp6.5ca' [ RunTime:0.023340s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002497s ]
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.050372s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799296 LIMIT 5 [ RunTime:0.044145s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799296 ORDER BY `minOrder` ASC [ RunTime:0.043509s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.014583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14799296 ORDER BY `unit` DESC [ RunTime:0.024081s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14799296 LIMIT 2 [ RunTime:0.005585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14799296 ORDER BY `minOrder` ASC [ RunTime:0.025926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800361 LIMIT 5 [ RunTime:0.042755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800361 ORDER BY `minOrder` ASC [ RunTime:0.065319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800361 ORDER BY `unit` DESC [ RunTime:0.078268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800361 LIMIT 2 [ RunTime:0.015736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800361 ORDER BY `minOrder` ASC [ RunTime:0.027093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16682644 LIMIT 5 [ RunTime:0.040600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16682644 ORDER BY `minOrder` ASC [ RunTime:0.081576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16682644 ORDER BY `unit` DESC [ RunTime:0.049863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16682644 LIMIT 2 [ RunTime:0.078852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16682644 ORDER BY `minOrder` ASC [ RunTime:0.042891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680186 LIMIT 5 [ RunTime:0.026569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680186 ORDER BY `minOrder` ASC [ RunTime:0.029680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680186 ORDER BY `unit` DESC [ RunTime:0.049116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680186 LIMIT 2 [ RunTime:0.055581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680186 ORDER BY `minOrder` ASC [ RunTime:0.034208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676965 LIMIT 5 [ RunTime:0.034621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676965 ORDER BY `minOrder` ASC [ RunTime:0.039502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676965 ORDER BY `unit` DESC [ RunTime:0.044769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676965 LIMIT 2 [ RunTime:0.046225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676965 ORDER BY `minOrder` ASC [ RunTime:0.026282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820321 LIMIT 5 [ RunTime:0.064916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820321 ORDER BY `minOrder` ASC [ RunTime:0.032242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820321 ORDER BY `unit` DESC [ RunTime:0.027103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820321 LIMIT 2 [ RunTime:0.051585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820321 ORDER BY `minOrder` ASC [ RunTime:0.019290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820068 LIMIT 5 [ RunTime:0.027663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820068 ORDER BY `minOrder` ASC [ RunTime:0.049189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820068 ORDER BY `unit` DESC [ RunTime:0.040547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820068 LIMIT 2 [ RunTime:0.010871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820068 ORDER BY `minOrder` ASC [ RunTime:0.014278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925002 LIMIT 5 [ RunTime:0.029377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925002 ORDER BY `minOrder` ASC [ RunTime:0.020843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13925002 ORDER BY `unit` DESC [ RunTime:0.017899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13925002 LIMIT 2 [ RunTime:0.026327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925002 ORDER BY `minOrder` ASC [ RunTime:0.008771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924794 LIMIT 5 [ RunTime:0.018323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924794 ORDER BY `minOrder` ASC [ RunTime:0.035965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924794 ORDER BY `unit` DESC [ RunTime:0.023225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924794 LIMIT 2 [ RunTime:0.005242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924794 ORDER BY `minOrder` ASC [ RunTime:0.005741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922981 LIMIT 5 [ RunTime:0.043576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922981 ORDER BY `minOrder` ASC [ RunTime:0.009532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13922981 ORDER BY `unit` DESC [ RunTime:0.029738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13922981 LIMIT 2 [ RunTime:0.003551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922981 ORDER BY `minOrder` ASC [ RunTime:0.007396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922559 LIMIT 5 [ RunTime:0.015547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922559 ORDER BY `minOrder` ASC [ RunTime:0.020581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13922559 ORDER BY `unit` DESC [ RunTime:0.027361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13922559 LIMIT 2 [ RunTime:0.005972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13922559 ORDER BY `minOrder` ASC [ RunTime:0.009287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921322 LIMIT 5 [ RunTime:0.021137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921322 ORDER BY `minOrder` ASC [ RunTime:0.011310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921322 ORDER BY `unit` DESC [ RunTime:0.018075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921322 LIMIT 2 [ RunTime:0.004204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921322 ORDER BY `minOrder` ASC [ RunTime:0.005060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13920888 LIMIT 5 [ RunTime:0.033495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920888 ORDER BY `minOrder` ASC [ RunTime:0.025234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13920888 ORDER BY `unit` DESC [ RunTime:0.042563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13920888 LIMIT 2 [ RunTime:0.024177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13920888 ORDER BY `minOrder` ASC [ RunTime:0.014894s ]
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.036554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51140799 LIMIT 5 [ RunTime:0.023240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140799 ORDER BY `minOrder` ASC [ RunTime:0.069402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51140799 ORDER BY `unit` DESC [ RunTime:0.086469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51140799 LIMIT 2 [ RunTime:0.023863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51140799 ORDER BY `minOrder` ASC [ RunTime:0.020664s ]
select * from pdf where partno='5kp6.5ca' and brandshort='littelfuse' limit 1 [ RunTime:0.061172s ]
select foldpath,foldpath2,filename from pdf_file where id=393626 limit 1 [ RunTime:0.071676s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5kp6.5ca' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.046607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51025916 LIMIT 5 [ RunTime:0.028613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025916 ORDER BY `minOrder` ASC [ RunTime:0.026440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51025916 ORDER BY `unit` DESC [ RunTime:0.007860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51025916 LIMIT 2 [ RunTime:0.029746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51025916 ORDER BY `minOrder` ASC [ RunTime:0.019698s ]
select * from pdf where partno='5kp6.5ca' and brandshort='littelfuse' limit 1 [ RunTime:0.008691s ]
select foldpath,foldpath2,filename from pdf_file where id=393626 limit 1 [ RunTime:0.003291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5kp6.5ca' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.003674s ]
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.028535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42136404 LIMIT 5 [ RunTime:0.057371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136404 ORDER BY `minOrder` ASC [ RunTime:0.039565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42136404 ORDER BY `unit` DESC [ RunTime:0.007770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42136404 LIMIT 2 [ RunTime:0.025136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42136404 ORDER BY `minOrder` ASC [ RunTime:0.033640s ]
select * from pdf where partno='5KP6.5CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.032747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.043652s ]
SELECT `id` FROM `stock` WHERE `id` <> 42136404 AND `partno` = '5KP6.5CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.035716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14799296 [ RunTime:0.043105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42164367 LIMIT 5 [ RunTime:0.012089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164367 ORDER BY `minOrder` ASC [ RunTime:0.025613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42164367 ORDER BY `unit` DESC [ RunTime:0.042039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42164367 LIMIT 2 [ RunTime:0.026991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42164367 ORDER BY `minOrder` ASC [ RunTime:0.003545s ]
select * from pdf where partno='5KP6.5CA' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.041587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.027633s ]
SELECT `id` FROM `stock` WHERE `id` <> 42164367 AND `partno` = '5KP6.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.008492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170877 LIMIT 5 [ RunTime:0.039506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170877 ORDER BY `minOrder` ASC [ RunTime:0.043760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170877 ORDER BY `unit` DESC [ RunTime:0.036497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170877 LIMIT 2 [ RunTime:0.062243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170877 ORDER BY `minOrder` ASC [ RunTime:0.028885s ]
select * from pdf where partno='5KP6.5CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.026752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.021008s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170877 AND `partno` = '5KP6.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.055698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16682644 [ RunTime:0.025844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42414616 LIMIT 5 [ RunTime:0.066457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414616 ORDER BY `minOrder` ASC [ RunTime:0.026895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42414616 ORDER BY `unit` DESC [ RunTime:0.012627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42414616 LIMIT 2 [ RunTime:0.044351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42414616 ORDER BY `minOrder` ASC [ RunTime:0.030148s ]
select * from pdf where partno='5KP6.5CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.038526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.005740s ]
SELECT `id` FROM `stock` WHERE `id` <> 42414616 AND `partno` = '5KP6.5CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.057455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925002 [ RunTime:0.054256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42411244 LIMIT 5 [ RunTime:0.132979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42411244 ORDER BY `minOrder` ASC [ RunTime:0.055262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42411244 ORDER BY `unit` DESC [ RunTime:0.063057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42411244 LIMIT 2 [ RunTime:0.036595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42411244 ORDER BY `minOrder` ASC [ RunTime:0.035702s ]
select * from pdf where partno='5KP6.5CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.055800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.119282s ]
SELECT `id` FROM `stock` WHERE `id` <> 42411244 AND `partno` = '5KP6.5CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.088975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924794 [ RunTime:0.122294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42319602 LIMIT 5 [ RunTime:0.065938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42319602 ORDER BY `minOrder` ASC [ RunTime:0.041583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42319602 ORDER BY `unit` DESC [ RunTime:0.095709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42319602 LIMIT 2 [ RunTime:0.067055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42319602 ORDER BY `minOrder` ASC [ RunTime:0.037035s ]
select * from pdf where partno='5KP6.5CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.028485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.088447s ]
SELECT `id` FROM `stock` WHERE `id` <> 42319602 AND `partno` = '5KP6.5CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.060835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922559 [ RunTime:0.073152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42315481 LIMIT 5 [ RunTime:0.034826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42315481 ORDER BY `minOrder` ASC [ RunTime:0.054384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42315481 ORDER BY `unit` DESC [ RunTime:0.044343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42315481 LIMIT 2 [ RunTime:0.043975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42315481 ORDER BY `minOrder` ASC [ RunTime:0.032679s ]
select * from pdf where partno='5KP6.5CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.052509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.042122s ]
SELECT `id` FROM `stock` WHERE `id` <> 42315481 AND `partno` = '5KP6.5CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.051840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680186 [ RunTime:0.030316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42299497 LIMIT 5 [ RunTime:0.014923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299497 ORDER BY `minOrder` ASC [ RunTime:0.029432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42299497 ORDER BY `unit` DESC [ RunTime:0.024218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42299497 LIMIT 2 [ RunTime:0.011399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42299497 ORDER BY `minOrder` ASC [ RunTime:0.001011s ]
select * from pdf where partno='5KP6.5CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.167938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.064618s ]
SELECT `id` FROM `stock` WHERE `id` <> 42299497 AND `partno` = '5KP6.5CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.040543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820321 [ RunTime:0.024283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42297858 LIMIT 5 [ RunTime:0.034733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297858 ORDER BY `minOrder` ASC [ RunTime:0.034452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42297858 ORDER BY `unit` DESC [ RunTime:0.029747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42297858 LIMIT 2 [ RunTime:0.059946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297858 ORDER BY `minOrder` ASC [ RunTime:0.004372s ]
select * from pdf where partno='5KP6.5CA-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.026108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.029469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42297854 LIMIT 5 [ RunTime:0.012441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297854 ORDER BY `minOrder` ASC [ RunTime:0.040647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42297854 ORDER BY `unit` DESC [ RunTime:0.004319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42297854 LIMIT 2 [ RunTime:0.024980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42297854 ORDER BY `minOrder` ASC [ RunTime:0.012411s ]
select * from pdf where partno='5KP6.5CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.015750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.027902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295831 LIMIT 5 [ RunTime:0.007361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295831 ORDER BY `minOrder` ASC [ RunTime:0.014045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295831 ORDER BY `unit` DESC [ RunTime:0.007643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295831 LIMIT 2 [ RunTime:0.005568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295831 ORDER BY `minOrder` ASC [ RunTime:0.002570s ]
select * from pdf where partno='5KP6.5CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.023500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.038590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295497 LIMIT 5 [ RunTime:0.008985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295497 ORDER BY `minOrder` ASC [ RunTime:0.021273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295497 ORDER BY `unit` DESC [ RunTime:0.023618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295497 LIMIT 2 [ RunTime:0.012093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295497 ORDER BY `minOrder` ASC [ RunTime:0.010311s ]
select * from pdf where partno='5KP6.5CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.018354s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.047577s ]
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.016875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13922981 [ RunTime:0.047462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42284938 LIMIT 5 [ RunTime:0.012301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284938 ORDER BY `minOrder` ASC [ RunTime:0.006876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42284938 ORDER BY `unit` DESC [ RunTime:0.032082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42284938 LIMIT 2 [ RunTime:0.049595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42284938 ORDER BY `minOrder` ASC [ RunTime:0.008525s ]
select * from pdf where partno='5KP6.5CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.037382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.043276s ]
SELECT `id` FROM `stock` WHERE `id` <> 42284938 AND `partno` = '5KP6.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.073862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676965 [ RunTime:0.024520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42179366 LIMIT 5 [ RunTime:0.038486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42179366 ORDER BY `minOrder` ASC [ RunTime:0.019501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42179366 ORDER BY `unit` DESC [ RunTime:0.008046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42179366 LIMIT 2 [ RunTime:0.020187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42179366 ORDER BY `minOrder` ASC [ RunTime:0.008653s ]
select * from pdf where partno='5KP6.5CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.074887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5KP6.5CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.038014s ]
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.035521s ]
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.101780s ]
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.064937s ]
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.034329s ]
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.038610s ]
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.058400s ]
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.028769s ]
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.045170s ]