SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001708s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.220' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.003178s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001248s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000527s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001617s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.002210s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001343s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001887s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001823s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.002836s ]
UPDATE `stock_search` SET `count` = 1334 , `updatetime` = '2026-06-06 18:32:53' WHERE `partno` = '210' [ RunTime:0.002103s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002202s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.003131s ]
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.000708s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002571s ]
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.004240s ]
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 160,20 [ RunTime:0.077417s ]
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 ('32267374','32270788','32277634','32163132','32446275','33406149','32277760','32163258','34357521','12519934','32277492','32162990','11484142','32256984','11926499','32304168','32296044','13317011','13255719','32277907') ORDER BY FIELD(s.id, 32267374,32270788,32277634,32163132,32446275,33406149,32277760,32163258,34357521,12519934,32277492,32162990,11484142,32256984,11926499,32304168,32296044,13317011,13255719,32277907) [ RunTime:0.105327s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267374 LIMIT 4 [ RunTime:0.019766s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267374 ORDER BY `minOrder` ASC [ RunTime:0.029350s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267374 ORDER BY `unit` DESC [ RunTime:0.008816s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.018270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267374 LIMIT 2 [ RunTime:0.014002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267374 ORDER BY `minOrder` ASC [ RunTime:0.023435s ]
select * from pdf where partno='2103306-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.024088s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103306-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.045436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270788 LIMIT 4 [ RunTime:0.026342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270788 ORDER BY `minOrder` ASC [ RunTime:0.059353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270788 ORDER BY `unit` DESC [ RunTime:0.038971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270788 LIMIT 2 [ RunTime:0.051189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270788 ORDER BY `minOrder` ASC [ RunTime:0.023369s ]
select * from pdf where partno='2102771-1' and brandshort='te connectivity' limit 1 [ RunTime:0.038152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102771-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.065624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277634 LIMIT 4 [ RunTime:0.064190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277634 ORDER BY `minOrder` ASC [ RunTime:0.045254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277634 ORDER BY `unit` DESC [ RunTime:0.031687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277634 LIMIT 2 [ RunTime:0.053418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277634 ORDER BY `minOrder` ASC [ RunTime:0.022172s ]
select * from pdf where partno='2106135-4' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.042852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106135-4' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.024950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163132 LIMIT 4 [ RunTime:0.028150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163132 ORDER BY `minOrder` ASC [ RunTime:0.097478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163132 ORDER BY `unit` DESC [ RunTime:0.034795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163132 LIMIT 2 [ RunTime:0.094902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163132 ORDER BY `minOrder` ASC [ RunTime:0.045606s ]
select * from pdf where partno='2106135-4' and brandshort='te connectivity / p&b' limit 1 [ RunTime:0.022031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106135-4' OR `brand` LIKE 'te connectivity / p&b%' ) ) LIMIT 1 [ RunTime:0.014315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32446275 LIMIT 4 [ RunTime:0.076842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32446275 ORDER BY `minOrder` ASC [ RunTime:0.037702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32446275 ORDER BY `unit` DESC [ RunTime:0.057337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32446275 LIMIT 2 [ RunTime:0.066382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32446275 ORDER BY `minOrder` ASC [ RunTime:0.002688s ]
select * from pdf where partno='2103' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.021087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.058115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33406149 LIMIT 4 [ RunTime:0.052862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33406149 ORDER BY `minOrder` ASC [ RunTime:0.033846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33406149 ORDER BY `unit` DESC [ RunTime:0.035065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33406149 LIMIT 2 [ RunTime:0.016327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33406149 ORDER BY `minOrder` ASC [ RunTime:0.051213s ]
select * from pdf where partno='2102-2-00-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.022649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2102-2-00-01-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.054924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277760 LIMIT 4 [ RunTime:0.023266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277760 ORDER BY `minOrder` ASC [ RunTime:0.047230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277760 ORDER BY `unit` DESC [ RunTime:0.020500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277760 LIMIT 2 [ RunTime:0.042500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277760 ORDER BY `minOrder` ASC [ RunTime:0.012558s ]
select * from pdf where partno='2106751-3' and brandshort='te connectivity' limit 1 [ RunTime:0.031214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106751-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.084887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32163258 LIMIT 4 [ RunTime:0.029199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163258 ORDER BY `minOrder` ASC [ RunTime:0.065010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32163258 ORDER BY `unit` DESC [ RunTime:0.027814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32163258 LIMIT 2 [ RunTime:0.019236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32163258 ORDER BY `minOrder` ASC [ RunTime:0.035628s ]
select * from pdf where partno='2106751-3' and brandshort='te connectivity' limit 1 [ RunTime:0.018026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106751-3' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.029410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34357521 LIMIT 4 [ RunTime:0.009784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34357521 ORDER BY `minOrder` ASC [ RunTime:0.039886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34357521 ORDER BY `unit` DESC [ RunTime:0.046948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34357521 LIMIT 2 [ RunTime:0.049249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34357521 ORDER BY `minOrder` ASC [ RunTime:0.015848s ]
select * from pdf where partno='21003211-01' and brandshort='Chogori Technologies Inc.' limit 1 [ RunTime:0.028426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21003211-01' OR `brand` LIKE 'Chogori Technologies Inc.%' ) ) LIMIT 1 [ RunTime:0.025498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519934 LIMIT 4 [ RunTime:0.027449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519934 ORDER BY `minOrder` ASC [ RunTime:0.022640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519934 ORDER BY `unit` DESC [ RunTime:0.030425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519934 LIMIT 2 [ RunTime:0.033351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519934 ORDER BY `minOrder` ASC [ RunTime:0.020720s ]
select * from pdf where partno='2101-3-00-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.017276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277492 LIMIT 4 [ RunTime:0.030992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277492 ORDER BY `minOrder` ASC [ RunTime:0.050048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277492 ORDER BY `unit` DESC [ RunTime:0.035984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277492 LIMIT 2 [ RunTime:0.029623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277492 ORDER BY `minOrder` ASC [ RunTime:0.010804s ]
select * from pdf where partno='2106489-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.016101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106489-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.011187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32162990 LIMIT 4 [ RunTime:0.083282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162990 ORDER BY `minOrder` ASC [ RunTime:0.029862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32162990 ORDER BY `unit` DESC [ RunTime:0.039502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32162990 LIMIT 2 [ RunTime:0.099440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32162990 ORDER BY `minOrder` ASC [ RunTime:0.012015s ]
select * from pdf where partno='2106489-3' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.007181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106489-3' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484142 LIMIT 4 [ RunTime:0.070727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484142 ORDER BY `minOrder` ASC [ RunTime:0.032370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484142 ORDER BY `unit` DESC [ RunTime:0.048682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484142 LIMIT 2 [ RunTime:0.045161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484142 ORDER BY `minOrder` ASC [ RunTime:0.005858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32256984 LIMIT 4 [ RunTime:0.014316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256984 ORDER BY `minOrder` ASC [ RunTime:0.025784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32256984 ORDER BY `unit` DESC [ RunTime:0.016777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32256984 LIMIT 2 [ RunTime:0.041507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32256984 ORDER BY `minOrder` ASC [ RunTime:0.019023s ]
select * from pdf where partno='210-43-316-41-001000' and brandshort='mill-max' limit 1 [ RunTime:0.027575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '210-43-316-41-001000' OR `brand` LIKE 'mill-max%' ) ) LIMIT 1 [ RunTime:0.020744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11926499 LIMIT 4 [ RunTime:0.037078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926499 ORDER BY `minOrder` ASC [ RunTime:0.025516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11926499 ORDER BY `unit` DESC [ RunTime:0.029534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11926499 LIMIT 2 [ RunTime:0.039293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11926499 ORDER BY `minOrder` ASC [ RunTime:0.015565s ]
select * from pdf where partno='210-1-08-003' and brandshort='CNC Tech' limit 1 [ RunTime:0.011554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32304168 LIMIT 4 [ RunTime:0.042807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304168 ORDER BY `minOrder` ASC [ RunTime:0.018627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32304168 ORDER BY `unit` DESC [ RunTime:0.002729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32304168 LIMIT 2 [ RunTime:0.024724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32304168 ORDER BY `minOrder` ASC [ RunTime:0.018216s ]
select * from pdf where partno='2108848-1' and brandshort='te connectivity' limit 1 [ RunTime:0.029543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108848-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.037234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32296044 LIMIT 4 [ RunTime:0.028485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296044 ORDER BY `minOrder` ASC [ RunTime:0.022517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32296044 ORDER BY `unit` DESC [ RunTime:0.035125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32296044 LIMIT 2 [ RunTime:0.033586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32296044 ORDER BY `minOrder` ASC [ RunTime:0.023979s ]
select * from pdf where partno='2108848-1' and brandshort='te connectivity' limit 1 [ RunTime:0.009927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108848-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.007297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13317011 LIMIT 4 [ RunTime:0.015975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13317011 ORDER BY `minOrder` ASC [ RunTime:0.028637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13317011 ORDER BY `unit` DESC [ RunTime:0.018072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13317011 LIMIT 2 [ RunTime:0.020750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13317011 ORDER BY `minOrder` ASC [ RunTime:0.044566s ]
select * from pdf where partno='2108-632-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.014425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13255719 LIMIT 4 [ RunTime:0.017060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13255719 ORDER BY `minOrder` ASC [ RunTime:0.012055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13255719 ORDER BY `unit` DESC [ RunTime:0.028060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13255719 LIMIT 2 [ RunTime:0.005188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13255719 ORDER BY `minOrder` ASC [ RunTime:0.007278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277907 LIMIT 4 [ RunTime:0.005087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277907 ORDER BY `minOrder` ASC [ RunTime:0.003940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277907 ORDER BY `unit` DESC [ RunTime:0.003536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277907 LIMIT 2 [ RunTime:0.004611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277907 ORDER BY `minOrder` ASC [ RunTime:0.006865s ]
select * from pdf where partno='2106123-1 (cut strip)' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2106123-1 (cut strip)' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.001004s ]
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.000661s ]