SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001869s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008723s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001720s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.79' ) [ RunTime:0.003866s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001704s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.017137s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002549s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ13A' LIMIT 1 [ RunTime:0.002016s ]
UPDATE `stock_search` SET `count` = 11311 , `updatetime` = '2026-04-24 23:22:50' WHERE `partno` = 'SMAJ13A' [ RunTime:0.007418s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.003480s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.011971s ]
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.002710s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002037s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMAJ13A%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.035630s ]
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 'SMAJ13A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.057998s ]
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 ('16666644','16666176','16665630','14832733','14832119','14809048','14808667','14807143','14806241','14806045','13932712','13931805','13930080','13914528','13912705','13912690','13911799','13911405','13910886','13910473') ORDER BY FIELD(s.id, 16666644,16666176,16665630,14832733,14832119,14809048,14808667,14807143,14806241,14806045,13932712,13931805,13930080,13914528,13912705,13912690,13911799,13911405,13910886,13910473) [ RunTime:0.073711s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.113515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666644 LIMIT 4 [ RunTime:0.060121s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.023769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666644 ORDER BY `minOrder` ASC [ RunTime:0.027092s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666644 ORDER BY `unit` DESC [ RunTime:0.026850s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666644 LIMIT 2 [ RunTime:0.021479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666644 ORDER BY `minOrder` ASC [ RunTime:0.025656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666176 LIMIT 4 [ RunTime:0.023447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666176 ORDER BY `minOrder` ASC [ RunTime:0.037859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666176 ORDER BY `unit` DESC [ RunTime:0.016894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666176 LIMIT 2 [ RunTime:0.014479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666176 ORDER BY `minOrder` ASC [ RunTime:0.008248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665630 LIMIT 4 [ RunTime:0.040580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665630 ORDER BY `minOrder` ASC [ RunTime:0.021356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665630 ORDER BY `unit` DESC [ RunTime:0.000860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665630 LIMIT 2 [ RunTime:0.003429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665630 ORDER BY `minOrder` ASC [ RunTime:0.007686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832733 LIMIT 4 [ RunTime:0.001505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832733 ORDER BY `minOrder` ASC [ RunTime:0.011982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832733 ORDER BY `unit` DESC [ RunTime:0.003680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832733 LIMIT 2 [ RunTime:0.010696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832733 ORDER BY `minOrder` ASC [ RunTime:0.024720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832119 LIMIT 4 [ RunTime:0.001309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832119 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832119 ORDER BY `unit` DESC [ RunTime:0.010811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832119 LIMIT 2 [ RunTime:0.004321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832119 ORDER BY `minOrder` ASC [ RunTime:0.006316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809048 LIMIT 4 [ RunTime:0.001287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809048 ORDER BY `minOrder` ASC [ RunTime:0.011666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809048 ORDER BY `unit` DESC [ RunTime:0.008320s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809048 LIMIT 2 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809048 ORDER BY `minOrder` ASC [ RunTime:0.005309s ]
select * from pdf where partno='SMAJ13A-M3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.016511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14808667 LIMIT 4 [ RunTime:0.010671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808667 ORDER BY `minOrder` ASC [ RunTime:0.006637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14808667 ORDER BY `unit` DESC [ RunTime:0.002977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14808667 LIMIT 2 [ RunTime:0.000779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14808667 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='SMAJ13A-M3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14807143 LIMIT 4 [ RunTime:0.004517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807143 ORDER BY `minOrder` ASC [ RunTime:0.001577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14807143 ORDER BY `unit` DESC [ RunTime:0.000571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14807143 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14807143 ORDER BY `minOrder` ASC [ RunTime:0.003925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806241 LIMIT 4 [ RunTime:0.018830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806241 ORDER BY `minOrder` ASC [ RunTime:0.001979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806241 ORDER BY `unit` DESC [ RunTime:0.052122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806241 LIMIT 2 [ RunTime:0.050736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806241 ORDER BY `minOrder` ASC [ RunTime:0.010874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14806045 LIMIT 4 [ RunTime:0.019409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806045 ORDER BY `minOrder` ASC [ RunTime:0.005098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14806045 ORDER BY `unit` DESC [ RunTime:0.044670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14806045 LIMIT 2 [ RunTime:0.016025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14806045 ORDER BY `minOrder` ASC [ RunTime:0.017135s ]
select * from pdf where partno='SMAJ13A-E3/5A' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.039067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13932712 LIMIT 4 [ RunTime:0.044452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932712 ORDER BY `minOrder` ASC [ RunTime:0.043603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13932712 ORDER BY `unit` DESC [ RunTime:0.002958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13932712 LIMIT 2 [ RunTime:0.012862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13932712 ORDER BY `minOrder` ASC [ RunTime:0.011609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931805 LIMIT 4 [ RunTime:0.009022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931805 ORDER BY `minOrder` ASC [ RunTime:0.037465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931805 ORDER BY `unit` DESC [ RunTime:0.103026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931805 LIMIT 2 [ RunTime:0.236535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931805 ORDER BY `minOrder` ASC [ RunTime:0.003944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13930080 LIMIT 4 [ RunTime:0.033748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930080 ORDER BY `minOrder` ASC [ RunTime:0.123360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13930080 ORDER BY `unit` DESC [ RunTime:0.178598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13930080 LIMIT 2 [ RunTime:0.053687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930080 ORDER BY `minOrder` ASC [ RunTime:0.001283s ]
select * from pdf where partno='SMAJ13AHE3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.037541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914528 LIMIT 4 [ RunTime:0.024026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914528 ORDER BY `minOrder` ASC [ RunTime:0.020424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13914528 ORDER BY `unit` DESC [ RunTime:0.016068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13914528 LIMIT 2 [ RunTime:0.004214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914528 ORDER BY `minOrder` ASC [ RunTime:0.018854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912705 LIMIT 4 [ RunTime:0.005402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912705 ORDER BY `minOrder` ASC [ RunTime:0.011767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912705 ORDER BY `unit` DESC [ RunTime:0.016186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912705 LIMIT 2 [ RunTime:0.030286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912705 ORDER BY `minOrder` ASC [ RunTime:0.011057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912690 LIMIT 4 [ RunTime:0.004100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912690 ORDER BY `minOrder` ASC [ RunTime:0.004792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912690 ORDER BY `unit` DESC [ RunTime:0.000748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912690 LIMIT 2 [ RunTime:0.011834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912690 ORDER BY `minOrder` ASC [ RunTime:0.001698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911799 LIMIT 4 [ RunTime:0.012465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911799 ORDER BY `minOrder` ASC [ RunTime:0.033106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13911799 ORDER BY `unit` DESC [ RunTime:0.023609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13911799 LIMIT 2 [ RunTime:0.028163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911799 ORDER BY `minOrder` ASC [ RunTime:0.004813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13911405 LIMIT 4 [ RunTime:0.103533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911405 ORDER BY `minOrder` ASC [ RunTime:0.024007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13911405 ORDER BY `unit` DESC [ RunTime:0.016443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13911405 LIMIT 2 [ RunTime:0.027265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13911405 ORDER BY `minOrder` ASC [ RunTime:0.025048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910886 LIMIT 4 [ RunTime:0.026195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910886 ORDER BY `minOrder` ASC [ RunTime:0.048648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910886 ORDER BY `unit` DESC [ RunTime:0.038161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910886 LIMIT 2 [ RunTime:0.093968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910886 ORDER BY `minOrder` ASC [ RunTime:0.014286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13910473 LIMIT 4 [ RunTime:0.055316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910473 ORDER BY `minOrder` ASC [ RunTime:0.028840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13910473 ORDER BY `unit` DESC [ RunTime:0.045771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13910473 LIMIT 2 [ RunTime:0.025355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13910473 ORDER BY `minOrder` ASC [ RunTime:0.002342s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMAJ13A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.212039s ]