SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001679s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000756s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001645s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.249' ) [ RunTime:0.000364s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002466s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000284s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001418s ]
SELECT * FROM `stock_search` WHERE `partno` = 'H11D1' LIMIT 1 [ RunTime:0.000568s ]
UPDATE `stock_search` SET `count` = 13605 , `updatetime` = '2026-05-31 13:51:36' WHERE `partno` = 'H11D1' [ RunTime:0.001597s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000256s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000228s ]
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.000409s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002432s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'H11D1%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.028083s ]
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 'H11D1%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026919s ]
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 ('25642300','20170675','20257635','20170536','18691505','18690169','25642481','20170688','25643967','20257458','20170408','25643945','25645686','25645644','18691360','15203918','16991258','25643950','25644781','15203430') ORDER BY FIELD(s.id, 25642300,20170675,20257635,20170536,18691505,18690169,25642481,20170688,25643967,20257458,20170408,25643945,25645686,25645644,18691360,15203918,16991258,25643950,25644781,15203430) [ RunTime:0.057137s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25642300 LIMIT 4 [ RunTime:0.011733s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25642300 ORDER BY `minOrder` ASC [ RunTime:0.011042s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25642300 ORDER BY `unit` DESC [ RunTime:0.004434s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25642300 LIMIT 2 [ RunTime:0.010796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25642300 ORDER BY `minOrder` ASC [ RunTime:0.008135s ]
select * from pdf where partno='H11D1' and brandshort='Lite-On Inc.' limit 1 [ RunTime:0.016617s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11D1' OR `brand` LIKE 'Lite-On Inc.%' ) ) LIMIT 1 [ RunTime:0.020283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20170675 LIMIT 4 [ RunTime:0.006047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20170675 ORDER BY `minOrder` ASC [ RunTime:0.010949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20170675 ORDER BY `unit` DESC [ RunTime:0.004600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20170675 LIMIT 2 [ RunTime:0.002985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20170675 ORDER BY `minOrder` ASC [ RunTime:0.003000s ]
select * from pdf where partno='h11d1sr2vm' and brandshort='onsemi' limit 1 [ RunTime:0.016249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'h11d1sr2vm' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.024417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20257635 LIMIT 4 [ RunTime:0.001832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20257635 ORDER BY `minOrder` ASC [ RunTime:0.004756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20257635 ORDER BY `unit` DESC [ RunTime:0.003038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20257635 LIMIT 2 [ RunTime:0.003327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20257635 ORDER BY `minOrder` ASC [ RunTime:0.002029s ]
select * from pdf where partno='h11d1vm' and brandshort='onsemi' limit 1 [ RunTime:0.003791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'h11d1vm' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.008094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20170536 LIMIT 4 [ RunTime:0.002855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20170536 ORDER BY `minOrder` ASC [ RunTime:0.000924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20170536 ORDER BY `unit` DESC [ RunTime:0.005832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20170536 LIMIT 2 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20170536 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
select * from pdf where partno='h11d1vm' and brandshort='onsemi' limit 1 [ RunTime:0.000574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'h11d1vm' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.000338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691505 LIMIT 4 [ RunTime:0.004932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691505 ORDER BY `minOrder` ASC [ RunTime:0.010410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691505 ORDER BY `unit` DESC [ RunTime:0.001919s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691505 LIMIT 2 [ RunTime:0.011289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691505 ORDER BY `minOrder` ASC [ RunTime:0.001290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690169 LIMIT 4 [ RunTime:0.003662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690169 ORDER BY `minOrder` ASC [ RunTime:0.006683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690169 ORDER BY `unit` DESC [ RunTime:0.005271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690169 LIMIT 2 [ RunTime:0.012712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690169 ORDER BY `minOrder` ASC [ RunTime:0.003289s ]
select * from pdf where partno='H11D1-X009' and brandshort='Vishay Semiconductor Opto Division' limit 1 [ RunTime:0.003060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25642481 LIMIT 4 [ RunTime:0.004729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25642481 ORDER BY `minOrder` ASC [ RunTime:0.007094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25642481 ORDER BY `unit` DESC [ RunTime:0.000773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25642481 LIMIT 2 [ RunTime:0.004360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25642481 ORDER BY `minOrder` ASC [ RunTime:0.001960s ]
select * from pdf where partno='H11D1' and brandshort='Vishay Semiconductor Opto Division' limit 1 [ RunTime:0.009975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11D1' OR `brand` LIKE 'Vishay Semiconductor Opto Division%' ) ) LIMIT 1 [ RunTime:0.004559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20170688 LIMIT 4 [ RunTime:0.009397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20170688 ORDER BY `minOrder` ASC [ RunTime:0.002277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20170688 ORDER BY `unit` DESC [ RunTime:0.003292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20170688 LIMIT 2 [ RunTime:0.002589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20170688 ORDER BY `minOrder` ASC [ RunTime:0.006546s ]
select * from pdf where partno='h11d1-x009' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.003339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'h11d1-x009' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.008427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25643967 LIMIT 4 [ RunTime:0.005074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25643967 ORDER BY `minOrder` ASC [ RunTime:0.007005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25643967 ORDER BY `unit` DESC [ RunTime:0.007614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25643967 LIMIT 2 [ RunTime:0.015433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25643967 ORDER BY `minOrder` ASC [ RunTime:0.014388s ]
select * from pdf where partno='H11D1-X009' and brandshort='Vishay Semiconductor Opto Division' limit 1 [ RunTime:0.013305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11D1-X009' OR `brand` LIKE 'Vishay Semiconductor Opto Division%' ) ) LIMIT 1 [ RunTime:0.009677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20257458 LIMIT 4 [ RunTime:0.012457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20257458 ORDER BY `minOrder` ASC [ RunTime:0.021988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20257458 ORDER BY `unit` DESC [ RunTime:0.008451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20257458 LIMIT 2 [ RunTime:0.005961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20257458 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='h11d1' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.032936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'h11d1' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.017885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20170408 LIMIT 4 [ RunTime:0.022803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20170408 ORDER BY `minOrder` ASC [ RunTime:0.014630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20170408 ORDER BY `unit` DESC [ RunTime:0.004544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20170408 LIMIT 2 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20170408 ORDER BY `minOrder` ASC [ RunTime:0.006561s ]
select * from pdf where partno='h11d1' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.000686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'h11d1' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.002098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25643945 LIMIT 4 [ RunTime:0.007071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25643945 ORDER BY `minOrder` ASC [ RunTime:0.006395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25643945 ORDER BY `unit` DESC [ RunTime:0.000691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25643945 LIMIT 2 [ RunTime:0.008673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25643945 ORDER BY `minOrder` ASC [ RunTime:0.004823s ]
select * from pdf where partno='H11D1' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.017678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11D1' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.016558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25645686 LIMIT 4 [ RunTime:0.003699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25645686 ORDER BY `minOrder` ASC [ RunTime:0.004451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25645686 ORDER BY `unit` DESC [ RunTime:0.007030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25645686 LIMIT 2 [ RunTime:0.001194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25645686 ORDER BY `minOrder` ASC [ RunTime:0.005109s ]
select * from pdf where partno='H11D1VM' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.007011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11D1VM' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.011384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25645644 LIMIT 4 [ RunTime:0.013682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25645644 ORDER BY `minOrder` ASC [ RunTime:0.013036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25645644 ORDER BY `unit` DESC [ RunTime:0.002090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25645644 LIMIT 2 [ RunTime:0.006334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25645644 ORDER BY `minOrder` ASC [ RunTime:0.004144s ]
select * from pdf where partno='H11D1300' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.012528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11D1300' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691360 LIMIT 4 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691360 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691360 ORDER BY `unit` DESC [ RunTime:0.006713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691360 LIMIT 2 [ RunTime:0.007854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691360 ORDER BY `minOrder` ASC [ RunTime:0.006954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203918 LIMIT 4 [ RunTime:0.014944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203918 ORDER BY `minOrder` ASC [ RunTime:0.000736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203918 ORDER BY `unit` DESC [ RunTime:0.003397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203918 LIMIT 2 [ RunTime:0.019138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203918 ORDER BY `minOrder` ASC [ RunTime:0.003332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991258 LIMIT 4 [ RunTime:0.007269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991258 ORDER BY `minOrder` ASC [ RunTime:0.001679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991258 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991258 LIMIT 2 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991258 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25643950 LIMIT 4 [ RunTime:0.002171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25643950 ORDER BY `minOrder` ASC [ RunTime:0.014361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25643950 ORDER BY `unit` DESC [ RunTime:0.008989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25643950 LIMIT 2 [ RunTime:0.003967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25643950 ORDER BY `minOrder` ASC [ RunTime:0.002049s ]
select * from pdf where partno='H11D1SR2VM' and brandshort='onsemi' limit 1 [ RunTime:0.003641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11D1SR2VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.020626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 25644781 LIMIT 4 [ RunTime:0.005762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25644781 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 25644781 ORDER BY `unit` DESC [ RunTime:0.000572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 25644781 LIMIT 2 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 25644781 ORDER BY `minOrder` ASC [ RunTime:0.009071s ]
select * from pdf where partno='H11D1M' and brandshort='onsemi' limit 1 [ RunTime:0.004117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11D1M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.017917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203430 LIMIT 4 [ RunTime:0.005055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203430 ORDER BY `minOrder` ASC [ RunTime:0.001876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203430 ORDER BY `unit` DESC [ RunTime:0.000971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203430 LIMIT 2 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203430 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'H11D1%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002501s ]