SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002081s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.162' , `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=1.5KE7.5C&search=1' [ RunTime:0.018867s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003354s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000596s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001605s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.162' ) [ RunTime:0.001980s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001164s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000426s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001758s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5KE7.5C' LIMIT 1 [ RunTime:0.010868s ]
UPDATE `stock_search` SET `count` = 19 , `updatetime` = '2026-08-18 14:18:10' WHERE `partno` = '1.5KE7.5C' [ RunTime:0.005132s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001239s ]
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 '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011917s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912572 LIMIT 5 [ RunTime:0.022020s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912572 ORDER BY `minOrder` ASC [ RunTime:0.007616s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912572 ORDER BY `unit` DESC [ RunTime:0.000713s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912572 LIMIT 2 [ RunTime:0.008271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912572 ORDER BY `minOrder` ASC [ RunTime:0.003453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819720 LIMIT 5 [ RunTime:0.009853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819720 ORDER BY `minOrder` ASC [ RunTime:0.010852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819720 ORDER BY `unit` DESC [ RunTime:0.007830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819720 LIMIT 2 [ RunTime:0.008658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819720 ORDER BY `minOrder` ASC [ RunTime:0.008914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809526 LIMIT 5 [ RunTime:0.012281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809526 ORDER BY `minOrder` ASC [ RunTime:0.003458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809526 ORDER BY `unit` DESC [ RunTime:0.005394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809526 LIMIT 2 [ RunTime:0.015795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809526 ORDER BY `minOrder` ASC [ RunTime:0.014968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802016 LIMIT 5 [ RunTime:0.037109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802016 ORDER BY `minOrder` ASC [ RunTime:0.005275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802016 ORDER BY `unit` DESC [ RunTime:0.026491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802016 LIMIT 2 [ RunTime:0.022119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802016 ORDER BY `minOrder` ASC [ RunTime:0.014982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908383 LIMIT 5 [ RunTime:0.011933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908383 ORDER BY `minOrder` ASC [ RunTime:0.013056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908383 ORDER BY `unit` DESC [ RunTime:0.010174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908383 LIMIT 2 [ RunTime:0.005486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908383 ORDER BY `minOrder` ASC [ RunTime:0.015227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803915 LIMIT 5 [ RunTime:0.006663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803915 ORDER BY `minOrder` ASC [ RunTime:0.020055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803915 ORDER BY `unit` DESC [ RunTime:0.008151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803915 LIMIT 2 [ RunTime:0.033057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803915 ORDER BY `minOrder` ASC [ RunTime:0.014913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690864 LIMIT 5 [ RunTime:0.021910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690864 ORDER BY `minOrder` ASC [ RunTime:0.023669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690864 ORDER BY `unit` DESC [ RunTime:0.019831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690864 LIMIT 2 [ RunTime:0.032171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690864 ORDER BY `minOrder` ASC [ RunTime:0.014184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688528 LIMIT 5 [ RunTime:0.015457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688528 ORDER BY `minOrder` ASC [ RunTime:0.012710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688528 ORDER BY `unit` DESC [ RunTime:0.025788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688528 LIMIT 2 [ RunTime:0.048547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688528 ORDER BY `minOrder` ASC [ RunTime:0.007531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688527 LIMIT 5 [ RunTime:0.028789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688527 ORDER BY `minOrder` ASC [ RunTime:0.071712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688527 ORDER BY `unit` DESC [ RunTime:0.083737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688527 LIMIT 2 [ RunTime:0.063933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688527 ORDER BY `minOrder` ASC [ RunTime:0.030278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688158 LIMIT 5 [ RunTime:0.042745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688158 ORDER BY `minOrder` ASC [ RunTime:0.022997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688158 ORDER BY `unit` DESC [ RunTime:0.036480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688158 LIMIT 2 [ RunTime:0.104531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688158 ORDER BY `minOrder` ASC [ RunTime:0.018326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688157 LIMIT 5 [ RunTime:0.042689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688157 ORDER BY `minOrder` ASC [ RunTime:0.076345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688157 ORDER BY `unit` DESC [ RunTime:0.093278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688157 LIMIT 2 [ RunTime:0.022230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688157 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676441 LIMIT 5 [ RunTime:0.030373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676441 ORDER BY `minOrder` ASC [ RunTime:0.011997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676441 ORDER BY `unit` DESC [ RunTime:0.038345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676441 LIMIT 2 [ RunTime:0.053692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676441 ORDER BY `minOrder` ASC [ RunTime:0.016349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675671 LIMIT 5 [ RunTime:0.020069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675671 ORDER BY `minOrder` ASC [ RunTime:0.024515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675671 ORDER BY `unit` DESC [ RunTime:0.027959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675671 LIMIT 2 [ RunTime:0.017886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675671 ORDER BY `minOrder` ASC [ RunTime:0.054331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674876 LIMIT 5 [ RunTime:0.030863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674876 ORDER BY `minOrder` ASC [ RunTime:0.052729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674876 ORDER BY `unit` DESC [ RunTime:0.057393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674876 LIMIT 2 [ RunTime:0.016916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674876 ORDER BY `minOrder` ASC [ RunTime:0.015706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674424 LIMIT 5 [ RunTime:0.006930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674424 ORDER BY `minOrder` ASC [ RunTime:0.007848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674424 ORDER BY `unit` DESC [ RunTime:0.019591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674424 LIMIT 2 [ RunTime:0.041168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674424 ORDER BY `minOrder` ASC [ RunTime:0.031308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831380 LIMIT 5 [ RunTime:0.022829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831380 ORDER BY `minOrder` ASC [ RunTime:0.012002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831380 ORDER BY `unit` DESC [ RunTime:0.010128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831380 LIMIT 2 [ RunTime:0.003922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831380 ORDER BY `minOrder` ASC [ RunTime:0.023271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831379 LIMIT 5 [ RunTime:0.014067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831379 ORDER BY `minOrder` ASC [ RunTime:0.027188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831379 ORDER BY `unit` DESC [ RunTime:0.030988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831379 LIMIT 2 [ RunTime:0.010126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831379 ORDER BY `minOrder` ASC [ RunTime:0.015565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814707 LIMIT 5 [ RunTime:0.001511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814707 ORDER BY `minOrder` ASC [ RunTime:0.013491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814707 ORDER BY `unit` DESC [ RunTime:0.009081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814707 LIMIT 2 [ RunTime:0.032018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814707 ORDER BY `minOrder` ASC [ RunTime:0.017947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812657 LIMIT 5 [ RunTime:0.013870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812657 ORDER BY `minOrder` ASC [ RunTime:0.016678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14812657 ORDER BY `unit` DESC [ RunTime:0.018928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14812657 LIMIT 2 [ RunTime:0.001996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14812657 ORDER BY `minOrder` ASC [ RunTime:0.006189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811837 LIMIT 5 [ RunTime:0.014968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811837 ORDER BY `minOrder` ASC [ RunTime:0.012544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811837 ORDER BY `unit` DESC [ RunTime:0.016174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811837 LIMIT 2 [ RunTime:0.003348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811837 ORDER BY `minOrder` ASC [ RunTime:0.003561s ]
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 '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013499s ]
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 '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42105798 LIMIT 5 [ RunTime:0.018574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105798 ORDER BY `minOrder` ASC [ RunTime:0.047927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42105798 ORDER BY `unit` DESC [ RunTime:0.008806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42105798 LIMIT 2 [ RunTime:0.043015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42105798 ORDER BY `minOrder` ASC [ RunTime:0.018863s ]
select * from pdf where partno='1.5KE7.5CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.045672s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.003203s ]
SELECT `id` FROM `stock` WHERE `id` <> 42105798 AND `partno` = '1.5KE7.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.036798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912572 [ RunTime:0.006961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162002 LIMIT 5 [ RunTime:0.008093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162002 ORDER BY `minOrder` ASC [ RunTime:0.003083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162002 ORDER BY `unit` DESC [ RunTime:0.004433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162002 LIMIT 2 [ RunTime:0.004697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162002 ORDER BY `minOrder` ASC [ RunTime:0.007234s ]
select * from pdf where partno='1.5KE7.5CA' and brandshort='Lumimax Optoelectronic Technology' limit 1 [ RunTime:0.016987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA' OR `brand` LIKE 'Lumimax Optoelectronic Technology%' ) ) LIMIT 1 [ RunTime:0.036932s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162002 AND `partno` = '1.5KE7.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumimax optoelectronic technology%' ) [ RunTime:0.029508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802016 [ RunTime:0.017954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170285 LIMIT 5 [ RunTime:0.032112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170285 ORDER BY `minOrder` ASC [ RunTime:0.036117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170285 ORDER BY `unit` DESC [ RunTime:0.033275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170285 LIMIT 2 [ RunTime:0.012859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170285 ORDER BY `minOrder` ASC [ RunTime:0.004158s ]
select * from pdf where partno='1.5KE7.5CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.032787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.013646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174925 LIMIT 5 [ RunTime:0.015569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174925 ORDER BY `minOrder` ASC [ RunTime:0.019900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174925 ORDER BY `unit` DESC [ RunTime:0.014291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174925 LIMIT 2 [ RunTime:0.014571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174925 ORDER BY `minOrder` ASC [ RunTime:0.009015s ]
select * from pdf where partno='1.5KE7.5CA' and brandshort='Meritek' limit 1 [ RunTime:0.011207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA' OR `brand` LIKE 'Meritek%' ) ) LIMIT 1 [ RunTime:0.002047s ]
SELECT `id` FROM `stock` WHERE `id` <> 42174925 AND `partno` = '1.5KE7.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%meritek%' ) [ RunTime:0.000786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908383 [ RunTime:0.001649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42107230 LIMIT 5 [ RunTime:0.005201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42107230 ORDER BY `minOrder` ASC [ RunTime:0.004160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42107230 ORDER BY `unit` DESC [ RunTime:0.006153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42107230 LIMIT 2 [ RunTime:0.007018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42107230 ORDER BY `minOrder` ASC [ RunTime:0.004170s ]
select * from pdf where partno='1.5KE7.5CA-E3/54' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA-E3/54' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014913s ]
SELECT `id` FROM `stock` WHERE `id` <> 42107230 AND `partno` = '1.5KE7.5CA-E3/54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809526 [ RunTime:0.014991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42295673 LIMIT 5 [ RunTime:0.012435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295673 ORDER BY `minOrder` ASC [ RunTime:0.019751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42295673 ORDER BY `unit` DESC [ RunTime:0.004197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42295673 LIMIT 2 [ RunTime:0.015579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42295673 ORDER BY `minOrder` ASC [ RunTime:0.004091s ]
select * from pdf where partno='1.5KE7.5CA_R2_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.007379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA_R2_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.011757s ]
SELECT `id` FROM `stock` WHERE `id` <> 42295673 AND `partno` = '1.5KE7.5CA_R2_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.000957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921124 [ RunTime:0.018329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42294772 LIMIT 5 [ RunTime:0.024978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294772 ORDER BY `minOrder` ASC [ RunTime:0.001612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42294772 ORDER BY `unit` DESC [ RunTime:0.000717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42294772 LIMIT 2 [ RunTime:0.005226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42294772 ORDER BY `minOrder` ASC [ RunTime:0.007391s ]
select * from pdf where partno='1.5KE7.5CA-T-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.018270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA-T-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.025014s ]
SELECT `id` FROM `stock` WHERE `id` <> 42294772 AND `partno` = '1.5KE7.5CA-T-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.012492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921020 [ RunTime:0.013355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42291412 LIMIT 5 [ RunTime:0.025266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291412 ORDER BY `minOrder` ASC [ RunTime:0.079323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42291412 ORDER BY `unit` DESC [ RunTime:0.007826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42291412 LIMIT 2 [ RunTime:0.036734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291412 ORDER BY `minOrder` ASC [ RunTime:0.011103s ]
select * from pdf where partno='1.5KE7.5CA-E3/73' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.031607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA-E3/73' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014166s ]
SELECT `id` FROM `stock` WHERE `id` <> 42291412 AND `partno` = '1.5KE7.5CA-E3/73' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.061523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42291135 LIMIT 5 [ RunTime:0.037147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291135 ORDER BY `minOrder` ASC [ RunTime:0.010304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42291135 ORDER BY `unit` DESC [ RunTime:0.002484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42291135 LIMIT 2 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42291135 ORDER BY `minOrder` ASC [ RunTime:0.010937s ]
select * from pdf where partno='1.5KE7.5CAHE3_B/C' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.023876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CAHE3_B/C' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.028892s ]
SELECT `id` FROM `stock` WHERE `id` <> 42291135 AND `partno` = '1.5KE7.5CAHE3_B/C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.029661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919451 [ RunTime:0.003770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42279328 LIMIT 5 [ RunTime:0.004652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279328 ORDER BY `minOrder` ASC [ RunTime:0.004281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42279328 ORDER BY `unit` DESC [ RunTime:0.000578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42279328 LIMIT 2 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279328 ORDER BY `minOrder` ASC [ RunTime:0.002432s ]
select * from pdf where partno='1.5KE7.5CA-G' and brandshort='Comchip Technology' limit 1 [ RunTime:0.044097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA-G' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.016059s ]
SELECT `id` FROM `stock` WHERE `id` <> 42279328 AND `partno` = '1.5KE7.5CA-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.000955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676441 [ RunTime:0.009759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42279299 LIMIT 5 [ RunTime:0.022754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279299 ORDER BY `minOrder` ASC [ RunTime:0.013108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42279299 ORDER BY `unit` DESC [ RunTime:0.000914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42279299 LIMIT 2 [ RunTime:0.051705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279299 ORDER BY `minOrder` ASC [ RunTime:0.007082s ]
select * from pdf where partno='1.5KE7.5CA-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.030189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.026206s ]
SELECT `id` FROM `stock` WHERE `id` <> 42279299 AND `partno` = '1.5KE7.5CA-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.020094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919097 [ RunTime:0.021492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42272235 LIMIT 5 [ RunTime:0.043086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272235 ORDER BY `minOrder` ASC [ RunTime:0.016875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42272235 ORDER BY `unit` DESC [ RunTime:0.021485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42272235 LIMIT 2 [ RunTime:0.019971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42272235 ORDER BY `minOrder` ASC [ RunTime:0.017224s ]
select * from pdf where partno='1.5KE7.5CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.026187s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.013573s ]
SELECT `id` FROM `stock` WHERE `id` <> 42272235 AND `partno` = '1.5KE7.5CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.014661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917747 [ RunTime:0.026557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42267609 LIMIT 5 [ RunTime:0.012796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267609 ORDER BY `minOrder` ASC [ RunTime:0.038145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42267609 ORDER BY `unit` DESC [ RunTime:0.016933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42267609 LIMIT 2 [ RunTime:0.016250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42267609 ORDER BY `minOrder` ASC [ RunTime:0.011443s ]
select * from pdf where partno='1.5KE7.5CAE3/TR13' and brandshort='Microsemi Corporation' limit 1 [ RunTime:0.016773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CAE3/TR13' OR `brand` LIKE 'Microsemi Corporation%' ) ) LIMIT 1 [ RunTime:0.044410s ]
SELECT `id` FROM `stock` WHERE `id` <> 42267609 AND `partno` = '1.5KE7.5CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microsemi corporation%' ) [ RunTime:0.021595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918043 [ RunTime:0.028328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262734 LIMIT 5 [ RunTime:0.005908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262734 ORDER BY `minOrder` ASC [ RunTime:0.022297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262734 ORDER BY `unit` DESC [ RunTime:0.043610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262734 LIMIT 2 [ RunTime:0.013615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262734 ORDER BY `minOrder` ASC [ RunTime:0.010430s ]
select * from pdf where partno='1.5KE7.5CH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.019672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.032039s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262734 AND `partno` = '1.5KE7.5CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.043406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674876 [ RunTime:0.001906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262726 LIMIT 5 [ RunTime:0.002903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262726 ORDER BY `minOrder` ASC [ RunTime:0.014487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262726 ORDER BY `unit` DESC [ RunTime:0.023417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262726 LIMIT 2 [ RunTime:0.031425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262726 ORDER BY `minOrder` ASC [ RunTime:0.014340s ]
select * from pdf where partno='1.5KE7.5C' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.016658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5C' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.016143s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262726 AND `partno` = '1.5KE7.5C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.001057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674424 [ RunTime:0.007334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42262240 LIMIT 5 [ RunTime:0.000689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262240 ORDER BY `minOrder` ASC [ RunTime:0.015506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42262240 ORDER BY `unit` DESC [ RunTime:0.009696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42262240 LIMIT 2 [ RunTime:0.021592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42262240 ORDER BY `minOrder` ASC [ RunTime:0.035057s ]
select * from pdf where partno='1.5KE7.5CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.025000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.030841s ]
SELECT `id` FROM `stock` WHERE `id` <> 42262240 AND `partno` = '1.5KE7.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.021823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814707 [ RunTime:0.088824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42245904 LIMIT 5 [ RunTime:0.017799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245904 ORDER BY `minOrder` ASC [ RunTime:0.014834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42245904 ORDER BY `unit` DESC [ RunTime:0.004522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42245904 LIMIT 2 [ RunTime:0.027477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42245904 ORDER BY `minOrder` ASC [ RunTime:0.015376s ]
select * from pdf where partno='1.5KE7.5CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.021293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.030069s ]
SELECT `id` FROM `stock` WHERE `id` <> 42245904 AND `partno` = '1.5KE7.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.015885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675671 [ RunTime:0.018728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42238574 LIMIT 5 [ RunTime:0.014631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238574 ORDER BY `minOrder` ASC [ RunTime:0.005451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42238574 ORDER BY `unit` DESC [ RunTime:0.002915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42238574 LIMIT 2 [ RunTime:0.001141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42238574 ORDER BY `minOrder` ASC [ RunTime:0.008134s ]
select * from pdf where partno='1.5KE7.5CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.026656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.029066s ]
SELECT `id` FROM `stock` WHERE `id` <> 42238574 AND `partno` = '1.5KE7.5CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.027018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812657 [ RunTime:0.014441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42236776 LIMIT 5 [ RunTime:0.016612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236776 ORDER BY `minOrder` ASC [ RunTime:0.020301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42236776 ORDER BY `unit` DESC [ RunTime:0.017135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42236776 LIMIT 2 [ RunTime:0.024436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236776 ORDER BY `minOrder` ASC [ RunTime:0.013067s ]
select * from pdf where partno='1.5KE7.5CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.022545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.008194s ]
SELECT `id` FROM `stock` WHERE `id` <> 42236776 AND `partno` = '1.5KE7.5CA-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.046462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916414 [ RunTime:0.013199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42223814 LIMIT 5 [ RunTime:0.054138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223814 ORDER BY `minOrder` ASC [ RunTime:0.012326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42223814 ORDER BY `unit` DESC [ RunTime:0.014257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42223814 LIMIT 2 [ RunTime:0.008446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42223814 ORDER BY `minOrder` ASC [ RunTime:0.002395s ]
select * from pdf where partno='1.5KE7.5CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.003127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE7.5CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003705s ]
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 '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004581s ]
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 '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012063s ]
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 '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016557s ]
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 '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003372s ]
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 '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008567s ]
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 '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009993s ]
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 '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006965s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1.5KE7.5C%' OR `brand` LIKE '1.5KE7.5C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007379s ]