SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001995s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000586s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001623s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.93' ) [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001162s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001262s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBJ16CA' LIMIT 1 [ RunTime:0.001577s ]
UPDATE `stock_search` SET `count` = 17779 , `updatetime` = '2026-06-02 19:00:56' WHERE `partno` = 'SMBJ16CA' [ RunTime:0.002534s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000237s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000202s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000387s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001616s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMBJ16CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.005644s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'SMBJ16CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.009735s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('30119037','30096539','13904619','14820418','30157277','30137528','30135779','14802048','13905848','13904948','13916937','14827516','30122707','30146556','30104140','30143980','14800790','30155750','13906655','13908497') ORDER BY FIELD(s.id, 30119037,30096539,13904619,14820418,30157277,30137528,30135779,14802048,13905848,13904948,13916937,14827516,30122707,30146556,30104140,30143980,14800790,30155750,13906655,13908497) [ RunTime:0.016077s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30119037 LIMIT 4 [ RunTime:0.002356s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30119037 ORDER BY `minOrder` ASC [ RunTime:0.005351s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30119037 ORDER BY `unit` DESC [ RunTime:0.006420s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30119037 LIMIT 2 [ RunTime:0.006105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30119037 ORDER BY `minOrder` ASC [ RunTime:0.010178s ]
select * from pdf where partno='SMBJ16CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.021521s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ16CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.016845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30096539 LIMIT 4 [ RunTime:0.017802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30096539 ORDER BY `minOrder` ASC [ RunTime:0.019955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30096539 ORDER BY `unit` DESC [ RunTime:0.006592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30096539 LIMIT 2 [ RunTime:0.006734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30096539 ORDER BY `minOrder` ASC [ RunTime:0.005034s ]
select * from pdf where partno='SMBJ16CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.017501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ16CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.002544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904619 LIMIT 4 [ RunTime:0.004317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904619 ORDER BY `minOrder` ASC [ RunTime:0.017132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904619 ORDER BY `unit` DESC [ RunTime:0.007166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904619 LIMIT 2 [ RunTime:0.016665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904619 ORDER BY `minOrder` ASC [ RunTime:0.007545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14820418 LIMIT 4 [ RunTime:0.017769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820418 ORDER BY `minOrder` ASC [ RunTime:0.010551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14820418 ORDER BY `unit` DESC [ RunTime:0.010860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14820418 LIMIT 2 [ RunTime:0.008412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14820418 ORDER BY `minOrder` ASC [ RunTime:0.001300s ]
select * from pdf where partno='SMBJ16CAQ-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.002432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30157277 LIMIT 4 [ RunTime:0.008681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30157277 ORDER BY `minOrder` ASC [ RunTime:0.023775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30157277 ORDER BY `unit` DESC [ RunTime:0.023928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30157277 LIMIT 2 [ RunTime:0.016256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30157277 ORDER BY `minOrder` ASC [ RunTime:0.003104s ]
select * from pdf where partno='SMBJ16CA-A' and brandshort='Yenyo Technology' limit 1 [ RunTime:0.038121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ16CA-A' OR `brand` LIKE 'Yenyo Technology%' ) ) LIMIT 1 [ RunTime:0.019027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30137528 LIMIT 4 [ RunTime:0.019809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30137528 ORDER BY `minOrder` ASC [ RunTime:0.041902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30137528 ORDER BY `unit` DESC [ RunTime:0.036924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30137528 LIMIT 2 [ RunTime:0.047740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30137528 ORDER BY `minOrder` ASC [ RunTime:0.004188s ]
select * from pdf where partno='SMBJ16CA' and brandshort='Semtech Corporation' limit 1 [ RunTime:0.016627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ16CA' OR `brand` LIKE 'Semtech Corporation%' ) ) LIMIT 1 [ RunTime:0.049972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30135779 LIMIT 4 [ RunTime:0.005744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30135779 ORDER BY `minOrder` ASC [ RunTime:0.036063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30135779 ORDER BY `unit` DESC [ RunTime:0.027958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30135779 LIMIT 2 [ RunTime:0.028091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30135779 ORDER BY `minOrder` ASC [ RunTime:0.010494s ]
select * from pdf where partno='SMBJ16CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.028392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ16CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.029208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802048 LIMIT 4 [ RunTime:0.031131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802048 ORDER BY `minOrder` ASC [ RunTime:0.015909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802048 ORDER BY `unit` DESC [ RunTime:0.006803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802048 LIMIT 2 [ RunTime:0.020655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802048 ORDER BY `minOrder` ASC [ RunTime:0.007124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905848 LIMIT 4 [ RunTime:0.016004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905848 ORDER BY `minOrder` ASC [ RunTime:0.026221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905848 ORDER BY `unit` DESC [ RunTime:0.034442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905848 LIMIT 2 [ RunTime:0.013791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905848 ORDER BY `minOrder` ASC [ RunTime:0.022774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904948 LIMIT 4 [ RunTime:0.017746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904948 ORDER BY `minOrder` ASC [ RunTime:0.009516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904948 ORDER BY `unit` DESC [ RunTime:0.007230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904948 LIMIT 2 [ RunTime:0.009209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904948 ORDER BY `minOrder` ASC [ RunTime:0.010953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916937 LIMIT 4 [ RunTime:0.042239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916937 ORDER BY `minOrder` ASC [ RunTime:0.033156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916937 ORDER BY `unit` DESC [ RunTime:0.043326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916937 LIMIT 2 [ RunTime:0.021351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916937 ORDER BY `minOrder` ASC [ RunTime:0.018911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827516 LIMIT 4 [ RunTime:0.021845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827516 ORDER BY `minOrder` ASC [ RunTime:0.029740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827516 ORDER BY `unit` DESC [ RunTime:0.011047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827516 LIMIT 2 [ RunTime:0.069126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827516 ORDER BY `minOrder` ASC [ RunTime:0.008082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30122707 LIMIT 4 [ RunTime:0.015781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30122707 ORDER BY `minOrder` ASC [ RunTime:0.023113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30122707 ORDER BY `unit` DESC [ RunTime:0.016656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30122707 LIMIT 2 [ RunTime:0.032971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30122707 ORDER BY `minOrder` ASC [ RunTime:0.002206s ]
select * from pdf where partno='SMBJ16CA-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.023606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ16CA-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.038362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30146556 LIMIT 4 [ RunTime:0.038058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30146556 ORDER BY `minOrder` ASC [ RunTime:0.035143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30146556 ORDER BY `unit` DESC [ RunTime:0.011963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30146556 LIMIT 2 [ RunTime:0.004980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30146556 ORDER BY `minOrder` ASC [ RunTime:0.014577s ]
select * from pdf where partno='SMBJ16CA-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.003388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ16CA-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.016657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30104140 LIMIT 4 [ RunTime:0.008687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30104140 ORDER BY `minOrder` ASC [ RunTime:0.014637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30104140 ORDER BY `unit` DESC [ RunTime:0.006975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30104140 LIMIT 2 [ RunTime:0.027579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30104140 ORDER BY `minOrder` ASC [ RunTime:0.004044s ]
select * from pdf where partno='SMBJ16CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.021083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ16CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30143980 LIMIT 4 [ RunTime:0.004921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30143980 ORDER BY `minOrder` ASC [ RunTime:0.023679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30143980 ORDER BY `unit` DESC [ RunTime:0.031631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30143980 LIMIT 2 [ RunTime:0.024141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30143980 ORDER BY `minOrder` ASC [ RunTime:0.015754s ]
select * from pdf where partno='SMBJ16CA' and brandshort='EVVO' limit 1 [ RunTime:0.011072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ16CA' OR `brand` LIKE 'EVVO%' ) ) LIMIT 1 [ RunTime:0.001654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800790 LIMIT 4 [ RunTime:0.022638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800790 ORDER BY `minOrder` ASC [ RunTime:0.013862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800790 ORDER BY `unit` DESC [ RunTime:0.022492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800790 LIMIT 2 [ RunTime:0.005994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800790 ORDER BY `minOrder` ASC [ RunTime:0.021137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30155750 LIMIT 4 [ RunTime:0.001028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30155750 ORDER BY `minOrder` ASC [ RunTime:0.006154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30155750 ORDER BY `unit` DESC [ RunTime:0.002722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30155750 LIMIT 2 [ RunTime:0.012113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30155750 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
select * from pdf where partno='SMBJ16CA' and brandshort='Lumimax Optoelectronic Technology' limit 1 [ RunTime:0.012037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ16CA' OR `brand` LIKE 'Lumimax Optoelectronic Technology%' ) ) LIMIT 1 [ RunTime:0.016140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906655 LIMIT 4 [ RunTime:0.019767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906655 ORDER BY `minOrder` ASC [ RunTime:0.008024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906655 ORDER BY `unit` DESC [ RunTime:0.002200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906655 LIMIT 2 [ RunTime:0.005552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906655 ORDER BY `minOrder` ASC [ RunTime:0.011965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13908497 LIMIT 4 [ RunTime:0.009120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908497 ORDER BY `minOrder` ASC [ RunTime:0.016344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13908497 ORDER BY `unit` DESC [ RunTime:0.017433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13908497 LIMIT 2 [ RunTime:0.021519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13908497 ORDER BY `minOrder` ASC [ RunTime:0.018664s ]
select * from pdf where partno='SMBJ16CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000466s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMBJ16CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.026558s ]