SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001904s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=SMBJ51AH&search=1' [ RunTime:0.001840s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001859s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009195s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001630s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.004446s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002537s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001376s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002365s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ51AH' LIMIT 1 [ RunTime:0.007553s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-24 21:07:00' WHERE `partno` = 'SMBJ51AH' [ RunTime:0.007870s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002706s ]
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 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018345s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818446 LIMIT 5 [ RunTime:0.011282s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818446 ORDER BY `minOrder` ASC [ RunTime:0.038326s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818446 ORDER BY `unit` DESC [ RunTime:0.037619s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818446 LIMIT 2 [ RunTime:0.030007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818446 ORDER BY `minOrder` ASC [ RunTime:0.015517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692425 LIMIT 5 [ RunTime:0.015039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692425 ORDER BY `minOrder` ASC [ RunTime:0.080163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692425 ORDER BY `unit` DESC [ RunTime:0.049896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692425 LIMIT 2 [ RunTime:0.085006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692425 ORDER BY `minOrder` ASC [ RunTime:0.078749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671097 LIMIT 5 [ RunTime:0.065409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671097 ORDER BY `minOrder` ASC [ RunTime:0.040407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671097 ORDER BY `unit` DESC [ RunTime:0.088449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671097 LIMIT 2 [ RunTime:0.042539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671097 ORDER BY `minOrder` ASC [ RunTime:0.019668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670822 LIMIT 5 [ RunTime:0.012276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670822 ORDER BY `minOrder` ASC [ RunTime:0.166214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670822 ORDER BY `unit` DESC [ RunTime:0.055917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670822 LIMIT 2 [ RunTime:0.063774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670822 ORDER BY `minOrder` ASC [ RunTime:0.027269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14831518 LIMIT 5 [ RunTime:0.105487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831518 ORDER BY `minOrder` ASC [ RunTime:0.034606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14831518 ORDER BY `unit` DESC [ RunTime:0.032539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14831518 LIMIT 2 [ RunTime:0.041806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14831518 ORDER BY `minOrder` ASC [ RunTime:0.024718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829320 LIMIT 5 [ RunTime:0.051424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829320 ORDER BY `minOrder` ASC [ RunTime:0.060279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829320 ORDER BY `unit` DESC [ RunTime:0.023250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829320 LIMIT 2 [ RunTime:0.053498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829320 ORDER BY `minOrder` ASC [ RunTime:0.051137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811728 LIMIT 5 [ RunTime:0.061541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811728 ORDER BY `minOrder` ASC [ RunTime:0.031382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811728 ORDER BY `unit` DESC [ RunTime:0.020907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811728 LIMIT 2 [ RunTime:0.022768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811728 ORDER BY `minOrder` ASC [ RunTime:0.027809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811651 LIMIT 5 [ RunTime:0.022120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811651 ORDER BY `minOrder` ASC [ RunTime:0.025771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811651 ORDER BY `unit` DESC [ RunTime:0.005057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811651 LIMIT 2 [ RunTime:0.017268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811651 ORDER BY `minOrder` ASC [ RunTime:0.006765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811345 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811345 ORDER BY `minOrder` ASC [ RunTime:0.012703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811345 ORDER BY `unit` DESC [ RunTime:0.010281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811345 LIMIT 2 [ RunTime:0.014145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811345 ORDER BY `minOrder` ASC [ RunTime:0.003557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811344 LIMIT 5 [ RunTime:0.008070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811344 ORDER BY `minOrder` ASC [ RunTime:0.008459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811344 ORDER BY `unit` DESC [ RunTime:0.003509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811344 LIMIT 2 [ RunTime:0.012392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811344 ORDER BY `minOrder` ASC [ RunTime:0.007728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932804 LIMIT 5 [ RunTime:0.014365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932804 ORDER BY `minOrder` ASC [ RunTime:0.013245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932804 ORDER BY `unit` DESC [ RunTime:0.004341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932804 LIMIT 2 [ RunTime:0.003947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932804 ORDER BY `minOrder` ASC [ RunTime:0.006731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931885 LIMIT 5 [ RunTime:0.007577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931885 ORDER BY `minOrder` ASC [ RunTime:0.004735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931885 ORDER BY `unit` DESC [ RunTime:0.009544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931885 LIMIT 2 [ RunTime:0.008699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931885 ORDER BY `minOrder` ASC [ RunTime:0.000624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13930214 LIMIT 5 [ RunTime:0.001186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930214 ORDER BY `minOrder` ASC [ RunTime:0.009749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13930214 ORDER BY `unit` DESC [ RunTime:0.021637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13930214 LIMIT 2 [ RunTime:0.013369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930214 ORDER BY `minOrder` ASC [ RunTime:0.002782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914660 LIMIT 5 [ RunTime:0.002547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914660 ORDER BY `minOrder` ASC [ RunTime:0.006730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13914660 ORDER BY `unit` DESC [ RunTime:0.000420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13914660 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914660 ORDER BY `minOrder` ASC [ RunTime:0.009960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914471 LIMIT 5 [ RunTime:0.010201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914471 ORDER BY `minOrder` ASC [ RunTime:0.002537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13914471 ORDER BY `unit` DESC [ RunTime:0.039355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13914471 LIMIT 2 [ RunTime:0.009635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914471 ORDER BY `minOrder` ASC [ RunTime:0.004818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913692 LIMIT 5 [ RunTime:0.010173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913692 ORDER BY `minOrder` ASC [ RunTime:0.008411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13913692 ORDER BY `unit` DESC [ RunTime:0.001697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13913692 LIMIT 2 [ RunTime:0.014041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13913692 ORDER BY `minOrder` ASC [ RunTime:0.008713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912934 LIMIT 5 [ RunTime:0.003384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912934 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912934 ORDER BY `unit` DESC [ RunTime:0.002718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912934 LIMIT 2 [ RunTime:0.005186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912934 ORDER BY `minOrder` ASC [ RunTime:0.002286s ]
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 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001529s ]
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 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42240859 LIMIT 5 [ RunTime:0.007885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240859 ORDER BY `minOrder` ASC [ RunTime:0.001625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42240859 ORDER BY `unit` DESC [ RunTime:0.009230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42240859 LIMIT 2 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240859 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='SMBJ51AHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000998s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.015208s ]
SELECT `id` FROM `stock` WHERE `id` <> 42240859 AND `partno` = 'SMBJ51AHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.030181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811651 [ RunTime:0.002892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42240857 LIMIT 5 [ RunTime:0.014340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240857 ORDER BY `minOrder` ASC [ RunTime:0.012459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42240857 ORDER BY `unit` DESC [ RunTime:0.001774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42240857 LIMIT 2 [ RunTime:0.004899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240857 ORDER BY `minOrder` ASC [ RunTime:0.010130s ]
select * from pdf where partno='SMBJ51AHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.003443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002964s ]
SELECT `id` FROM `stock` WHERE `id` <> 42240857 AND `partno` = 'SMBJ51AHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.015914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811344 [ RunTime:0.008209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42237052 LIMIT 5 [ RunTime:0.017331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237052 ORDER BY `minOrder` ASC [ RunTime:0.018153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42237052 ORDER BY `unit` DESC [ RunTime:0.031848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42237052 LIMIT 2 [ RunTime:0.029005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237052 ORDER BY `minOrder` ASC [ RunTime:0.012093s ]
select * from pdf where partno='SMBJ51AHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.037660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.012065s ]
SELECT `id` FROM `stock` WHERE `id` <> 42237052 AND `partno` = 'SMBJ51AHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.020426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914660 [ RunTime:0.006485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42237048 LIMIT 5 [ RunTime:0.030440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237048 ORDER BY `minOrder` ASC [ RunTime:0.018106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42237048 ORDER BY `unit` DESC [ RunTime:0.038650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42237048 LIMIT 2 [ RunTime:0.028685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237048 ORDER BY `minOrder` ASC [ RunTime:0.028647s ]
select * from pdf where partno='SMBJ51AHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.034312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.027044s ]
SELECT `id` FROM `stock` WHERE `id` <> 42237048 AND `partno` = 'SMBJ51AHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.025230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811345 [ RunTime:0.006007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42230449 LIMIT 5 [ RunTime:0.056576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42230449 ORDER BY `minOrder` ASC [ RunTime:0.028032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42230449 ORDER BY `unit` DESC [ RunTime:0.008146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42230449 LIMIT 2 [ RunTime:0.035073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42230449 ORDER BY `minOrder` ASC [ RunTime:0.021339s ]
select * from pdf where partno='SMBJ51AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.031628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014662s ]
SELECT `id` FROM `stock` WHERE `id` <> 42230449 AND `partno` = 'SMBJ51AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811728 [ RunTime:0.025603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42229300 LIMIT 5 [ RunTime:0.038807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42229300 ORDER BY `minOrder` ASC [ RunTime:0.021212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42229300 ORDER BY `unit` DESC [ RunTime:0.005844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42229300 LIMIT 2 [ RunTime:0.033342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42229300 ORDER BY `minOrder` ASC [ RunTime:0.033359s ]
select * from pdf where partno='SMBJ51AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.015753s ]
SELECT `id` FROM `stock` WHERE `id` <> 42229300 AND `partno` = 'SMBJ51AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.009055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914471 [ RunTime:0.009157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42226802 LIMIT 5 [ RunTime:0.009518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42226802 ORDER BY `minOrder` ASC [ RunTime:0.040381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42226802 ORDER BY `unit` DESC [ RunTime:0.025054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42226802 LIMIT 2 [ RunTime:0.025247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42226802 ORDER BY `minOrder` ASC [ RunTime:0.023474s ]
select * from pdf where partno='SMBJ51AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.042946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.010682s ]
SELECT `id` FROM `stock` WHERE `id` <> 42226802 AND `partno` = 'SMBJ51AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.027492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671097 [ RunTime:0.038684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42225841 LIMIT 5 [ RunTime:0.016720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225841 ORDER BY `minOrder` ASC [ RunTime:0.030612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42225841 ORDER BY `unit` DESC [ RunTime:0.008452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42225841 LIMIT 2 [ RunTime:0.042920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225841 ORDER BY `minOrder` ASC [ RunTime:0.021157s ]
select * from pdf where partno='SMBJ51AHE3-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.009193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AHE3-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.002203s ]
SELECT `id` FROM `stock` WHERE `id` <> 42225841 AND `partno` = 'SMBJ51AHE3-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.027098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13913692 [ RunTime:0.009441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42225532 LIMIT 5 [ RunTime:0.042741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225532 ORDER BY `minOrder` ASC [ RunTime:0.007428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42225532 ORDER BY `unit` DESC [ RunTime:0.009949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42225532 LIMIT 2 [ RunTime:0.017169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225532 ORDER BY `minOrder` ASC [ RunTime:0.034986s ]
select * from pdf where partno='SMBJ51AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.014239s ]
SELECT `id` FROM `stock` WHERE `id` <> 42225532 AND `partno` = 'SMBJ51AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.020458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670822 [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42213801 LIMIT 5 [ RunTime:0.007044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42213801 ORDER BY `minOrder` ASC [ RunTime:0.025440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42213801 ORDER BY `unit` DESC [ RunTime:0.010124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42213801 LIMIT 2 [ RunTime:0.026127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42213801 ORDER BY `minOrder` ASC [ RunTime:0.007839s ]
select * from pdf where partno='SMBJ51AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.005360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.009757s ]
SELECT `id` FROM `stock` WHERE `id` <> 42213801 AND `partno` = 'SMBJ51AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.030541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912934 [ RunTime:0.031604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42201014 LIMIT 5 [ RunTime:0.021359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42201014 ORDER BY `minOrder` ASC [ RunTime:0.034427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42201014 ORDER BY `unit` DESC [ RunTime:0.004378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42201014 LIMIT 2 [ RunTime:0.005239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42201014 ORDER BY `minOrder` ASC [ RunTime:0.005961s ]
select * from pdf where partno='SMBJ51AH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.010044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ51AH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.006714s ]
SELECT `id` FROM `stock` WHERE `id` <> 42201014 AND `partno` = 'SMBJ51AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.018447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818446 [ RunTime:0.016152s ]
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 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023946s ]
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 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016141s ]
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 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016763s ]
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 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039016s ]
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 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059039s ]
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 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014044s ]
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 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030949s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBJ51AH%' OR `brand` LIKE 'SMBJ51AH%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019054s ]