SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002242s ]
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=BZX84C39&search=1' [ RunTime:0.002663s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001255s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000447s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001565s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.115' ) [ RunTime:0.006732s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001476s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008163s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001320s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BZX84C39' LIMIT 1 [ RunTime:0.007406s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-15 00:33:34' WHERE `partno` = 'BZX84C39' [ RunTime:0.011660s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001308s ]
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 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007703s ]
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 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005832s ]
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 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031319s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58643663 LIMIT 5 [ RunTime:0.020432s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58643663 ORDER BY `minOrder` ASC [ RunTime:0.014238s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58643663 ORDER BY `unit` DESC [ RunTime:0.009185s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58643663 LIMIT 2 [ RunTime:0.004264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58643663 ORDER BY `minOrder` ASC [ RunTime:0.003371s ]
select * from pdf where partno='BZX84C39-E3-08' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014723s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39-E3-08' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003323s ]
SELECT `id` FROM `stock` WHERE `id` <> 58643663 AND `partno` = 'BZX84C39-E3-08' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58640690 LIMIT 5 [ RunTime:0.024081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58640690 ORDER BY `minOrder` ASC [ RunTime:0.032298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58640690 ORDER BY `unit` DESC [ RunTime:0.015280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58640690 LIMIT 2 [ RunTime:0.025000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58640690 ORDER BY `minOrder` ASC [ RunTime:0.022486s ]
select * from pdf where partno='BZX84C39LT1G' and brandshort='onsemi' limit 1 [ RunTime:0.051703s ]
select foldpath,foldpath2,filename from pdf_file where id=321148 limit 1 [ RunTime:0.066800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39LT1G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.043727s ]
SELECT `id` FROM `stock` WHERE `id` <> 58640690 AND `partno` = 'BZX84C39LT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.057329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58646952 LIMIT 5 [ RunTime:0.057516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58646952 ORDER BY `minOrder` ASC [ RunTime:0.044576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58646952 ORDER BY `unit` DESC [ RunTime:0.009807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58646952 LIMIT 2 [ RunTime:0.092675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58646952 ORDER BY `minOrder` ASC [ RunTime:0.037372s ]
select * from pdf where partno='BZX84C39H RFG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.021129s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39H RFG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.056160s ]
SELECT `id` FROM `stock` WHERE `id` <> 58646952 AND `partno` = 'BZX84C39H RFG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.023659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58645247 LIMIT 5 [ RunTime:0.042150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58645247 ORDER BY `minOrder` ASC [ RunTime:0.026468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58645247 ORDER BY `unit` DESC [ RunTime:0.027286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58645247 LIMIT 2 [ RunTime:0.007357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58645247 ORDER BY `minOrder` ASC [ RunTime:0.005839s ]
select * from pdf where partno='BZX84C39WHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.024964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39WHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.007186s ]
SELECT `id` FROM `stock` WHERE `id` <> 58645247 AND `partno` = 'BZX84C39WHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.004149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58647054 LIMIT 5 [ RunTime:0.014197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58647054 ORDER BY `minOrder` ASC [ RunTime:0.013972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58647054 ORDER BY `unit` DESC [ RunTime:0.003883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58647054 LIMIT 2 [ RunTime:0.004373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58647054 ORDER BY `minOrder` ASC [ RunTime:0.006575s ]
select * from pdf where partno='BZX84C39HE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.010511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39HE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.013855s ]
SELECT `id` FROM `stock` WHERE `id` <> 58647054 AND `partno` = 'BZX84C39HE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.001590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58650468 LIMIT 5 [ RunTime:0.006358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58650468 ORDER BY `minOrder` ASC [ RunTime:0.009757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58650468 ORDER BY `unit` DESC [ RunTime:0.003110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58650468 LIMIT 2 [ RunTime:0.008015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58650468 ORDER BY `minOrder` ASC [ RunTime:0.002359s ]
select * from pdf where partno='BZX84C39W-AU_R1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.019076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39W-AU_R1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.007032s ]
SELECT `id` FROM `stock` WHERE `id` <> 58650468 AND `partno` = 'BZX84C39W-AU_R1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.003886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58645207 LIMIT 5 [ RunTime:0.006537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58645207 ORDER BY `minOrder` ASC [ RunTime:0.005998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58645207 ORDER BY `unit` DESC [ RunTime:0.002029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58645207 LIMIT 2 [ RunTime:0.007532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58645207 ORDER BY `minOrder` ASC [ RunTime:0.006426s ]
select * from pdf where partno='BZX84C39 RFG' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39 RFG' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.003306s ]
SELECT `id` FROM `stock` WHERE `id` <> 58645207 AND `partno` = 'BZX84C39 RFG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58647786 LIMIT 5 [ RunTime:0.018786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58647786 ORDER BY `minOrder` ASC [ RunTime:0.038858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58647786 ORDER BY `unit` DESC [ RunTime:0.015492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58647786 LIMIT 2 [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58647786 ORDER BY `minOrder` ASC [ RunTime:0.002620s ]
select * from pdf where partno='BZX84C39_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.004849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.004795s ]
SELECT `id` FROM `stock` WHERE `id` <> 58647786 AND `partno` = 'BZX84C39_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.005913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58647253 LIMIT 5 [ RunTime:0.004040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58647253 ORDER BY `minOrder` ASC [ RunTime:0.004363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58647253 ORDER BY `unit` DESC [ RunTime:0.003516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58647253 LIMIT 2 [ RunTime:0.003350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58647253 ORDER BY `minOrder` ASC [ RunTime:0.001654s ]
select * from pdf where partno='BZX84C39VDBZR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.001009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39VDBZR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.001709s ]
SELECT `id` FROM `stock` WHERE `id` <> 58647253 AND `partno` = 'BZX84C39VDBZR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58647328 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58647328 ORDER BY `minOrder` ASC [ RunTime:0.000994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58647328 ORDER BY `unit` DESC [ RunTime:0.006661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58647328 LIMIT 2 [ RunTime:0.003132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58647328 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
select * from pdf where partno='BZX84C39VDBZRQ1' and brandshort='Texas Instruments' limit 1 [ RunTime:0.003213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39VDBZRQ1' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.019074s ]
SELECT `id` FROM `stock` WHERE `id` <> 58647328 AND `partno` = 'BZX84C39VDBZRQ1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.044003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58642517 LIMIT 5 [ RunTime:0.038106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58642517 ORDER BY `minOrder` ASC [ RunTime:0.023040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58642517 ORDER BY `unit` DESC [ RunTime:0.038587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58642517 LIMIT 2 [ RunTime:0.006912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58642517 ORDER BY `minOrder` ASC [ RunTime:0.006823s ]
select * from pdf where partno='BZX84C39-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.012781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.023001s ]
SELECT `id` FROM `stock` WHERE `id` <> 58642517 AND `partno` = 'BZX84C39-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.018119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58646481 LIMIT 5 [ RunTime:0.005492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58646481 ORDER BY `minOrder` ASC [ RunTime:0.003174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58646481 ORDER BY `unit` DESC [ RunTime:0.010406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58646481 LIMIT 2 [ RunTime:0.006204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58646481 ORDER BY `minOrder` ASC [ RunTime:0.004588s ]
select * from pdf where partno='BZX84C39' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.001666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000503s ]
SELECT `id` FROM `stock` WHERE `id` <> 58646481 AND `partno` = 'BZX84C39' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diotec semiconductor%' ) [ RunTime:0.007843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58650546 LIMIT 5 [ RunTime:0.006285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58650546 ORDER BY `minOrder` ASC [ RunTime:0.009491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58650546 ORDER BY `unit` DESC [ RunTime:0.003973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58650546 LIMIT 2 [ RunTime:0.007934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58650546 ORDER BY `minOrder` ASC [ RunTime:0.003618s ]
select * from pdf where partno='BZX84C39-AU_R1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.003956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39-AU_R1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.002296s ]
SELECT `id` FROM `stock` WHERE `id` <> 58650546 AND `partno` = 'BZX84C39-AU_R1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.002086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58654406 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58654406 ORDER BY `minOrder` ASC [ RunTime:0.002693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58654406 ORDER BY `unit` DESC [ RunTime:0.000378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58654406 LIMIT 2 [ RunTime:0.003317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58654406 ORDER BY `minOrder` ASC [ RunTime:0.007369s ]
select * from pdf where partno='BZX84C39-7-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.000687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39-7-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.008778s ]
SELECT `id` FROM `stock` WHERE `id` <> 58654406 AND `partno` = 'BZX84C39-7-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58712527 LIMIT 5 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58712527 ORDER BY `minOrder` ASC [ RunTime:0.017454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58712527 ORDER BY `unit` DESC [ RunTime:0.006205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58712527 LIMIT 2 [ RunTime:0.005180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58712527 ORDER BY `minOrder` ASC [ RunTime:0.003648s ]
select * from pdf where partno='BZX84C39TS-7-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.008072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39TS-7-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.011934s ]
SELECT `id` FROM `stock` WHERE `id` <> 58712527 AND `partno` = 'BZX84C39TS-7-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.004003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58712379 LIMIT 5 [ RunTime:0.008286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58712379 ORDER BY `minOrder` ASC [ RunTime:0.016712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58712379 ORDER BY `unit` DESC [ RunTime:0.012872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58712379 LIMIT 2 [ RunTime:0.005027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58712379 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
select * from pdf where partno='BZX84C39S-7-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.011754s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39S-7-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.013152s ]
SELECT `id` FROM `stock` WHERE `id` <> 58712379 AND `partno` = 'BZX84C39S-7-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.023211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58711709 LIMIT 5 [ RunTime:0.006520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58711709 ORDER BY `minOrder` ASC [ RunTime:0.010842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58711709 ORDER BY `unit` DESC [ RunTime:0.007923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58711709 LIMIT 2 [ RunTime:0.012039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58711709 ORDER BY `minOrder` ASC [ RunTime:0.000878s ]
select * from pdf where partno='BZX84C39TW-AU_S1_000A1' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.018157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39TW-AU_S1_000A1' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.013223s ]
SELECT `id` FROM `stock` WHERE `id` <> 58711709 AND `partno` = 'BZX84C39TW-AU_S1_000A1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.005377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58711522 LIMIT 5 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58711522 ORDER BY `minOrder` ASC [ RunTime:0.003990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58711522 ORDER BY `unit` DESC [ RunTime:0.008266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58711522 LIMIT 2 [ RunTime:0.004621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58711522 ORDER BY `minOrder` ASC [ RunTime:0.012447s ]
select * from pdf where partno='BZX84C39S-7' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.004497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39S-7' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.000654s ]
SELECT `id` FROM `stock` WHERE `id` <> 58711522 AND `partno` = 'BZX84C39S-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.010729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58669669 LIMIT 5 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58669669 ORDER BY `minOrder` ASC [ RunTime:0.006170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58669669 ORDER BY `unit` DESC [ RunTime:0.008432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58669669 LIMIT 2 [ RunTime:0.002116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58669669 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
select * from pdf where partno='BZX84C39-E3-18' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39-E3-18' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001077s ]
SELECT `id` FROM `stock` WHERE `id` <> 58669669 AND `partno` = 'BZX84C39-E3-18' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58668903 LIMIT 5 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58668903 ORDER BY `minOrder` ASC [ RunTime:0.007596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58668903 ORDER BY `unit` DESC [ RunTime:0.008362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58668903 LIMIT 2 [ RunTime:0.003413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58668903 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='BZX84C39T-7-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.008918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX84C39T-7-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.008204s ]
SELECT `id` FROM `stock` WHERE `id` <> 58668903 AND `partno` = 'BZX84C39T-7-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.003580s ]
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 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001303s ]
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 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002514s ]
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 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004515s ]
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 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012940s ]
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 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005656s ]
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 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005343s ]
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 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016260s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BZX84C39%' OR `brand` LIKE 'BZX84C39%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011399s ]