SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001908s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.115' , `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=P4SMA16A&search=1' [ RunTime:0.002345s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002262s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001397s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002732s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.115' ) [ RunTime:0.000395s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002215s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003740s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002071s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P4SMA16A' LIMIT 1 [ RunTime:0.022460s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-15 00:40:21' WHERE `partno` = 'P4SMA16A' [ RunTime:0.004909s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001299s ]
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 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033060s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906572 LIMIT 5 [ RunTime:0.018154s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906572 ORDER BY `minOrder` ASC [ RunTime:0.011984s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906572 ORDER BY `unit` DESC [ RunTime:0.005219s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906572 LIMIT 2 [ RunTime:0.003510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906572 ORDER BY `minOrder` ASC [ RunTime:0.008070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685047 LIMIT 5 [ RunTime:0.041679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685047 ORDER BY `minOrder` ASC [ RunTime:0.021030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16685047 ORDER BY `unit` DESC [ RunTime:0.025196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16685047 LIMIT 2 [ RunTime:0.057232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685047 ORDER BY `minOrder` ASC [ RunTime:0.014169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926141 LIMIT 5 [ RunTime:0.023508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926141 ORDER BY `minOrder` ASC [ RunTime:0.042196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13926141 ORDER BY `unit` DESC [ RunTime:0.019730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13926141 LIMIT 2 [ RunTime:0.034237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13926141 ORDER BY `minOrder` ASC [ RunTime:0.018897s ]
select * from pdf where partno='P4SMA16A-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.019866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919581 LIMIT 5 [ RunTime:0.009286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919581 ORDER BY `minOrder` ASC [ RunTime:0.054545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13919581 ORDER BY `unit` DESC [ RunTime:0.030299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13919581 LIMIT 2 [ RunTime:0.050237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919581 ORDER BY `minOrder` ASC [ RunTime:0.018413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814334 LIMIT 5 [ RunTime:0.021757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814334 ORDER BY `minOrder` ASC [ RunTime:0.021565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14814334 ORDER BY `unit` DESC [ RunTime:0.012366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14814334 LIMIT 2 [ RunTime:0.040457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14814334 ORDER BY `minOrder` ASC [ RunTime:0.004468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800960 LIMIT 5 [ RunTime:0.013350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800960 ORDER BY `minOrder` ASC [ RunTime:0.009926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800960 ORDER BY `unit` DESC [ RunTime:0.026415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800960 LIMIT 2 [ RunTime:0.019207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800960 ORDER BY `minOrder` ASC [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692079 LIMIT 5 [ RunTime:0.000445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692079 ORDER BY `minOrder` ASC [ RunTime:0.005986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692079 ORDER BY `unit` DESC [ RunTime:0.006181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692079 LIMIT 2 [ RunTime:0.006646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692079 ORDER BY `minOrder` ASC [ RunTime:0.002425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16689315 LIMIT 5 [ RunTime:0.010036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689315 ORDER BY `minOrder` ASC [ RunTime:0.010979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16689315 ORDER BY `unit` DESC [ RunTime:0.004577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16689315 LIMIT 2 [ RunTime:0.012821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16689315 ORDER BY `minOrder` ASC [ RunTime:0.005459s ]
select * from pdf where partno='P4SMA16AHE3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667871 LIMIT 5 [ RunTime:0.010484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667871 ORDER BY `minOrder` ASC [ RunTime:0.001837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667871 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667871 LIMIT 2 [ RunTime:0.007606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667871 ORDER BY `minOrder` ASC [ RunTime:0.007127s ]
select * from pdf where partno='P4SMA16A-M3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667621 LIMIT 5 [ RunTime:0.004002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667621 ORDER BY `minOrder` ASC [ RunTime:0.000934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667621 ORDER BY `unit` DESC [ RunTime:0.001797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667621 LIMIT 2 [ RunTime:0.009601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667621 ORDER BY `minOrder` ASC [ RunTime:0.015298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667048 LIMIT 5 [ RunTime:0.001347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667048 ORDER BY `minOrder` ASC [ RunTime:0.008893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16667048 ORDER BY `unit` DESC [ RunTime:0.006319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16667048 LIMIT 2 [ RunTime:0.000859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16667048 ORDER BY `minOrder` ASC [ RunTime:0.009467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831280 LIMIT 5 [ RunTime:0.012050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831280 ORDER BY `minOrder` ASC [ RunTime:0.001981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831280 ORDER BY `unit` DESC [ RunTime:0.002470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831280 LIMIT 2 [ RunTime:0.002883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831280 ORDER BY `minOrder` ASC [ RunTime:0.003478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828847 LIMIT 5 [ RunTime:0.003179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828847 ORDER BY `minOrder` ASC [ RunTime:0.020352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828847 ORDER BY `unit` DESC [ RunTime:0.016646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828847 LIMIT 2 [ RunTime:0.012895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828847 ORDER BY `minOrder` ASC [ RunTime:0.005725s ]
select * from pdf where partno='P4SMA16AHE3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807777 LIMIT 5 [ RunTime:0.030386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807777 ORDER BY `minOrder` ASC [ RunTime:0.002973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807777 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807777 LIMIT 2 [ RunTime:0.001622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807777 ORDER BY `minOrder` ASC [ RunTime:0.005434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807120 LIMIT 5 [ RunTime:0.003381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807120 ORDER BY `minOrder` ASC [ RunTime:0.012135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807120 ORDER BY `unit` DESC [ RunTime:0.010212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807120 LIMIT 2 [ RunTime:0.003682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807120 ORDER BY `minOrder` ASC [ RunTime:0.005335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807085 LIMIT 5 [ RunTime:0.005057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807085 ORDER BY `minOrder` ASC [ RunTime:0.000787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807085 ORDER BY `unit` DESC [ RunTime:0.015177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807085 LIMIT 2 [ RunTime:0.006450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807085 ORDER BY `minOrder` ASC [ RunTime:0.003581s ]
select * from pdf where partno='P4SMA16A-M3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806117 LIMIT 5 [ RunTime:0.011788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806117 ORDER BY `minOrder` ASC [ RunTime:0.014097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806117 ORDER BY `unit` DESC [ RunTime:0.003146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806117 LIMIT 2 [ RunTime:0.008122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806117 ORDER BY `minOrder` ASC [ RunTime:0.003836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806088 LIMIT 5 [ RunTime:0.022381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806088 ORDER BY `minOrder` ASC [ RunTime:0.009988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806088 ORDER BY `unit` DESC [ RunTime:0.007571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806088 LIMIT 2 [ RunTime:0.005996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806088 ORDER BY `minOrder` ASC [ RunTime:0.030919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932506 LIMIT 5 [ RunTime:0.009485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932506 ORDER BY `minOrder` ASC [ RunTime:0.009204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932506 ORDER BY `unit` DESC [ RunTime:0.005427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932506 LIMIT 2 [ RunTime:0.013080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932506 ORDER BY `minOrder` ASC [ RunTime:0.014495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931740 LIMIT 5 [ RunTime:0.016024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931740 ORDER BY `minOrder` ASC [ RunTime:0.010683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931740 ORDER BY `unit` DESC [ RunTime:0.001953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931740 LIMIT 2 [ RunTime:0.006979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931740 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
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 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011505s ]
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 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160600 LIMIT 5 [ RunTime:0.022611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160600 ORDER BY `minOrder` ASC [ RunTime:0.022799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160600 ORDER BY `unit` DESC [ RunTime:0.011225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160600 LIMIT 2 [ RunTime:0.015723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160600 ORDER BY `minOrder` ASC [ RunTime:0.005702s ]
select * from pdf where partno='P4SMA16A' and brandshort='NextGen Components' limit 1 [ RunTime:0.021723s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002811s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.020586s ]
SELECT `id` FROM `stock` WHERE `id` <> 42160600 AND `partno` = 'P4SMA16A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.032920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906572 [ RunTime:0.004754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123477 LIMIT 5 [ RunTime:0.006246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123477 ORDER BY `minOrder` ASC [ RunTime:0.008498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123477 ORDER BY `unit` DESC [ RunTime:0.024092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123477 LIMIT 2 [ RunTime:0.007418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123477 ORDER BY `minOrder` ASC [ RunTime:0.001533s ]
select * from pdf where partno='P4SMA16A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.020419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.038335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42126753 LIMIT 5 [ RunTime:0.017832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126753 ORDER BY `minOrder` ASC [ RunTime:0.020704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42126753 ORDER BY `unit` DESC [ RunTime:0.006465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42126753 LIMIT 2 [ RunTime:0.030277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42126753 ORDER BY `minOrder` ASC [ RunTime:0.008200s ]
select * from pdf where partno='P4SMA16A-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.018424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A-E3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.027712s ]
SELECT `id` FROM `stock` WHERE `id` <> 42126753 AND `partno` = 'P4SMA16A-E3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13926141 [ RunTime:0.023490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112410 LIMIT 5 [ RunTime:0.014313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112410 ORDER BY `minOrder` ASC [ RunTime:0.034044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112410 ORDER BY `unit` DESC [ RunTime:0.020768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112410 LIMIT 2 [ RunTime:0.030867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112410 ORDER BY `minOrder` ASC [ RunTime:0.037288s ]
select * from pdf where partno='P4SMA16A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.058189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.046632s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112410 AND `partno` = 'P4SMA16A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.034366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14814334 [ RunTime:0.012659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42114982 LIMIT 5 [ RunTime:0.018421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114982 ORDER BY `minOrder` ASC [ RunTime:0.018809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42114982 ORDER BY `unit` DESC [ RunTime:0.039576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42114982 LIMIT 2 [ RunTime:0.038545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42114982 ORDER BY `minOrder` ASC [ RunTime:0.003223s ]
select * from pdf where partno='P4SMA16A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.018693s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.025641s ]
SELECT `id` FROM `stock` WHERE `id` <> 42114982 AND `partno` = 'P4SMA16A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.032006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919581 [ RunTime:0.022279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150852 LIMIT 5 [ RunTime:0.010012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150852 ORDER BY `minOrder` ASC [ RunTime:0.018149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150852 ORDER BY `unit` DESC [ RunTime:0.010345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150852 LIMIT 2 [ RunTime:0.019626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150852 ORDER BY `minOrder` ASC [ RunTime:0.007169s ]
select * from pdf where partno='P4SMA16AS_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.009246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16AS_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.016516s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150852 AND `partno` = 'P4SMA16AS_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.016074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800960 [ RunTime:0.023707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42205128 LIMIT 5 [ RunTime:0.006542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205128 ORDER BY `minOrder` ASC [ RunTime:0.007050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42205128 ORDER BY `unit` DESC [ RunTime:0.003976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42205128 LIMIT 2 [ RunTime:0.003114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42205128 ORDER BY `minOrder` ASC [ RunTime:0.000920s ]
select * from pdf where partno='P4SMA16A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.000892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002955s ]
SELECT `id` FROM `stock` WHERE `id` <> 42205128 AND `partno` = 'P4SMA16A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.000927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807777 [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42202417 LIMIT 5 [ RunTime:0.000954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202417 ORDER BY `minOrder` ASC [ RunTime:0.017619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42202417 ORDER BY `unit` DESC [ RunTime:0.022858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42202417 LIMIT 2 [ RunTime:0.017378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42202417 ORDER BY `minOrder` ASC [ RunTime:0.007460s ]
select * from pdf where partno='P4SMA16A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.013023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.003304s ]
SELECT `id` FROM `stock` WHERE `id` <> 42202417 AND `partno` = 'P4SMA16A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.005938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807120 [ RunTime:0.005223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42200570 LIMIT 5 [ RunTime:0.013439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42200570 ORDER BY `minOrder` ASC [ RunTime:0.004205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42200570 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42200570 LIMIT 2 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42200570 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='P4SMA16A-M3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A-M3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000521s ]
SELECT `id` FROM `stock` WHERE `id` <> 42200570 AND `partno` = 'P4SMA16A-M3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667871 [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42199195 LIMIT 5 [ RunTime:0.003033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199195 ORDER BY `minOrder` ASC [ RunTime:0.005314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42199195 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42199195 LIMIT 2 [ RunTime:0.002664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42199195 ORDER BY `minOrder` ASC [ RunTime:0.017991s ]
select * from pdf where partno='P4SMA16A-M3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A-M3/5A' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000546s ]
SELECT `id` FROM `stock` WHERE `id` <> 42199195 AND `partno` = 'P4SMA16A-M3/5A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807085 [ RunTime:0.000553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42196843 LIMIT 5 [ RunTime:0.001278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196843 ORDER BY `minOrder` ASC [ RunTime:0.004979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42196843 ORDER BY `unit` DESC [ RunTime:0.003838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42196843 LIMIT 2 [ RunTime:0.000970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42196843 ORDER BY `minOrder` ASC [ RunTime:0.003607s ]
select * from pdf where partno='P4SMA16A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.013350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.000981s ]
SELECT `id` FROM `stock` WHERE `id` <> 42196843 AND `partno` = 'P4SMA16A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.005853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919837 [ RunTime:0.010832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42195326 LIMIT 5 [ RunTime:0.009124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42195326 ORDER BY `minOrder` ASC [ RunTime:0.004796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42195326 ORDER BY `unit` DESC [ RunTime:0.004504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42195326 LIMIT 2 [ RunTime:0.002470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42195326 ORDER BY `minOrder` ASC [ RunTime:0.005658s ]
select * from pdf where partno='P4SMA16AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.002715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002162s ]
SELECT `id` FROM `stock` WHERE `id` <> 42195326 AND `partno` = 'P4SMA16AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.005114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910711 [ RunTime:0.001249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42195325 LIMIT 5 [ RunTime:0.016230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42195325 ORDER BY `minOrder` ASC [ RunTime:0.016948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42195325 ORDER BY `unit` DESC [ RunTime:0.002278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42195325 LIMIT 2 [ RunTime:0.001712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42195325 ORDER BY `minOrder` ASC [ RunTime:0.002668s ]
select * from pdf where partno='P4SMA16A' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.008452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002735s ]
SELECT `id` FROM `stock` WHERE `id` <> 42195325 AND `partno` = 'P4SMA16A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.017432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16667048 [ RunTime:0.006093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42192111 LIMIT 5 [ RunTime:0.005555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192111 ORDER BY `minOrder` ASC [ RunTime:0.004847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42192111 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42192111 LIMIT 2 [ RunTime:0.012442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42192111 ORDER BY `minOrder` ASC [ RunTime:0.003246s ]
select * from pdf where partno='P4SMA16A-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.001377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42191003 LIMIT 5 [ RunTime:0.004749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191003 ORDER BY `minOrder` ASC [ RunTime:0.006349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42191003 ORDER BY `unit` DESC [ RunTime:0.002354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42191003 LIMIT 2 [ RunTime:0.021796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42191003 ORDER BY `minOrder` ASC [ RunTime:0.002394s ]
select * from pdf where partno='P4SMA16A-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.000370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42187830 LIMIT 5 [ RunTime:0.001282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187830 ORDER BY `minOrder` ASC [ RunTime:0.003286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42187830 ORDER BY `unit` DESC [ RunTime:0.002418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42187830 LIMIT 2 [ RunTime:0.009142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42187830 ORDER BY `minOrder` ASC [ RunTime:0.004598s ]
select * from pdf where partno='P4SMA16A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.002503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42178210 LIMIT 5 [ RunTime:0.010693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42178210 ORDER BY `minOrder` ASC [ RunTime:0.010090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42178210 ORDER BY `unit` DESC [ RunTime:0.006382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42178210 LIMIT 2 [ RunTime:0.001942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42178210 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='P4SMA16A-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P4SMA16A-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001085s ]
SELECT `id` FROM `stock` WHERE `id` <> 42178210 AND `partno` = 'P4SMA16A-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908675 [ RunTime:0.017681s ]
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 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002692s ]
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 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017863s ]
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 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006847s ]
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 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012720s ]
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 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009955s ]
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 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017425s ]
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 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007970s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P4SMA16A%' OR `brand` LIKE 'P4SMA16A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005710s ]