SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001511s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000612s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001863s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.103' ) [ RunTime:0.000346s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001405s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004709s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001575s ]
SELECT * FROM `stock_search` WHERE `partno` = '1.5KE12CA' LIMIT 1 [ RunTime:0.014582s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-06-02 00:59:40' WHERE `partno` = '1.5KE12CA' [ RunTime:0.013963s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002885s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000290s ]
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.000517s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002494s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '1.5KE12CA%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.008879s ]
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 '1.5KE12CA%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.011156s ]
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 ('30240432','30232651','30218331','30218307','30203091','16691037','16690847','16688077','16686863','16676814','16674635','16673448','16670069','14830414','14827050','14819638','14817413','14816977','14816952','14815340') ORDER BY FIELD(s.id, 30240432,30232651,30218331,30218307,30203091,16691037,16690847,16688077,16686863,16676814,16674635,16673448,16670069,14830414,14827050,14819638,14817413,14816977,14816952,14815340) [ RunTime:0.014552s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30240432 LIMIT 4 [ RunTime:0.008700s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30240432 ORDER BY `minOrder` ASC [ RunTime:0.005726s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30240432 ORDER BY `unit` DESC [ RunTime:0.011900s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30240432 LIMIT 2 [ RunTime:0.009095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30240432 ORDER BY `minOrder` ASC [ RunTime:0.008308s ]
select * from pdf where partno='1.5KE12CA' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.016215s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE12CA' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.010522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30232651 LIMIT 4 [ RunTime:0.009933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30232651 ORDER BY `minOrder` ASC [ RunTime:0.004791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30232651 ORDER BY `unit` DESC [ RunTime:0.003938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30232651 LIMIT 2 [ RunTime:0.010360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30232651 ORDER BY `minOrder` ASC [ RunTime:0.008856s ]
select * from pdf where partno='1.5KE12CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.016383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE12CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.004438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30218331 LIMIT 4 [ RunTime:0.001472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30218331 ORDER BY `minOrder` ASC [ RunTime:0.011290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30218331 ORDER BY `unit` DESC [ RunTime:0.007490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30218331 LIMIT 2 [ RunTime:0.001726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30218331 ORDER BY `minOrder` ASC [ RunTime:0.003118s ]
select * from pdf where partno='1.5KE12CA-AT/B' and brandshort='YAGEO' limit 1 [ RunTime:0.007457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE12CA-AT/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30218307 LIMIT 4 [ RunTime:0.007794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30218307 ORDER BY `minOrder` ASC [ RunTime:0.004935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30218307 ORDER BY `unit` DESC [ RunTime:0.006443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30218307 LIMIT 2 [ RunTime:0.012924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30218307 ORDER BY `minOrder` ASC [ RunTime:0.008954s ]
select * from pdf where partno='1.5KE12CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.009889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE12CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.009361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 30203091 LIMIT 4 [ RunTime:0.002361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30203091 ORDER BY `minOrder` ASC [ RunTime:0.023482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 30203091 ORDER BY `unit` DESC [ RunTime:0.004517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 30203091 LIMIT 2 [ RunTime:0.012672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 30203091 ORDER BY `minOrder` ASC [ RunTime:0.001002s ]
select * from pdf where partno='1.5KE12CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.004111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.5KE12CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16691037 LIMIT 4 [ RunTime:0.005222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691037 ORDER BY `minOrder` ASC [ RunTime:0.005021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16691037 ORDER BY `unit` DESC [ RunTime:0.003574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16691037 LIMIT 2 [ RunTime:0.002007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16691037 ORDER BY `minOrder` ASC [ RunTime:0.003177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690847 LIMIT 4 [ RunTime:0.006698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690847 ORDER BY `minOrder` ASC [ RunTime:0.003244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690847 ORDER BY `unit` DESC [ RunTime:0.006077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690847 LIMIT 2 [ RunTime:0.002451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690847 ORDER BY `minOrder` ASC [ RunTime:0.003871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688077 LIMIT 4 [ RunTime:0.023274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688077 ORDER BY `minOrder` ASC [ RunTime:0.009204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688077 ORDER BY `unit` DESC [ RunTime:0.004796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688077 LIMIT 2 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688077 ORDER BY `minOrder` ASC [ RunTime:0.002158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16686863 LIMIT 4 [ RunTime:0.013916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16686863 ORDER BY `minOrder` ASC [ RunTime:0.007926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16686863 ORDER BY `unit` DESC [ RunTime:0.003453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16686863 LIMIT 2 [ RunTime:0.010025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16686863 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16676814 LIMIT 4 [ RunTime:0.014136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676814 ORDER BY `minOrder` ASC [ RunTime:0.024304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16676814 ORDER BY `unit` DESC [ RunTime:0.022139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16676814 LIMIT 2 [ RunTime:0.022481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16676814 ORDER BY `minOrder` ASC [ RunTime:0.002859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16674635 LIMIT 4 [ RunTime:0.014765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674635 ORDER BY `minOrder` ASC [ RunTime:0.004586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16674635 ORDER BY `unit` DESC [ RunTime:0.003999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16674635 LIMIT 2 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16674635 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673448 LIMIT 4 [ RunTime:0.007130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673448 ORDER BY `minOrder` ASC [ RunTime:0.001155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673448 ORDER BY `unit` DESC [ RunTime:0.009761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673448 LIMIT 2 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673448 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670069 LIMIT 4 [ RunTime:0.001924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670069 ORDER BY `minOrder` ASC [ RunTime:0.004326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670069 ORDER BY `unit` DESC [ RunTime:0.005981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670069 LIMIT 2 [ RunTime:0.007770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670069 ORDER BY `minOrder` ASC [ RunTime:0.001131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830414 LIMIT 4 [ RunTime:0.001091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830414 ORDER BY `minOrder` ASC [ RunTime:0.005236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830414 ORDER BY `unit` DESC [ RunTime:0.006151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830414 LIMIT 2 [ RunTime:0.010793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830414 ORDER BY `minOrder` ASC [ RunTime:0.014010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14827050 LIMIT 4 [ RunTime:0.005586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827050 ORDER BY `minOrder` ASC [ RunTime:0.009891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14827050 ORDER BY `unit` DESC [ RunTime:0.011574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14827050 LIMIT 2 [ RunTime:0.018975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14827050 ORDER BY `minOrder` ASC [ RunTime:0.012727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819638 LIMIT 4 [ RunTime:0.002448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819638 ORDER BY `minOrder` ASC [ RunTime:0.010468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14819638 ORDER BY `unit` DESC [ RunTime:0.002806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14819638 LIMIT 2 [ RunTime:0.002072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14819638 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14817413 LIMIT 4 [ RunTime:0.014139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817413 ORDER BY `minOrder` ASC [ RunTime:0.003080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14817413 ORDER BY `unit` DESC [ RunTime:0.008809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14817413 LIMIT 2 [ RunTime:0.008146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14817413 ORDER BY `minOrder` ASC [ RunTime:0.000757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816977 LIMIT 4 [ RunTime:0.002014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816977 ORDER BY `minOrder` ASC [ RunTime:0.017995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816977 ORDER BY `unit` DESC [ RunTime:0.023212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816977 LIMIT 2 [ RunTime:0.007133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816977 ORDER BY `minOrder` ASC [ RunTime:0.003774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14816952 LIMIT 4 [ RunTime:0.005119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816952 ORDER BY `minOrder` ASC [ RunTime:0.000590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14816952 ORDER BY `unit` DESC [ RunTime:0.010490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14816952 LIMIT 2 [ RunTime:0.012536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14816952 ORDER BY `minOrder` ASC [ RunTime:0.004990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815340 LIMIT 4 [ RunTime:0.005911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815340 ORDER BY `minOrder` ASC [ RunTime:0.030579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815340 ORDER BY `unit` DESC [ RunTime:0.019368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815340 LIMIT 2 [ RunTime:0.001307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815340 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '1.5KE12CA%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001652s ]