SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002811s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=592212&search=1' [ RunTime:0.006112s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003119s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000701s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001986s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.003260s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002260s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002241s ]
SELECT * FROM `stock_search` WHERE `partno` = '592212' LIMIT 1 [ RunTime:0.004600s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 15:38:11' WHERE `partno` = '592212' [ RunTime:0.004361s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002788s ]
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 '592212%' OR `brand` LIKE '592212%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007755s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18963829 LIMIT 5 [ RunTime:0.064764s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963829 ORDER BY `minOrder` ASC [ RunTime:0.005646s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18963829 ORDER BY `unit` DESC [ RunTime:0.005846s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.031115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18963829 LIMIT 2 [ RunTime:0.057416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18963829 ORDER BY `minOrder` ASC [ RunTime:0.077528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908649 LIMIT 5 [ RunTime:0.037359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908649 ORDER BY `minOrder` ASC [ RunTime:0.010752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18908649 ORDER BY `unit` DESC [ RunTime:0.026707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18908649 LIMIT 2 [ RunTime:0.034618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908649 ORDER BY `minOrder` ASC [ RunTime:0.044056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908648 LIMIT 5 [ RunTime:0.015212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908648 ORDER BY `minOrder` ASC [ RunTime:0.083562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18908648 ORDER BY `unit` DESC [ RunTime:0.037551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18908648 LIMIT 2 [ RunTime:0.091258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908648 ORDER BY `minOrder` ASC [ RunTime:0.026973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907479 LIMIT 5 [ RunTime:0.007557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907479 ORDER BY `minOrder` ASC [ RunTime:0.047927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907479 ORDER BY `unit` DESC [ RunTime:0.031874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907479 LIMIT 2 [ RunTime:0.057143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907479 ORDER BY `minOrder` ASC [ RunTime:0.114976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907040 LIMIT 5 [ RunTime:0.038962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907040 ORDER BY `minOrder` ASC [ RunTime:0.033705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907040 ORDER BY `unit` DESC [ RunTime:0.023499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907040 LIMIT 2 [ RunTime:0.010808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907040 ORDER BY `minOrder` ASC [ RunTime:0.024238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906874 LIMIT 5 [ RunTime:0.038633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906874 ORDER BY `minOrder` ASC [ RunTime:0.014958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906874 ORDER BY `unit` DESC [ RunTime:0.059478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906874 LIMIT 2 [ RunTime:0.066231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906874 ORDER BY `minOrder` ASC [ RunTime:0.095263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906746 LIMIT 5 [ RunTime:0.038686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906746 ORDER BY `minOrder` ASC [ RunTime:0.016066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906746 ORDER BY `unit` DESC [ RunTime:0.008900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906746 LIMIT 2 [ RunTime:0.009573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906746 ORDER BY `minOrder` ASC [ RunTime:0.009548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906744 LIMIT 5 [ RunTime:0.013047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906744 ORDER BY `minOrder` ASC [ RunTime:0.019012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906744 ORDER BY `unit` DESC [ RunTime:0.001396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906744 LIMIT 2 [ RunTime:0.001003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906744 ORDER BY `minOrder` ASC [ RunTime:0.001705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906528 LIMIT 5 [ RunTime:0.013784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906528 ORDER BY `minOrder` ASC [ RunTime:0.010075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906528 ORDER BY `unit` DESC [ RunTime:0.009001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906528 LIMIT 2 [ RunTime:0.008464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906528 ORDER BY `minOrder` ASC [ RunTime:0.032107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906343 LIMIT 5 [ RunTime:0.013908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906343 ORDER BY `minOrder` ASC [ RunTime:0.018551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906343 ORDER BY `unit` DESC [ RunTime:0.030931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906343 LIMIT 2 [ RunTime:0.035487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906343 ORDER BY `minOrder` ASC [ RunTime:0.016310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906240 LIMIT 5 [ RunTime:0.016300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906240 ORDER BY `minOrder` ASC [ RunTime:0.002347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906240 ORDER BY `unit` DESC [ RunTime:0.013433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906240 LIMIT 2 [ RunTime:0.010774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906240 ORDER BY `minOrder` ASC [ RunTime:0.007409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906237 LIMIT 5 [ RunTime:0.014933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906237 ORDER BY `minOrder` ASC [ RunTime:0.005369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906237 ORDER BY `unit` DESC [ RunTime:0.013076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906237 LIMIT 2 [ RunTime:0.013044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906237 ORDER BY `minOrder` ASC [ RunTime:0.015270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906105 LIMIT 5 [ RunTime:0.010470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906105 ORDER BY `minOrder` ASC [ RunTime:0.012436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906105 ORDER BY `unit` DESC [ RunTime:0.010908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906105 LIMIT 2 [ RunTime:0.019720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906105 ORDER BY `minOrder` ASC [ RunTime:0.003909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712013 LIMIT 5 [ RunTime:0.019835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712013 ORDER BY `minOrder` ASC [ RunTime:0.004213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712013 ORDER BY `unit` DESC [ RunTime:0.003130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712013 LIMIT 2 [ RunTime:0.015919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712013 ORDER BY `minOrder` ASC [ RunTime:0.006063s ]
select * from pdf where partno='592212' and brandshort='3M' limit 1 [ RunTime:0.011650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034231 LIMIT 5 [ RunTime:0.018513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034231 ORDER BY `minOrder` ASC [ RunTime:0.005681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17034231 ORDER BY `unit` DESC [ RunTime:0.011276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17034231 LIMIT 2 [ RunTime:0.009724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034231 ORDER BY `minOrder` ASC [ RunTime:0.008246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16014998 LIMIT 5 [ RunTime:0.009382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16014998 ORDER BY `minOrder` ASC [ RunTime:0.012936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16014998 ORDER BY `unit` DESC [ RunTime:0.004386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16014998 LIMIT 2 [ RunTime:0.003065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16014998 ORDER BY `minOrder` ASC [ RunTime:0.009094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250112 LIMIT 5 [ RunTime:0.015525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250112 ORDER BY `minOrder` ASC [ RunTime:0.013527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15250112 ORDER BY `unit` DESC [ RunTime:0.004224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15250112 LIMIT 2 [ RunTime:0.004974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15250112 ORDER BY `minOrder` ASC [ RunTime:0.003434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14191880 LIMIT 5 [ RunTime:0.032245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14191880 ORDER BY `minOrder` ASC [ RunTime:0.024077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14191880 ORDER BY `unit` DESC [ RunTime:0.026929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14191880 LIMIT 2 [ RunTime:0.019735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14191880 ORDER BY `minOrder` ASC [ RunTime:0.031180s ]
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 '592212%' OR `brand` LIKE '592212%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004903s ]
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 '592212%' OR `brand` LIKE '592212%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246782 LIMIT 5 [ RunTime:0.007792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246782 ORDER BY `minOrder` ASC [ RunTime:0.005462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246782 ORDER BY `unit` DESC [ RunTime:0.015440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246782 LIMIT 2 [ RunTime:0.020386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246782 ORDER BY `minOrder` ASC [ RunTime:0.019858s ]
select * from pdf where partno='5922126302NF' and brandshort='Dialight' limit 1 [ RunTime:0.003129s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922126302NF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.022501s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246782 AND `partno` = '5922126302NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.055474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907479 [ RunTime:0.007926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246316 LIMIT 5 [ RunTime:0.025522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246316 ORDER BY `minOrder` ASC [ RunTime:0.042047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246316 ORDER BY `unit` DESC [ RunTime:0.021549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246316 LIMIT 2 [ RunTime:0.045310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246316 ORDER BY `minOrder` ASC [ RunTime:0.010981s ]
select * from pdf where partno='5922121302NF' and brandshort='Dialight' limit 1 [ RunTime:0.039059s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922121302NF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.025968s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246316 AND `partno` = '5922121302NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.028278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907040 [ RunTime:0.020470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246315 LIMIT 5 [ RunTime:0.073659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246315 ORDER BY `minOrder` ASC [ RunTime:0.031554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246315 ORDER BY `unit` DESC [ RunTime:0.092313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246315 LIMIT 2 [ RunTime:0.029736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246315 ORDER BY `minOrder` ASC [ RunTime:0.040044s ]
select * from pdf where partno='5922124302NF' and brandshort='Dialight' limit 1 [ RunTime:0.041111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922124302NF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.083740s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246315 AND `partno` = '5922124302NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.011074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16014998 [ RunTime:0.012604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246105 LIMIT 5 [ RunTime:0.012584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246105 ORDER BY `minOrder` ASC [ RunTime:0.027639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246105 ORDER BY `unit` DESC [ RunTime:0.030997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246105 LIMIT 2 [ RunTime:0.057549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246105 ORDER BY `minOrder` ASC [ RunTime:0.011002s ]
select * from pdf where partno='5922126302F' and brandshort='Dialight' limit 1 [ RunTime:0.031912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922126302F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.019122s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246105 AND `partno` = '5922126302F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.015208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906874 [ RunTime:0.012151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245948 LIMIT 5 [ RunTime:0.009895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245948 ORDER BY `minOrder` ASC [ RunTime:0.023960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245948 ORDER BY `unit` DESC [ RunTime:0.052614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245948 LIMIT 2 [ RunTime:0.040341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245948 ORDER BY `minOrder` ASC [ RunTime:0.108317s ]
select * from pdf where partno='5922126313F' and brandshort='Dialight' limit 1 [ RunTime:0.023674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922126313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.184294s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245948 AND `partno` = '5922126313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.046623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906744 [ RunTime:0.044382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245947 LIMIT 5 [ RunTime:0.046129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245947 ORDER BY `minOrder` ASC [ RunTime:0.071768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245947 ORDER BY `unit` DESC [ RunTime:0.012913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245947 LIMIT 2 [ RunTime:0.050588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245947 ORDER BY `minOrder` ASC [ RunTime:0.022776s ]
select * from pdf where partno='5922126313NF' and brandshort='Dialight' limit 1 [ RunTime:0.115367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922126313NF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.018613s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245947 AND `partno` = '5922126313NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.028489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906746 [ RunTime:0.022617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245699 LIMIT 5 [ RunTime:0.026294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245699 ORDER BY `minOrder` ASC [ RunTime:0.053270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245699 ORDER BY `unit` DESC [ RunTime:0.013115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245699 LIMIT 2 [ RunTime:0.017149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245699 ORDER BY `minOrder` ASC [ RunTime:0.010978s ]
select * from pdf where partno='5922121313NF' and brandshort='Dialight' limit 1 [ RunTime:0.055826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922121313NF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.041727s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245699 AND `partno` = '5922121313NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.067831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034231 [ RunTime:0.032466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245674 LIMIT 5 [ RunTime:0.015722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245674 ORDER BY `minOrder` ASC [ RunTime:0.016265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245674 ORDER BY `unit` DESC [ RunTime:0.027480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245674 LIMIT 2 [ RunTime:0.001458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245674 ORDER BY `minOrder` ASC [ RunTime:0.007894s ]
select * from pdf where partno='5922124013F' and brandshort='Dialight' limit 1 [ RunTime:0.028285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922124013F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.047102s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245674 AND `partno` = '5922124013F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.026033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906528 [ RunTime:0.053846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245667 LIMIT 5 [ RunTime:0.019043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245667 ORDER BY `minOrder` ASC [ RunTime:0.009381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245667 ORDER BY `unit` DESC [ RunTime:0.018787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245667 LIMIT 2 [ RunTime:0.012860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245667 ORDER BY `minOrder` ASC [ RunTime:0.009448s ]
select * from pdf where partno='5922124313NF' and brandshort='Dialight' limit 1 [ RunTime:0.055027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922124313NF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.052825s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245667 AND `partno` = '5922124313NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.011749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14191880 [ RunTime:0.041416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245518 LIMIT 5 [ RunTime:0.086644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245518 ORDER BY `minOrder` ASC [ RunTime:0.013202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245518 ORDER BY `unit` DESC [ RunTime:0.009910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245518 LIMIT 2 [ RunTime:0.040032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245518 ORDER BY `minOrder` ASC [ RunTime:0.010053s ]
select * from pdf where partno='5922122313NF' and brandshort='Dialight' limit 1 [ RunTime:0.037082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922122313NF' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.027940s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245518 AND `partno` = '5922122313NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.009783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906343 [ RunTime:0.029642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245399 LIMIT 5 [ RunTime:0.056958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245399 ORDER BY `minOrder` ASC [ RunTime:0.025609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245399 ORDER BY `unit` DESC [ RunTime:0.102729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245399 LIMIT 2 [ RunTime:0.107350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245399 ORDER BY `minOrder` ASC [ RunTime:0.040571s ]
select * from pdf where partno='5922122313F' and brandshort='Dialight' limit 1 [ RunTime:0.054460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922122313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.023681s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245399 AND `partno` = '5922122313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.049310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906240 [ RunTime:0.060699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245393 LIMIT 5 [ RunTime:0.024023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245393 ORDER BY `minOrder` ASC [ RunTime:0.030158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245393 ORDER BY `unit` DESC [ RunTime:0.050600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245393 LIMIT 2 [ RunTime:0.027068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245393 ORDER BY `minOrder` ASC [ RunTime:0.025488s ]
select * from pdf where partno='5922124313F' and brandshort='Dialight' limit 1 [ RunTime:0.030421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922124313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.008681s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245393 AND `partno` = '5922124313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.051837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906237 [ RunTime:0.030095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245220 LIMIT 5 [ RunTime:0.060345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245220 ORDER BY `minOrder` ASC [ RunTime:0.026273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245220 ORDER BY `unit` DESC [ RunTime:0.037788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245220 LIMIT 2 [ RunTime:0.018068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245220 ORDER BY `minOrder` ASC [ RunTime:0.023469s ]
select * from pdf where partno='5922121313F' and brandshort='Dialight' limit 1 [ RunTime:0.022007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922121313F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.015187s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245220 AND `partno` = '5922121313F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.015623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906105 [ RunTime:0.001569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50615152 LIMIT 5 [ RunTime:0.001307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50615152 ORDER BY `minOrder` ASC [ RunTime:0.004533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50615152 ORDER BY `unit` DESC [ RunTime:0.010297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50615152 LIMIT 2 [ RunTime:0.009954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50615152 ORDER BY `minOrder` ASC [ RunTime:0.010119s ]
select * from pdf where partno='592212' and brandshort='3M' limit 1 [ RunTime:0.001428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '592212' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.012735s ]
SELECT `id` FROM `stock` WHERE `id` <> 50615152 AND `partno` = '592212' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.018007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712013 [ RunTime:0.027416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41355753 LIMIT 5 [ RunTime:0.018035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41355753 ORDER BY `minOrder` ASC [ RunTime:0.054950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41355753 ORDER BY `unit` DESC [ RunTime:0.007899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41355753 LIMIT 2 [ RunTime:0.030234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41355753 ORDER BY `minOrder` ASC [ RunTime:0.022834s ]
select * from pdf where partno='5922126413F' and brandshort='Dialight' limit 1 [ RunTime:0.033511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5922126413F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.038899s ]
SELECT `id` FROM `stock` WHERE `id` <> 41355753 AND `partno` = '5922126413F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.018772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18963829 [ RunTime:0.036148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37942356 LIMIT 5 [ RunTime:0.044305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37942356 ORDER BY `minOrder` ASC [ RunTime:0.028072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37942356 ORDER BY `unit` DESC [ RunTime:0.044451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37942356 LIMIT 2 [ RunTime:0.025361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37942356 ORDER BY `minOrder` ASC [ RunTime:0.023171s ]
select * from pdf where partno='592212' and brandshort='3M' limit 1 [ RunTime:0.005114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '592212' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.002252s ]
SELECT `id` FROM `stock` WHERE `id` <> 37942356 AND `partno` = '592212' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.006051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712013 [ RunTime:0.006584s ]
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 '592212%' OR `brand` LIKE '592212%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026367s ]
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 '592212%' OR `brand` LIKE '592212%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012891s ]
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 '592212%' OR `brand` LIKE '592212%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005697s ]
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 '592212%' OR `brand` LIKE '592212%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026623s ]
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 '592212%' OR `brand` LIKE '592212%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033925s ]
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 '592212%' OR `brand` LIKE '592212%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018015s ]
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 '592212%' OR `brand` LIKE '592212%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013141s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '592212%' OR `brand` LIKE '592212%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011355s ]