SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002925s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.83' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://ic118.com/stock&keyword=210&page=34&srecordnum=7530' [ RunTime:0.008432s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001351s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000850s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001306s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.83' ) [ RunTime:0.000246s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000909s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004389s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.000981s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000606s ]
UPDATE `stock_search` SET `count` = 5202 , `updatetime` = '2026-06-08 22:50:04' WHERE `partno` = '210' [ RunTime:0.001747s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000186s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000198s ]
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.000724s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002585s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.146405s ]
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 '210%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 660,20 [ RunTime:0.052232s ]
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 ('34363099','13316335','10825251','36532134','14399116','11496218','10755327','36771175','34360058','36760389','34360050','36771308','34358623','13373739','10751819','12520168','13144457','35294836','36770671','13192369') ORDER BY FIELD(s.id, 34363099,13316335,10825251,36532134,14399116,11496218,10755327,36771175,34360058,36760389,34360050,36771308,34358623,13373739,10751819,12520168,13144457,35294836,36770671,13192369) [ RunTime:0.024064s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34363099 LIMIT 4 [ RunTime:0.016414s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34363099 ORDER BY `minOrder` ASC [ RunTime:0.009839s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34363099 ORDER BY `unit` DESC [ RunTime:0.033931s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34363099 LIMIT 2 [ RunTime:0.032293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34363099 ORDER BY `minOrder` ASC [ RunTime:0.013755s ]
select * from pdf where partno='21003615-01' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.012150s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21003615-01' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.013928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316335 LIMIT 4 [ RunTime:0.008259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316335 ORDER BY `minOrder` ASC [ RunTime:0.007028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316335 ORDER BY `unit` DESC [ RunTime:0.000693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316335 LIMIT 2 [ RunTime:0.002001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316335 ORDER BY `minOrder` ASC [ RunTime:0.001751s ]
select * from pdf where partno='2106-632-B-5' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.004622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10825251 LIMIT 4 [ RunTime:0.001156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10825251 ORDER BY `minOrder` ASC [ RunTime:0.001892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10825251 ORDER BY `unit` DESC [ RunTime:0.004551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10825251 LIMIT 2 [ RunTime:0.006216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10825251 ORDER BY `minOrder` ASC [ RunTime:0.002586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36532134 LIMIT 4 [ RunTime:0.005177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36532134 ORDER BY `minOrder` ASC [ RunTime:0.004229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36532134 ORDER BY `unit` DESC [ RunTime:0.000873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36532134 LIMIT 2 [ RunTime:0.013292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36532134 ORDER BY `minOrder` ASC [ RunTime:0.009227s ]
select * from pdf where partno='210862-000' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.004034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210862-000' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.001116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14399116 LIMIT 4 [ RunTime:0.017216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14399116 ORDER BY `minOrder` ASC [ RunTime:0.008817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14399116 ORDER BY `unit` DESC [ RunTime:0.007539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14399116 LIMIT 2 [ RunTime:0.005452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14399116 ORDER BY `minOrder` ASC [ RunTime:0.016766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11496218 LIMIT 4 [ RunTime:0.003295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496218 ORDER BY `minOrder` ASC [ RunTime:0.003109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11496218 ORDER BY `unit` DESC [ RunTime:0.003977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11496218 LIMIT 2 [ RunTime:0.021085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11496218 ORDER BY `minOrder` ASC [ RunTime:0.010965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10755327 LIMIT 4 [ RunTime:0.015250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10755327 ORDER BY `minOrder` ASC [ RunTime:0.009606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10755327 ORDER BY `unit` DESC [ RunTime:0.009845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10755327 LIMIT 2 [ RunTime:0.010384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10755327 ORDER BY `minOrder` ASC [ RunTime:0.007256s ]
select * from pdf where partno='21021511305' and brandshort='HARTING' limit 1 [ RunTime:0.006031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36771175 LIMIT 4 [ RunTime:0.002989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36771175 ORDER BY `minOrder` ASC [ RunTime:0.008229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36771175 ORDER BY `unit` DESC [ RunTime:0.006131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36771175 LIMIT 2 [ RunTime:0.009645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36771175 ORDER BY `minOrder` ASC [ RunTime:0.002015s ]
select * from pdf where partno='2105T-632-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2105T-632-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.001697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34360058 LIMIT 4 [ RunTime:0.001813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360058 ORDER BY `minOrder` ASC [ RunTime:0.003636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34360058 ORDER BY `unit` DESC [ RunTime:0.000911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34360058 LIMIT 2 [ RunTime:0.002510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360058 ORDER BY `minOrder` ASC [ RunTime:0.008805s ]
select * from pdf where partno='21002311-01' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.007806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21002311-01' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.004947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36760389 LIMIT 4 [ RunTime:0.004694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760389 ORDER BY `minOrder` ASC [ RunTime:0.004105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36760389 ORDER BY `unit` DESC [ RunTime:0.002597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36760389 LIMIT 2 [ RunTime:0.006727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36760389 ORDER BY `minOrder` ASC [ RunTime:0.001935s ]
select * from pdf where partno='210-197' and brandshort='WAGO Corporation' limit 1 [ RunTime:0.003636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-197' OR `brand` LIKE 'WAGO Corporation%' ) ) LIMIT 1 [ RunTime:0.002227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34360050 LIMIT 4 [ RunTime:0.000787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360050 ORDER BY `minOrder` ASC [ RunTime:0.003464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34360050 ORDER BY `unit` DESC [ RunTime:0.000846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34360050 LIMIT 2 [ RunTime:0.007336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34360050 ORDER BY `minOrder` ASC [ RunTime:0.007419s ]
select * from pdf where partno='21003515-02' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.001123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21003515-02' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.002572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36771308 LIMIT 4 [ RunTime:0.004164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36771308 ORDER BY `minOrder` ASC [ RunTime:0.003867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36771308 ORDER BY `unit` DESC [ RunTime:0.001185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36771308 LIMIT 2 [ RunTime:0.002592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36771308 ORDER BY `minOrder` ASC [ RunTime:0.002998s ]
select * from pdf where partno='2106-440-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-440-N' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34358623 LIMIT 4 [ RunTime:0.004237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34358623 ORDER BY `minOrder` ASC [ RunTime:0.002321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34358623 ORDER BY `unit` DESC [ RunTime:0.000487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34358623 LIMIT 2 [ RunTime:0.002435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34358623 ORDER BY `minOrder` ASC [ RunTime:0.001630s ]
select * from pdf where partno='21006211-01' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.001602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21006211-01' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.000738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13373739 LIMIT 4 [ RunTime:0.004201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13373739 ORDER BY `minOrder` ASC [ RunTime:0.003917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13373739 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13373739 LIMIT 2 [ RunTime:0.002203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13373739 ORDER BY `minOrder` ASC [ RunTime:0.001137s ]
select * from pdf where partno='2103' and brandshort='Kitronik Ltd.' limit 1 [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10751819 LIMIT 4 [ RunTime:0.005495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10751819 ORDER BY `minOrder` ASC [ RunTime:0.003009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10751819 ORDER BY `unit` DESC [ RunTime:0.007204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10751819 LIMIT 2 [ RunTime:0.026178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10751819 ORDER BY `minOrder` ASC [ RunTime:0.016062s ]
select * from pdf where partno='21004311-01' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.004510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520168 LIMIT 4 [ RunTime:0.006309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520168 ORDER BY `minOrder` ASC [ RunTime:0.009132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12520168 ORDER BY `unit` DESC [ RunTime:0.023772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12520168 LIMIT 2 [ RunTime:0.013283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520168 ORDER BY `minOrder` ASC [ RunTime:0.006189s ]
select * from pdf where partno='2108-4-00-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.011351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13144457 LIMIT 4 [ RunTime:0.004540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13144457 ORDER BY `minOrder` ASC [ RunTime:0.010283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13144457 ORDER BY `unit` DESC [ RunTime:0.008956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13144457 LIMIT 2 [ RunTime:0.005766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13144457 ORDER BY `minOrder` ASC [ RunTime:0.002462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35294836 LIMIT 4 [ RunTime:0.005013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35294836 ORDER BY `minOrder` ASC [ RunTime:0.003151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35294836 ORDER BY `unit` DESC [ RunTime:0.001005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35294836 LIMIT 2 [ RunTime:0.006614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35294836 ORDER BY `minOrder` ASC [ RunTime:0.003545s ]
select * from pdf where partno='2101-0200-14' and brandshort='Encitech Connectors AB' limit 1 [ RunTime:0.001657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101-0200-14' OR `brand` LIKE 'Encitech Connectors AB%' ) ) LIMIT 1 [ RunTime:0.006622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36770671 LIMIT 4 [ RunTime:0.005329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36770671 ORDER BY `minOrder` ASC [ RunTime:0.004605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36770671 ORDER BY `unit` DESC [ RunTime:0.008630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36770671 LIMIT 2 [ RunTime:0.002625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36770671 ORDER BY `minOrder` ASC [ RunTime:0.001923s ]
select * from pdf where partno='2106-440-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.003976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106-440-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.008924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13192369 LIMIT 4 [ RunTime:0.015179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13192369 ORDER BY `minOrder` ASC [ RunTime:0.000935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13192369 ORDER BY `unit` DESC [ RunTime:0.003378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13192369 LIMIT 2 [ RunTime:0.001547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13192369 ORDER BY `minOrder` ASC [ RunTime:0.000832s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '210%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.081077s ]