SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001244s ]
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.012627s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002434s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.014434s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001401s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.220' ) [ RunTime:0.002682s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001477s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001526s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002093s ]
SELECT * FROM `stock_search` WHERE `partno` = '210' LIMIT 1 [ RunTime:0.000766s ]
UPDATE `stock_search` SET `count` = 1178 , `updatetime` = '2026-06-06 15:16:54' WHERE `partno` = '210' [ RunTime:0.012136s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000768s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.001805s ]
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.008285s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001380s ]
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.001415s ]
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 2940,20 [ RunTime:0.067187s ]
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 ('32622626','32622469','32622460','32622447','32622220','32622217','32622200','32622199','32621681','32619473','32613996','32609188','32607156','32601425','32600908','32598421','32596696','32592358','32592168','32591990') ORDER BY FIELD(s.id, 32622626,32622469,32622460,32622447,32622220,32622217,32622200,32622199,32621681,32619473,32613996,32609188,32607156,32601425,32600908,32598421,32596696,32592358,32592168,32591990) [ RunTime:0.034049s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32622626 LIMIT 4 [ RunTime:0.024369s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622626 ORDER BY `minOrder` ASC [ RunTime:0.031778s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.028249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32622626 ORDER BY `unit` DESC [ RunTime:0.024904s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32622626 LIMIT 2 [ RunTime:0.040045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622626 ORDER BY `minOrder` ASC [ RunTime:0.015534s ]
select * from pdf where partno='21006R' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.034108s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21006R' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.070195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32622469 LIMIT 4 [ RunTime:0.042840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622469 ORDER BY `minOrder` ASC [ RunTime:0.041712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32622469 ORDER BY `unit` DESC [ RunTime:0.143212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32622469 LIMIT 2 [ RunTime:0.091225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622469 ORDER BY `minOrder` ASC [ RunTime:0.076846s ]
select * from pdf where partno='21006' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.101725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21006' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.063026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32622460 LIMIT 4 [ RunTime:0.129362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622460 ORDER BY `minOrder` ASC [ RunTime:0.134536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32622460 ORDER BY `unit` DESC [ RunTime:0.046420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32622460 LIMIT 2 [ RunTime:0.132243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622460 ORDER BY `minOrder` ASC [ RunTime:0.113698s ]
select * from pdf where partno='21005' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.051089s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21005' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.026410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32622447 LIMIT 4 [ RunTime:0.089522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622447 ORDER BY `minOrder` ASC [ RunTime:0.141562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32622447 ORDER BY `unit` DESC [ RunTime:0.049709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32622447 LIMIT 2 [ RunTime:0.040688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622447 ORDER BY `minOrder` ASC [ RunTime:0.009586s ]
select * from pdf where partno='21005R' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.087751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21005R' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.089020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32622220 LIMIT 4 [ RunTime:0.087472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622220 ORDER BY `minOrder` ASC [ RunTime:0.101959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32622220 ORDER BY `unit` DESC [ RunTime:0.205751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32622220 LIMIT 2 [ RunTime:0.024037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622220 ORDER BY `minOrder` ASC [ RunTime:0.151817s ]
select * from pdf where partno='21035R' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.077318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035R' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.043487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32622217 LIMIT 4 [ RunTime:0.074157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622217 ORDER BY `minOrder` ASC [ RunTime:0.051937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32622217 ORDER BY `unit` DESC [ RunTime:0.068386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32622217 LIMIT 2 [ RunTime:0.035360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622217 ORDER BY `minOrder` ASC [ RunTime:0.014956s ]
select * from pdf where partno='21036' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.041230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21036' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.156855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32622200 LIMIT 4 [ RunTime:0.081565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622200 ORDER BY `minOrder` ASC [ RunTime:0.051141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32622200 ORDER BY `unit` DESC [ RunTime:0.064533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32622200 LIMIT 2 [ RunTime:0.201045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622200 ORDER BY `minOrder` ASC [ RunTime:0.051100s ]
select * from pdf where partno='21035' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.134256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21035' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.076139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32622199 LIMIT 4 [ RunTime:0.028755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622199 ORDER BY `minOrder` ASC [ RunTime:0.047012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32622199 ORDER BY `unit` DESC [ RunTime:0.031991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32622199 LIMIT 2 [ RunTime:0.080322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32622199 ORDER BY `minOrder` ASC [ RunTime:0.041750s ]
select * from pdf where partno='21036R' and brandshort='Mersen USA Newburyport-MA L.L.C.' limit 1 [ RunTime:0.051664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21036R' OR `brand` LIKE 'Mersen USA Newburyport-MA L.L.C.%' ) ) LIMIT 1 [ RunTime:0.031080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32621681 LIMIT 4 [ RunTime:0.110137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32621681 ORDER BY `minOrder` ASC [ RunTime:0.063711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32621681 ORDER BY `unit` DESC [ RunTime:0.138430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32621681 LIMIT 2 [ RunTime:0.087248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32621681 ORDER BY `minOrder` ASC [ RunTime:0.080483s ]
select * from pdf where partno='2100176' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.076212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100176' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.114529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32619473 LIMIT 4 [ RunTime:0.089401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32619473 ORDER BY `minOrder` ASC [ RunTime:0.176147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32619473 ORDER BY `unit` DESC [ RunTime:0.047481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32619473 LIMIT 2 [ RunTime:0.057988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32619473 ORDER BY `minOrder` ASC [ RunTime:0.023039s ]
select * from pdf where partno='2109773' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.079267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109773' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32613996 LIMIT 4 [ RunTime:0.056938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32613996 ORDER BY `minOrder` ASC [ RunTime:0.137972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32613996 ORDER BY `unit` DESC [ RunTime:0.062085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32613996 LIMIT 2 [ RunTime:0.047419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32613996 ORDER BY `minOrder` ASC [ RunTime:0.054619s ]
select * from pdf where partno='2104594' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.062828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104594' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.078721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32609188 LIMIT 4 [ RunTime:0.044791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32609188 ORDER BY `minOrder` ASC [ RunTime:0.035271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32609188 ORDER BY `unit` DESC [ RunTime:0.117498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32609188 LIMIT 2 [ RunTime:0.114581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32609188 ORDER BY `minOrder` ASC [ RunTime:0.043372s ]
select * from pdf where partno='2103333' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.032115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103333' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.061389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32607156 LIMIT 4 [ RunTime:0.037772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32607156 ORDER BY `minOrder` ASC [ RunTime:0.116770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32607156 ORDER BY `unit` DESC [ RunTime:0.085330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32607156 LIMIT 2 [ RunTime:0.022521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32607156 ORDER BY `minOrder` ASC [ RunTime:0.018025s ]
select * from pdf where partno='2108248' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.061513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2108248' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32601425 LIMIT 4 [ RunTime:0.045988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32601425 ORDER BY `minOrder` ASC [ RunTime:0.056650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32601425 ORDER BY `unit` DESC [ RunTime:0.027150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32601425 LIMIT 2 [ RunTime:0.026104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32601425 ORDER BY `minOrder` ASC [ RunTime:0.009583s ]
select * from pdf where partno='2101325' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101325' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.037052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32600908 LIMIT 4 [ RunTime:0.019485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32600908 ORDER BY `minOrder` ASC [ RunTime:0.024322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32600908 ORDER BY `unit` DESC [ RunTime:0.051711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32600908 LIMIT 2 [ RunTime:0.033151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32600908 ORDER BY `minOrder` ASC [ RunTime:0.028911s ]
select * from pdf where partno='2103419' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.037740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2103419' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32598421 LIMIT 4 [ RunTime:0.062203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32598421 ORDER BY `minOrder` ASC [ RunTime:0.087235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32598421 ORDER BY `unit` DESC [ RunTime:0.043245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32598421 LIMIT 2 [ RunTime:0.039196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32598421 ORDER BY `minOrder` ASC [ RunTime:0.007157s ]
select * from pdf where partno='2104795' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.059113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2104795' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.069198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32596696 LIMIT 4 [ RunTime:0.032633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32596696 ORDER BY `minOrder` ASC [ RunTime:0.065807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32596696 ORDER BY `unit` DESC [ RunTime:0.059648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32596696 LIMIT 2 [ RunTime:0.014216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32596696 ORDER BY `minOrder` ASC [ RunTime:0.060683s ]
select * from pdf where partno='2101322' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.048368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101322' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32592358 LIMIT 4 [ RunTime:0.039194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32592358 ORDER BY `minOrder` ASC [ RunTime:0.027992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32592358 ORDER BY `unit` DESC [ RunTime:0.012786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32592358 LIMIT 2 [ RunTime:0.008748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32592358 ORDER BY `minOrder` ASC [ RunTime:0.005554s ]
select * from pdf where partno='2101780-4' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.055496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2101780-4' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.051323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32592168 LIMIT 4 [ RunTime:0.050901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32592168 ORDER BY `minOrder` ASC [ RunTime:0.051345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32592168 ORDER BY `unit` DESC [ RunTime:0.050827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32592168 LIMIT 2 [ RunTime:0.050746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32592168 ORDER BY `minOrder` ASC [ RunTime:0.050826s ]
select * from pdf where partno='2109770' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.051054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2109770' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.047867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32591990 LIMIT 4 [ RunTime:0.063360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32591990 ORDER BY `minOrder` ASC [ RunTime:0.038413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32591990 ORDER BY `unit` DESC [ RunTime:0.106222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32591990 LIMIT 2 [ RunTime:0.108609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32591990 ORDER BY `minOrder` ASC [ RunTime:0.039605s ]
select * from pdf where partno='2100791' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.077142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2100791' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039520s ]
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.094241s ]