SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001586s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.227' , `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=XLC-25-H&search=1' [ RunTime:0.001710s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001294s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000515s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001785s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.227' ) [ RunTime:0.000327s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001868s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000306s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001681s ]
SELECT * FROM `stock_search` WHERE `partno` = 'XLC-25-H' LIMIT 1 [ RunTime:0.011238s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-27 10:10:48' WHERE `partno` = 'XLC-25-H' [ RunTime:0.007024s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001796s ]
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 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025572s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16804477 LIMIT 5 [ RunTime:0.018515s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16804477 ORDER BY `minOrder` ASC [ RunTime:0.003899s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16804477 ORDER BY `unit` DESC [ RunTime:0.013777s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16804477 LIMIT 2 [ RunTime:0.006051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16804477 ORDER BY `minOrder` ASC [ RunTime:0.007931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870142 LIMIT 5 [ RunTime:0.006799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870142 ORDER BY `minOrder` ASC [ RunTime:0.022212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17870142 ORDER BY `unit` DESC [ RunTime:0.012485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17870142 LIMIT 2 [ RunTime:0.008499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870142 ORDER BY `minOrder` ASC [ RunTime:0.008189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870134 LIMIT 5 [ RunTime:0.018160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870134 ORDER BY `minOrder` ASC [ RunTime:0.009396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17870134 ORDER BY `unit` DESC [ RunTime:0.024229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17870134 LIMIT 2 [ RunTime:0.008575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870134 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15012900 LIMIT 5 [ RunTime:0.014831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15012900 ORDER BY `minOrder` ASC [ RunTime:0.029186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15012900 ORDER BY `unit` DESC [ RunTime:0.016245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15012900 LIMIT 2 [ RunTime:0.008709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15012900 ORDER BY `minOrder` ASC [ RunTime:0.002157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14073327 LIMIT 5 [ RunTime:0.015992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14073327 ORDER BY `minOrder` ASC [ RunTime:0.005770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14073327 ORDER BY `unit` DESC [ RunTime:0.007711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14073327 LIMIT 2 [ RunTime:0.037245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14073327 ORDER BY `minOrder` ASC [ RunTime:0.013688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870149 LIMIT 5 [ RunTime:0.015111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870149 ORDER BY `minOrder` ASC [ RunTime:0.012920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17870149 ORDER BY `unit` DESC [ RunTime:0.034813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17870149 LIMIT 2 [ RunTime:0.010625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870149 ORDER BY `minOrder` ASC [ RunTime:0.004670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870139 LIMIT 5 [ RunTime:0.019119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870139 ORDER BY `minOrder` ASC [ RunTime:0.011439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17870139 ORDER BY `unit` DESC [ RunTime:0.015202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17870139 LIMIT 2 [ RunTime:0.025767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870139 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15720922 LIMIT 5 [ RunTime:0.017343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15720922 ORDER BY `minOrder` ASC [ RunTime:0.022937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15720922 ORDER BY `unit` DESC [ RunTime:0.012724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15720922 LIMIT 2 [ RunTime:0.020969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15720922 ORDER BY `minOrder` ASC [ RunTime:0.013255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870155 LIMIT 5 [ RunTime:0.004823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870155 ORDER BY `minOrder` ASC [ RunTime:0.014776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17870155 ORDER BY `unit` DESC [ RunTime:0.006886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17870155 LIMIT 2 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870155 ORDER BY `minOrder` ASC [ RunTime:0.006584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870164 LIMIT 5 [ RunTime:0.019799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870164 ORDER BY `minOrder` ASC [ RunTime:0.010751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17870164 ORDER BY `unit` DESC [ RunTime:0.014603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17870164 LIMIT 2 [ RunTime:0.010082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870164 ORDER BY `minOrder` ASC [ RunTime:0.001649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16804390 LIMIT 5 [ RunTime:0.013473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16804390 ORDER BY `minOrder` ASC [ RunTime:0.001570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16804390 ORDER BY `unit` DESC [ RunTime:0.009689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16804390 LIMIT 2 [ RunTime:0.012092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16804390 ORDER BY `minOrder` ASC [ RunTime:0.007945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870082 LIMIT 5 [ RunTime:0.004300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870082 ORDER BY `minOrder` ASC [ RunTime:0.007214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17870082 ORDER BY `unit` DESC [ RunTime:0.014628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17870082 LIMIT 2 [ RunTime:0.010879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870082 ORDER BY `minOrder` ASC [ RunTime:0.009547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15012895 LIMIT 5 [ RunTime:0.008642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15012895 ORDER BY `minOrder` ASC [ RunTime:0.022258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15012895 ORDER BY `unit` DESC [ RunTime:0.006415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15012895 LIMIT 2 [ RunTime:0.010214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15012895 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870810 LIMIT 5 [ RunTime:0.016841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870810 ORDER BY `minOrder` ASC [ RunTime:0.012246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17870810 ORDER BY `unit` DESC [ RunTime:0.008934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17870810 LIMIT 2 [ RunTime:0.023346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17870810 ORDER BY `minOrder` ASC [ RunTime:0.001343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15013034 LIMIT 5 [ RunTime:0.008027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15013034 ORDER BY `minOrder` ASC [ RunTime:0.008318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15013034 ORDER BY `unit` DESC [ RunTime:0.018292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15013034 LIMIT 2 [ RunTime:0.010090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15013034 ORDER BY `minOrder` ASC [ RunTime:0.012101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14073493 LIMIT 5 [ RunTime:0.020828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14073493 ORDER BY `minOrder` ASC [ RunTime:0.004280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14073493 ORDER BY `unit` DESC [ RunTime:0.018130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14073493 LIMIT 2 [ RunTime:0.011651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14073493 ORDER BY `minOrder` ASC [ RunTime:0.006327s ]
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 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013997s ]
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 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298141 LIMIT 5 [ RunTime:0.009683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298141 ORDER BY `minOrder` ASC [ RunTime:0.002557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298141 ORDER BY `unit` DESC [ RunTime:0.001371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298141 LIMIT 2 [ RunTime:0.009306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298141 ORDER BY `minOrder` ASC [ RunTime:0.014397s ]
select * from pdf where partno='XLC-25-H-DA2SN' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.016327s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-DA2SN' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.023440s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298141 AND `partno` = 'XLC-25-H-DA2SN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.013611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16804477 [ RunTime:0.019799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298579 LIMIT 5 [ RunTime:0.008568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298579 ORDER BY `minOrder` ASC [ RunTime:0.017689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298579 ORDER BY `unit` DESC [ RunTime:0.013087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298579 LIMIT 2 [ RunTime:0.017172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298579 ORDER BY `minOrder` ASC [ RunTime:0.004035s ]
select * from pdf where partno='XLC-25-H-S' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.005699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-S' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.026318s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298579 AND `partno` = 'XLC-25-H-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.022993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870134 [ RunTime:0.005744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298577 LIMIT 5 [ RunTime:0.018218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298577 ORDER BY `minOrder` ASC [ RunTime:0.006751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298577 ORDER BY `unit` DESC [ RunTime:0.004720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298577 LIMIT 2 [ RunTime:0.001767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298577 ORDER BY `minOrder` ASC [ RunTime:0.010141s ]
select * from pdf where partno='XLC-25-H-N' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.011269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-N' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.009797s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298577 AND `partno` = 'XLC-25-H-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.018734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870142 [ RunTime:0.013551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298576 LIMIT 5 [ RunTime:0.018870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298576 ORDER BY `minOrder` ASC [ RunTime:0.015357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298576 ORDER BY `unit` DESC [ RunTime:0.032265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298576 LIMIT 2 [ RunTime:0.025975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298576 ORDER BY `minOrder` ASC [ RunTime:0.009672s ]
select * from pdf where partno='XLC-25-H' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.022004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.012505s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298576 AND `partno` = 'XLC-25-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.018177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14073327 [ RunTime:0.025395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298116 LIMIT 5 [ RunTime:0.023950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298116 ORDER BY `minOrder` ASC [ RunTime:0.035435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298116 ORDER BY `unit` DESC [ RunTime:0.025162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298116 LIMIT 2 [ RunTime:0.027361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298116 ORDER BY `minOrder` ASC [ RunTime:0.017058s ]
select * from pdf where partno='XLC-25-H-BN' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.022516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-BN' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.018957s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298116 AND `partno` = 'XLC-25-H-BN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.011870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15012900 [ RunTime:0.008292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298117 LIMIT 5 [ RunTime:0.024950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298117 ORDER BY `minOrder` ASC [ RunTime:0.012209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298117 ORDER BY `unit` DESC [ RunTime:0.000874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298117 LIMIT 2 [ RunTime:0.017220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298117 ORDER BY `minOrder` ASC [ RunTime:0.010456s ]
select * from pdf where partno='XLC-25-H-B' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.066968s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-B' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.026128s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298117 AND `partno` = 'XLC-25-H-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.019408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870810 [ RunTime:0.034570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298083 LIMIT 5 [ RunTime:0.016045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298083 ORDER BY `minOrder` ASC [ RunTime:0.055599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298083 ORDER BY `unit` DESC [ RunTime:0.020327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298083 LIMIT 2 [ RunTime:0.025874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298083 ORDER BY `minOrder` ASC [ RunTime:0.033348s ]
select * from pdf where partno='XLC-25-H-SN' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.051969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-SN' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.014570s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298083 AND `partno` = 'XLC-25-H-SN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.029192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16804390 [ RunTime:0.037586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298137 LIMIT 5 [ RunTime:0.056281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298137 ORDER BY `minOrder` ASC [ RunTime:0.055891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298137 ORDER BY `unit` DESC [ RunTime:0.059470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298137 LIMIT 2 [ RunTime:0.044403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298137 ORDER BY `minOrder` ASC [ RunTime:0.019255s ]
select * from pdf where partno='XLC-25-H-DA2N' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.021713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-DA2N' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.057257s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298137 AND `partno` = 'XLC-25-H-DA2N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.040789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870149 [ RunTime:0.035303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298125 LIMIT 5 [ RunTime:0.020704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298125 ORDER BY `minOrder` ASC [ RunTime:0.025036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298125 ORDER BY `unit` DESC [ RunTime:0.023126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298125 LIMIT 2 [ RunTime:0.012002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298125 ORDER BY `minOrder` ASC [ RunTime:0.035934s ]
select * from pdf where partno='XLC-25-H-BSN' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.034580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-BSN' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.036167s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298125 AND `partno` = 'XLC-25-H-BSN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.023699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870155 [ RunTime:0.045602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298737 LIMIT 5 [ RunTime:0.016570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298737 ORDER BY `minOrder` ASC [ RunTime:0.039258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298737 ORDER BY `unit` DESC [ RunTime:0.027827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298737 LIMIT 2 [ RunTime:0.057738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298737 ORDER BY `minOrder` ASC [ RunTime:0.046232s ]
select * from pdf where partno='XLC-25-H-KNS' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.028545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-KNS' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.090873s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298737 AND `partno` = 'XLC-25-H-KNS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.090228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870082 [ RunTime:0.016389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298736 LIMIT 5 [ RunTime:0.018983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298736 ORDER BY `minOrder` ASC [ RunTime:0.031909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298736 ORDER BY `unit` DESC [ RunTime:0.080077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298736 LIMIT 2 [ RunTime:0.059190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298736 ORDER BY `minOrder` ASC [ RunTime:0.003497s ]
select * from pdf where partno='XLC-25-H-KN' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.019993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-KN' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.046672s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298736 AND `partno` = 'XLC-25-H-KN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.014725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15012895 [ RunTime:0.033684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51298126 LIMIT 5 [ RunTime:0.029671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298126 ORDER BY `minOrder` ASC [ RunTime:0.021912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51298126 ORDER BY `unit` DESC [ RunTime:0.022785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51298126 LIMIT 2 [ RunTime:0.043750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51298126 ORDER BY `minOrder` ASC [ RunTime:0.010383s ]
select * from pdf where partno='XLC-25-H-BS' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.057022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-BS' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.063489s ]
SELECT `id` FROM `stock` WHERE `id` <> 51298126 AND `partno` = 'XLC-25-H-BS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.043257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870139 [ RunTime:0.041642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51299251 LIMIT 5 [ RunTime:0.015171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51299251 ORDER BY `minOrder` ASC [ RunTime:0.001236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51299251 ORDER BY `unit` DESC [ RunTime:0.031122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51299251 LIMIT 2 [ RunTime:0.042236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51299251 ORDER BY `minOrder` ASC [ RunTime:0.022622s ]
select * from pdf where partno='XLC-25-H-DA2S' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.031704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-DA2S' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.009281s ]
SELECT `id` FROM `stock` WHERE `id` <> 51299251 AND `partno` = 'XLC-25-H-DA2S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.013955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17870164 [ RunTime:0.017569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51300190 LIMIT 5 [ RunTime:0.012884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51300190 ORDER BY `minOrder` ASC [ RunTime:0.042937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51300190 ORDER BY `unit` DESC [ RunTime:0.051392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51300190 LIMIT 2 [ RunTime:0.061736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51300190 ORDER BY `minOrder` ASC [ RunTime:0.015658s ]
select * from pdf where partno='XLC-25-H-MAS' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.023519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-MAS' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.020551s ]
SELECT `id` FROM `stock` WHERE `id` <> 51300190 AND `partno` = 'XLC-25-H-MAS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.063771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14073493 [ RunTime:0.033016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51300189 LIMIT 5 [ RunTime:0.051292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51300189 ORDER BY `minOrder` ASC [ RunTime:0.021905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51300189 ORDER BY `unit` DESC [ RunTime:0.021084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51300189 LIMIT 2 [ RunTime:0.034906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51300189 ORDER BY `minOrder` ASC [ RunTime:0.032799s ]
select * from pdf where partno='XLC-25-H-MA' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.022916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-MA' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.034475s ]
SELECT `id` FROM `stock` WHERE `id` <> 51300189 AND `partno` = 'XLC-25-H-MA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.043363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15013034 [ RunTime:0.022032s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51299249 LIMIT 5 [ RunTime:0.048249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51299249 ORDER BY `minOrder` ASC [ RunTime:0.054093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51299249 ORDER BY `unit` DESC [ RunTime:0.008092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51299249 LIMIT 2 [ RunTime:0.019530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51299249 ORDER BY `minOrder` ASC [ RunTime:0.016141s ]
select * from pdf where partno='XLC-25-H-DA2' and brandshort='MEAN WELL USA Inc.' limit 1 [ RunTime:0.036493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XLC-25-H-DA2' OR `brand` LIKE 'MEAN WELL USA Inc.%' ) ) LIMIT 1 [ RunTime:0.039554s ]
SELECT `id` FROM `stock` WHERE `id` <> 51299249 AND `partno` = 'XLC-25-H-DA2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mean well usa inc.%' ) [ RunTime:0.045030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15720922 [ RunTime:0.026700s ]
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 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052913s ]
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 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042500s ]
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 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040368s ]
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 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057550s ]
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 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011927s ]
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 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016562s ]
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 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022378s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'XLC-25-H%' OR `brand` LIKE 'XLC-25-H%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.028057s ]