SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001658s ]
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=B132&search=1' [ RunTime:0.002837s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002259s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000486s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001241s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.001956s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000977s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000765s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002468s ]
SELECT * FROM `stock_search` WHERE `partno` = 'B132' LIMIT 1 [ RunTime:0.017045s ]
UPDATE `stock_search` SET `count` = 8 , `updatetime` = '2026-08-21 08:53:03' WHERE `partno` = 'B132' [ RunTime:0.013015s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002243s ]
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 'B132%' OR `brand` LIKE 'B132%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018024s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12009546 LIMIT 5 [ RunTime:0.006286s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12009546 ORDER BY `minOrder` ASC [ RunTime:0.004892s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12009546 ORDER BY `unit` DESC [ RunTime:0.002346s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12009546 LIMIT 2 [ RunTime:0.007553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12009546 ORDER BY `minOrder` ASC [ RunTime:0.005867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11986442 LIMIT 5 [ RunTime:0.008544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11986442 ORDER BY `minOrder` ASC [ RunTime:0.016372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11986442 ORDER BY `unit` DESC [ RunTime:0.013246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11986442 LIMIT 2 [ RunTime:0.010929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11986442 ORDER BY `minOrder` ASC [ RunTime:0.005186s ]
select * from pdf where partno='B1322N' and brandshort='TE Connectivity' limit 1 [ RunTime:0.014915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11986530 LIMIT 5 [ RunTime:0.027901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11986530 ORDER BY `minOrder` ASC [ RunTime:0.014566s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11986530 ORDER BY `unit` DESC [ RunTime:0.040647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11986530 LIMIT 2 [ RunTime:0.013673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11986530 ORDER BY `minOrder` ASC [ RunTime:0.029170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13257912 LIMIT 5 [ RunTime:0.034120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13257912 ORDER BY `minOrder` ASC [ RunTime:0.026640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13257912 ORDER BY `unit` DESC [ RunTime:0.041384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13257912 LIMIT 2 [ RunTime:0.021979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13257912 ORDER BY `minOrder` ASC [ RunTime:0.016781s ]
select * from pdf where partno='B1322WS' and brandshort='TE Connectivity' limit 1 [ RunTime:0.034320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281454 LIMIT 5 [ RunTime:0.061718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281454 ORDER BY `minOrder` ASC [ RunTime:0.049859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281454 ORDER BY `unit` DESC [ RunTime:0.035111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281454 LIMIT 2 [ RunTime:0.013607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281454 ORDER BY `minOrder` ASC [ RunTime:0.005741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11986563 LIMIT 5 [ RunTime:0.023650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11986563 ORDER BY `minOrder` ASC [ RunTime:0.062542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11986563 ORDER BY `unit` DESC [ RunTime:0.053064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11986563 LIMIT 2 [ RunTime:0.080358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11986563 ORDER BY `minOrder` ASC [ RunTime:0.004945s ]
select * from pdf where partno='B1322W' and brandshort='TE Connectivity' limit 1 [ RunTime:0.042489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281559 LIMIT 5 [ RunTime:0.045180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281559 ORDER BY `minOrder` ASC [ RunTime:0.019047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281559 ORDER BY `unit` DESC [ RunTime:0.026272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281559 LIMIT 2 [ RunTime:0.040015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281559 ORDER BY `minOrder` ASC [ RunTime:0.039526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281338 LIMIT 5 [ RunTime:0.027632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281338 ORDER BY `minOrder` ASC [ RunTime:0.004879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281338 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281338 LIMIT 2 [ RunTime:0.005406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281338 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281331 LIMIT 5 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281331 ORDER BY `minOrder` ASC [ RunTime:0.012208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281331 ORDER BY `unit` DESC [ RunTime:0.009392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281331 LIMIT 2 [ RunTime:0.009880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281331 ORDER BY `minOrder` ASC [ RunTime:0.009133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281330 LIMIT 5 [ RunTime:0.000802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281330 ORDER BY `minOrder` ASC [ RunTime:0.008113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281330 ORDER BY `unit` DESC [ RunTime:0.007842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281330 LIMIT 2 [ RunTime:0.001706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281330 ORDER BY `minOrder` ASC [ RunTime:0.005312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281329 LIMIT 5 [ RunTime:0.000431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281329 ORDER BY `minOrder` ASC [ RunTime:0.003284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281329 ORDER BY `unit` DESC [ RunTime:0.003283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281329 LIMIT 2 [ RunTime:0.002029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281329 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281328 LIMIT 5 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281328 ORDER BY `minOrder` ASC [ RunTime:0.009111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13281328 ORDER BY `unit` DESC [ RunTime:0.000639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13281328 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13281328 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13260083 LIMIT 5 [ RunTime:0.009098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13260083 ORDER BY `minOrder` ASC [ RunTime:0.005817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13260083 ORDER BY `unit` DESC [ RunTime:0.007570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13260083 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13260083 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13260025 LIMIT 5 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13260025 ORDER BY `minOrder` ASC [ RunTime:0.004894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13260025 ORDER BY `unit` DESC [ RunTime:0.005118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13260025 LIMIT 2 [ RunTime:0.006071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13260025 ORDER BY `minOrder` ASC [ RunTime:0.002988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13259681 LIMIT 5 [ RunTime:0.008674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259681 ORDER BY `minOrder` ASC [ RunTime:0.002496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13259681 ORDER BY `unit` DESC [ RunTime:0.001625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13259681 LIMIT 2 [ RunTime:0.005077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259681 ORDER BY `minOrder` ASC [ RunTime:0.004305s ]
select * from pdf where partno='B1323S' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13257896 LIMIT 5 [ RunTime:0.004453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13257896 ORDER BY `minOrder` ASC [ RunTime:0.001332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13257896 ORDER BY `unit` DESC [ RunTime:0.000712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13257896 LIMIT 2 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13257896 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='B132S-L' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12079443 LIMIT 5 [ RunTime:0.010226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12079443 ORDER BY `minOrder` ASC [ RunTime:0.008729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12079443 ORDER BY `unit` DESC [ RunTime:0.009630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12079443 LIMIT 2 [ RunTime:0.001455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12079443 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010404 LIMIT 5 [ RunTime:0.002856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010404 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12010404 ORDER BY `unit` DESC [ RunTime:0.001009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12010404 LIMIT 2 [ RunTime:0.000832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010404 ORDER BY `minOrder` ASC [ RunTime:0.002527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010380 LIMIT 5 [ RunTime:0.007567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010380 ORDER BY `minOrder` ASC [ RunTime:0.015589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12010380 ORDER BY `unit` DESC [ RunTime:0.003759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12010380 LIMIT 2 [ RunTime:0.003170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010380 ORDER BY `minOrder` ASC [ RunTime:0.003506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010375 LIMIT 5 [ RunTime:0.003583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010375 ORDER BY `minOrder` ASC [ RunTime:0.005448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12010375 ORDER BY `unit` DESC [ RunTime:0.001727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12010375 LIMIT 2 [ RunTime:0.007626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12010375 ORDER BY `minOrder` ASC [ RunTime:0.000751s ]
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 'B132%' OR `brand` LIKE 'B132%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081703 LIMIT 5 [ RunTime:0.008265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081703 ORDER BY `minOrder` ASC [ RunTime:0.002767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51081703 ORDER BY `unit` DESC [ RunTime:0.004737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51081703 LIMIT 2 [ RunTime:0.002870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081703 ORDER BY `minOrder` ASC [ RunTime:0.007651s ]
select * from pdf where partno='b132-100a' and brandshort='tripp lite' limit 1 [ RunTime:0.005295s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'b132-100a' OR `brand` LIKE 'tripp lite%' ) ) LIMIT 1 [ RunTime:0.005213s ]
SELECT `id` FROM `stock` WHERE `id` <> 51081703 AND `partno` = 'b132-100a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tripp lite%' ) [ RunTime:0.007836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64382637 [ RunTime:0.007392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32310014 [ RunTime:0.006132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32310014 LIMIT 5 [ RunTime:0.003192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310014 ORDER BY `minOrder` ASC [ RunTime:0.001285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32310014 ORDER BY `unit` DESC [ RunTime:0.000587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32310014 LIMIT 2 [ RunTime:0.002990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310014 ORDER BY `minOrder` ASC [ RunTime:0.002078s ]
select * from pdf where partno='b132-100a' and brandshort='tripp lite' limit 1 [ RunTime:0.000393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'b132-100a' OR `brand` LIKE 'tripp lite%' ) ) LIMIT 1 [ RunTime:0.003364s ]
SELECT `id` FROM `stock` WHERE `id` <> 32310014 AND `partno` = 'b132-100a' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tripp lite%' ) [ RunTime:0.001608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64382637 [ RunTime:0.001111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081703 [ RunTime:0.007439s ]
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 'B132%' OR `brand` LIKE 'B132%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64223687 LIMIT 5 [ RunTime:0.003334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223687 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64223687 ORDER BY `unit` DESC [ RunTime:0.003172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64223687 LIMIT 2 [ RunTime:0.003301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64223687 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
select * from pdf where partno='B132S-L' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132S-L' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.014373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64381975 LIMIT 5 [ RunTime:0.005674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64381975 ORDER BY `minOrder` ASC [ RunTime:0.001743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64381975 ORDER BY `unit` DESC [ RunTime:0.003059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64381975 LIMIT 2 [ RunTime:0.001700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64381975 ORDER BY `minOrder` ASC [ RunTime:0.004785s ]
select * from pdf where partno='B132-100A-MR' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.002382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132-100A-MR' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.003320s ]
SELECT `id` FROM `stock` WHERE `id` <> 64381975 AND `partno` = 'B132-100A-MR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.007502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12009546 [ RunTime:0.006923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64228042 LIMIT 5 [ RunTime:0.008138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64228042 ORDER BY `minOrder` ASC [ RunTime:0.002738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64228042 ORDER BY `unit` DESC [ RunTime:0.005379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64228042 LIMIT 2 [ RunTime:0.009811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64228042 ORDER BY `minOrder` ASC [ RunTime:0.001524s ]
select * from pdf where partno='B1322N' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B1322N' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.011451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64227829 LIMIT 5 [ RunTime:0.005952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64227829 ORDER BY `minOrder` ASC [ RunTime:0.005557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64227829 ORDER BY `unit` DESC [ RunTime:0.005719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64227829 LIMIT 2 [ RunTime:0.000960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64227829 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
select * from pdf where partno='B1322WS' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B1322WS' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.022309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64228051 LIMIT 5 [ RunTime:0.000994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64228051 ORDER BY `minOrder` ASC [ RunTime:0.005354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64228051 ORDER BY `unit` DESC [ RunTime:0.002232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64228051 LIMIT 2 [ RunTime:0.001017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64228051 ORDER BY `minOrder` ASC [ RunTime:0.010076s ]
select * from pdf where partno='B132R' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132R' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.023795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64227777 LIMIT 5 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64227777 ORDER BY `minOrder` ASC [ RunTime:0.007103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64227777 ORDER BY `unit` DESC [ RunTime:0.007254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64227777 LIMIT 2 [ RunTime:0.006743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64227777 ORDER BY `minOrder` ASC [ RunTime:0.000882s ]
select * from pdf where partno='B1323-L' and brandshort='TE Connectivity' limit 1 [ RunTime:0.003495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B1323-L' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.030544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64228092 LIMIT 5 [ RunTime:0.001560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64228092 ORDER BY `minOrder` ASC [ RunTime:0.006459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64228092 ORDER BY `unit` DESC [ RunTime:0.013317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64228092 LIMIT 2 [ RunTime:0.012462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64228092 ORDER BY `minOrder` ASC [ RunTime:0.004713s ]
select * from pdf where partno='B1322W' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B1322W' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.021380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64382452 LIMIT 5 [ RunTime:0.008039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382452 ORDER BY `minOrder` ASC [ RunTime:0.022138s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64382452 ORDER BY `unit` DESC [ RunTime:0.005060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64382452 LIMIT 2 [ RunTime:0.014996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382452 ORDER BY `minOrder` ASC [ RunTime:0.009587s ]
select * from pdf where partno='B132-002A-2' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.015558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132-002A-2' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.017503s ]
SELECT `id` FROM `stock` WHERE `id` <> 64382452 AND `partno` = 'B132-002A-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.021328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281454 [ RunTime:0.015779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64382727 LIMIT 5 [ RunTime:0.005467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382727 ORDER BY `minOrder` ASC [ RunTime:0.018710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64382727 ORDER BY `unit` DESC [ RunTime:0.032718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64382727 LIMIT 2 [ RunTime:0.024821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382727 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
select * from pdf where partno='B132-004A-2' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.004629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132-004A-2' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.023682s ]
SELECT `id` FROM `stock` WHERE `id` <> 64382727 AND `partno` = 'B132-004A-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.004179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64382690 LIMIT 5 [ RunTime:0.012498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382690 ORDER BY `minOrder` ASC [ RunTime:0.015796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64382690 ORDER BY `unit` DESC [ RunTime:0.041240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64382690 LIMIT 2 [ RunTime:0.021421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382690 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
select * from pdf where partno='B132-008A-2' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.007151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132-008A-2' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.011687s ]
SELECT `id` FROM `stock` WHERE `id` <> 64382690 AND `partno` = 'B132-008A-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.010385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64382637 LIMIT 5 [ RunTime:0.022817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382637 ORDER BY `minOrder` ASC [ RunTime:0.026393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64382637 ORDER BY `unit` DESC [ RunTime:0.002068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64382637 LIMIT 2 [ RunTime:0.005712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382637 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
select * from pdf where partno='B132-100A' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.035161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132-100A' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.004041s ]
SELECT `id` FROM `stock` WHERE `id` <> 64382637 AND `partno` = 'B132-100A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.008574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64382585 LIMIT 5 [ RunTime:0.013333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382585 ORDER BY `minOrder` ASC [ RunTime:0.027640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64382585 ORDER BY `unit` DESC [ RunTime:0.001147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64382585 LIMIT 2 [ RunTime:0.001380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382585 ORDER BY `minOrder` ASC [ RunTime:0.008195s ]
select * from pdf where partno='B132-100-1' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.027571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132-100-1' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.008144s ]
SELECT `id` FROM `stock` WHERE `id` <> 64382585 AND `partno` = 'B132-100-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.018426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13281559 [ RunTime:0.013107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64382573 LIMIT 5 [ RunTime:0.013565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382573 ORDER BY `minOrder` ASC [ RunTime:0.028848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64382573 ORDER BY `unit` DESC [ RunTime:0.024634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64382573 LIMIT 2 [ RunTime:0.019872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382573 ORDER BY `minOrder` ASC [ RunTime:0.019998s ]
select * from pdf where partno='B132-100A-WP-1' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.020431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132-100A-WP-1' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.023210s ]
SELECT `id` FROM `stock` WHERE `id` <> 64382573 AND `partno` = 'B132-100A-WP-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.036881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010380 [ RunTime:0.014680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64382560 LIMIT 5 [ RunTime:0.022644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382560 ORDER BY `minOrder` ASC [ RunTime:0.023354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64382560 ORDER BY `unit` DESC [ RunTime:0.014606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64382560 LIMIT 2 [ RunTime:0.015043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64382560 ORDER BY `minOrder` ASC [ RunTime:0.017483s ]
select * from pdf where partno='B132-200A-SR' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.032726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132-200A-SR' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.014533s ]
SELECT `id` FROM `stock` WHERE `id` <> 64382560 AND `partno` = 'B132-200A-SR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.028087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12010375 [ RunTime:0.007668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64379973 LIMIT 5 [ RunTime:0.005818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64379973 ORDER BY `minOrder` ASC [ RunTime:0.009368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64379973 ORDER BY `unit` DESC [ RunTime:0.033440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64379973 LIMIT 2 [ RunTime:0.015398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64379973 ORDER BY `minOrder` ASC [ RunTime:0.008296s ]
select * from pdf where partno='B132-004-RB' and brandshort='Eaton Tripp Lite' limit 1 [ RunTime:0.016064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B132-004-RB' OR `brand` LIKE 'Eaton Tripp Lite%' ) ) LIMIT 1 [ RunTime:0.013324s ]
SELECT `id` FROM `stock` WHERE `id` <> 64379973 AND `partno` = 'B132-004-RB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton tripp lite%' ) [ RunTime:0.034101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12009481 [ RunTime:0.010925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64234120 LIMIT 5 [ RunTime:0.008325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64234120 ORDER BY `minOrder` ASC [ RunTime:0.005896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64234120 ORDER BY `unit` DESC [ RunTime:0.009516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64234120 LIMIT 2 [ RunTime:0.004877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64234120 ORDER BY `minOrder` ASC [ RunTime:0.008631s ]
select * from pdf where partno='B1322NR' and brandshort='TE Connectivity' limit 1 [ RunTime:0.009934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B1322NR' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.025117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64233731 LIMIT 5 [ RunTime:0.009591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64233731 ORDER BY `minOrder` ASC [ RunTime:0.014675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64233731 ORDER BY `unit` DESC [ RunTime:0.006929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64233731 LIMIT 2 [ RunTime:0.003185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64233731 ORDER BY `minOrder` ASC [ RunTime:0.009998s ]
select * from pdf where partno='B1323S' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B1323S' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.024962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58031742 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58031742 ORDER BY `minOrder` ASC [ RunTime:0.003395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58031742 ORDER BY `unit` DESC [ RunTime:0.007222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58031742 LIMIT 2 [ RunTime:0.002419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58031742 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
select * from pdf where partno='B1325-2R5106' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.002517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B1325-2R5106' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.003309s ]
SELECT `id` FROM `stock` WHERE `id` <> 58031742 AND `partno` = 'B1325-2R5106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.013253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11126915 [ RunTime:0.004913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58030573 LIMIT 5 [ RunTime:0.002712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58030573 ORDER BY `minOrder` ASC [ RunTime:0.012504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58030573 ORDER BY `unit` DESC [ RunTime:0.012581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58030573 LIMIT 2 [ RunTime:0.008659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58030573 ORDER BY `minOrder` ASC [ RunTime:0.000874s ]
select * from pdf where partno='B1325-2R5106-R' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.016988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B1325-2R5106-R' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.013189s ]
SELECT `id` FROM `stock` WHERE `id` <> 58030573 AND `partno` = 'B1325-2R5106-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.014908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12079443 [ RunTime:0.012770s ]
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 'B132%' OR `brand` LIKE 'B132%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006430s ]
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 'B132%' OR `brand` LIKE 'B132%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007962s ]
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 'B132%' OR `brand` LIKE 'B132%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002757s ]
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 'B132%' OR `brand` LIKE 'B132%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004802s ]
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 'B132%' OR `brand` LIKE 'B132%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003302s ]
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 'B132%' OR `brand` LIKE 'B132%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014737s ]
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 'B132%' OR `brand` LIKE 'B132%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016061s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'B132%' OR `brand` LIKE 'B132%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017970s ]