SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001196s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=15KPA33&search=1' [ RunTime:0.011186s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001521s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.022757s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.004432s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.014475s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001568s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001829s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001233s ]
SELECT * FROM `stock_search` WHERE `partno` = '15KPA33' LIMIT 1 [ RunTime:0.018746s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-18 05:16:18' WHERE `partno` = '15KPA33' [ RunTime:0.040646s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001299s ]
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 '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047179s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671446 LIMIT 5 [ RunTime:0.041584s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671446 ORDER BY `minOrder` ASC [ RunTime:0.047054s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.029934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671446 ORDER BY `unit` DESC [ RunTime:0.018234s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.049590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671446 LIMIT 2 [ RunTime:0.013834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671446 ORDER BY `minOrder` ASC [ RunTime:0.031712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830876 LIMIT 5 [ RunTime:0.035962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830876 ORDER BY `minOrder` ASC [ RunTime:0.047476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830876 ORDER BY `unit` DESC [ RunTime:0.032366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830876 LIMIT 2 [ RunTime:0.063376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830876 ORDER BY `minOrder` ASC [ RunTime:0.024127s ]
select * from pdf where partno='15KPA33CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.091573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664169 LIMIT 5 [ RunTime:0.043801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664169 ORDER BY `minOrder` ASC [ RunTime:0.102420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664169 ORDER BY `unit` DESC [ RunTime:0.049333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664169 LIMIT 2 [ RunTime:0.079458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664169 ORDER BY `minOrder` ASC [ RunTime:0.028658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801554 LIMIT 5 [ RunTime:0.058175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801554 ORDER BY `minOrder` ASC [ RunTime:0.015888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801554 ORDER BY `unit` DESC [ RunTime:0.077693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801554 LIMIT 2 [ RunTime:0.008084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801554 ORDER BY `minOrder` ASC [ RunTime:0.026603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690735 LIMIT 5 [ RunTime:0.082719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690735 ORDER BY `minOrder` ASC [ RunTime:0.066864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690735 ORDER BY `unit` DESC [ RunTime:0.049487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690735 LIMIT 2 [ RunTime:0.058497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690735 ORDER BY `minOrder` ASC [ RunTime:0.044836s ]
select * from pdf where partno='15KPA33A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.070143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906388 LIMIT 5 [ RunTime:0.091911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906388 ORDER BY `minOrder` ASC [ RunTime:0.085581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906388 ORDER BY `unit` DESC [ RunTime:0.103000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906388 LIMIT 2 [ RunTime:0.063613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906388 ORDER BY `minOrder` ASC [ RunTime:0.055219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800403 LIMIT 5 [ RunTime:0.063976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800403 ORDER BY `minOrder` ASC [ RunTime:0.100212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800403 ORDER BY `unit` DESC [ RunTime:0.046039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800403 LIMIT 2 [ RunTime:0.030936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800403 ORDER BY `minOrder` ASC [ RunTime:0.024636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13904556 LIMIT 5 [ RunTime:0.053648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904556 ORDER BY `minOrder` ASC [ RunTime:0.019000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13904556 ORDER BY `unit` DESC [ RunTime:0.049588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13904556 LIMIT 2 [ RunTime:0.052317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13904556 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16687800 LIMIT 5 [ RunTime:0.047859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687800 ORDER BY `minOrder` ASC [ RunTime:0.015141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16687800 ORDER BY `unit` DESC [ RunTime:0.041723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16687800 LIMIT 2 [ RunTime:0.042060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16687800 ORDER BY `minOrder` ASC [ RunTime:0.036323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684173 LIMIT 5 [ RunTime:0.053289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684173 ORDER BY `minOrder` ASC [ RunTime:0.046567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16684173 ORDER BY `unit` DESC [ RunTime:0.066164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16684173 LIMIT 2 [ RunTime:0.054445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684173 ORDER BY `minOrder` ASC [ RunTime:0.028587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684172 LIMIT 5 [ RunTime:0.042971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684172 ORDER BY `minOrder` ASC [ RunTime:0.111727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16684172 ORDER BY `unit` DESC [ RunTime:0.056067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16684172 LIMIT 2 [ RunTime:0.047580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684172 ORDER BY `minOrder` ASC [ RunTime:0.017013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683366 LIMIT 5 [ RunTime:0.021088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683366 ORDER BY `minOrder` ASC [ RunTime:0.007014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683366 ORDER BY `unit` DESC [ RunTime:0.017331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683366 LIMIT 2 [ RunTime:0.018543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683366 ORDER BY `minOrder` ASC [ RunTime:0.009008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681452 LIMIT 5 [ RunTime:0.035185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681452 ORDER BY `minOrder` ASC [ RunTime:0.011255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16681452 ORDER BY `unit` DESC [ RunTime:0.038602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16681452 LIMIT 2 [ RunTime:0.016940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681452 ORDER BY `minOrder` ASC [ RunTime:0.003776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680335 LIMIT 5 [ RunTime:0.015330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680335 ORDER BY `minOrder` ASC [ RunTime:0.022444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680335 ORDER BY `unit` DESC [ RunTime:0.010668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680335 LIMIT 2 [ RunTime:0.004096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680335 ORDER BY `minOrder` ASC [ RunTime:0.005875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830691 LIMIT 5 [ RunTime:0.014318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830691 ORDER BY `minOrder` ASC [ RunTime:0.012055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830691 ORDER BY `unit` DESC [ RunTime:0.012286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830691 LIMIT 2 [ RunTime:0.007833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830691 ORDER BY `minOrder` ASC [ RunTime:0.006290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830690 LIMIT 5 [ RunTime:0.003967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830690 ORDER BY `minOrder` ASC [ RunTime:0.006171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830690 ORDER BY `unit` DESC [ RunTime:0.017030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830690 LIMIT 2 [ RunTime:0.008267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830690 ORDER BY `minOrder` ASC [ RunTime:0.001599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14824546 LIMIT 5 [ RunTime:0.002093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14824546 ORDER BY `minOrder` ASC [ RunTime:0.001463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14824546 ORDER BY `unit` DESC [ RunTime:0.000508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14824546 LIMIT 2 [ RunTime:0.012958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14824546 ORDER BY `minOrder` ASC [ RunTime:0.008259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14824545 LIMIT 5 [ RunTime:0.004291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14824545 ORDER BY `minOrder` ASC [ RunTime:0.007672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14824545 ORDER BY `unit` DESC [ RunTime:0.009108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14824545 LIMIT 2 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14824545 ORDER BY `minOrder` ASC [ RunTime:0.002341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823567 LIMIT 5 [ RunTime:0.008445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823567 ORDER BY `minOrder` ASC [ RunTime:0.020721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14823567 ORDER BY `unit` DESC [ RunTime:0.007338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14823567 LIMIT 2 [ RunTime:0.010879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823567 ORDER BY `minOrder` ASC [ RunTime:0.008609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823566 LIMIT 5 [ RunTime:0.002664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823566 ORDER BY `minOrder` ASC [ RunTime:0.014874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14823566 ORDER BY `unit` DESC [ RunTime:0.032661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14823566 LIMIT 2 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14823566 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
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 '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003696s ]
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 '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42097382 LIMIT 5 [ RunTime:0.026545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42097382 ORDER BY `minOrder` ASC [ RunTime:0.029296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42097382 ORDER BY `unit` DESC [ RunTime:0.010132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42097382 LIMIT 2 [ RunTime:0.029240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42097382 ORDER BY `minOrder` ASC [ RunTime:0.005340s ]
select * from pdf where partno='15KPA33CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007925s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.027310s ]
SELECT `id` FROM `stock` WHERE `id` <> 42097382 AND `partno` = '15KPA33CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.018750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830876 [ RunTime:0.007323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42109229 LIMIT 5 [ RunTime:0.027064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109229 ORDER BY `minOrder` ASC [ RunTime:0.010183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42109229 ORDER BY `unit` DESC [ RunTime:0.005033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42109229 LIMIT 2 [ RunTime:0.012132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109229 ORDER BY `minOrder` ASC [ RunTime:0.033419s ]
select * from pdf where partno='15KPA33CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.008065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.033034s ]
SELECT `id` FROM `stock` WHERE `id` <> 42109229 AND `partno` = '15KPA33CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.015989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671446 [ RunTime:0.017806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42097385 LIMIT 5 [ RunTime:0.019069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42097385 ORDER BY `minOrder` ASC [ RunTime:0.004779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42097385 ORDER BY `unit` DESC [ RunTime:0.020426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42097385 LIMIT 2 [ RunTime:0.057848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42097385 ORDER BY `minOrder` ASC [ RunTime:0.020441s ]
select * from pdf where partno='15KPA33A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.012722s ]
SELECT `id` FROM `stock` WHERE `id` <> 42097385 AND `partno` = '15KPA33A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.016868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690735 [ RunTime:0.046539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42158101 LIMIT 5 [ RunTime:0.017176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158101 ORDER BY `minOrder` ASC [ RunTime:0.013242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42158101 ORDER BY `unit` DESC [ RunTime:0.007959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42158101 LIMIT 2 [ RunTime:0.035719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158101 ORDER BY `minOrder` ASC [ RunTime:0.012664s ]
select * from pdf where partno='15KPA33CA' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.012571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CA' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.033285s ]
SELECT `id` FROM `stock` WHERE `id` <> 42158101 AND `partno` = '15KPA33CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.046329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801554 [ RunTime:0.023217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42158102 LIMIT 5 [ RunTime:0.025710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158102 ORDER BY `minOrder` ASC [ RunTime:0.022204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42158102 ORDER BY `unit` DESC [ RunTime:0.020610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42158102 LIMIT 2 [ RunTime:0.013235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158102 ORDER BY `minOrder` ASC [ RunTime:0.006019s ]
select * from pdf where partno='15KPA33A' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.053161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33A' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.016878s ]
SELECT `id` FROM `stock` WHERE `id` <> 42158102 AND `partno` = '15KPA33A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.021693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664169 [ RunTime:0.025245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42158040 LIMIT 5 [ RunTime:0.025490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158040 ORDER BY `minOrder` ASC [ RunTime:0.032664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42158040 ORDER BY `unit` DESC [ RunTime:0.027106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42158040 LIMIT 2 [ RunTime:0.059095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158040 ORDER BY `minOrder` ASC [ RunTime:0.024977s ]
select * from pdf where partno='15KPA33CA' and brandshort='Good-Ark Semiconductor' limit 1 [ RunTime:0.046886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CA' OR `brand` LIKE 'Good-Ark Semiconductor%' ) ) LIMIT 1 [ RunTime:0.010697s ]
SELECT `id` FROM `stock` WHERE `id` <> 42158040 AND `partno` = '15KPA33CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%good-ark semiconductor%' ) [ RunTime:0.036832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906388 [ RunTime:0.012189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42137753 LIMIT 5 [ RunTime:0.036848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42137753 ORDER BY `minOrder` ASC [ RunTime:0.034240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42137753 ORDER BY `unit` DESC [ RunTime:0.005513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42137753 LIMIT 2 [ RunTime:0.001765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42137753 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
select * from pdf where partno='15KPA33A/B' and brandshort='YAGEO' limit 1 [ RunTime:0.010845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33A/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.036487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42137743 LIMIT 5 [ RunTime:0.014557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42137743 ORDER BY `minOrder` ASC [ RunTime:0.009311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42137743 ORDER BY `unit` DESC [ RunTime:0.013012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42137743 LIMIT 2 [ RunTime:0.000931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42137743 ORDER BY `minOrder` ASC [ RunTime:0.002121s ]
select * from pdf where partno='15KPA33CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.001532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.017765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42418192 LIMIT 5 [ RunTime:0.027612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418192 ORDER BY `minOrder` ASC [ RunTime:0.036449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42418192 ORDER BY `unit` DESC [ RunTime:0.014959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42418192 LIMIT 2 [ RunTime:0.012908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418192 ORDER BY `minOrder` ASC [ RunTime:0.028160s ]
select * from pdf where partno='15KPA33CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004481s ]
SELECT `id` FROM `stock` WHERE `id` <> 42418192 AND `partno` = '15KPA33CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.004135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14824546 [ RunTime:0.005721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42418191 LIMIT 5 [ RunTime:0.001660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418191 ORDER BY `minOrder` ASC [ RunTime:0.003352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42418191 ORDER BY `unit` DESC [ RunTime:0.015408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42418191 LIMIT 2 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418191 ORDER BY `minOrder` ASC [ RunTime:0.003169s ]
select * from pdf where partno='15KPA33A-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.020014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33A-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.011755s ]
SELECT `id` FROM `stock` WHERE `id` <> 42418191 AND `partno` = '15KPA33A-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.001115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14824545 [ RunTime:0.033583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42417639 LIMIT 5 [ RunTime:0.008622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417639 ORDER BY `minOrder` ASC [ RunTime:0.019245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42417639 ORDER BY `unit` DESC [ RunTime:0.008778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42417639 LIMIT 2 [ RunTime:0.003127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417639 ORDER BY `minOrder` ASC [ RunTime:0.006436s ]
select * from pdf where partno='15KPA33CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.004783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001663s ]
SELECT `id` FROM `stock` WHERE `id` <> 42417639 AND `partno` = '15KPA33CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.010695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684173 [ RunTime:0.011484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42417638 LIMIT 5 [ RunTime:0.006983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417638 ORDER BY `minOrder` ASC [ RunTime:0.004121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42417638 ORDER BY `unit` DESC [ RunTime:0.002764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42417638 LIMIT 2 [ RunTime:0.007126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417638 ORDER BY `minOrder` ASC [ RunTime:0.008701s ]
select * from pdf where partno='15KPA33A-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.013777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33A-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.018118s ]
SELECT `id` FROM `stock` WHERE `id` <> 42417638 AND `partno` = '15KPA33A-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.024556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684172 [ RunTime:0.018650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42402435 LIMIT 5 [ RunTime:0.011313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402435 ORDER BY `minOrder` ASC [ RunTime:0.003733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42402435 ORDER BY `unit` DESC [ RunTime:0.011590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42402435 LIMIT 2 [ RunTime:0.011669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402435 ORDER BY `minOrder` ASC [ RunTime:0.008444s ]
select * from pdf where partno='15KPA33CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.014373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.008977s ]
SELECT `id` FROM `stock` WHERE `id` <> 42402435 AND `partno` = '15KPA33CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.002464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683366 [ RunTime:0.021570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42401059 LIMIT 5 [ RunTime:0.028564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401059 ORDER BY `minOrder` ASC [ RunTime:0.012115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42401059 ORDER BY `unit` DESC [ RunTime:0.024150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42401059 LIMIT 2 [ RunTime:0.025585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401059 ORDER BY `minOrder` ASC [ RunTime:0.012698s ]
select * from pdf where partno='15KPA33E3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.042123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33E3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.008071s ]
SELECT `id` FROM `stock` WHERE `id` <> 42401059 AND `partno` = '15KPA33E3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.025899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823567 [ RunTime:0.029870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42401058 LIMIT 5 [ RunTime:0.028194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401058 ORDER BY `minOrder` ASC [ RunTime:0.016423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42401058 ORDER BY `unit` DESC [ RunTime:0.024237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42401058 LIMIT 2 [ RunTime:0.042374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401058 ORDER BY `minOrder` ASC [ RunTime:0.015826s ]
select * from pdf where partno='15KPA33CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.021786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.034490s ]
SELECT `id` FROM `stock` WHERE `id` <> 42401058 AND `partno` = '15KPA33CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.013278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14823566 [ RunTime:0.039556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42401057 LIMIT 5 [ RunTime:0.016144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401057 ORDER BY `minOrder` ASC [ RunTime:0.043773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42401057 ORDER BY `unit` DESC [ RunTime:0.010354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42401057 LIMIT 2 [ RunTime:0.008464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42401057 ORDER BY `minOrder` ASC [ RunTime:0.017232s ]
select * from pdf where partno='15KPA33AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.006640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.010787s ]
SELECT `id` FROM `stock` WHERE `id` <> 42401057 AND `partno` = '15KPA33AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.004257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924693 [ RunTime:0.018883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42333095 LIMIT 5 [ RunTime:0.024296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42333095 ORDER BY `minOrder` ASC [ RunTime:0.013729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42333095 ORDER BY `unit` DESC [ RunTime:0.011957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42333095 LIMIT 2 [ RunTime:0.022722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42333095 ORDER BY `minOrder` ASC [ RunTime:0.007406s ]
select * from pdf where partno='15KPA33A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33A-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004346s ]
SELECT `id` FROM `stock` WHERE `id` <> 42333095 AND `partno` = '15KPA33A-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.009038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13923546 [ RunTime:0.007084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42332985 LIMIT 5 [ RunTime:0.002358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42332985 ORDER BY `minOrder` ASC [ RunTime:0.002717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42332985 ORDER BY `unit` DESC [ RunTime:0.014086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42332985 LIMIT 2 [ RunTime:0.002109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42332985 ORDER BY `minOrder` ASC [ RunTime:0.003441s ]
select * from pdf where partno='15KPA33CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.014364s ]
SELECT `id` FROM `stock` WHERE `id` <> 42332985 AND `partno` = '15KPA33CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.012077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13923544 [ RunTime:0.037481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42327531 LIMIT 5 [ RunTime:0.000851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327531 ORDER BY `minOrder` ASC [ RunTime:0.005447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42327531 ORDER BY `unit` DESC [ RunTime:0.006553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42327531 LIMIT 2 [ RunTime:0.001262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327531 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='15KPA33A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.002361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42327519 LIMIT 5 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327519 ORDER BY `minOrder` ASC [ RunTime:0.002022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42327519 ORDER BY `unit` DESC [ RunTime:0.004019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42327519 LIMIT 2 [ RunTime:0.003158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327519 ORDER BY `minOrder` ASC [ RunTime:0.001392s ]
select * from pdf where partno='15KPA33CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.011064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA33CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.003528s ]
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 '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000903s ]
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 '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002209s ]
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 '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000860s ]
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 '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005372s ]
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 '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001927s ]
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 '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000752s ]
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 '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002768s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15KPA33%' OR `brand` LIKE '15KPA33%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000703s ]