SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001846s ]
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=P6SMB30CA&search=1' [ RunTime:0.005274s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001874s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004188s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002390s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.004134s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001492s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001156s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001190s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6SMB30CA' LIMIT 1 [ RunTime:0.010470s ]
UPDATE `stock_search` SET `count` = 7 , `updatetime` = '2026-08-17 16:24:30' WHERE `partno` = 'P6SMB30CA' [ RunTime:0.014345s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001402s ]
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 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056719s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663473 LIMIT 5 [ RunTime:0.021641s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.021447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663473 ORDER BY `minOrder` ASC [ RunTime:0.055416s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663473 ORDER BY `unit` DESC [ RunTime:0.056864s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.048301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663473 LIMIT 2 [ RunTime:0.014614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663473 ORDER BY `minOrder` ASC [ RunTime:0.042844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16678842 LIMIT 5 [ RunTime:0.021054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678842 ORDER BY `minOrder` ASC [ RunTime:0.029244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16678842 ORDER BY `unit` DESC [ RunTime:0.007460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16678842 LIMIT 2 [ RunTime:0.053335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16678842 ORDER BY `minOrder` ASC [ RunTime:0.043345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806560 LIMIT 5 [ RunTime:0.020094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806560 ORDER BY `minOrder` ASC [ RunTime:0.013121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806560 ORDER BY `unit` DESC [ RunTime:0.033954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806560 LIMIT 2 [ RunTime:0.024225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806560 ORDER BY `minOrder` ASC [ RunTime:0.007985s ]
select * from pdf where partno='P6SMB30CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665257 LIMIT 5 [ RunTime:0.011643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665257 ORDER BY `minOrder` ASC [ RunTime:0.013419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665257 ORDER BY `unit` DESC [ RunTime:0.024421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665257 LIMIT 2 [ RunTime:0.004220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665257 ORDER BY `minOrder` ASC [ RunTime:0.009388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931870 LIMIT 5 [ RunTime:0.050338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931870 ORDER BY `minOrder` ASC [ RunTime:0.076157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931870 ORDER BY `unit` DESC [ RunTime:0.036447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931870 LIMIT 2 [ RunTime:0.047361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931870 ORDER BY `minOrder` ASC [ RunTime:0.014241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685793 LIMIT 5 [ RunTime:0.003865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685793 ORDER BY `minOrder` ASC [ RunTime:0.013985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16685793 ORDER BY `unit` DESC [ RunTime:0.002988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16685793 LIMIT 2 [ RunTime:0.011310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685793 ORDER BY `minOrder` ASC [ RunTime:0.012216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675520 LIMIT 5 [ RunTime:0.005610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675520 ORDER BY `minOrder` ASC [ RunTime:0.011014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675520 ORDER BY `unit` DESC [ RunTime:0.003467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675520 LIMIT 2 [ RunTime:0.008833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675520 ORDER BY `minOrder` ASC [ RunTime:0.002645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928208 LIMIT 5 [ RunTime:0.014440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928208 ORDER BY `minOrder` ASC [ RunTime:0.003470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928208 ORDER BY `unit` DESC [ RunTime:0.004274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928208 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928208 ORDER BY `minOrder` ASC [ RunTime:0.001824s ]
select * from pdf where partno='P6SMB30CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688853 LIMIT 5 [ RunTime:0.012934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688853 ORDER BY `minOrder` ASC [ RunTime:0.003749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688853 ORDER BY `unit` DESC [ RunTime:0.013935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688853 LIMIT 2 [ RunTime:0.004908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688853 ORDER BY `minOrder` ASC [ RunTime:0.001614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692558 LIMIT 5 [ RunTime:0.004004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692558 ORDER BY `minOrder` ASC [ RunTime:0.008783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692558 ORDER BY `unit` DESC [ RunTime:0.009018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692558 LIMIT 2 [ RunTime:0.003706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692558 ORDER BY `minOrder` ASC [ RunTime:0.003685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3430 LIMIT 5 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3430 ORDER BY `minOrder` ASC [ RunTime:0.001484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3430 ORDER BY `unit` DESC [ RunTime:0.005770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3430 LIMIT 2 [ RunTime:0.010659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3430 ORDER BY `minOrder` ASC [ RunTime:0.001655s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA.' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.019573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664564 LIMIT 5 [ RunTime:0.053873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664564 ORDER BY `minOrder` ASC [ RunTime:0.012471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664564 ORDER BY `unit` DESC [ RunTime:0.016216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664564 LIMIT 2 [ RunTime:0.011833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664564 ORDER BY `minOrder` ASC [ RunTime:0.018362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908067 LIMIT 5 [ RunTime:0.020656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908067 ORDER BY `minOrder` ASC [ RunTime:0.015042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908067 ORDER BY `unit` DESC [ RunTime:0.002021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908067 LIMIT 2 [ RunTime:0.024207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908067 ORDER BY `minOrder` ASC [ RunTime:0.012446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908442 LIMIT 5 [ RunTime:0.018150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908442 ORDER BY `minOrder` ASC [ RunTime:0.019790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908442 ORDER BY `unit` DESC [ RunTime:0.010978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908442 LIMIT 2 [ RunTime:0.004631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908442 ORDER BY `minOrder` ASC [ RunTime:0.003459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907833 LIMIT 5 [ RunTime:0.007312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907833 ORDER BY `minOrder` ASC [ RunTime:0.005639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907833 ORDER BY `unit` DESC [ RunTime:0.005956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907833 LIMIT 2 [ RunTime:0.003948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907833 ORDER BY `minOrder` ASC [ RunTime:0.005176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802732 LIMIT 5 [ RunTime:0.001709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802732 ORDER BY `minOrder` ASC [ RunTime:0.002508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802732 ORDER BY `unit` DESC [ RunTime:0.011840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802732 LIMIT 2 [ RunTime:0.000223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802732 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690979 LIMIT 5 [ RunTime:0.007272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690979 ORDER BY `minOrder` ASC [ RunTime:0.019017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690979 ORDER BY `unit` DESC [ RunTime:0.015728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690979 LIMIT 2 [ RunTime:0.025886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690979 ORDER BY `minOrder` ASC [ RunTime:0.008709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688764 LIMIT 5 [ RunTime:0.010923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688764 ORDER BY `minOrder` ASC [ RunTime:0.008959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688764 ORDER BY `unit` DESC [ RunTime:0.006292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688764 LIMIT 2 [ RunTime:0.008529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688764 ORDER BY `minOrder` ASC [ RunTime:0.007491s ]
select * from pdf where partno='P6SMB30CAHE3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687759 LIMIT 5 [ RunTime:0.010646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687759 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687759 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687759 LIMIT 2 [ RunTime:0.002209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687759 ORDER BY `minOrder` ASC [ RunTime:0.007204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673191 LIMIT 5 [ RunTime:0.015138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673191 ORDER BY `minOrder` ASC [ RunTime:0.009057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673191 ORDER BY `unit` DESC [ RunTime:0.022704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673191 LIMIT 2 [ RunTime:0.009973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673191 ORDER BY `minOrder` ASC [ RunTime:0.010588s ]
select * from pdf where partno='P6SMB30CA-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008081s ]
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 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141672 LIMIT 5 [ RunTime:0.020992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141672 ORDER BY `minOrder` ASC [ RunTime:0.019988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141672 ORDER BY `unit` DESC [ RunTime:0.008310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141672 LIMIT 2 [ RunTime:0.019933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141672 ORDER BY `minOrder` ASC [ RunTime:0.006533s ]
select * from pdf where partno='p6smb30ca-q' and brandshort='bourns' limit 1 [ RunTime:0.018997s ]
select foldpath,foldpath2,filename from pdf_file where id=1987465 limit 1 [ RunTime:0.012309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'p6smb30ca-q' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.019204s ]
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 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160735 LIMIT 5 [ RunTime:0.006349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160735 ORDER BY `minOrder` ASC [ RunTime:0.021551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160735 ORDER BY `unit` DESC [ RunTime:0.045004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160735 LIMIT 2 [ RunTime:0.026572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160735 ORDER BY `minOrder` ASC [ RunTime:0.023880s ]
select * from pdf where partno='P6SMB30CA' and brandshort='NextGen Components' limit 1 [ RunTime:0.018274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.016130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162145 LIMIT 5 [ RunTime:0.020644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162145 ORDER BY `minOrder` ASC [ RunTime:0.038445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162145 ORDER BY `unit` DESC [ RunTime:0.052456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162145 LIMIT 2 [ RunTime:0.023245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162145 ORDER BY `minOrder` ASC [ RunTime:0.015841s ]
select * from pdf where partno='P6SMB30CALS30C' and brandshort='LGE Diodes' limit 1 [ RunTime:0.018523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CALS30C' OR `brand` LIKE 'LGE Diodes%' ) ) LIMIT 1 [ RunTime:0.010268s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162145 AND `partno` = 'P6SMB30CALS30C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lge diodes%' ) [ RunTime:0.005574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42113770 LIMIT 5 [ RunTime:0.011843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113770 ORDER BY `minOrder` ASC [ RunTime:0.008626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42113770 ORDER BY `unit` DESC [ RunTime:0.009075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42113770 LIMIT 2 [ RunTime:0.019182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42113770 ORDER BY `minOrder` ASC [ RunTime:0.008228s ]
select * from pdf where partno='P6SMB30CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.011550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.015820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128964 LIMIT 5 [ RunTime:0.009154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128964 ORDER BY `minOrder` ASC [ RunTime:0.037405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128964 ORDER BY `unit` DESC [ RunTime:0.027295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128964 LIMIT 2 [ RunTime:0.055896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128964 ORDER BY `minOrder` ASC [ RunTime:0.005774s ]
select * from pdf where partno='P6SMB30CA' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.033903s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.045517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42115002 LIMIT 5 [ RunTime:0.005455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115002 ORDER BY `minOrder` ASC [ RunTime:0.014091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42115002 ORDER BY `unit` DESC [ RunTime:0.014705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42115002 LIMIT 2 [ RunTime:0.045789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115002 ORDER BY `minOrder` ASC [ RunTime:0.004879s ]
select * from pdf where partno='P6SMB30CAH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.042862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CAH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.007971s ]
SELECT `id` FROM `stock` WHERE `id` <> 42115002 AND `partno` = 'P6SMB30CAH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.010114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802732 [ RunTime:0.005126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42111229 LIMIT 5 [ RunTime:0.029564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111229 ORDER BY `minOrder` ASC [ RunTime:0.033224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42111229 ORDER BY `unit` DESC [ RunTime:0.022669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42111229 LIMIT 2 [ RunTime:0.048141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111229 ORDER BY `minOrder` ASC [ RunTime:0.038205s ]
select * from pdf where partno='P6SMB30CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.075852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.046203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42152561 LIMIT 5 [ RunTime:0.031102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152561 ORDER BY `minOrder` ASC [ RunTime:0.014255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42152561 ORDER BY `unit` DESC [ RunTime:0.004503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42152561 LIMIT 2 [ RunTime:0.049446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42152561 ORDER BY `minOrder` ASC [ RunTime:0.017978s ]
select * from pdf where partno='P6SMB30CA' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.018936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.017089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42102489 LIMIT 5 [ RunTime:0.028777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102489 ORDER BY `minOrder` ASC [ RunTime:0.029191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42102489 ORDER BY `unit` DESC [ RunTime:0.045372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42102489 LIMIT 2 [ RunTime:0.037041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42102489 ORDER BY `minOrder` ASC [ RunTime:0.018306s ]
select * from pdf where partno='P6SMB30CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.017560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168666 LIMIT 5 [ RunTime:0.010284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168666 ORDER BY `minOrder` ASC [ RunTime:0.041996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168666 ORDER BY `unit` DESC [ RunTime:0.012170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168666 LIMIT 2 [ RunTime:0.022883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168666 ORDER BY `minOrder` ASC [ RunTime:0.017821s ]
select * from pdf where partno='P6SMB30CA-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.030658s ]
SELECT `id` FROM `stock` WHERE `id` <> 42168666 AND `partno` = 'P6SMB30CA-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928208 [ RunTime:0.011299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42142528 LIMIT 5 [ RunTime:0.002833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142528 ORDER BY `minOrder` ASC [ RunTime:0.006447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42142528 ORDER BY `unit` DESC [ RunTime:0.000302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42142528 LIMIT 2 [ RunTime:0.000194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42142528 ORDER BY `minOrder` ASC [ RunTime:0.003517s ]
select * from pdf where partno='P6SMB30CAHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CAHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.008453s ]
SELECT `id` FROM `stock` WHERE `id` <> 42142528 AND `partno` = 'P6SMB30CAHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665257 [ RunTime:0.001222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42115570 LIMIT 5 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115570 ORDER BY `minOrder` ASC [ RunTime:0.019738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42115570 ORDER BY `unit` DESC [ RunTime:0.019802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42115570 LIMIT 2 [ RunTime:0.032302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42115570 ORDER BY `minOrder` ASC [ RunTime:0.018925s ]
select * from pdf where partno='P6SMB30CA-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.024825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.007437s ]
SELECT `id` FROM `stock` WHERE `id` <> 42115570 AND `partno` = 'P6SMB30CA-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.019637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688853 [ RunTime:0.016713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169729 LIMIT 5 [ RunTime:0.018994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169729 ORDER BY `minOrder` ASC [ RunTime:0.003997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169729 ORDER BY `unit` DESC [ RunTime:0.019326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169729 LIMIT 2 [ RunTime:0.009213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169729 ORDER BY `minOrder` ASC [ RunTime:0.005305s ]
select * from pdf where partno='P6SMB30CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.015644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.020383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42173143 LIMIT 5 [ RunTime:0.003961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173143 ORDER BY `minOrder` ASC [ RunTime:0.018002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42173143 ORDER BY `unit` DESC [ RunTime:0.006656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42173143 LIMIT 2 [ RunTime:0.010974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173143 ORDER BY `minOrder` ASC [ RunTime:0.002576s ]
select * from pdf where partno='P6SMB30CA_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.007409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.017383s ]
SELECT `id` FROM `stock` WHERE `id` <> 42173143 AND `partno` = 'P6SMB30CA_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.013798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908067 [ RunTime:0.016030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42174958 LIMIT 5 [ RunTime:0.017010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174958 ORDER BY `minOrder` ASC [ RunTime:0.019446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42174958 ORDER BY `unit` DESC [ RunTime:0.021610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42174958 LIMIT 2 [ RunTime:0.019909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42174958 ORDER BY `minOrder` ASC [ RunTime:0.041373s ]
select * from pdf where partno='P6SMB30CA' and brandshort='VIITOR SEMICONDUCTOR CO., LTD' limit 1 [ RunTime:0.024468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA' OR `brand` LIKE 'VIITOR SEMICONDUCTOR CO., LTD%' ) ) LIMIT 1 [ RunTime:0.015924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42171561 LIMIT 5 [ RunTime:0.001958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42171561 ORDER BY `minOrder` ASC [ RunTime:0.012194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42171561 ORDER BY `unit` DESC [ RunTime:0.030070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42171561 LIMIT 2 [ RunTime:0.018647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42171561 ORDER BY `minOrder` ASC [ RunTime:0.015060s ]
select * from pdf where partno='P6SMB30CA-AU_R1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.042637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CA-AU_R1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.008987s ]
SELECT `id` FROM `stock` WHERE `id` <> 42171561 AND `partno` = 'P6SMB30CA-AU_R1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.028798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907833 [ RunTime:0.135303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42292437 LIMIT 5 [ RunTime:0.043477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42292437 ORDER BY `minOrder` ASC [ RunTime:0.000844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42292437 ORDER BY `unit` DESC [ RunTime:0.009152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42292437 LIMIT 2 [ RunTime:0.008814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42292437 ORDER BY `minOrder` ASC [ RunTime:0.008893s ]
select * from pdf where partno='P6SMB30CAHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.016960s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CAHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.017941s ]
SELECT `id` FROM `stock` WHERE `id` <> 42292437 AND `partno` = 'P6SMB30CAHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819015 [ RunTime:0.016237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42258499 LIMIT 5 [ RunTime:0.017868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258499 ORDER BY `minOrder` ASC [ RunTime:0.024873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42258499 ORDER BY `unit` DESC [ RunTime:0.033990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42258499 LIMIT 2 [ RunTime:0.019795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258499 ORDER BY `minOrder` ASC [ RunTime:0.016952s ]
select * from pdf where partno='P6SMB30CAHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.028338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CAHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002546s ]
SELECT `id` FROM `stock` WHERE `id` <> 42258499 AND `partno` = 'P6SMB30CAHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915257 [ RunTime:0.030358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42258498 LIMIT 5 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258498 ORDER BY `minOrder` ASC [ RunTime:0.012885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42258498 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42258498 LIMIT 2 [ RunTime:0.005035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258498 ORDER BY `minOrder` ASC [ RunTime:0.010320s ]
select * from pdf where partno='P6SMB30CAHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CAHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.008975s ]
SELECT `id` FROM `stock` WHERE `id` <> 42258498 AND `partno` = 'P6SMB30CAHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.012703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812823 [ RunTime:0.008175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42256635 LIMIT 5 [ RunTime:0.013217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256635 ORDER BY `minOrder` ASC [ RunTime:0.007076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42256635 ORDER BY `unit` DESC [ RunTime:0.018525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42256635 LIMIT 2 [ RunTime:0.016453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256635 ORDER BY `minOrder` ASC [ RunTime:0.015391s ]
select * from pdf where partno='P6SMB30CAHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.025688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CAHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014426s ]
SELECT `id` FROM `stock` WHERE `id` <> 42256635 AND `partno` = 'P6SMB30CAHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.020646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14812833 [ RunTime:0.009565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42242513 LIMIT 5 [ RunTime:0.027038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242513 ORDER BY `minOrder` ASC [ RunTime:0.016791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42242513 ORDER BY `unit` DESC [ RunTime:0.016798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42242513 LIMIT 2 [ RunTime:0.007377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42242513 ORDER BY `minOrder` ASC [ RunTime:0.027650s ]
select * from pdf where partno='P6SMB30CAHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.019520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB30CAHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014549s ]
SELECT `id` FROM `stock` WHERE `id` <> 42242513 AND `partno` = 'P6SMB30CAHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.036139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813387 [ RunTime:0.010923s ]
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 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039690s ]
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 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057959s ]
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 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015876s ]
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 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047490s ]
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 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019116s ]
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 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039058s ]
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 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055205s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6SMB30CA%' OR `brand` LIKE 'P6SMB30CA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.062350s ]