SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001304s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `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=DAM-15S&search=1' [ RunTime:0.024372s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001299s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005111s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001501s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.021412s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003074s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.024106s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001293s ]
SELECT * FROM `stock_search` WHERE `partno` = 'DAM-15S' LIMIT 1 [ RunTime:0.036292s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-28 20:06:53' WHERE `partno` = 'DAM-15S' [ RunTime:0.007240s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001580s ]
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 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058403s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11902183 LIMIT 5 [ RunTime:0.011402s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11902183 ORDER BY `minOrder` ASC [ RunTime:0.071069s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11902183 ORDER BY `unit` DESC [ RunTime:0.045063s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11902183 LIMIT 2 [ RunTime:0.025361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11902183 ORDER BY `minOrder` ASC [ RunTime:0.012053s ]
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 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016125s ]
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 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55122792 LIMIT 5 [ RunTime:0.026845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122792 ORDER BY `minOrder` ASC [ RunTime:0.024008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55122792 ORDER BY `unit` DESC [ RunTime:0.019298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55122792 LIMIT 2 [ RunTime:0.006955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55122792 ORDER BY `minOrder` ASC [ RunTime:0.009747s ]
select * from pdf where partno='DAM-15S' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.033507s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.021586s ]
SELECT `id` FROM `stock` WHERE `id` <> 55122792 AND `partno` = 'DAM-15S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.040193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55126398 LIMIT 5 [ RunTime:0.034047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55126398 ORDER BY `minOrder` ASC [ RunTime:0.008177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55126398 ORDER BY `unit` DESC [ RunTime:0.029643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55126398 LIMIT 2 [ RunTime:0.015849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55126398 ORDER BY `minOrder` ASC [ RunTime:0.012232s ]
select * from pdf where partno='DAM-15S-K126' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.009169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-K126' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.017967s ]
SELECT `id` FROM `stock` WHERE `id` <> 55126398 AND `partno` = 'DAM-15S-K126' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.005372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55120774 LIMIT 5 [ RunTime:0.001238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55120774 ORDER BY `minOrder` ASC [ RunTime:0.003424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55120774 ORDER BY `unit` DESC [ RunTime:0.014445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55120774 LIMIT 2 [ RunTime:0.014997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55120774 ORDER BY `minOrder` ASC [ RunTime:0.007269s ]
select * from pdf where partno='DAM-15S-K' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.012302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-K' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.006541s ]
SELECT `id` FROM `stock` WHERE `id` <> 55120774 AND `partno` = 'DAM-15S-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.002965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55119447 LIMIT 5 [ RunTime:0.008112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55119447 ORDER BY `minOrder` ASC [ RunTime:0.025161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55119447 ORDER BY `unit` DESC [ RunTime:0.001932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55119447 LIMIT 2 [ RunTime:0.006278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55119447 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='DAM-15S-G' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.005397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-G' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.004469s ]
SELECT `id` FROM `stock` WHERE `id` <> 55119447 AND `partno` = 'DAM-15S-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.019888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55118934 LIMIT 5 [ RunTime:0.015848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118934 ORDER BY `minOrder` ASC [ RunTime:0.020595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55118934 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55118934 LIMIT 2 [ RunTime:0.000860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118934 ORDER BY `minOrder` ASC [ RunTime:0.000973s ]
select * from pdf where partno='DAM-15S-F179A' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-F179A' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.004508s ]
SELECT `id` FROM `stock` WHERE `id` <> 55118934 AND `partno` = 'DAM-15S-F179A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.012195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55118705 LIMIT 5 [ RunTime:0.002653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118705 ORDER BY `minOrder` ASC [ RunTime:0.001311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55118705 ORDER BY `unit` DESC [ RunTime:0.000540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55118705 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118705 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
select * from pdf where partno='DAM-15S-D' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.000854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-D' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.003293s ]
SELECT `id` FROM `stock` WHERE `id` <> 55118705 AND `partno` = 'DAM-15S-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.007780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55118640 LIMIT 5 [ RunTime:0.002314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118640 ORDER BY `minOrder` ASC [ RunTime:0.011155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55118640 ORDER BY `unit` DESC [ RunTime:0.007387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55118640 LIMIT 2 [ RunTime:0.001112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118640 ORDER BY `minOrder` ASC [ RunTime:0.002570s ]
select * from pdf where partno='DAM-15S-X' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.010878s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-X' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.004871s ]
SELECT `id` FROM `stock` WHERE `id` <> 55118640 AND `partno` = 'DAM-15S-X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.003910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55118637 LIMIT 5 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118637 ORDER BY `minOrder` ASC [ RunTime:0.000605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55118637 ORDER BY `unit` DESC [ RunTime:0.002727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55118637 LIMIT 2 [ RunTime:0.016799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118637 ORDER BY `minOrder` ASC [ RunTime:0.002938s ]
select * from pdf where partno='DAM-15S-L' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.009953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-L' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.003360s ]
SELECT `id` FROM `stock` WHERE `id` <> 55118637 AND `partno` = 'DAM-15S-L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.014900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55118625 LIMIT 5 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118625 ORDER BY `minOrder` ASC [ RunTime:0.006863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55118625 ORDER BY `unit` DESC [ RunTime:0.000774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55118625 LIMIT 2 [ RunTime:0.005034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118625 ORDER BY `minOrder` ASC [ RunTime:0.017157s ]
select * from pdf where partno='DAM-15S-A' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.011276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-A' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.001340s ]
SELECT `id` FROM `stock` WHERE `id` <> 55118625 AND `partno` = 'DAM-15S-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.004347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55118604 LIMIT 5 [ RunTime:0.013023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118604 ORDER BY `minOrder` ASC [ RunTime:0.028621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55118604 ORDER BY `unit` DESC [ RunTime:0.009434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55118604 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118604 ORDER BY `minOrder` ASC [ RunTime:0.007424s ]
select * from pdf where partno='DAM-15S-P' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.013185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-P' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.034893s ]
SELECT `id` FROM `stock` WHERE `id` <> 55118604 AND `partno` = 'DAM-15S-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.023102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55118561 LIMIT 5 [ RunTime:0.033038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118561 ORDER BY `minOrder` ASC [ RunTime:0.017789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55118561 ORDER BY `unit` DESC [ RunTime:0.015675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55118561 LIMIT 2 [ RunTime:0.048432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118561 ORDER BY `minOrder` ASC [ RunTime:0.006360s ]
select * from pdf where partno='DAM-15S-M' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.015667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-M' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.005082s ]
SELECT `id` FROM `stock` WHERE `id` <> 55118561 AND `partno` = 'DAM-15S-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.020261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55118556 LIMIT 5 [ RunTime:0.026167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118556 ORDER BY `minOrder` ASC [ RunTime:0.011715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55118556 ORDER BY `unit` DESC [ RunTime:0.016416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55118556 LIMIT 2 [ RunTime:0.024406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118556 ORDER BY `minOrder` ASC [ RunTime:0.007655s ]
select * from pdf where partno='DAM-15S-Z' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.034865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-Z' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.008237s ]
SELECT `id` FROM `stock` WHERE `id` <> 55118556 AND `partno` = 'DAM-15S-Z' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.036688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55118555 LIMIT 5 [ RunTime:0.035516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118555 ORDER BY `minOrder` ASC [ RunTime:0.010065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55118555 ORDER BY `unit` DESC [ RunTime:0.003858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55118555 LIMIT 2 [ RunTime:0.010135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118555 ORDER BY `minOrder` ASC [ RunTime:0.009892s ]
select * from pdf where partno='DAM-15S-E' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.040947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-E' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.017823s ]
SELECT `id` FROM `stock` WHERE `id` <> 55118555 AND `partno` = 'DAM-15S-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.024902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11902183 [ RunTime:0.012924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55118510 LIMIT 5 [ RunTime:0.021584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118510 ORDER BY `minOrder` ASC [ RunTime:0.018051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55118510 ORDER BY `unit` DESC [ RunTime:0.035784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55118510 LIMIT 2 [ RunTime:0.041697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55118510 ORDER BY `minOrder` ASC [ RunTime:0.020767s ]
select * from pdf where partno='DAM-15S-F' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.010602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-F' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.020206s ]
SELECT `id` FROM `stock` WHERE `id` <> 55118510 AND `partno` = 'DAM-15S-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.022052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32516551 LIMIT 5 [ RunTime:0.008755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32516551 ORDER BY `minOrder` ASC [ RunTime:0.014434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32516551 ORDER BY `unit` DESC [ RunTime:0.004617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32516551 LIMIT 2 [ RunTime:0.013968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32516551 ORDER BY `minOrder` ASC [ RunTime:0.027291s ]
select * from pdf where partno='DAM-15S-K52' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.029294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-K52' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.010133s ]
SELECT `id` FROM `stock` WHERE `id` <> 32516551 AND `partno` = 'DAM-15S-K52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.007532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32480691 LIMIT 5 [ RunTime:0.015354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32480691 ORDER BY `minOrder` ASC [ RunTime:0.008487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32480691 ORDER BY `unit` DESC [ RunTime:0.003384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32480691 LIMIT 2 [ RunTime:0.006542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32480691 ORDER BY `minOrder` ASC [ RunTime:0.002748s ]
select * from pdf where partno='DAM-15S-F179-A222' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.017115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-F179-A222' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.005790s ]
SELECT `id` FROM `stock` WHERE `id` <> 32480691 AND `partno` = 'DAM-15S-F179-A222' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.010678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32470945 LIMIT 5 [ RunTime:0.018419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32470945 ORDER BY `minOrder` ASC [ RunTime:0.006857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32470945 ORDER BY `unit` DESC [ RunTime:0.010962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32470945 LIMIT 2 [ RunTime:0.015126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32470945 ORDER BY `minOrder` ASC [ RunTime:0.010520s ]
select * from pdf where partno='DAM-15S-F179-A197' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.006322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-F179-A197' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.007815s ]
SELECT `id` FROM `stock` WHERE `id` <> 32470945 AND `partno` = 'DAM-15S-F179-A197' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.007409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32456793 LIMIT 5 [ RunTime:0.012779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32456793 ORDER BY `minOrder` ASC [ RunTime:0.023658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32456793 ORDER BY `unit` DESC [ RunTime:0.003153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32456793 LIMIT 2 [ RunTime:0.021152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32456793 ORDER BY `minOrder` ASC [ RunTime:0.010542s ]
select * from pdf where partno='DAM-15S-1A0N-A197' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.017269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-1A0N-A197' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.031857s ]
SELECT `id` FROM `stock` WHERE `id` <> 32456793 AND `partno` = 'DAM-15S-1A0N-A197' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.012915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32430965 LIMIT 5 [ RunTime:0.008110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32430965 ORDER BY `minOrder` ASC [ RunTime:0.011240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32430965 ORDER BY `unit` DESC [ RunTime:0.002172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32430965 LIMIT 2 [ RunTime:0.001633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32430965 ORDER BY `minOrder` ASC [ RunTime:0.001428s ]
select * from pdf where partno='DAM-15S-S' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.020523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-S' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.025099s ]
SELECT `id` FROM `stock` WHERE `id` <> 32430965 AND `partno` = 'DAM-15S-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.021633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32424515 LIMIT 5 [ RunTime:0.020063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32424515 ORDER BY `minOrder` ASC [ RunTime:0.011629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32424515 ORDER BY `unit` DESC [ RunTime:0.026231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32424515 LIMIT 2 [ RunTime:0.012032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32424515 ORDER BY `minOrder` ASC [ RunTime:0.022532s ]
select * from pdf where partno='DAM-15S-L-F225' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.004200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DAM-15S-L-F225' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.022595s ]
SELECT `id` FROM `stock` WHERE `id` <> 32424515 AND `partno` = 'DAM-15S-L-F225' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.005624s ]
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 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014081s ]
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 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029240s ]
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 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038700s ]
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 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006994s ]
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 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052848s ]
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 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023190s ]
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 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002587s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'DAM-15S%' OR `brand` LIKE 'DAM-15S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009939s ]