SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001595s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=C410C102K1R5TA&search=1' [ RunTime:0.008874s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002258s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.013739s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001665s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.020797s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001238s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000619s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001367s ]
SELECT * FROM `stock_search` WHERE `partno` = 'C410C102K1R5TA' LIMIT 1 [ RunTime:0.025108s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-09 20:28:44' WHERE `partno` = 'C410C102K1R5TA' [ RunTime:0.010772s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001690s ]
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 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046054s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.026528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14003837 LIMIT 5 [ RunTime:0.023772s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14003837 ORDER BY `minOrder` ASC [ RunTime:0.017823s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14003837 ORDER BY `unit` DESC [ RunTime:0.013305s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.032802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14003837 LIMIT 2 [ RunTime:0.038451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14003837 ORDER BY `minOrder` ASC [ RunTime:0.027409s ]
select * from pdf where partno='C410C102K1R5TA7200' and brandshort='KEMET' limit 1 [ RunTime:0.038845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14020040 LIMIT 5 [ RunTime:0.040131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14020040 ORDER BY `minOrder` ASC [ RunTime:0.022185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14020040 ORDER BY `unit` DESC [ RunTime:0.038392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14020040 LIMIT 2 [ RunTime:0.034487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14020040 ORDER BY `minOrder` ASC [ RunTime:0.085267s ]
select * from pdf where partno='C410C102K1R5TA' and brandshort='KEMET' limit 1 [ RunTime:0.053446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17728056 LIMIT 5 [ RunTime:0.045806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17728056 ORDER BY `minOrder` ASC [ RunTime:0.076149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17728056 ORDER BY `unit` DESC [ RunTime:0.056441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17728056 LIMIT 2 [ RunTime:0.042706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17728056 ORDER BY `minOrder` ASC [ RunTime:0.026752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17727353 LIMIT 5 [ RunTime:0.038980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17727353 ORDER BY `minOrder` ASC [ RunTime:0.012052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17727353 ORDER BY `unit` DESC [ RunTime:0.063276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17727353 LIMIT 2 [ RunTime:0.062717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17727353 ORDER BY `minOrder` ASC [ RunTime:0.016614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17727076 LIMIT 5 [ RunTime:0.027199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17727076 ORDER BY `minOrder` ASC [ RunTime:0.052886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17727076 ORDER BY `unit` DESC [ RunTime:0.030334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17727076 LIMIT 2 [ RunTime:0.021704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17727076 ORDER BY `minOrder` ASC [ RunTime:0.037537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15658393 LIMIT 5 [ RunTime:0.044640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15658393 ORDER BY `minOrder` ASC [ RunTime:0.020863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15658393 ORDER BY `unit` DESC [ RunTime:0.050755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15658393 LIMIT 2 [ RunTime:0.025013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15658393 ORDER BY `minOrder` ASC [ RunTime:0.008420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15658392 LIMIT 5 [ RunTime:0.013496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15658392 ORDER BY `minOrder` ASC [ RunTime:0.040911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15658392 ORDER BY `unit` DESC [ RunTime:0.031108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15658392 LIMIT 2 [ RunTime:0.035484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15658392 ORDER BY `minOrder` ASC [ RunTime:0.012409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15657007 LIMIT 5 [ RunTime:0.007841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15657007 ORDER BY `minOrder` ASC [ RunTime:0.022466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15657007 ORDER BY `unit` DESC [ RunTime:0.020464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15657007 LIMIT 2 [ RunTime:0.021902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15657007 ORDER BY `minOrder` ASC [ RunTime:0.014534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14017793 LIMIT 5 [ RunTime:0.018630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14017793 ORDER BY `minOrder` ASC [ RunTime:0.075834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14017793 ORDER BY `unit` DESC [ RunTime:0.045592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14017793 LIMIT 2 [ RunTime:0.004005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14017793 ORDER BY `minOrder` ASC [ RunTime:0.011649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14016427 LIMIT 5 [ RunTime:0.028141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14016427 ORDER BY `minOrder` ASC [ RunTime:0.020717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14016427 ORDER BY `unit` DESC [ RunTime:0.012691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14016427 LIMIT 2 [ RunTime:0.039920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14016427 ORDER BY `minOrder` ASC [ RunTime:0.010728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10104052 LIMIT 5 [ RunTime:0.034813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10104052 ORDER BY `minOrder` ASC [ RunTime:0.038747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10104052 ORDER BY `unit` DESC [ RunTime:0.031819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10104052 LIMIT 2 [ RunTime:0.029374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10104052 ORDER BY `minOrder` ASC [ RunTime:0.008310s ]
select * from pdf where partno='C410C102K1R5TA9170' and brandshort='KEMET' limit 1 [ RunTime:0.011948s ]
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 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034440s ]
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 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39468883 LIMIT 5 [ RunTime:0.045325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39468883 ORDER BY `minOrder` ASC [ RunTime:0.122532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39468883 ORDER BY `unit` DESC [ RunTime:0.072479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39468883 LIMIT 2 [ RunTime:0.058997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39468883 ORDER BY `minOrder` ASC [ RunTime:0.002749s ]
select * from pdf where partno='C410C102K1R5TA7200' and brandshort='KEMET' limit 1 [ RunTime:0.007787s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TA7200' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.036345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39743178 LIMIT 5 [ RunTime:0.070547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39743178 ORDER BY `minOrder` ASC [ RunTime:0.041083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39743178 ORDER BY `unit` DESC [ RunTime:0.037481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39743178 LIMIT 2 [ RunTime:0.034242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39743178 ORDER BY `minOrder` ASC [ RunTime:0.054845s ]
select * from pdf where partno='C410C102K1R5TA9170' and brandshort='KEMET' limit 1 [ RunTime:0.000672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TA9170' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.056423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39735912 LIMIT 5 [ RunTime:0.037546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39735912 ORDER BY `minOrder` ASC [ RunTime:0.029962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39735912 ORDER BY `unit` DESC [ RunTime:0.043791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39735912 LIMIT 2 [ RunTime:0.040736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39735912 ORDER BY `minOrder` ASC [ RunTime:0.077205s ]
select * from pdf where partno='C410C102K1R5TA7046' and brandshort='KEMET' limit 1 [ RunTime:0.020730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TA7046' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.038295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39735256 LIMIT 5 [ RunTime:0.082557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39735256 ORDER BY `minOrder` ASC [ RunTime:0.068518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39735256 ORDER BY `unit` DESC [ RunTime:0.111431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39735256 LIMIT 2 [ RunTime:0.042446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39735256 ORDER BY `minOrder` ASC [ RunTime:0.010752s ]
select * from pdf where partno='C410C102K1R5TA91707200' and brandshort='KEMET' limit 1 [ RunTime:0.029836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TA91707200' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.013447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39713248 LIMIT 5 [ RunTime:0.060623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39713248 ORDER BY `minOrder` ASC [ RunTime:0.026625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39713248 ORDER BY `unit` DESC [ RunTime:0.025185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39713248 LIMIT 2 [ RunTime:0.012964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39713248 ORDER BY `minOrder` ASC [ RunTime:0.010435s ]
select * from pdf where partno='C410C102K1R5TA7093' and brandshort='KEMET' limit 1 [ RunTime:0.016070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TA7093' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.075429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39705972 LIMIT 5 [ RunTime:0.022549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39705972 ORDER BY `minOrder` ASC [ RunTime:0.075068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39705972 ORDER BY `unit` DESC [ RunTime:0.047940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39705972 LIMIT 2 [ RunTime:0.040586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39705972 ORDER BY `minOrder` ASC [ RunTime:0.028740s ]
select * from pdf where partno='C410C102K1R5TA9270' and brandshort='KEMET' limit 1 [ RunTime:0.058468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TA9270' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.045198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39704860 LIMIT 5 [ RunTime:0.126772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39704860 ORDER BY `minOrder` ASC [ RunTime:0.127456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39704860 ORDER BY `unit` DESC [ RunTime:0.108372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39704860 LIMIT 2 [ RunTime:0.090272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39704860 ORDER BY `minOrder` ASC [ RunTime:0.094953s ]
select * from pdf where partno='C410C102K1R5TAAUTO' and brandshort='KEMET' limit 1 [ RunTime:0.073026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TAAUTO' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.068536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39704416 LIMIT 5 [ RunTime:0.074247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39704416 ORDER BY `minOrder` ASC [ RunTime:0.046811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39704416 ORDER BY `unit` DESC [ RunTime:0.054658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39704416 LIMIT 2 [ RunTime:0.026066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39704416 ORDER BY `minOrder` ASC [ RunTime:0.064418s ]
select * from pdf where partno='C410C102K1R5TA9077' and brandshort='KEMET' limit 1 [ RunTime:0.019904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TA9077' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.037528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39704415 LIMIT 5 [ RunTime:0.063641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39704415 ORDER BY `minOrder` ASC [ RunTime:0.095437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39704415 ORDER BY `unit` DESC [ RunTime:0.059861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39704415 LIMIT 2 [ RunTime:0.071475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39704415 ORDER BY `minOrder` ASC [ RunTime:0.032801s ]
select * from pdf where partno='C410C102K1R5TAED01' and brandshort='KEMET' limit 1 [ RunTime:0.031917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TAED01' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.059430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39704414 LIMIT 5 [ RunTime:0.046533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39704414 ORDER BY `minOrder` ASC [ RunTime:0.070835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39704414 ORDER BY `unit` DESC [ RunTime:0.032760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39704414 LIMIT 2 [ RunTime:0.035870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39704414 ORDER BY `minOrder` ASC [ RunTime:0.004911s ]
select * from pdf where partno='C410C102K1R5TA9003' and brandshort='KEMET' limit 1 [ RunTime:0.033507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TA9003' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.017137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39698755 LIMIT 5 [ RunTime:0.016853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39698755 ORDER BY `minOrder` ASC [ RunTime:0.047146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39698755 ORDER BY `unit` DESC [ RunTime:0.024594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39698755 LIMIT 2 [ RunTime:0.031527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39698755 ORDER BY `minOrder` ASC [ RunTime:0.043745s ]
select * from pdf where partno='C410C102K1R5TA92707200' and brandshort='KEMET' limit 1 [ RunTime:0.081293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TA92707200' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.067084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39543448 LIMIT 5 [ RunTime:0.057827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39543448 ORDER BY `minOrder` ASC [ RunTime:0.096319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39543448 ORDER BY `unit` DESC [ RunTime:0.033791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39543448 LIMIT 2 [ RunTime:0.061490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39543448 ORDER BY `minOrder` ASC [ RunTime:0.014751s ]
select * from pdf where partno='C410C102K1R5TA' and brandshort='KEMET' limit 1 [ RunTime:0.010488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C410C102K1R5TA' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.065830s ]
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 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028928s ]
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 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089696s ]
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 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060138s ]
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 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016945s ]
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 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019062s ]
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 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050751s ]
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 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031463s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'C410C102K1R5TA%' OR `brand` LIKE 'C410C102K1R5TA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.032331s ]