SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001251s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=T491D336M010AT&search=1' [ RunTime:0.004727s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001841s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000639s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001717s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.001502s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001173s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010425s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001327s ]
SELECT * FROM `stock_search` WHERE `partno` = 'T491D336M010AT' LIMIT 1 [ RunTime:0.007418s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-21 01:11:53' WHERE `partno` = 'T491D336M010AT' [ RunTime:0.023141s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001415s ]
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 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044490s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.024138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17634074 LIMIT 5 [ RunTime:0.035247s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17634074 ORDER BY `minOrder` ASC [ RunTime:0.029240s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17634074 ORDER BY `unit` DESC [ RunTime:0.042134s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17634074 LIMIT 2 [ RunTime:0.026660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17634074 ORDER BY `minOrder` ASC [ RunTime:0.006865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17628439 LIMIT 5 [ RunTime:0.094740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17628439 ORDER BY `minOrder` ASC [ RunTime:0.058275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17628439 ORDER BY `unit` DESC [ RunTime:0.018450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17628439 LIMIT 2 [ RunTime:0.049724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17628439 ORDER BY `minOrder` ASC [ RunTime:0.063193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17626096 LIMIT 5 [ RunTime:0.071899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17626096 ORDER BY `minOrder` ASC [ RunTime:0.078869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17626096 ORDER BY `unit` DESC [ RunTime:0.062701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17626096 LIMIT 2 [ RunTime:0.058341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17626096 ORDER BY `minOrder` ASC [ RunTime:0.033678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17626058 LIMIT 5 [ RunTime:0.036421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17626058 ORDER BY `minOrder` ASC [ RunTime:0.042602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17626058 ORDER BY `unit` DESC [ RunTime:0.022298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17626058 LIMIT 2 [ RunTime:0.027815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17626058 ORDER BY `minOrder` ASC [ RunTime:0.016221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16744180 LIMIT 5 [ RunTime:0.064487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16744180 ORDER BY `minOrder` ASC [ RunTime:0.062802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16744180 ORDER BY `unit` DESC [ RunTime:0.032701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16744180 LIMIT 2 [ RunTime:0.035357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16744180 ORDER BY `minOrder` ASC [ RunTime:0.022669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16743812 LIMIT 5 [ RunTime:0.049902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16743812 ORDER BY `minOrder` ASC [ RunTime:0.036349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16743812 ORDER BY `unit` DESC [ RunTime:0.033935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16743812 LIMIT 2 [ RunTime:0.031769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16743812 ORDER BY `minOrder` ASC [ RunTime:0.014121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16743811 LIMIT 5 [ RunTime:0.036898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16743811 ORDER BY `minOrder` ASC [ RunTime:0.020440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16743811 ORDER BY `unit` DESC [ RunTime:0.024404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16743811 LIMIT 2 [ RunTime:0.048424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16743811 ORDER BY `minOrder` ASC [ RunTime:0.007708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15601981 LIMIT 5 [ RunTime:0.026775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15601981 ORDER BY `minOrder` ASC [ RunTime:0.054343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15601981 ORDER BY `unit` DESC [ RunTime:0.008549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15601981 LIMIT 2 [ RunTime:0.033694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15601981 ORDER BY `minOrder` ASC [ RunTime:0.026395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14917270 LIMIT 5 [ RunTime:0.024154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14917270 ORDER BY `minOrder` ASC [ RunTime:0.069973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14917270 ORDER BY `unit` DESC [ RunTime:0.032033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14917270 LIMIT 2 [ RunTime:0.033423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14917270 ORDER BY `minOrder` ASC [ RunTime:0.009794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14917211 LIMIT 5 [ RunTime:0.018639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14917211 ORDER BY `minOrder` ASC [ RunTime:0.015296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14917211 ORDER BY `unit` DESC [ RunTime:0.005082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14917211 LIMIT 2 [ RunTime:0.020589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14917211 ORDER BY `minOrder` ASC [ RunTime:0.021238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14917210 LIMIT 5 [ RunTime:0.024059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14917210 ORDER BY `minOrder` ASC [ RunTime:0.026666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14917210 ORDER BY `unit` DESC [ RunTime:0.037046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14917210 LIMIT 2 [ RunTime:0.010001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14917210 ORDER BY `minOrder` ASC [ RunTime:0.005238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13993250 LIMIT 5 [ RunTime:0.024771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13993250 ORDER BY `minOrder` ASC [ RunTime:0.012365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13993250 ORDER BY `unit` DESC [ RunTime:0.018815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13993250 LIMIT 2 [ RunTime:0.026344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13993250 ORDER BY `minOrder` ASC [ RunTime:0.041505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13993037 LIMIT 5 [ RunTime:0.023310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13993037 ORDER BY `minOrder` ASC [ RunTime:0.013724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13993037 ORDER BY `unit` DESC [ RunTime:0.051724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13993037 LIMIT 2 [ RunTime:0.018438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13993037 ORDER BY `minOrder` ASC [ RunTime:0.016062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13992804 LIMIT 5 [ RunTime:0.029434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13992804 ORDER BY `minOrder` ASC [ RunTime:0.032122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13992804 ORDER BY `unit` DESC [ RunTime:0.015033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13992804 LIMIT 2 [ RunTime:0.015644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13992804 ORDER BY `minOrder` ASC [ RunTime:0.016994s ]
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 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044895s ]
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 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39318159 LIMIT 5 [ RunTime:0.017645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39318159 ORDER BY `minOrder` ASC [ RunTime:0.030415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39318159 ORDER BY `unit` DESC [ RunTime:0.048656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39318159 LIMIT 2 [ RunTime:0.026918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39318159 ORDER BY `minOrder` ASC [ RunTime:0.011449s ]
select * from pdf where partno='T491D336M010AT' and brandshort='KEMET' limit 1 [ RunTime:0.039984s ]
select foldpath,foldpath2,filename from pdf_file where id=1639087 limit 1 [ RunTime:0.014672s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.021318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39343787 LIMIT 5 [ RunTime:0.023852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39343787 ORDER BY `minOrder` ASC [ RunTime:0.034394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39343787 ORDER BY `unit` DESC [ RunTime:0.001133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39343787 LIMIT 2 [ RunTime:0.027939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39343787 ORDER BY `minOrder` ASC [ RunTime:0.003791s ]
select * from pdf where partno='T491D336M010AT7027' and brandshort='KEMET' limit 1 [ RunTime:0.019325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT7027' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.028682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39337381 LIMIT 5 [ RunTime:0.023687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39337381 ORDER BY `minOrder` ASC [ RunTime:0.008238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39337381 ORDER BY `unit` DESC [ RunTime:0.000998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39337381 LIMIT 2 [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39337381 ORDER BY `minOrder` ASC [ RunTime:0.000671s ]
select * from pdf where partno='T491D336M010AT2478' and brandshort='KEMET' limit 1 [ RunTime:0.003066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT2478' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.019775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39337220 LIMIT 5 [ RunTime:0.030087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39337220 ORDER BY `minOrder` ASC [ RunTime:0.080856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39337220 ORDER BY `unit` DESC [ RunTime:0.024587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39337220 LIMIT 2 [ RunTime:0.021969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39337220 ORDER BY `minOrder` ASC [ RunTime:0.007970s ]
select * from pdf where partno='T491D336M010AT4100' and brandshort='KEMET' limit 1 [ RunTime:0.014771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT4100' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.034656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39337219 LIMIT 5 [ RunTime:0.016781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39337219 ORDER BY `minOrder` ASC [ RunTime:0.039332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39337219 ORDER BY `unit` DESC [ RunTime:0.013866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39337219 LIMIT 2 [ RunTime:0.004596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39337219 ORDER BY `minOrder` ASC [ RunTime:0.001485s ]
select * from pdf where partno='T491D336M010AT40537683' and brandshort='KEMET' limit 1 [ RunTime:0.020318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT40537683' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.032360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39337218 LIMIT 5 [ RunTime:0.014003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39337218 ORDER BY `minOrder` ASC [ RunTime:0.023568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39337218 ORDER BY `unit` DESC [ RunTime:0.010297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39337218 LIMIT 2 [ RunTime:0.029763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39337218 ORDER BY `minOrder` ASC [ RunTime:0.003945s ]
select * from pdf where partno='T491D336M010AT4053' and brandshort='KEMET' limit 1 [ RunTime:0.010709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT4053' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.035765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39337217 LIMIT 5 [ RunTime:0.043960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39337217 ORDER BY `minOrder` ASC [ RunTime:0.049060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39337217 ORDER BY `unit` DESC [ RunTime:0.027807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39337217 LIMIT 2 [ RunTime:0.072306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39337217 ORDER BY `minOrder` ASC [ RunTime:0.027617s ]
select * from pdf where partno='T491D336M010ATAUTO' and brandshort='KEMET' limit 1 [ RunTime:0.015116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010ATAUTO' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.039476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39335773 LIMIT 5 [ RunTime:0.018602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335773 ORDER BY `minOrder` ASC [ RunTime:0.021966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39335773 ORDER BY `unit` DESC [ RunTime:0.054606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39335773 LIMIT 2 [ RunTime:0.036252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335773 ORDER BY `minOrder` ASC [ RunTime:0.010806s ]
select * from pdf where partno='T491D336M010AT4380' and brandshort='KEMET' limit 1 [ RunTime:0.016291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT4380' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.034950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39335772 LIMIT 5 [ RunTime:0.017474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335772 ORDER BY `minOrder` ASC [ RunTime:0.018004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39335772 ORDER BY `unit` DESC [ RunTime:0.008026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39335772 LIMIT 2 [ RunTime:0.005743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335772 ORDER BY `minOrder` ASC [ RunTime:0.002776s ]
select * from pdf where partno='T491D336M010AT42807333' and brandshort='KEMET' limit 1 [ RunTime:0.002034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT42807333' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.011743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39335580 LIMIT 5 [ RunTime:0.006915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335580 ORDER BY `minOrder` ASC [ RunTime:0.024967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39335580 ORDER BY `unit` DESC [ RunTime:0.006762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39335580 LIMIT 2 [ RunTime:0.029120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335580 ORDER BY `minOrder` ASC [ RunTime:0.013765s ]
select * from pdf where partno='T491D336M010AT4280' and brandshort='KEMET' limit 1 [ RunTime:0.007386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT4280' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.021167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39335579 LIMIT 5 [ RunTime:0.018943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335579 ORDER BY `minOrder` ASC [ RunTime:0.010238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39335579 ORDER BY `unit` DESC [ RunTime:0.017915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39335579 LIMIT 2 [ RunTime:0.028063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335579 ORDER BY `minOrder` ASC [ RunTime:0.003721s ]
select * from pdf where partno='T491D336M010AT4153' and brandshort='KEMET' limit 1 [ RunTime:0.012337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT4153' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.009704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39335578 LIMIT 5 [ RunTime:0.012228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335578 ORDER BY `minOrder` ASC [ RunTime:0.045307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39335578 ORDER BY `unit` DESC [ RunTime:0.021982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39335578 LIMIT 2 [ RunTime:0.028890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335578 ORDER BY `minOrder` ASC [ RunTime:0.001476s ]
select * from pdf where partno='T491D336M010AT4121' and brandshort='KEMET' limit 1 [ RunTime:0.014640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT4121' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.032636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39335577 LIMIT 5 [ RunTime:0.016184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335577 ORDER BY `minOrder` ASC [ RunTime:0.031069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39335577 ORDER BY `unit` DESC [ RunTime:0.035627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39335577 LIMIT 2 [ RunTime:0.037161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39335577 ORDER BY `minOrder` ASC [ RunTime:0.011761s ]
select * from pdf where partno='T491D336M010ATAU50' and brandshort='KEMET' limit 1 [ RunTime:0.040083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010ATAU50' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.034201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39334239 LIMIT 5 [ RunTime:0.029418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39334239 ORDER BY `minOrder` ASC [ RunTime:0.055459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39334239 ORDER BY `unit` DESC [ RunTime:0.067495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39334239 LIMIT 2 [ RunTime:0.033321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39334239 ORDER BY `minOrder` ASC [ RunTime:0.008256s ]
select * from pdf where partno='T491D336M010AT7280' and brandshort='KEMET' limit 1 [ RunTime:0.048765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T491D336M010AT7280' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.052835s ]
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 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024400s ]
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 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.146510s ]
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 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059367s ]
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 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025670s ]
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 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034844s ]
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 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050569s ]
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 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020937s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'T491D336M010AT%' OR `brand` LIKE 'T491D336M010AT%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.086164s ]