SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002593s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=CT-25&search=1' [ RunTime:0.004259s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002196s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002973s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004147s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.001435s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002435s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003151s ]
SELECT * FROM `stock_search` WHERE `partno` = 'CT-25' LIMIT 1 [ RunTime:0.024094s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 15:06:00' WHERE `partno` = 'CT-25' [ RunTime:0.006693s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002405s ]
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 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014075s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17008470 LIMIT 5 [ RunTime:0.027841s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17008470 ORDER BY `minOrder` ASC [ RunTime:0.002887s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17008470 ORDER BY `unit` DESC [ RunTime:0.008950s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17008470 LIMIT 2 [ RunTime:0.010491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17008470 ORDER BY `minOrder` ASC [ RunTime:0.003689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14179272 LIMIT 5 [ RunTime:0.004164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14179272 ORDER BY `minOrder` ASC [ RunTime:0.006295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14179272 ORDER BY `unit` DESC [ RunTime:0.007620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14179272 LIMIT 2 [ RunTime:0.003733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14179272 ORDER BY `minOrder` ASC [ RunTime:0.008972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18765490 LIMIT 5 [ RunTime:0.021129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18765490 ORDER BY `minOrder` ASC [ RunTime:0.019212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18765490 ORDER BY `unit` DESC [ RunTime:0.026136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18765490 LIMIT 2 [ RunTime:0.012351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18765490 ORDER BY `minOrder` ASC [ RunTime:0.009626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17008825 LIMIT 5 [ RunTime:0.028452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17008825 ORDER BY `minOrder` ASC [ RunTime:0.015877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17008825 ORDER BY `unit` DESC [ RunTime:0.026637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17008825 LIMIT 2 [ RunTime:0.021748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17008825 ORDER BY `minOrder` ASC [ RunTime:0.016232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15211101 LIMIT 5 [ RunTime:0.008508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15211101 ORDER BY `minOrder` ASC [ RunTime:0.008522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15211101 ORDER BY `unit` DESC [ RunTime:0.012052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15211101 LIMIT 2 [ RunTime:0.019603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15211101 ORDER BY `minOrder` ASC [ RunTime:0.012981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14176683 LIMIT 5 [ RunTime:0.010473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14176683 ORDER BY `minOrder` ASC [ RunTime:0.014543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14176683 ORDER BY `unit` DESC [ RunTime:0.009913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14176683 LIMIT 2 [ RunTime:0.007068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14176683 ORDER BY `minOrder` ASC [ RunTime:0.010368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763285 LIMIT 5 [ RunTime:0.019048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763285 ORDER BY `minOrder` ASC [ RunTime:0.020624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763285 ORDER BY `unit` DESC [ RunTime:0.015194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763285 LIMIT 2 [ RunTime:0.016408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763285 ORDER BY `minOrder` ASC [ RunTime:0.002775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763284 LIMIT 5 [ RunTime:0.011034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763284 ORDER BY `minOrder` ASC [ RunTime:0.005746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763284 ORDER BY `unit` DESC [ RunTime:0.021122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763284 LIMIT 2 [ RunTime:0.009454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763284 ORDER BY `minOrder` ASC [ RunTime:0.015919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763277 LIMIT 5 [ RunTime:0.022485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763277 ORDER BY `minOrder` ASC [ RunTime:0.016652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18763277 ORDER BY `unit` DESC [ RunTime:0.010893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18763277 LIMIT 2 [ RunTime:0.015469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18763277 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18721119 LIMIT 5 [ RunTime:0.009972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18721119 ORDER BY `minOrder` ASC [ RunTime:0.019748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18721119 ORDER BY `unit` DESC [ RunTime:0.002250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18721119 LIMIT 2 [ RunTime:0.007364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18721119 ORDER BY `minOrder` ASC [ RunTime:0.008582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17008827 LIMIT 5 [ RunTime:0.011406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17008827 ORDER BY `minOrder` ASC [ RunTime:0.023230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17008827 ORDER BY `unit` DESC [ RunTime:0.041209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17008827 LIMIT 2 [ RunTime:0.008829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17008827 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15210723 LIMIT 5 [ RunTime:0.021175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210723 ORDER BY `minOrder` ASC [ RunTime:0.010009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15210723 ORDER BY `unit` DESC [ RunTime:0.010944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15210723 LIMIT 2 [ RunTime:0.019818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15210723 ORDER BY `minOrder` ASC [ RunTime:0.005545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12537853 LIMIT 5 [ RunTime:0.020511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12537853 ORDER BY `minOrder` ASC [ RunTime:0.023519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12537853 ORDER BY `unit` DESC [ RunTime:0.008144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12537853 LIMIT 2 [ RunTime:0.015094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12537853 ORDER BY `minOrder` ASC [ RunTime:0.013006s ]
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 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013658s ]
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 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44009218 LIMIT 5 [ RunTime:0.013214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44009218 ORDER BY `minOrder` ASC [ RunTime:0.015922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44009218 ORDER BY `unit` DESC [ RunTime:0.024665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44009218 LIMIT 2 [ RunTime:0.024614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44009218 ORDER BY `minOrder` ASC [ RunTime:0.007307s ]
select * from pdf where partno='CT-2500CHR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.015159s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2500CHR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.025303s ]
SELECT `id` FROM `stock` WHERE `id` <> 44009218 AND `partno` = 'CT-2500CHR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.019942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17008470 [ RunTime:0.025925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44007299 LIMIT 5 [ RunTime:0.006027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44007299 ORDER BY `minOrder` ASC [ RunTime:0.021122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44007299 ORDER BY `unit` DESC [ RunTime:0.010264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44007299 LIMIT 2 [ RunTime:0.031660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44007299 ORDER BY `minOrder` ASC [ RunTime:0.007457s ]
select * from pdf where partno='CT-2500BC' and brandshort='Panduit Corp' limit 1 [ RunTime:0.008510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2500BC' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.015025s ]
SELECT `id` FROM `stock` WHERE `id` <> 44007299 AND `partno` = 'CT-2500BC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.025042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14179272 [ RunTime:0.006361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51679323 LIMIT 5 [ RunTime:0.001998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679323 ORDER BY `minOrder` ASC [ RunTime:0.014616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51679323 ORDER BY `unit` DESC [ RunTime:0.016572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51679323 LIMIT 2 [ RunTime:0.004861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679323 ORDER BY `minOrder` ASC [ RunTime:0.003370s ]
select * from pdf where partno='CT-2570CH' and brandshort='Panduit Corp' limit 1 [ RunTime:0.078431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2570CH' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.077710s ]
SELECT `id` FROM `stock` WHERE `id` <> 51679323 AND `partno` = 'CT-2570CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.025641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763285 [ RunTime:0.009545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51679302 LIMIT 5 [ RunTime:0.025670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679302 ORDER BY `minOrder` ASC [ RunTime:0.023442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51679302 ORDER BY `unit` DESC [ RunTime:0.007826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51679302 LIMIT 2 [ RunTime:0.009918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679302 ORDER BY `minOrder` ASC [ RunTime:0.010510s ]
select * from pdf where partno='CT-2523CH' and brandshort='Panduit Corp' limit 1 [ RunTime:0.055670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2523CH' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.008092s ]
SELECT `id` FROM `stock` WHERE `id` <> 51679302 AND `partno` = 'CT-2523CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.049469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17008825 [ RunTime:0.016824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51679300 LIMIT 5 [ RunTime:0.008924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679300 ORDER BY `minOrder` ASC [ RunTime:0.024991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51679300 ORDER BY `unit` DESC [ RunTime:0.004687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51679300 LIMIT 2 [ RunTime:0.011728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679300 ORDER BY `minOrder` ASC [ RunTime:0.003387s ]
select * from pdf where partno='CT-2504CH' and brandshort='Panduit Corp' limit 1 [ RunTime:0.019399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2504CH' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.025278s ]
SELECT `id` FROM `stock` WHERE `id` <> 51679300 AND `partno` = 'CT-2504CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.016433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18765490 [ RunTime:0.012417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44010173 LIMIT 5 [ RunTime:0.013426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010173 ORDER BY `minOrder` ASC [ RunTime:0.008307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44010173 ORDER BY `unit` DESC [ RunTime:0.002494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44010173 LIMIT 2 [ RunTime:0.005924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010173 ORDER BY `minOrder` ASC [ RunTime:0.006703s ]
select * from pdf where partno='CT-2500/LCHR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.029444s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2500/LCHR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.021127s ]
SELECT `id` FROM `stock` WHERE `id` <> 44010173 AND `partno` = 'CT-2500/LCHR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.015982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14176683 [ RunTime:0.010183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51679324 LIMIT 5 [ RunTime:0.010999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679324 ORDER BY `minOrder` ASC [ RunTime:0.012372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51679324 ORDER BY `unit` DESC [ RunTime:0.006221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51679324 LIMIT 2 [ RunTime:0.000549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679324 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
select * from pdf where partno='CT-2525CH' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2525CH' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.018003s ]
SELECT `id` FROM `stock` WHERE `id` <> 51679324 AND `partno` = 'CT-2525CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.013919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763284 [ RunTime:0.007386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51679319 LIMIT 5 [ RunTime:0.009230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679319 ORDER BY `minOrder` ASC [ RunTime:0.004988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51679319 ORDER BY `unit` DESC [ RunTime:0.007060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51679319 LIMIT 2 [ RunTime:0.007845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679319 ORDER BY `minOrder` ASC [ RunTime:0.001176s ]
select * from pdf where partno='CT-2550CH' and brandshort='Panduit Corp' limit 1 [ RunTime:0.005325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2550CH' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.001197s ]
SELECT `id` FROM `stock` WHERE `id` <> 51679319 AND `partno` = 'CT-2550CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.002830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18763277 [ RunTime:0.016876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51679309 LIMIT 5 [ RunTime:0.015080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679309 ORDER BY `minOrder` ASC [ RunTime:0.019103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51679309 ORDER BY `unit` DESC [ RunTime:0.024880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51679309 LIMIT 2 [ RunTime:0.012514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51679309 ORDER BY `minOrder` ASC [ RunTime:0.007092s ]
select * from pdf where partno='CT-2500CH' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2500CH' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.013310s ]
SELECT `id` FROM `stock` WHERE `id` <> 51679309 AND `partno` = 'CT-2500CH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.017552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17008827 [ RunTime:0.009729s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51662922 LIMIT 5 [ RunTime:0.005296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51662922 ORDER BY `minOrder` ASC [ RunTime:0.023658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51662922 ORDER BY `unit` DESC [ RunTime:0.015326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51662922 LIMIT 2 [ RunTime:0.016186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51662922 ORDER BY `minOrder` ASC [ RunTime:0.009146s ]
select * from pdf where partno='CT-2500/L' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2500/L' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.007008s ]
SELECT `id` FROM `stock` WHERE `id` <> 51662922 AND `partno` = 'CT-2500/L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.014565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15211101 [ RunTime:0.016621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32740444 LIMIT 5 [ RunTime:0.001545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32740444 ORDER BY `minOrder` ASC [ RunTime:0.023129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32740444 ORDER BY `unit` DESC [ RunTime:0.015736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32740444 LIMIT 2 [ RunTime:0.009346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32740444 ORDER BY `minOrder` ASC [ RunTime:0.008431s ]
select * from pdf where partno='CT-2500-DEMO' and brandshort='Panduit Corp' limit 1 [ RunTime:0.020146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CT-2500-DEMO' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.011542s ]
SELECT `id` FROM `stock` WHERE `id` <> 32740444 AND `partno` = 'CT-2500-DEMO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.011206s ]
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 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021009s ]
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 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043885s ]
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 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022405s ]
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 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043055s ]
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 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014812s ]
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 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014861s ]
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 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023426s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CT-25%' OR `brand` LIKE 'CT-25%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013358s ]