SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001191s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=SDC2&search=1' [ RunTime:0.002461s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002216s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000605s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003007s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.009408s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002040s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005011s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001877s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SDC2' LIMIT 1 [ RunTime:0.012255s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-10 17:19:39' WHERE `partno` = 'SDC2' [ RunTime:0.009587s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002473s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023353s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17384666 LIMIT 5 [ RunTime:0.001222s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17384666 ORDER BY `minOrder` ASC [ RunTime:0.007381s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17384666 ORDER BY `unit` DESC [ RunTime:0.008298s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17384666 LIMIT 2 [ RunTime:0.022346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17384666 ORDER BY `minOrder` ASC [ RunTime:0.013407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15562147 LIMIT 5 [ RunTime:0.008121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15562147 ORDER BY `minOrder` ASC [ RunTime:0.004706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15562147 ORDER BY `unit` DESC [ RunTime:0.001130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15562147 LIMIT 2 [ RunTime:0.003177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15562147 ORDER BY `minOrder` ASC [ RunTime:0.004942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19000411 LIMIT 5 [ RunTime:0.007462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19000411 ORDER BY `minOrder` ASC [ RunTime:0.001666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19000411 ORDER BY `unit` DESC [ RunTime:0.005530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19000411 LIMIT 2 [ RunTime:0.004174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19000411 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17053164 LIMIT 5 [ RunTime:0.004059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17053164 ORDER BY `minOrder` ASC [ RunTime:0.017300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17053164 ORDER BY `unit` DESC [ RunTime:0.024609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17053164 LIMIT 2 [ RunTime:0.005486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17053164 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14199960 LIMIT 5 [ RunTime:0.000949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14199960 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14199960 ORDER BY `unit` DESC [ RunTime:0.012286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14199960 LIMIT 2 [ RunTime:0.001964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14199960 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
select * from pdf where partno='SDC246U24BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001818 LIMIT 5 [ RunTime:0.015704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001818 ORDER BY `minOrder` ASC [ RunTime:0.019843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001818 ORDER BY `unit` DESC [ RunTime:0.009743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001818 LIMIT 2 [ RunTime:0.012193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001818 ORDER BY `minOrder` ASC [ RunTime:0.002228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001816 LIMIT 5 [ RunTime:0.002255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001816 ORDER BY `minOrder` ASC [ RunTime:0.005793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001816 ORDER BY `unit` DESC [ RunTime:0.025381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001816 LIMIT 2 [ RunTime:0.004322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001816 ORDER BY `minOrder` ASC [ RunTime:0.006678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001781 LIMIT 5 [ RunTime:0.018697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001781 ORDER BY `minOrder` ASC [ RunTime:0.007810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001781 ORDER BY `unit` DESC [ RunTime:0.037673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001781 LIMIT 2 [ RunTime:0.013490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001781 ORDER BY `minOrder` ASC [ RunTime:0.015717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001069 LIMIT 5 [ RunTime:0.020961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001069 ORDER BY `minOrder` ASC [ RunTime:0.007439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001069 ORDER BY `unit` DESC [ RunTime:0.017197s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001069 LIMIT 2 [ RunTime:0.007056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001069 ORDER BY `minOrder` ASC [ RunTime:0.007943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19002075 LIMIT 5 [ RunTime:0.001275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19002075 ORDER BY `minOrder` ASC [ RunTime:0.048384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19002075 ORDER BY `unit` DESC [ RunTime:0.009973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19002075 LIMIT 2 [ RunTime:0.016518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19002075 ORDER BY `minOrder` ASC [ RunTime:0.007165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001821 LIMIT 5 [ RunTime:0.006676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001821 ORDER BY `minOrder` ASC [ RunTime:0.003939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001821 ORDER BY `unit` DESC [ RunTime:0.004705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001821 LIMIT 2 [ RunTime:0.021037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001821 ORDER BY `minOrder` ASC [ RunTime:0.009092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001815 LIMIT 5 [ RunTime:0.008105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001815 ORDER BY `minOrder` ASC [ RunTime:0.010146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19001815 ORDER BY `unit` DESC [ RunTime:0.004053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19001815 LIMIT 2 [ RunTime:0.001983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19001815 ORDER BY `minOrder` ASC [ RunTime:0.000787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15562471 LIMIT 5 [ RunTime:0.002092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15562471 ORDER BY `minOrder` ASC [ RunTime:0.006720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15562471 ORDER BY `unit` DESC [ RunTime:0.000714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15562471 LIMIT 2 [ RunTime:0.002444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15562471 ORDER BY `minOrder` ASC [ RunTime:0.003083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15270585 LIMIT 5 [ RunTime:0.019162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15270585 ORDER BY `minOrder` ASC [ RunTime:0.008388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15270585 ORDER BY `unit` DESC [ RunTime:0.001608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15270585 LIMIT 2 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15270585 ORDER BY `minOrder` ASC [ RunTime:0.005205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12184658 LIMIT 5 [ RunTime:0.019376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12184658 ORDER BY `minOrder` ASC [ RunTime:0.010882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12184658 ORDER BY `unit` DESC [ RunTime:0.016420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12184658 LIMIT 2 [ RunTime:0.009598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12184658 ORDER BY `minOrder` ASC [ RunTime:0.024501s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220142 LIMIT 5 [ RunTime:0.009320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220142 ORDER BY `minOrder` ASC [ RunTime:0.016031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220142 ORDER BY `unit` DESC [ RunTime:0.011923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220142 LIMIT 2 [ RunTime:0.006125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220142 ORDER BY `minOrder` ASC [ RunTime:0.002369s ]
select * from pdf where partno='sdc243u17bk' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.005372s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sdc243u17bk' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.007151s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220142 AND `partno` = 'sdc243u17bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.007979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51077427 LIMIT 5 [ RunTime:0.000563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077427 ORDER BY `minOrder` ASC [ RunTime:0.002940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51077427 ORDER BY `unit` DESC [ RunTime:0.023384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51077427 LIMIT 2 [ RunTime:0.008104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51077427 ORDER BY `minOrder` ASC [ RunTime:0.005675s ]
select * from pdf where partno='sdc243u24bk' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.007038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'sdc243u24bk' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.008287s ]
SELECT `id` FROM `stock` WHERE `id` <> 51077427 AND `partno` = 'sdc243u24bk' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.013211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001815 [ RunTime:0.003075s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60376490 LIMIT 5 [ RunTime:0.008341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60376490 ORDER BY `minOrder` ASC [ RunTime:0.001209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60376490 ORDER BY `unit` DESC [ RunTime:0.002713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60376490 LIMIT 2 [ RunTime:0.007436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60376490 ORDER BY `minOrder` ASC [ RunTime:0.002377s ]
select * from pdf where partno='SDC25AG' and brandshort='L-com' limit 1 [ RunTime:0.001294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC25AG' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.009115s ]
SELECT `id` FROM `stock` WHERE `id` <> 60376490 AND `partno` = 'SDC25AG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.002518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60377540 LIMIT 5 [ RunTime:0.006516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60377540 ORDER BY `minOrder` ASC [ RunTime:0.007371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60377540 ORDER BY `unit` DESC [ RunTime:0.004403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60377540 LIMIT 2 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60377540 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='SDC25M' and brandshort='L-com' limit 1 [ RunTime:0.001233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC25M' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.006762s ]
SELECT `id` FROM `stock` WHERE `id` <> 60377540 AND `partno` = 'SDC25M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15562147 [ RunTime:0.001406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63464979 LIMIT 5 [ RunTime:0.005997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464979 ORDER BY `minOrder` ASC [ RunTime:0.001649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63464979 ORDER BY `unit` DESC [ RunTime:0.001404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63464979 LIMIT 2 [ RunTime:0.000783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464979 ORDER BY `minOrder` ASC [ RunTime:0.001865s ]
select * from pdf where partno='SDC243U24BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC243U24BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.007451s ]
SELECT `id` FROM `stock` WHERE `id` <> 63464979 AND `partno` = 'SDC243U24BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.003248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001815 [ RunTime:0.003697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63464950 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464950 ORDER BY `minOrder` ASC [ RunTime:0.001418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63464950 ORDER BY `unit` DESC [ RunTime:0.000650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63464950 LIMIT 2 [ RunTime:0.000891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464950 ORDER BY `minOrder` ASC [ RunTime:0.004268s ]
select * from pdf where partno='SDC249U31BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC249U31BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.011571s ]
SELECT `id` FROM `stock` WHERE `id` <> 63464950 AND `partno` = 'SDC249U31BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.011752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19000411 [ RunTime:0.003325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63464986 LIMIT 5 [ RunTime:0.004061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464986 ORDER BY `minOrder` ASC [ RunTime:0.008436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63464986 ORDER BY `unit` DESC [ RunTime:0.003121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63464986 LIMIT 2 [ RunTime:0.003413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464986 ORDER BY `minOrder` ASC [ RunTime:0.006009s ]
select * from pdf where partno='SDC249U24BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.005070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC249U24BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.011388s ]
SELECT `id` FROM `stock` WHERE `id` <> 63464986 AND `partno` = 'SDC249U24BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.003096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17053164 [ RunTime:0.002463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63464987 LIMIT 5 [ RunTime:0.020011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464987 ORDER BY `minOrder` ASC [ RunTime:0.015805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63464987 ORDER BY `unit` DESC [ RunTime:0.019820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63464987 LIMIT 2 [ RunTime:0.006350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464987 ORDER BY `minOrder` ASC [ RunTime:0.013723s ]
select * from pdf where partno='SDC246U31BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.009855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC246U31BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.006259s ]
SELECT `id` FROM `stock` WHERE `id` <> 63464987 AND `partno` = 'SDC246U31BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.006625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001821 [ RunTime:0.006226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63464984 LIMIT 5 [ RunTime:0.026311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464984 ORDER BY `minOrder` ASC [ RunTime:0.005146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63464984 ORDER BY `unit` DESC [ RunTime:0.003111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63464984 LIMIT 2 [ RunTime:0.001168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464984 ORDER BY `minOrder` ASC [ RunTime:0.006213s ]
select * from pdf where partno='SDC243U36BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.018815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC243U36BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.018522s ]
SELECT `id` FROM `stock` WHERE `id` <> 63464984 AND `partno` = 'SDC243U36BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.041517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001818 [ RunTime:0.003630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63464939 LIMIT 5 [ RunTime:0.011158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464939 ORDER BY `minOrder` ASC [ RunTime:0.012426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63464939 ORDER BY `unit` DESC [ RunTime:0.007087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63464939 LIMIT 2 [ RunTime:0.000739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464939 ORDER BY `minOrder` ASC [ RunTime:0.000821s ]
select * from pdf where partno='SDC246U24BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC246U24BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.005212s ]
SELECT `id` FROM `stock` WHERE `id` <> 63464939 AND `partno` = 'SDC246U24BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.017671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14199960 [ RunTime:0.037212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63464983 LIMIT 5 [ RunTime:0.017043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464983 ORDER BY `minOrder` ASC [ RunTime:0.029304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63464983 ORDER BY `unit` DESC [ RunTime:0.008822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63464983 LIMIT 2 [ RunTime:0.010078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63464983 ORDER BY `minOrder` ASC [ RunTime:0.017706s ]
select * from pdf where partno='SDC249U17BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.029638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC249U17BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.010952s ]
SELECT `id` FROM `stock` WHERE `id` <> 63464983 AND `partno` = 'SDC249U17BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.012666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001816 [ RunTime:0.003334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63465089 LIMIT 5 [ RunTime:0.003272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63465089 ORDER BY `minOrder` ASC [ RunTime:0.023488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63465089 ORDER BY `unit` DESC [ RunTime:0.005617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63465089 LIMIT 2 [ RunTime:0.001282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63465089 ORDER BY `minOrder` ASC [ RunTime:0.007621s ]
select * from pdf where partno='SDC249U36BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.005738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC249U36BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.008736s ]
SELECT `id` FROM `stock` WHERE `id` <> 63465089 AND `partno` = 'SDC249U36BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.006636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001781 [ RunTime:0.011941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63465632 LIMIT 5 [ RunTime:0.010933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63465632 ORDER BY `minOrder` ASC [ RunTime:0.012568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63465632 ORDER BY `unit` DESC [ RunTime:0.002694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63465632 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63465632 ORDER BY `minOrder` ASC [ RunTime:0.004437s ]
select * from pdf where partno='SDC246U36BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC246U36BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.004538s ]
SELECT `id` FROM `stock` WHERE `id` <> 63465632 AND `partno` = 'SDC246U36BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.009511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15270585 [ RunTime:0.002650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63465559 LIMIT 5 [ RunTime:0.001481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63465559 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63465559 ORDER BY `unit` DESC [ RunTime:0.004045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63465559 LIMIT 2 [ RunTime:0.003322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63465559 ORDER BY `minOrder` ASC [ RunTime:0.002276s ]
select * from pdf where partno='SDC243U31BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC243U31BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.007392s ]
SELECT `id` FROM `stock` WHERE `id` <> 63465559 AND `partno` = 'SDC243U31BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.004623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19002075 [ RunTime:0.007035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63465521 LIMIT 5 [ RunTime:0.003275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63465521 ORDER BY `minOrder` ASC [ RunTime:0.002402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63465521 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63465521 LIMIT 2 [ RunTime:0.004237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63465521 ORDER BY `minOrder` ASC [ RunTime:0.003896s ]
select * from pdf where partno='SDC246U17BK' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC246U17BK' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000741s ]
SELECT `id` FROM `stock` WHERE `id` <> 63465521 AND `partno` = 'SDC246U17BK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.009613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19001069 [ RunTime:0.008623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60379795 LIMIT 5 [ RunTime:0.002152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60379795 ORDER BY `minOrder` ASC [ RunTime:0.007522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60379795 ORDER BY `unit` DESC [ RunTime:0.006880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60379795 LIMIT 2 [ RunTime:0.000306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60379795 ORDER BY `minOrder` ASC [ RunTime:0.002079s ]
select * from pdf where partno='SDC25B' and brandshort='L-com' limit 1 [ RunTime:0.000574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC25B' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.009950s ]
SELECT `id` FROM `stock` WHERE `id` <> 60379795 AND `partno` = 'SDC25B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.000988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15562471 [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60378701 LIMIT 5 [ RunTime:0.002539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60378701 ORDER BY `minOrder` ASC [ RunTime:0.004657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60378701 ORDER BY `unit` DESC [ RunTime:0.004098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60378701 LIMIT 2 [ RunTime:0.000861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60378701 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
select * from pdf where partno='SDC25G' and brandshort='L-com' limit 1 [ RunTime:0.000844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC25G' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.006768s ]
SELECT `id` FROM `stock` WHERE `id` <> 60378701 AND `partno` = 'SDC25G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.000653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17384666 [ RunTime:0.004844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58551461 LIMIT 5 [ RunTime:0.008593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58551461 ORDER BY `minOrder` ASC [ RunTime:0.004228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58551461 ORDER BY `unit` DESC [ RunTime:0.008963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58551461 LIMIT 2 [ RunTime:0.001436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58551461 ORDER BY `minOrder` ASC [ RunTime:0.003322s ]
select * from pdf where partno='SDC2' and brandshort='Dremel' limit 1 [ RunTime:0.007009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDC2' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.007294s ]
SELECT `id` FROM `stock` WHERE `id` <> 58551461 AND `partno` = 'SDC2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.000818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12184658 [ RunTime:0.000490s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001013s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002990s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001720s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023058s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014958s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008456s ]
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 `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005762s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SDC2%' OR `brand` LIKE 'SDC2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007203s ]