SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002115s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001039s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002270s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.130' ) [ RunTime:0.001003s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001658s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000422s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001574s ]
SELECT * FROM `stock_search` WHERE `partno` = '388' LIMIT 1 [ RunTime:0.000402s ]
UPDATE `stock_search` SET `count` = 197 , `updatetime` = '2026-06-04 19:28:49' WHERE `partno` = '388' [ RunTime:0.002716s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000664s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000403s ]
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.000618s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002134s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '388%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.002370s ]
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 '388%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 220,20 [ RunTime:0.007021s ]
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 ('12046843','12014626','11998723','11921574','11686991','11686744','11686532','11686515','11686314','11686171','11686123','11686003','11608135','11195167','11195151','11195074','11195034','11195033','11195032','11194994') ORDER BY FIELD(s.id, 12046843,12014626,11998723,11921574,11686991,11686744,11686532,11686515,11686314,11686171,11686123,11686003,11608135,11195167,11195151,11195074,11195034,11195033,11195032,11194994) [ RunTime:0.010351s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046843 LIMIT 4 [ RunTime:0.001889s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046843 ORDER BY `minOrder` ASC [ RunTime:0.006582s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12046843 ORDER BY `unit` DESC [ RunTime:0.008462s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12046843 LIMIT 2 [ RunTime:0.001006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046843 ORDER BY `minOrder` ASC [ RunTime:0.002770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12014626 LIMIT 4 [ RunTime:0.006041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014626 ORDER BY `minOrder` ASC [ RunTime:0.007951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12014626 ORDER BY `unit` DESC [ RunTime:0.005101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12014626 LIMIT 2 [ RunTime:0.003207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12014626 ORDER BY `minOrder` ASC [ RunTime:0.003265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11998723 LIMIT 4 [ RunTime:0.004991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11998723 ORDER BY `minOrder` ASC [ RunTime:0.006472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11998723 ORDER BY `unit` DESC [ RunTime:0.012633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11998723 LIMIT 2 [ RunTime:0.004946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11998723 ORDER BY `minOrder` ASC [ RunTime:0.008403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11921574 LIMIT 4 [ RunTime:0.004819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11921574 ORDER BY `minOrder` ASC [ RunTime:0.002859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11921574 ORDER BY `unit` DESC [ RunTime:0.000659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11921574 LIMIT 2 [ RunTime:0.005909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11921574 ORDER BY `minOrder` ASC [ RunTime:0.006721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11686991 LIMIT 4 [ RunTime:0.006261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686991 ORDER BY `minOrder` ASC [ RunTime:0.006066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11686991 ORDER BY `unit` DESC [ RunTime:0.008068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11686991 LIMIT 2 [ RunTime:0.001164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686991 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11686744 LIMIT 4 [ RunTime:0.005310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686744 ORDER BY `minOrder` ASC [ RunTime:0.003584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11686744 ORDER BY `unit` DESC [ RunTime:0.006850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11686744 LIMIT 2 [ RunTime:0.006300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686744 ORDER BY `minOrder` ASC [ RunTime:0.001562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11686532 LIMIT 4 [ RunTime:0.006377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686532 ORDER BY `minOrder` ASC [ RunTime:0.001573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11686532 ORDER BY `unit` DESC [ RunTime:0.006540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11686532 LIMIT 2 [ RunTime:0.002074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686532 ORDER BY `minOrder` ASC [ RunTime:0.002041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11686515 LIMIT 4 [ RunTime:0.007382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686515 ORDER BY `minOrder` ASC [ RunTime:0.007736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11686515 ORDER BY `unit` DESC [ RunTime:0.008466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11686515 LIMIT 2 [ RunTime:0.006990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686515 ORDER BY `minOrder` ASC [ RunTime:0.006299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11686314 LIMIT 4 [ RunTime:0.003981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686314 ORDER BY `minOrder` ASC [ RunTime:0.004288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11686314 ORDER BY `unit` DESC [ RunTime:0.009434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11686314 LIMIT 2 [ RunTime:0.014539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686314 ORDER BY `minOrder` ASC [ RunTime:0.005467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11686171 LIMIT 4 [ RunTime:0.006340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686171 ORDER BY `minOrder` ASC [ RunTime:0.003974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11686171 ORDER BY `unit` DESC [ RunTime:0.001634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11686171 LIMIT 2 [ RunTime:0.012719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686171 ORDER BY `minOrder` ASC [ RunTime:0.002938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11686123 LIMIT 4 [ RunTime:0.006292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686123 ORDER BY `minOrder` ASC [ RunTime:0.001086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11686123 ORDER BY `unit` DESC [ RunTime:0.008614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11686123 LIMIT 2 [ RunTime:0.005917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686123 ORDER BY `minOrder` ASC [ RunTime:0.006353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11686003 LIMIT 4 [ RunTime:0.003565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686003 ORDER BY `minOrder` ASC [ RunTime:0.007474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11686003 ORDER BY `unit` DESC [ RunTime:0.006120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11686003 LIMIT 2 [ RunTime:0.005664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11686003 ORDER BY `minOrder` ASC [ RunTime:0.004114s ]
select * from pdf where partno='38822071' and brandshort='Amphenol Air LB Germany' limit 1 [ RunTime:0.002760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11608135 LIMIT 4 [ RunTime:0.008855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608135 ORDER BY `minOrder` ASC [ RunTime:0.003823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11608135 ORDER BY `unit` DESC [ RunTime:0.003557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11608135 LIMIT 2 [ RunTime:0.007469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608135 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195167 LIMIT 4 [ RunTime:0.004290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195167 ORDER BY `minOrder` ASC [ RunTime:0.005320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11195167 ORDER BY `unit` DESC [ RunTime:0.012259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11195167 LIMIT 2 [ RunTime:0.003033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195167 ORDER BY `minOrder` ASC [ RunTime:0.001437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195151 LIMIT 4 [ RunTime:0.003562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195151 ORDER BY `minOrder` ASC [ RunTime:0.011649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11195151 ORDER BY `unit` DESC [ RunTime:0.008267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11195151 LIMIT 2 [ RunTime:0.004763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195151 ORDER BY `minOrder` ASC [ RunTime:0.004284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195074 LIMIT 4 [ RunTime:0.010198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195074 ORDER BY `minOrder` ASC [ RunTime:0.009875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11195074 ORDER BY `unit` DESC [ RunTime:0.012161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11195074 LIMIT 2 [ RunTime:0.007459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195074 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195034 LIMIT 4 [ RunTime:0.010226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195034 ORDER BY `minOrder` ASC [ RunTime:0.006467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11195034 ORDER BY `unit` DESC [ RunTime:0.006429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11195034 LIMIT 2 [ RunTime:0.003421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195034 ORDER BY `minOrder` ASC [ RunTime:0.002843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195033 LIMIT 4 [ RunTime:0.002183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195033 ORDER BY `minOrder` ASC [ RunTime:0.005916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11195033 ORDER BY `unit` DESC [ RunTime:0.007913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11195033 LIMIT 2 [ RunTime:0.016387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195033 ORDER BY `minOrder` ASC [ RunTime:0.003712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195032 LIMIT 4 [ RunTime:0.002334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195032 ORDER BY `minOrder` ASC [ RunTime:0.002856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11195032 ORDER BY `unit` DESC [ RunTime:0.004855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11195032 LIMIT 2 [ RunTime:0.002475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195032 ORDER BY `minOrder` ASC [ RunTime:0.007362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194994 LIMIT 4 [ RunTime:0.008103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194994 ORDER BY `minOrder` ASC [ RunTime:0.002408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11194994 ORDER BY `unit` DESC [ RunTime:0.001177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11194994 LIMIT 2 [ RunTime:0.002829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194994 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '388%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001067s ]