SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002615s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.222' , `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=BSR&search=1' [ RunTime:0.004638s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002784s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001661s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003837s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.222' ) [ RunTime:0.001542s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001849s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008971s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002323s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BSR' LIMIT 1 [ RunTime:0.003197s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-31 01:25:25' WHERE `partno` = 'BSR' [ RunTime:0.006304s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002218s ]
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 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011878s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3571 LIMIT 5 [ RunTime:0.009420s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3571 ORDER BY `minOrder` ASC [ RunTime:0.018070s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3571 ORDER BY `unit` DESC [ RunTime:0.017768s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3571 LIMIT 2 [ RunTime:0.013856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3571 ORDER BY `minOrder` ASC [ RunTime:0.008894s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR16..' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.019875s ]
SELECT `id` FROM `stock` WHERE `id` <> 3571 AND `partno` = 'BSR16..' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.016175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 320 LIMIT 5 [ RunTime:0.051889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 320 ORDER BY `minOrder` ASC [ RunTime:0.011865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 320 ORDER BY `unit` DESC [ RunTime:0.022518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 320 LIMIT 2 [ RunTime:0.024787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 320 ORDER BY `minOrder` ASC [ RunTime:0.029363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR14,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.034501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16001449 LIMIT 5 [ RunTime:0.004887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16001449 ORDER BY `minOrder` ASC [ RunTime:0.034421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16001449 ORDER BY `unit` DESC [ RunTime:0.024368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16001449 LIMIT 2 [ RunTime:0.025895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16001449 ORDER BY `minOrder` ASC [ RunTime:0.008009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21534 LIMIT 5 [ RunTime:0.014268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21534 ORDER BY `minOrder` ASC [ RunTime:0.010941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21534 ORDER BY `unit` DESC [ RunTime:0.040182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21534 LIMIT 2 [ RunTime:0.020735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21534 ORDER BY `minOrder` ASC [ RunTime:0.013854s ]
select * from pdf where partno='BSR33,115' and brandshort='NXP' limit 1 [ RunTime:0.025591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR33,115' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.040464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19000400 LIMIT 5 [ RunTime:0.030148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19000400 ORDER BY `minOrder` ASC [ RunTime:0.027198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19000400 ORDER BY `unit` DESC [ RunTime:0.033989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19000400 LIMIT 2 [ RunTime:0.024104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19000400 ORDER BY `minOrder` ASC [ RunTime:0.035634s ]
select * from pdf where partno='BSR-44-BT' and brandshort='Bud Industries' limit 1 [ RunTime:0.020115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18582421 LIMIT 5 [ RunTime:0.010005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582421 ORDER BY `minOrder` ASC [ RunTime:0.007681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18582421 ORDER BY `unit` DESC [ RunTime:0.028558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18582421 LIMIT 2 [ RunTime:0.052449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582421 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18582366 LIMIT 5 [ RunTime:0.009705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582366 ORDER BY `minOrder` ASC [ RunTime:0.020871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18582366 ORDER BY `unit` DESC [ RunTime:0.012832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18582366 LIMIT 2 [ RunTime:0.005612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582366 ORDER BY `minOrder` ASC [ RunTime:0.013275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18582365 LIMIT 5 [ RunTime:0.020506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582365 ORDER BY `minOrder` ASC [ RunTime:0.001612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18582365 ORDER BY `unit` DESC [ RunTime:0.012333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18582365 LIMIT 2 [ RunTime:0.012117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582365 ORDER BY `minOrder` ASC [ RunTime:0.006849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18582340 LIMIT 5 [ RunTime:0.010116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582340 ORDER BY `minOrder` ASC [ RunTime:0.019519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18582340 ORDER BY `unit` DESC [ RunTime:0.007339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18582340 LIMIT 2 [ RunTime:0.014698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18582340 ORDER BY `minOrder` ASC [ RunTime:0.002189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16001488 LIMIT 5 [ RunTime:0.008579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16001488 ORDER BY `minOrder` ASC [ RunTime:0.011459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16001488 ORDER BY `unit` DESC [ RunTime:0.012185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16001488 LIMIT 2 [ RunTime:0.024431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16001488 ORDER BY `minOrder` ASC [ RunTime:0.011699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15177534 LIMIT 5 [ RunTime:0.016315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15177534 ORDER BY `minOrder` ASC [ RunTime:0.021523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15177534 ORDER BY `unit` DESC [ RunTime:0.000713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15177534 LIMIT 2 [ RunTime:0.013005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15177534 ORDER BY `minOrder` ASC [ RunTime:0.001084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15177467 LIMIT 5 [ RunTime:0.006068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15177467 ORDER BY `minOrder` ASC [ RunTime:0.000664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15177467 ORDER BY `unit` DESC [ RunTime:0.000442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15177467 LIMIT 2 [ RunTime:0.011865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15177467 ORDER BY `minOrder` ASC [ RunTime:0.001391s ]
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 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005210s ]
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 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58598944 LIMIT 5 [ RunTime:0.014067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58598944 ORDER BY `minOrder` ASC [ RunTime:0.010178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58598944 ORDER BY `unit` DESC [ RunTime:0.007086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58598944 LIMIT 2 [ RunTime:0.003722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58598944 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
select * from pdf where partno='BSR14' and brandshort='onsemi' limit 1 [ RunTime:0.009611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR14' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.014354s ]
SELECT `id` FROM `stock` WHERE `id` <> 58598944 AND `partno` = 'BSR14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.016743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58605494 LIMIT 5 [ RunTime:0.024163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58605494 ORDER BY `minOrder` ASC [ RunTime:0.016374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58605494 ORDER BY `unit` DESC [ RunTime:0.003800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58605494 LIMIT 2 [ RunTime:0.008570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58605494 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='BSR16/DG/B4VL' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.016591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR16/DG/B4VL' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.001154s ]
SELECT `id` FROM `stock` WHERE `id` <> 58605494 AND `partno` = 'BSR16/DG/B4VL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.019715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58599648 LIMIT 5 [ RunTime:0.009412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58599648 ORDER BY `minOrder` ASC [ RunTime:0.007594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58599648 ORDER BY `unit` DESC [ RunTime:0.002512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58599648 LIMIT 2 [ RunTime:0.007585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58599648 ORDER BY `minOrder` ASC [ RunTime:0.001471s ]
select * from pdf where partno='BSR16' and brandshort='onsemi' limit 1 [ RunTime:0.004861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR16' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.026252s ]
SELECT `id` FROM `stock` WHERE `id` <> 58599648 AND `partno` = 'BSR16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.013974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58605468 LIMIT 5 [ RunTime:0.006356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58605468 ORDER BY `minOrder` ASC [ RunTime:0.010307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58605468 ORDER BY `unit` DESC [ RunTime:0.009689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58605468 LIMIT 2 [ RunTime:0.011015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58605468 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='BSR16' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.001470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR16' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.004261s ]
SELECT `id` FROM `stock` WHERE `id` <> 58605468 AND `partno` = 'BSR16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.005404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58699765 LIMIT 5 [ RunTime:0.001666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58699765 ORDER BY `minOrder` ASC [ RunTime:0.006373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58699765 ORDER BY `unit` DESC [ RunTime:0.004190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58699765 LIMIT 2 [ RunTime:0.001347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58699765 ORDER BY `minOrder` ASC [ RunTime:0.004212s ]
select * from pdf where partno='BSR58' and brandshort='onsemi' limit 1 [ RunTime:0.004496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR58' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.025145s ]
SELECT `id` FROM `stock` WHERE `id` <> 58699765 AND `partno` = 'BSR58' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.003374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15177534 [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44046160 LIMIT 5 [ RunTime:0.000923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44046160 ORDER BY `minOrder` ASC [ RunTime:0.003575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44046160 ORDER BY `unit` DESC [ RunTime:0.003596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44046160 LIMIT 2 [ RunTime:0.007782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44046160 ORDER BY `minOrder` ASC [ RunTime:0.002352s ]
select * from pdf where partno='BSR315PH6327XTSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.004866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR315PH6327XTSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.002095s ]
SELECT `id` FROM `stock` WHERE `id` <> 44046160 AND `partno` = 'BSR315PH6327XTSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44044186 LIMIT 5 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44044186 ORDER BY `minOrder` ASC [ RunTime:0.000885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44044186 ORDER BY `unit` DESC [ RunTime:0.002227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44044186 LIMIT 2 [ RunTime:0.006089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44044186 ORDER BY `minOrder` ASC [ RunTime:0.002957s ]
select * from pdf where partno='BSR802NL6327HTSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.003764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR802NL6327HTSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.001096s ]
SELECT `id` FROM `stock` WHERE `id` <> 44044186 AND `partno` = 'BSR802NL6327HTSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.001795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58605578 LIMIT 5 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58605578 ORDER BY `minOrder` ASC [ RunTime:0.003282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58605578 ORDER BY `unit` DESC [ RunTime:0.007408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58605578 LIMIT 2 [ RunTime:0.011154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58605578 ORDER BY `minOrder` ASC [ RunTime:0.005195s ]
select * from pdf where partno='BSR30,115' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.022751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR30,115' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.008871s ]
SELECT `id` FROM `stock` WHERE `id` <> 58605578 AND `partno` = 'BSR30,115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.027643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58598941 LIMIT 5 [ RunTime:0.034453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58598941 ORDER BY `minOrder` ASC [ RunTime:0.013149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58598941 ORDER BY `unit` DESC [ RunTime:0.008765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58598941 LIMIT 2 [ RunTime:0.028055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58598941 ORDER BY `minOrder` ASC [ RunTime:0.007593s ]
select * from pdf where partno='BSR14,215' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.016010s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR14,215' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.009455s ]
SELECT `id` FROM `stock` WHERE `id` <> 58598941 AND `partno` = 'BSR14,215' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.019922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44046171 LIMIT 5 [ RunTime:0.042126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44046171 ORDER BY `minOrder` ASC [ RunTime:0.032818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44046171 ORDER BY `unit` DESC [ RunTime:0.030483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44046171 LIMIT 2 [ RunTime:0.054916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44046171 ORDER BY `minOrder` ASC [ RunTime:0.023717s ]
select * from pdf where partno='BSR202NL6327HTSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.017577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR202NL6327HTSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.029332s ]
SELECT `id` FROM `stock` WHERE `id` <> 44046171 AND `partno` = 'BSR202NL6327HTSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.026036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58606101 LIMIT 5 [ RunTime:0.008518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58606101 ORDER BY `minOrder` ASC [ RunTime:0.052472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58606101 ORDER BY `unit` DESC [ RunTime:0.046144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58606101 LIMIT 2 [ RunTime:0.016130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58606101 ORDER BY `minOrder` ASC [ RunTime:0.050955s ]
select * from pdf where partno='BSR41,115' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.046931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR41,115' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.025663s ]
SELECT `id` FROM `stock` WHERE `id` <> 58606101 AND `partno` = 'BSR41,115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.075609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44064079 LIMIT 5 [ RunTime:0.052329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44064079 ORDER BY `minOrder` ASC [ RunTime:0.034220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44064079 ORDER BY `unit` DESC [ RunTime:0.028505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44064079 LIMIT 2 [ RunTime:0.014245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44064079 ORDER BY `minOrder` ASC [ RunTime:0.015770s ]
select * from pdf where partno='BSR316PH6327XTSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.045496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR316PH6327XTSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.048343s ]
SELECT `id` FROM `stock` WHERE `id` <> 44064079 AND `partno` = 'BSR316PH6327XTSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.037625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58700144 LIMIT 5 [ RunTime:0.043026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58700144 ORDER BY `minOrder` ASC [ RunTime:0.028319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58700144 ORDER BY `unit` DESC [ RunTime:0.008662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58700144 LIMIT 2 [ RunTime:0.030086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58700144 ORDER BY `minOrder` ASC [ RunTime:0.017946s ]
select * from pdf where partno='BSR57' and brandshort='onsemi' limit 1 [ RunTime:0.017314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR57' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.046759s ]
SELECT `id` FROM `stock` WHERE `id` <> 58700144 AND `partno` = 'BSR57' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.027358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16001449 [ RunTime:0.023882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58106024 LIMIT 5 [ RunTime:0.017789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58106024 ORDER BY `minOrder` ASC [ RunTime:0.034011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58106024 ORDER BY `unit` DESC [ RunTime:0.017935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58106024 LIMIT 2 [ RunTime:0.012003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58106024 ORDER BY `minOrder` ASC [ RunTime:0.009794s ]
select * from pdf where partno='BSR' and brandshort='MPD Memory Protection Devices' limit 1 [ RunTime:0.006185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR' OR `brand` LIKE 'MPD (Memory Protection Devices)%' ) ) LIMIT 1 [ RunTime:0.031729s ]
SELECT `id` FROM `stock` WHERE `id` <> 58106024 AND `partno` = 'BSR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mpd%' ) [ RunTime:0.026606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63464915 LIMIT 5 [ RunTime:0.009415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464915 ORDER BY `minOrder` ASC [ RunTime:0.027327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63464915 ORDER BY `unit` DESC [ RunTime:0.010438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63464915 LIMIT 2 [ RunTime:0.053397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464915 ORDER BY `minOrder` ASC [ RunTime:0.001557s ]
select * from pdf where partno='BSR-44-BT' and brandshort='Bud Industries' limit 1 [ RunTime:0.003147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR-44-BT' OR `brand` LIKE 'Bud Industries%' ) ) LIMIT 1 [ RunTime:0.008744s ]
SELECT `id` FROM `stock` WHERE `id` <> 63464915 AND `partno` = 'BSR-44-BT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bud industries%' ) [ RunTime:0.014475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19000400 [ RunTime:0.022661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58611503 LIMIT 5 [ RunTime:0.030939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58611503 ORDER BY `minOrder` ASC [ RunTime:0.034608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58611503 ORDER BY `unit` DESC [ RunTime:0.046327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58611503 LIMIT 2 [ RunTime:0.019575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58611503 ORDER BY `minOrder` ASC [ RunTime:0.016406s ]
select * from pdf where partno='BSR33-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.018486s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR33-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.004677s ]
SELECT `id` FROM `stock` WHERE `id` <> 58611503 AND `partno` = 'BSR33-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.001052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58611384 LIMIT 5 [ RunTime:0.002203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58611384 ORDER BY `minOrder` ASC [ RunTime:0.009301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58611384 ORDER BY `unit` DESC [ RunTime:0.000813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58611384 LIMIT 2 [ RunTime:0.002897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58611384 ORDER BY `minOrder` ASC [ RunTime:0.000834s ]
select * from pdf where partno='BSR43QTA' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.007057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR43QTA' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.011470s ]
SELECT `id` FROM `stock` WHERE `id` <> 58611384 AND `partno` = 'BSR43QTA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.029655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58611041 LIMIT 5 [ RunTime:0.004629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58611041 ORDER BY `minOrder` ASC [ RunTime:0.007614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58611041 ORDER BY `unit` DESC [ RunTime:0.003641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58611041 LIMIT 2 [ RunTime:0.035969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58611041 ORDER BY `minOrder` ASC [ RunTime:0.046991s ]
select * from pdf where partno='BSR31-QX' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.024091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR31-QX' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.015755s ]
SELECT `id` FROM `stock` WHERE `id` <> 58611041 AND `partno` = 'BSR31-QX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.007397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58611040 LIMIT 5 [ RunTime:0.013009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58611040 ORDER BY `minOrder` ASC [ RunTime:0.010352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58611040 ORDER BY `unit` DESC [ RunTime:0.022303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58611040 LIMIT 2 [ RunTime:0.058783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58611040 ORDER BY `minOrder` ASC [ RunTime:0.004030s ]
select * from pdf where partno='BSR41-QX' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.002231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR41-QX' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.005800s ]
SELECT `id` FROM `stock` WHERE `id` <> 58611040 AND `partno` = 'BSR41-QX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.006683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58611039 LIMIT 5 [ RunTime:0.006327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58611039 ORDER BY `minOrder` ASC [ RunTime:0.006005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58611039 ORDER BY `unit` DESC [ RunTime:0.012783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58611039 LIMIT 2 [ RunTime:0.010994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58611039 ORDER BY `minOrder` ASC [ RunTime:0.000811s ]
select * from pdf where partno='BSR43-QX' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.001928s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR43-QX' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.007838s ]
SELECT `id` FROM `stock` WHERE `id` <> 58611039 AND `partno` = 'BSR43-QX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.007618s ]
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 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019384s ]
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 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001039s ]
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 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006322s ]
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 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007827s ]
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 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018641s ]
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 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016940s ]
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 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015054s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BSR%' OR `brand` LIKE 'BSR%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022038s ]