SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001375s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&keyword=228&page=431&srecordnum=10000' [ RunTime:0.003071s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000955s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000389s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002032s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001166s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000262s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000878s ]
SELECT * FROM `stock_search` WHERE `partno` = '228' LIMIT 1 [ RunTime:0.002727s ]
UPDATE `stock_search` SET `count` = 1981 , `updatetime` = '2026-06-12 13:16:16' WHERE `partno` = '228' [ RunTime:0.004098s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000621s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000311s ]
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.000624s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002795s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `lockUser` = 0 [ RunTime:0.187997s ]
SELECT `s`.`id` FROM `stock` `s` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 8600,20 [ RunTime:0.140421s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `lockUser` = 0 AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('17007978','17007825','17007812','17007488','17006254','17005312','17005307','17004548','17003910','17003736','17003712','17003665','17003551','17003239','17002626','17002389','17001152','17001133','16995982','16975593') ORDER BY FIELD(s.id, 17007978,17007825,17007812,17007488,17006254,17005312,17005307,17004548,17003910,17003736,17003712,17003665,17003551,17003239,17002626,17002389,17001152,17001133,16995982,16975593) [ RunTime:0.008064s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17007978 LIMIT 4 [ RunTime:0.004379s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17007978 ORDER BY `minOrder` ASC [ RunTime:0.001446s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17007978 ORDER BY `unit` DESC [ RunTime:0.005594s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17007978 LIMIT 2 [ RunTime:0.003488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17007978 ORDER BY `minOrder` ASC [ RunTime:0.000225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17007825 LIMIT 4 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17007825 ORDER BY `minOrder` ASC [ RunTime:0.009524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17007825 ORDER BY `unit` DESC [ RunTime:0.015896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17007825 LIMIT 2 [ RunTime:0.011255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17007825 ORDER BY `minOrder` ASC [ RunTime:0.005101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17007812 LIMIT 4 [ RunTime:0.017243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17007812 ORDER BY `minOrder` ASC [ RunTime:0.006502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17007812 ORDER BY `unit` DESC [ RunTime:0.014948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17007812 LIMIT 2 [ RunTime:0.005869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17007812 ORDER BY `minOrder` ASC [ RunTime:0.006743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17007488 LIMIT 4 [ RunTime:0.002713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17007488 ORDER BY `minOrder` ASC [ RunTime:0.002756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17007488 ORDER BY `unit` DESC [ RunTime:0.000706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17007488 LIMIT 2 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17007488 ORDER BY `minOrder` ASC [ RunTime:0.001737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17006254 LIMIT 4 [ RunTime:0.007968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17006254 ORDER BY `minOrder` ASC [ RunTime:0.004700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17006254 ORDER BY `unit` DESC [ RunTime:0.002372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17006254 LIMIT 2 [ RunTime:0.005694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17006254 ORDER BY `minOrder` ASC [ RunTime:0.002629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17005312 LIMIT 4 [ RunTime:0.005463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005312 ORDER BY `minOrder` ASC [ RunTime:0.009101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17005312 ORDER BY `unit` DESC [ RunTime:0.003981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17005312 LIMIT 2 [ RunTime:0.003317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005312 ORDER BY `minOrder` ASC [ RunTime:0.001432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17005307 LIMIT 4 [ RunTime:0.003548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005307 ORDER BY `minOrder` ASC [ RunTime:0.006936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17005307 ORDER BY `unit` DESC [ RunTime:0.003416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17005307 LIMIT 2 [ RunTime:0.011765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005307 ORDER BY `minOrder` ASC [ RunTime:0.006573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17004548 LIMIT 4 [ RunTime:0.004720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17004548 ORDER BY `minOrder` ASC [ RunTime:0.017826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17004548 ORDER BY `unit` DESC [ RunTime:0.016288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17004548 LIMIT 2 [ RunTime:0.004164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17004548 ORDER BY `minOrder` ASC [ RunTime:0.004019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003910 LIMIT 4 [ RunTime:0.012725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003910 ORDER BY `minOrder` ASC [ RunTime:0.018846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17003910 ORDER BY `unit` DESC [ RunTime:0.012027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17003910 LIMIT 2 [ RunTime:0.003337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003910 ORDER BY `minOrder` ASC [ RunTime:0.006225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003736 LIMIT 4 [ RunTime:0.006505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003736 ORDER BY `minOrder` ASC [ RunTime:0.007440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17003736 ORDER BY `unit` DESC [ RunTime:0.002259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17003736 LIMIT 2 [ RunTime:0.008837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003736 ORDER BY `minOrder` ASC [ RunTime:0.003088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003712 LIMIT 4 [ RunTime:0.005274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003712 ORDER BY `minOrder` ASC [ RunTime:0.003911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17003712 ORDER BY `unit` DESC [ RunTime:0.003403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17003712 LIMIT 2 [ RunTime:0.014373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003712 ORDER BY `minOrder` ASC [ RunTime:0.003521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003665 LIMIT 4 [ RunTime:0.009694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003665 ORDER BY `minOrder` ASC [ RunTime:0.005231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17003665 ORDER BY `unit` DESC [ RunTime:0.007641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17003665 LIMIT 2 [ RunTime:0.000970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003665 ORDER BY `minOrder` ASC [ RunTime:0.002904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003551 LIMIT 4 [ RunTime:0.001347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003551 ORDER BY `minOrder` ASC [ RunTime:0.007653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17003551 ORDER BY `unit` DESC [ RunTime:0.003133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17003551 LIMIT 2 [ RunTime:0.011153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003551 ORDER BY `minOrder` ASC [ RunTime:0.001639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003239 LIMIT 4 [ RunTime:0.006753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003239 ORDER BY `minOrder` ASC [ RunTime:0.004236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17003239 ORDER BY `unit` DESC [ RunTime:0.006499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17003239 LIMIT 2 [ RunTime:0.004516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003239 ORDER BY `minOrder` ASC [ RunTime:0.003174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17002626 LIMIT 4 [ RunTime:0.007818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17002626 ORDER BY `minOrder` ASC [ RunTime:0.005188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17002626 ORDER BY `unit` DESC [ RunTime:0.004852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17002626 LIMIT 2 [ RunTime:0.005785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17002626 ORDER BY `minOrder` ASC [ RunTime:0.014483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17002389 LIMIT 4 [ RunTime:0.014290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17002389 ORDER BY `minOrder` ASC [ RunTime:0.010248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17002389 ORDER BY `unit` DESC [ RunTime:0.008679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17002389 LIMIT 2 [ RunTime:0.047746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17002389 ORDER BY `minOrder` ASC [ RunTime:0.014012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17001152 LIMIT 4 [ RunTime:0.007797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17001152 ORDER BY `minOrder` ASC [ RunTime:0.013981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17001152 ORDER BY `unit` DESC [ RunTime:0.004877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17001152 LIMIT 2 [ RunTime:0.002790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17001152 ORDER BY `minOrder` ASC [ RunTime:0.003291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17001133 LIMIT 4 [ RunTime:0.002036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17001133 ORDER BY `minOrder` ASC [ RunTime:0.004884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17001133 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17001133 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17001133 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16995982 LIMIT 4 [ RunTime:0.005600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16995982 ORDER BY `minOrder` ASC [ RunTime:0.006002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16995982 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16995982 LIMIT 2 [ RunTime:0.001322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16995982 ORDER BY `minOrder` ASC [ RunTime:0.003998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16975593 LIMIT 4 [ RunTime:0.004588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16975593 ORDER BY `minOrder` ASC [ RunTime:0.007281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16975593 ORDER BY `unit` DESC [ RunTime:0.012699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16975593 LIMIT 2 [ RunTime:0.011510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16975593 ORDER BY `minOrder` ASC [ RunTime:0.008866s ]
select * from pdf where partno='2283B' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.006499s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.007407s ]