SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001774s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.15' , `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=MDM100PCBS&search=1' [ RunTime:0.007584s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001772s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000672s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002017s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.15' ) [ RunTime:0.000882s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001434s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002794s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001876s ]
SELECT * FROM `stock_search` WHERE `partno` = 'MDM100PCBS' LIMIT 1 [ RunTime:0.015738s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-14 01:10:28' WHERE `partno` = 'MDM100PCBS' [ RunTime:0.006663s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001982s ]
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 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031404s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127880 LIMIT 5 [ RunTime:0.015085s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127880 ORDER BY `minOrder` ASC [ RunTime:0.013136s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127880 ORDER BY `unit` DESC [ RunTime:0.032057s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127880 LIMIT 2 [ RunTime:0.017492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127880 ORDER BY `minOrder` ASC [ RunTime:0.002938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127875 LIMIT 5 [ RunTime:0.012335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127875 ORDER BY `minOrder` ASC [ RunTime:0.011756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127875 ORDER BY `unit` DESC [ RunTime:0.009375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127875 LIMIT 2 [ RunTime:0.044023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127875 ORDER BY `minOrder` ASC [ RunTime:0.024738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127874 LIMIT 5 [ RunTime:0.027904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127874 ORDER BY `minOrder` ASC [ RunTime:0.041446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127874 ORDER BY `unit` DESC [ RunTime:0.057758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127874 LIMIT 2 [ RunTime:0.014422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127874 ORDER BY `minOrder` ASC [ RunTime:0.025700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127794 LIMIT 5 [ RunTime:0.023756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127794 ORDER BY `minOrder` ASC [ RunTime:0.046268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13127794 ORDER BY `unit` DESC [ RunTime:0.027196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13127794 LIMIT 2 [ RunTime:0.027436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13127794 ORDER BY `minOrder` ASC [ RunTime:0.037038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122547 LIMIT 5 [ RunTime:0.057800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122547 ORDER BY `minOrder` ASC [ RunTime:0.014999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13122547 ORDER BY `unit` DESC [ RunTime:0.022179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13122547 LIMIT 2 [ RunTime:0.013116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122547 ORDER BY `minOrder` ASC [ RunTime:0.024557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122546 LIMIT 5 [ RunTime:0.021080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122546 ORDER BY `minOrder` ASC [ RunTime:0.057347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13122546 ORDER BY `unit` DESC [ RunTime:0.017644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13122546 LIMIT 2 [ RunTime:0.005980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122546 ORDER BY `minOrder` ASC [ RunTime:0.019160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122545 LIMIT 5 [ RunTime:0.013762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122545 ORDER BY `minOrder` ASC [ RunTime:0.023736s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13122545 ORDER BY `unit` DESC [ RunTime:0.015103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13122545 LIMIT 2 [ RunTime:0.011063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122545 ORDER BY `minOrder` ASC [ RunTime:0.011971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122540 LIMIT 5 [ RunTime:0.019793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122540 ORDER BY `minOrder` ASC [ RunTime:0.014299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13122540 ORDER BY `unit` DESC [ RunTime:0.015761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13122540 LIMIT 2 [ RunTime:0.017360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122540 ORDER BY `minOrder` ASC [ RunTime:0.019120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122539 LIMIT 5 [ RunTime:0.012140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122539 ORDER BY `minOrder` ASC [ RunTime:0.010366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13122539 ORDER BY `unit` DESC [ RunTime:0.005897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13122539 LIMIT 2 [ RunTime:0.010263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122539 ORDER BY `minOrder` ASC [ RunTime:0.004112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122538 LIMIT 5 [ RunTime:0.020548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122538 ORDER BY `minOrder` ASC [ RunTime:0.015143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13122538 ORDER BY `unit` DESC [ RunTime:0.001288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13122538 LIMIT 2 [ RunTime:0.001204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13122538 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11871207 LIMIT 5 [ RunTime:0.012001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11871207 ORDER BY `minOrder` ASC [ RunTime:0.007763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11871207 ORDER BY `unit` DESC [ RunTime:0.005589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11871207 LIMIT 2 [ RunTime:0.004800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11871207 ORDER BY `minOrder` ASC [ RunTime:0.004745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11871146 LIMIT 5 [ RunTime:0.001271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11871146 ORDER BY `minOrder` ASC [ RunTime:0.003776s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11871146 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11871146 LIMIT 2 [ RunTime:0.004626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11871146 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11871144 LIMIT 5 [ RunTime:0.000817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11871144 ORDER BY `minOrder` ASC [ RunTime:0.009835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11871144 ORDER BY `unit` DESC [ RunTime:0.000573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11871144 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11871144 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11871143 LIMIT 5 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11871143 ORDER BY `minOrder` ASC [ RunTime:0.006714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11871143 ORDER BY `unit` DESC [ RunTime:0.006126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11871143 LIMIT 2 [ RunTime:0.011554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11871143 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11867115 LIMIT 5 [ RunTime:0.006368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11867115 ORDER BY `minOrder` ASC [ RunTime:0.007741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11867115 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11867115 LIMIT 2 [ RunTime:0.004276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11867115 ORDER BY `minOrder` ASC [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11867111 LIMIT 5 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11867111 ORDER BY `minOrder` ASC [ RunTime:0.007757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11867111 ORDER BY `unit` DESC [ RunTime:0.000470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11867111 LIMIT 2 [ RunTime:0.001829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11867111 ORDER BY `minOrder` ASC [ RunTime:0.002917s ]
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 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001109s ]
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 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61938871 LIMIT 5 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938871 ORDER BY `minOrder` ASC [ RunTime:0.001851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61938871 ORDER BY `unit` DESC [ RunTime:0.001966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61938871 LIMIT 2 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938871 ORDER BY `minOrder` ASC [ RunTime:0.001113s ]
select * from pdf where partno='MDM100PCBSPL67' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.019850s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSPL67' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.012245s ]
SELECT `id` FROM `stock` WHERE `id` <> 61938871 AND `partno` = 'MDM100PCBSPL67' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.001006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122547 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61938870 LIMIT 5 [ RunTime:0.006254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938870 ORDER BY `minOrder` ASC [ RunTime:0.007791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61938870 ORDER BY `unit` DESC [ RunTime:0.015606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61938870 LIMIT 2 [ RunTime:0.010505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938870 ORDER BY `minOrder` ASC [ RunTime:0.004225s ]
select * from pdf where partno='MDM100PCBSPTL67' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.009116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSPTL67' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.013810s ]
SELECT `id` FROM `stock` WHERE `id` <> 61938870 AND `partno` = 'MDM100PCBSPTL67' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.008027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122546 [ RunTime:0.005561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61938869 LIMIT 5 [ RunTime:0.009239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938869 ORDER BY `minOrder` ASC [ RunTime:0.021422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61938869 ORDER BY `unit` DESC [ RunTime:0.000983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61938869 LIMIT 2 [ RunTime:0.019257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938869 ORDER BY `minOrder` ASC [ RunTime:0.008387s ]
select * from pdf where partno='MDM100PCBSTL67' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.010425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSTL67' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.013022s ]
SELECT `id` FROM `stock` WHERE `id` <> 61938869 AND `partno` = 'MDM100PCBSTL67' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.008188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122545 [ RunTime:0.007339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61938868 LIMIT 5 [ RunTime:0.004151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938868 ORDER BY `minOrder` ASC [ RunTime:0.015270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61938868 ORDER BY `unit` DESC [ RunTime:0.011699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61938868 LIMIT 2 [ RunTime:0.012495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938868 ORDER BY `minOrder` ASC [ RunTime:0.008489s ]
select * from pdf where partno='MDM100PCBSL67' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.009657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSL67' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.017669s ]
SELECT `id` FROM `stock` WHERE `id` <> 61938868 AND `partno` = 'MDM100PCBSL67' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.011641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11867115 [ RunTime:0.017421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61938863 LIMIT 5 [ RunTime:0.006552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938863 ORDER BY `minOrder` ASC [ RunTime:0.011221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61938863 ORDER BY `unit` DESC [ RunTime:0.011494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61938863 LIMIT 2 [ RunTime:0.014521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938863 ORDER BY `minOrder` ASC [ RunTime:0.007803s ]
select * from pdf where partno='MDM100PCBSPT' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.003593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSPT' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.004786s ]
SELECT `id` FROM `stock` WHERE `id` <> 61938863 AND `partno` = 'MDM100PCBSPT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.013959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122540 [ RunTime:0.007548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61938862 LIMIT 5 [ RunTime:0.002237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938862 ORDER BY `minOrder` ASC [ RunTime:0.006020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61938862 ORDER BY `unit` DESC [ RunTime:0.011734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61938862 LIMIT 2 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938862 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='MDM100PCBSP' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.002715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSP' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.012945s ]
SELECT `id` FROM `stock` WHERE `id` <> 61938862 AND `partno` = 'MDM100PCBSP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.026799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122539 [ RunTime:0.015620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61938860 LIMIT 5 [ RunTime:0.002224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938860 ORDER BY `minOrder` ASC [ RunTime:0.002627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61938860 ORDER BY `unit` DESC [ RunTime:0.010758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61938860 LIMIT 2 [ RunTime:0.013221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938860 ORDER BY `minOrder` ASC [ RunTime:0.002114s ]
select * from pdf where partno='MDM100PCBST' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.005861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBST' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.006438s ]
SELECT `id` FROM `stock` WHERE `id` <> 61938860 AND `partno` = 'MDM100PCBST' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.003079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13122538 [ RunTime:0.007089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61938861 LIMIT 5 [ RunTime:0.008052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938861 ORDER BY `minOrder` ASC [ RunTime:0.006023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61938861 ORDER BY `unit` DESC [ RunTime:0.006670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61938861 LIMIT 2 [ RunTime:0.016448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938861 ORDER BY `minOrder` ASC [ RunTime:0.004852s ]
select * from pdf where partno='MDM100PCBS' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.003703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBS' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.023261s ]
SELECT `id` FROM `stock` WHERE `id` <> 61938861 AND `partno` = 'MDM100PCBS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.007593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11867111 [ RunTime:0.009623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61943721 LIMIT 5 [ RunTime:0.017424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943721 ORDER BY `minOrder` ASC [ RunTime:0.007426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61943721 ORDER BY `unit` DESC [ RunTime:0.009403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61943721 LIMIT 2 [ RunTime:0.005709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943721 ORDER BY `minOrder` ASC [ RunTime:0.002201s ]
select * from pdf where partno='MDM100PCBSTL67A174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.019634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSTL67A174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.012090s ]
SELECT `id` FROM `stock` WHERE `id` <> 61943721 AND `partno` = 'MDM100PCBSTL67A174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.033698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127874 [ RunTime:0.025661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61943667 LIMIT 5 [ RunTime:0.014137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943667 ORDER BY `minOrder` ASC [ RunTime:0.008330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61943667 ORDER BY `unit` DESC [ RunTime:0.007263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61943667 LIMIT 2 [ RunTime:0.017697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943667 ORDER BY `minOrder` ASC [ RunTime:0.005834s ]
select * from pdf where partno='MDM100PCBSPTL67A174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.022364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSPTL67A174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.013811s ]
SELECT `id` FROM `stock` WHERE `id` <> 61943667 AND `partno` = 'MDM100PCBSPTL67A174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.016779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11871207 [ RunTime:0.014284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61943666 LIMIT 5 [ RunTime:0.008788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943666 ORDER BY `minOrder` ASC [ RunTime:0.006821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61943666 ORDER BY `unit` DESC [ RunTime:0.016870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61943666 LIMIT 2 [ RunTime:0.014321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943666 ORDER BY `minOrder` ASC [ RunTime:0.004257s ]
select * from pdf where partno='MDM100PCBSPL67A174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.014828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSPL67A174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.009278s ]
SELECT `id` FROM `stock` WHERE `id` <> 61943666 AND `partno` = 'MDM100PCBSPL67A174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.026199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127880 [ RunTime:0.009682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61943664 LIMIT 5 [ RunTime:0.016100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943664 ORDER BY `minOrder` ASC [ RunTime:0.029080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61943664 ORDER BY `unit` DESC [ RunTime:0.026853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61943664 LIMIT 2 [ RunTime:0.034019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943664 ORDER BY `minOrder` ASC [ RunTime:0.005146s ]
select * from pdf where partno='MDM100PCBSL67A174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.009743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSL67A174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.018044s ]
SELECT `id` FROM `stock` WHERE `id` <> 61943664 AND `partno` = 'MDM100PCBSL67A174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.014481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127875 [ RunTime:0.017686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61943607 LIMIT 5 [ RunTime:0.015206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943607 ORDER BY `minOrder` ASC [ RunTime:0.010665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61943607 ORDER BY `unit` DESC [ RunTime:0.021687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61943607 LIMIT 2 [ RunTime:0.020767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943607 ORDER BY `minOrder` ASC [ RunTime:0.008105s ]
select * from pdf where partno='MDM100PCBSPA174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.013795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSPA174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.007662s ]
SELECT `id` FROM `stock` WHERE `id` <> 61943607 AND `partno` = 'MDM100PCBSPA174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.005579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13127794 [ RunTime:0.004005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61943606 LIMIT 5 [ RunTime:0.033545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943606 ORDER BY `minOrder` ASC [ RunTime:0.047087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61943606 ORDER BY `unit` DESC [ RunTime:0.019559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61943606 LIMIT 2 [ RunTime:0.027392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943606 ORDER BY `minOrder` ASC [ RunTime:0.008965s ]
select * from pdf where partno='MDM100PCBSPTA174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.008181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSPTA174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.025453s ]
SELECT `id` FROM `stock` WHERE `id` <> 61943606 AND `partno` = 'MDM100PCBSPTA174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.014283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11871146 [ RunTime:0.009116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61943603 LIMIT 5 [ RunTime:0.032582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943603 ORDER BY `minOrder` ASC [ RunTime:0.019750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61943603 ORDER BY `unit` DESC [ RunTime:0.028038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61943603 LIMIT 2 [ RunTime:0.003800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943603 ORDER BY `minOrder` ASC [ RunTime:0.005286s ]
select * from pdf where partno='MDM100PCBSA174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.012077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSA174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.015613s ]
SELECT `id` FROM `stock` WHERE `id` <> 61943603 AND `partno` = 'MDM100PCBSA174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.024988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11871144 [ RunTime:0.024095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61943602 LIMIT 5 [ RunTime:0.024989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943602 ORDER BY `minOrder` ASC [ RunTime:0.029254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61943602 ORDER BY `unit` DESC [ RunTime:0.007766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61943602 LIMIT 2 [ RunTime:0.027191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61943602 ORDER BY `minOrder` ASC [ RunTime:0.014522s ]
select * from pdf where partno='MDM100PCBSTA174' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.032669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MDM100PCBSTA174' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.017273s ]
SELECT `id` FROM `stock` WHERE `id` <> 61943602 AND `partno` = 'MDM100PCBSTA174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.016056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11871143 [ RunTime:0.051896s ]
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 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028877s ]
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 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044029s ]
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 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031183s ]
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 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019549s ]
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 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029006s ]
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 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039814s ]
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 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068887s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MDM100PCBS%' OR `brand` LIKE 'MDM100PCBS%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.028091s ]