SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002796s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001327s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002392s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.0' ) [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002347s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003105s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002263s ]
SELECT * FROM `stock_search` WHERE `partno` = '10078' LIMIT 1 [ RunTime:0.007786s ]
UPDATE `stock_search` SET `count` = 6428 , `updatetime` = '2026-03-14 11:08:03' WHERE `partno` = '10078' [ RunTime:0.006941s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002409s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003638s ]
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.007864s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002497s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '10078%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.007153s ]
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 '10078%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.014556s ]
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 ('19796916','19794082','19792498','19792497','19791158','19785483','19783614','19783613','19783612','19783611','19752000','19636645','19600761','19600760','17341382','16226210','16226209','16225624','16225623','16220074') ORDER BY FIELD(s.id, 19796916,19794082,19792498,19792497,19791158,19785483,19783614,19783613,19783612,19783611,19752000,19636645,19600761,19600760,17341382,16226210,16226209,16225624,16225623,16220074) [ RunTime:0.017452s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19796916 LIMIT 4 [ RunTime:0.019159s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796916 ORDER BY `minOrder` ASC [ RunTime:0.005976s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19796916 ORDER BY `unit` DESC [ RunTime:0.001120s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19796916 LIMIT 2 [ RunTime:0.001334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796916 ORDER BY `minOrder` ASC [ RunTime:0.003948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19794082 LIMIT 4 [ RunTime:0.006031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19794082 ORDER BY `minOrder` ASC [ RunTime:0.020715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19794082 ORDER BY `unit` DESC [ RunTime:0.013652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19794082 LIMIT 2 [ RunTime:0.009781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19794082 ORDER BY `minOrder` ASC [ RunTime:0.000888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19792498 LIMIT 4 [ RunTime:0.004033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19792498 ORDER BY `minOrder` ASC [ RunTime:0.003316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19792498 ORDER BY `unit` DESC [ RunTime:0.004887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19792498 LIMIT 2 [ RunTime:0.011114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19792498 ORDER BY `minOrder` ASC [ RunTime:0.003804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19792497 LIMIT 4 [ RunTime:0.008545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19792497 ORDER BY `minOrder` ASC [ RunTime:0.003699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19792497 ORDER BY `unit` DESC [ RunTime:0.029033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19792497 LIMIT 2 [ RunTime:0.010785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19792497 ORDER BY `minOrder` ASC [ RunTime:0.002440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19791158 LIMIT 4 [ RunTime:0.003647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19791158 ORDER BY `minOrder` ASC [ RunTime:0.006132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19791158 ORDER BY `unit` DESC [ RunTime:0.012589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19791158 LIMIT 2 [ RunTime:0.006458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19791158 ORDER BY `minOrder` ASC [ RunTime:0.003246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19785483 LIMIT 4 [ RunTime:0.013472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19785483 ORDER BY `minOrder` ASC [ RunTime:0.010434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19785483 ORDER BY `unit` DESC [ RunTime:0.012991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19785483 LIMIT 2 [ RunTime:0.004449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19785483 ORDER BY `minOrder` ASC [ RunTime:0.009062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19783614 LIMIT 4 [ RunTime:0.003061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19783614 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19783614 ORDER BY `unit` DESC [ RunTime:0.009124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19783614 LIMIT 2 [ RunTime:0.010052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19783614 ORDER BY `minOrder` ASC [ RunTime:0.008414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19783613 LIMIT 4 [ RunTime:0.015691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19783613 ORDER BY `minOrder` ASC [ RunTime:0.013881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19783613 ORDER BY `unit` DESC [ RunTime:0.004258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19783613 LIMIT 2 [ RunTime:0.003024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19783613 ORDER BY `minOrder` ASC [ RunTime:0.009877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19783612 LIMIT 4 [ RunTime:0.003577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19783612 ORDER BY `minOrder` ASC [ RunTime:0.003958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19783612 ORDER BY `unit` DESC [ RunTime:0.015098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19783612 LIMIT 2 [ RunTime:0.005045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19783612 ORDER BY `minOrder` ASC [ RunTime:0.001983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19783611 LIMIT 4 [ RunTime:0.015525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19783611 ORDER BY `minOrder` ASC [ RunTime:0.005085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19783611 ORDER BY `unit` DESC [ RunTime:0.012027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19783611 LIMIT 2 [ RunTime:0.015336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19783611 ORDER BY `minOrder` ASC [ RunTime:0.009102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19752000 LIMIT 4 [ RunTime:0.004055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19752000 ORDER BY `minOrder` ASC [ RunTime:0.002833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19752000 ORDER BY `unit` DESC [ RunTime:0.004820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19752000 LIMIT 2 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19752000 ORDER BY `minOrder` ASC [ RunTime:0.001366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19636645 LIMIT 4 [ RunTime:0.004064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636645 ORDER BY `minOrder` ASC [ RunTime:0.005869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19636645 ORDER BY `unit` DESC [ RunTime:0.020812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19636645 LIMIT 2 [ RunTime:0.009532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19636645 ORDER BY `minOrder` ASC [ RunTime:0.008370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19600761 LIMIT 4 [ RunTime:0.005910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19600761 ORDER BY `minOrder` ASC [ RunTime:0.012693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19600761 ORDER BY `unit` DESC [ RunTime:0.008043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19600761 LIMIT 2 [ RunTime:0.013428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19600761 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19600760 LIMIT 4 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19600760 ORDER BY `minOrder` ASC [ RunTime:0.005015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19600760 ORDER BY `unit` DESC [ RunTime:0.010989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19600760 LIMIT 2 [ RunTime:0.019378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19600760 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17341382 LIMIT 4 [ RunTime:0.021716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17341382 ORDER BY `minOrder` ASC [ RunTime:0.028477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17341382 ORDER BY `unit` DESC [ RunTime:0.017058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17341382 LIMIT 2 [ RunTime:0.007545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17341382 ORDER BY `minOrder` ASC [ RunTime:0.015080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16226210 LIMIT 4 [ RunTime:0.006039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16226210 ORDER BY `minOrder` ASC [ RunTime:0.005251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16226210 ORDER BY `unit` DESC [ RunTime:0.003997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16226210 LIMIT 2 [ RunTime:0.034179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16226210 ORDER BY `minOrder` ASC [ RunTime:0.007901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16226209 LIMIT 4 [ RunTime:0.017853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16226209 ORDER BY `minOrder` ASC [ RunTime:0.039339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16226209 ORDER BY `unit` DESC [ RunTime:0.032689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16226209 LIMIT 2 [ RunTime:0.007244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16226209 ORDER BY `minOrder` ASC [ RunTime:0.013060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16225624 LIMIT 4 [ RunTime:0.017042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16225624 ORDER BY `minOrder` ASC [ RunTime:0.032930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16225624 ORDER BY `unit` DESC [ RunTime:0.046020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16225624 LIMIT 2 [ RunTime:0.016371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16225624 ORDER BY `minOrder` ASC [ RunTime:0.019541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16225623 LIMIT 4 [ RunTime:0.015718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16225623 ORDER BY `minOrder` ASC [ RunTime:0.013505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16225623 ORDER BY `unit` DESC [ RunTime:0.021465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16225623 LIMIT 2 [ RunTime:0.012506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16225623 ORDER BY `minOrder` ASC [ RunTime:0.008723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16220074 LIMIT 4 [ RunTime:0.005002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220074 ORDER BY `minOrder` ASC [ RunTime:0.009821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16220074 ORDER BY `unit` DESC [ RunTime:0.007794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16220074 LIMIT 2 [ RunTime:0.005003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220074 ORDER BY `minOrder` ASC [ RunTime:0.001919s ]
select * from pdf where partno='10078991-G32-08ULF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001514s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '10078%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000530s ]