SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002385s ]
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=2111&search=1' [ RunTime:0.004511s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002307s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000522s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002998s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000574s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002244s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000322s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001997s ]
SELECT * FROM `stock_search` WHERE `partno` = '2111' LIMIT 1 [ RunTime:0.013053s ]
UPDATE `stock_search` SET `count` = 16 , `updatetime` = '2026-08-28 16:56:51' WHERE `partno` = '2111' [ RunTime:0.004906s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002844s ]
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 '2111%' OR `brand` LIKE '2111%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030037s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11609440 LIMIT 5 [ RunTime:0.009036s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609440 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11609440 ORDER BY `unit` DESC [ RunTime:0.002545s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11609440 LIMIT 2 [ RunTime:0.001673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609440 ORDER BY `minOrder` ASC [ RunTime:0.006410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791364 LIMIT 5 [ RunTime:0.010083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791364 ORDER BY `minOrder` ASC [ RunTime:0.008862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12791364 ORDER BY `unit` DESC [ RunTime:0.011091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12791364 LIMIT 2 [ RunTime:0.010427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791364 ORDER BY `minOrder` ASC [ RunTime:0.001622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11984192 LIMIT 5 [ RunTime:0.012472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11984192 ORDER BY `minOrder` ASC [ RunTime:0.008770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11984192 ORDER BY `unit` DESC [ RunTime:0.015725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11984192 LIMIT 2 [ RunTime:0.010239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11984192 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14290259 LIMIT 5 [ RunTime:0.000951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14290259 ORDER BY `minOrder` ASC [ RunTime:0.007268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14290259 ORDER BY `unit` DESC [ RunTime:0.016164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14290259 LIMIT 2 [ RunTime:0.008043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14290259 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520105 LIMIT 5 [ RunTime:0.002938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520105 ORDER BY `minOrder` ASC [ RunTime:0.003300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12520105 ORDER BY `unit` DESC [ RunTime:0.000643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12520105 LIMIT 2 [ RunTime:0.013194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520105 ORDER BY `minOrder` ASC [ RunTime:0.010438s ]
select * from pdf where partno='2111-2-00-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.011235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419069 LIMIT 5 [ RunTime:0.013928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419069 ORDER BY `minOrder` ASC [ RunTime:0.003281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419069 ORDER BY `unit` DESC [ RunTime:0.014838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419069 LIMIT 2 [ RunTime:0.021965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419069 ORDER BY `minOrder` ASC [ RunTime:0.000930s ]
select * from pdf where partno='2111-1-00-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.015935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520136 LIMIT 5 [ RunTime:0.010023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520136 ORDER BY `minOrder` ASC [ RunTime:0.040024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12520136 ORDER BY `unit` DESC [ RunTime:0.020533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12520136 LIMIT 2 [ RunTime:0.013538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520136 ORDER BY `minOrder` ASC [ RunTime:0.009413s ]
select * from pdf where partno='2111-2-00-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.005668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520150 LIMIT 5 [ RunTime:0.005972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520150 ORDER BY `minOrder` ASC [ RunTime:0.011483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12520150 ORDER BY `unit` DESC [ RunTime:0.049365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12520150 LIMIT 2 [ RunTime:0.006210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520150 ORDER BY `minOrder` ASC [ RunTime:0.001030s ]
select * from pdf where partno='2111-1-00-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.004646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419068 LIMIT 5 [ RunTime:0.002366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419068 ORDER BY `minOrder` ASC [ RunTime:0.016726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419068 ORDER BY `unit` DESC [ RunTime:0.027939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419068 LIMIT 2 [ RunTime:0.015700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419068 ORDER BY `minOrder` ASC [ RunTime:0.006292s ]
select * from pdf where partno='2111-3-00-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.018099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419073 LIMIT 5 [ RunTime:0.013256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419073 ORDER BY `minOrder` ASC [ RunTime:0.010195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11419073 ORDER BY `unit` DESC [ RunTime:0.034902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11419073 LIMIT 2 [ RunTime:0.013681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11419073 ORDER BY `minOrder` ASC [ RunTime:0.003965s ]
select * from pdf where partno='2111-2-00-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.025532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17038212 LIMIT 5 [ RunTime:0.010961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17038212 ORDER BY `minOrder` ASC [ RunTime:0.029252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17038212 ORDER BY `unit` DESC [ RunTime:0.013740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17038212 LIMIT 2 [ RunTime:0.002887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17038212 ORDER BY `minOrder` ASC [ RunTime:0.008389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11389472 LIMIT 5 [ RunTime:0.019459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11389472 ORDER BY `minOrder` ASC [ RunTime:0.024146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11389472 ORDER BY `unit` DESC [ RunTime:0.020630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11389472 LIMIT 2 [ RunTime:0.007745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11389472 ORDER BY `minOrder` ASC [ RunTime:0.011762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13314775 LIMIT 5 [ RunTime:0.018453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314775 ORDER BY `minOrder` ASC [ RunTime:0.006206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13314775 ORDER BY `unit` DESC [ RunTime:0.006309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13314775 LIMIT 2 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314775 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17038213 LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17038213 ORDER BY `minOrder` ASC [ RunTime:0.004423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17038213 ORDER BY `unit` DESC [ RunTime:0.010879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17038213 LIMIT 2 [ RunTime:0.001776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17038213 ORDER BY `minOrder` ASC [ RunTime:0.006613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13413285 LIMIT 5 [ RunTime:0.001175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13413285 ORDER BY `minOrder` ASC [ RunTime:0.000710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13413285 ORDER BY `unit` DESC [ RunTime:0.001577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13413285 LIMIT 2 [ RunTime:0.011347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13413285 ORDER BY `minOrder` ASC [ RunTime:0.005464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041831 LIMIT 5 [ RunTime:0.010897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041831 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12041831 ORDER BY `unit` DESC [ RunTime:0.006156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12041831 LIMIT 2 [ RunTime:0.005088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12041831 ORDER BY `minOrder` ASC [ RunTime:0.007003s ]
select * from pdf where partno='2111-440-AL-7' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.007048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042002 LIMIT 5 [ RunTime:0.019110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042002 ORDER BY `minOrder` ASC [ RunTime:0.012203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042002 ORDER BY `unit` DESC [ RunTime:0.002125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042002 LIMIT 2 [ RunTime:0.006406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042002 ORDER BY `minOrder` ASC [ RunTime:0.012266s ]
select * from pdf where partno='2111-632-N' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.011840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484007 LIMIT 5 [ RunTime:0.012451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484007 ORDER BY `minOrder` ASC [ RunTime:0.010368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484007 ORDER BY `unit` DESC [ RunTime:0.010116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484007 LIMIT 2 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484007 ORDER BY `minOrder` ASC [ RunTime:0.006754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13178427 LIMIT 5 [ RunTime:0.012552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13178427 ORDER BY `minOrder` ASC [ RunTime:0.006588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13178427 ORDER BY `unit` DESC [ RunTime:0.010965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13178427 LIMIT 2 [ RunTime:0.017265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13178427 ORDER BY `minOrder` ASC [ RunTime:0.006595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13324187 LIMIT 5 [ RunTime:0.006192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13324187 ORDER BY `minOrder` ASC [ RunTime:0.010099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13324187 ORDER BY `unit` DESC [ RunTime:0.006312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13324187 LIMIT 2 [ RunTime:0.002463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13324187 ORDER BY `minOrder` ASC [ RunTime:0.001903s ]
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 '2111%' OR `brand` LIKE '2111%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32283933 LIMIT 5 [ RunTime:0.002044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283933 ORDER BY `minOrder` ASC [ RunTime:0.019152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32283933 ORDER BY `unit` DESC [ RunTime:0.008468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32283933 LIMIT 2 [ RunTime:0.006940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32283933 ORDER BY `minOrder` ASC [ RunTime:0.012769s ]
select * from pdf where partno='2111h 10 c3' and brandshort='volex' limit 1 [ RunTime:0.011334s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111h 10 c3' OR `brand` LIKE 'volex%' ) ) LIMIT 1 [ RunTime:0.006349s ]
SELECT `id` FROM `stock` WHERE `id` <> 32283933 AND `partno` = '2111h 10 c3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%volex%' ) [ RunTime:0.013275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51092448 LIMIT 5 [ RunTime:0.009495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51092448 ORDER BY `minOrder` ASC [ RunTime:0.016273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51092448 ORDER BY `unit` DESC [ RunTime:0.023322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51092448 LIMIT 2 [ RunTime:0.014147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51092448 ORDER BY `minOrder` ASC [ RunTime:0.003623s ]
select * from pdf where partno='2111a3' and brandshort='vcc' limit 1 [ RunTime:0.022820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111a3' OR `brand` LIKE 'vcc%' ) ) LIMIT 1 [ RunTime:0.022773s ]
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 '2111%' OR `brand` LIKE '2111%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64222685 LIMIT 5 [ RunTime:0.011788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222685 ORDER BY `minOrder` ASC [ RunTime:0.017225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64222685 ORDER BY `unit` DESC [ RunTime:0.012379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64222685 LIMIT 2 [ RunTime:0.012788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64222685 ORDER BY `minOrder` ASC [ RunTime:0.010310s ]
select * from pdf where partno='2111400100' and brandshort='Molex' limit 1 [ RunTime:0.016981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111400100' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.054125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59358474 LIMIT 5 [ RunTime:0.009976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358474 ORDER BY `minOrder` ASC [ RunTime:0.007133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59358474 ORDER BY `unit` DESC [ RunTime:0.032263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59358474 LIMIT 2 [ RunTime:0.029135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358474 ORDER BY `minOrder` ASC [ RunTime:0.003841s ]
select * from pdf where partno='2111760080' and brandshort='Molex' limit 1 [ RunTime:0.034793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111760080' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59358475 LIMIT 5 [ RunTime:0.023316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358475 ORDER BY `minOrder` ASC [ RunTime:0.026312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59358475 ORDER BY `unit` DESC [ RunTime:0.034475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59358475 LIMIT 2 [ RunTime:0.021907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59358475 ORDER BY `minOrder` ASC [ RunTime:0.013680s ]
select * from pdf where partno='2111750080' and brandshort='Molex' limit 1 [ RunTime:0.014391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111750080' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.026090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59452837 LIMIT 5 [ RunTime:0.016059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452837 ORDER BY `minOrder` ASC [ RunTime:0.008348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59452837 ORDER BY `unit` DESC [ RunTime:0.020741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59452837 LIMIT 2 [ RunTime:0.009795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59452837 ORDER BY `minOrder` ASC [ RunTime:0.005206s ]
select * from pdf where partno='2111-1X04G00SB' and brandshort='Oupiin' limit 1 [ RunTime:0.002692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-1X04G00SB' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.017133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40469131 LIMIT 5 [ RunTime:0.006096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40469131 ORDER BY `minOrder` ASC [ RunTime:0.010045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40469131 ORDER BY `unit` DESC [ RunTime:0.008988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40469131 LIMIT 2 [ RunTime:0.001489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40469131 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
select * from pdf where partno='2111-H-RC' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.010515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-H-RC' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001005s ]
SELECT `id` FROM `stock` WHERE `id` <> 40469131 AND `partno` = '2111-H-RC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.014586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14290259 [ RunTime:0.010692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59454001 LIMIT 5 [ RunTime:0.010839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59454001 ORDER BY `minOrder` ASC [ RunTime:0.014243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59454001 ORDER BY `unit` DESC [ RunTime:0.018704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59454001 LIMIT 2 [ RunTime:0.011205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59454001 ORDER BY `minOrder` ASC [ RunTime:0.002517s ]
select * from pdf where partno='2111-2X05G00SB' and brandshort='Oupiin' limit 1 [ RunTime:0.013695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-2X05G00SB' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.026351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943906 LIMIT 5 [ RunTime:0.012265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943906 ORDER BY `minOrder` ASC [ RunTime:0.016683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943906 ORDER BY `unit` DESC [ RunTime:0.011903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943906 LIMIT 2 [ RunTime:0.005154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943906 ORDER BY `minOrder` ASC [ RunTime:0.007987s ]
select * from pdf where partno='211150-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.004438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '211150-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.028223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60321865 LIMIT 5 [ RunTime:0.002304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60321865 ORDER BY `minOrder` ASC [ RunTime:0.019117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60321865 ORDER BY `unit` DESC [ RunTime:0.007141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60321865 LIMIT 2 [ RunTime:0.028288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60321865 ORDER BY `minOrder` ASC [ RunTime:0.006665s ]
select * from pdf where partno='2111-2-00-01-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-2-00-01-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.002657s ]
SELECT `id` FROM `stock` WHERE `id` <> 60321865 AND `partno` = '2111-2-00-01-00-00-07-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.015677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520105 [ RunTime:0.000796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60321933 LIMIT 5 [ RunTime:0.020323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60321933 ORDER BY `minOrder` ASC [ RunTime:0.010108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60321933 ORDER BY `unit` DESC [ RunTime:0.019241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60321933 LIMIT 2 [ RunTime:0.038816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60321933 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
select * from pdf where partno='2111-1-00-50-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.008563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-1-00-50-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.003332s ]
SELECT `id` FROM `stock` WHERE `id` <> 60321933 AND `partno` = '2111-1-00-50-00-00-07-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.011975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520150 [ RunTime:0.021308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60350504 LIMIT 5 [ RunTime:0.017275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60350504 ORDER BY `minOrder` ASC [ RunTime:0.009979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60350504 ORDER BY `unit` DESC [ RunTime:0.013657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60350504 LIMIT 2 [ RunTime:0.024485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60350504 ORDER BY `minOrder` ASC [ RunTime:0.012779s ]
select * from pdf where partno='211159-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.017597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '211159-1' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.023689s ]
SELECT `id` FROM `stock` WHERE `id` <> 60350504 AND `partno` = '211159-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.013231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59547011 LIMIT 5 [ RunTime:0.012730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59547011 ORDER BY `minOrder` ASC [ RunTime:0.015433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59547011 ORDER BY `unit` DESC [ RunTime:0.008119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59547011 LIMIT 2 [ RunTime:0.024641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59547011 ORDER BY `minOrder` ASC [ RunTime:0.012535s ]
select * from pdf where partno='2111-1X40G00SB' and brandshort='Oupiin' limit 1 [ RunTime:0.018445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-1X40G00SB' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.004370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60321869 LIMIT 5 [ RunTime:0.019135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60321869 ORDER BY `minOrder` ASC [ RunTime:0.022524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60321869 ORDER BY `unit` DESC [ RunTime:0.051472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60321869 LIMIT 2 [ RunTime:0.038498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60321869 ORDER BY `minOrder` ASC [ RunTime:0.002702s ]
select * from pdf where partno='2111-2-00-44-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-2-00-44-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.025170s ]
SELECT `id` FROM `stock` WHERE `id` <> 60321869 AND `partno` = '2111-2-00-44-00-00-07-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.048426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520136 [ RunTime:0.015837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60596804 LIMIT 5 [ RunTime:0.026571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60596804 ORDER BY `minOrder` ASC [ RunTime:0.039836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60596804 ORDER BY `unit` DESC [ RunTime:0.024196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60596804 LIMIT 2 [ RunTime:0.007813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60596804 ORDER BY `minOrder` ASC [ RunTime:0.006707s ]
select * from pdf where partno='211149-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.033930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '211149-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.030053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59966765 LIMIT 5 [ RunTime:0.006102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59966765 ORDER BY `minOrder` ASC [ RunTime:0.009901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59966765 ORDER BY `unit` DESC [ RunTime:0.024983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59966765 LIMIT 2 [ RunTime:0.010371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59966765 ORDER BY `minOrder` ASC [ RunTime:0.007461s ]
select * from pdf where partno='211103-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '211103-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.014616s ]
SELECT `id` FROM `stock` WHERE `id` <> 59966765 AND `partno` = '211103-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.036744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11737118 [ RunTime:0.026991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60321885 LIMIT 5 [ RunTime:0.000893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60321885 ORDER BY `minOrder` ASC [ RunTime:0.021855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60321885 ORDER BY `unit` DESC [ RunTime:0.040535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60321885 LIMIT 2 [ RunTime:0.019359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60321885 ORDER BY `minOrder` ASC [ RunTime:0.005421s ]
select * from pdf where partno='2111-2-00-80-00-00-07-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.011600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-2-00-80-00-00-07-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.005470s ]
SELECT `id` FROM `stock` WHERE `id` <> 60321885 AND `partno` = '2111-2-00-80-00-00-07-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.010080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11419073 [ RunTime:0.027372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63396210 LIMIT 5 [ RunTime:0.021896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63396210 ORDER BY `minOrder` ASC [ RunTime:0.015612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63396210 ORDER BY `unit` DESC [ RunTime:0.013181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63396210 LIMIT 2 [ RunTime:0.002712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63396210 ORDER BY `minOrder` ASC [ RunTime:0.000878s ]
select * from pdf where partno='2111-440-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-440-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000900s ]
SELECT `id` FROM `stock` WHERE `id` <> 63396210 AND `partno` = '2111-440-AL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.004796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13317994 [ RunTime:0.000946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59966762 LIMIT 5 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59966762 ORDER BY `minOrder` ASC [ RunTime:0.019959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59966762 ORDER BY `unit` DESC [ RunTime:0.000967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59966762 LIMIT 2 [ RunTime:0.001548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59966762 ORDER BY `minOrder` ASC [ RunTime:0.010550s ]
select * from pdf where partno='211102-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '211102-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003823s ]
SELECT `id` FROM `stock` WHERE `id` <> 59966762 AND `partno` = '211102-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.018863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63396220 LIMIT 5 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63396220 ORDER BY `minOrder` ASC [ RunTime:0.000780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63396220 ORDER BY `unit` DESC [ RunTime:0.007895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63396220 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63396220 ORDER BY `minOrder` ASC [ RunTime:0.002603s ]
select * from pdf where partno='2111-440-AL-7' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-440-AL-7' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.003506s ]
SELECT `id` FROM `stock` WHERE `id` <> 63396220 AND `partno` = '2111-440-AL-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.015030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12041831 [ RunTime:0.015366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60596628 LIMIT 5 [ RunTime:0.011017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60596628 ORDER BY `minOrder` ASC [ RunTime:0.027155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60596628 ORDER BY `unit` DESC [ RunTime:0.013040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60596628 LIMIT 2 [ RunTime:0.024914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60596628 ORDER BY `minOrder` ASC [ RunTime:0.006910s ]
select * from pdf where partno='211149-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '211149-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.017703s ]
SELECT `id` FROM `stock` WHERE `id` <> 60596628 AND `partno` = '211149-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.016640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11389472 [ RunTime:0.009198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40475241 LIMIT 5 [ RunTime:0.023335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475241 ORDER BY `minOrder` ASC [ RunTime:0.010573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40475241 ORDER BY `unit` DESC [ RunTime:0.003822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40475241 LIMIT 2 [ RunTime:0.002772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40475241 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
select * from pdf where partno='2111-V-RC' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.002237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2111-V-RC' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.007317s ]
SELECT `id` FROM `stock` WHERE `id` <> 40475241 AND `partno` = '2111-V-RC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.004070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13413285 [ RunTime:0.000761s ]
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 '2111%' OR `brand` LIKE '2111%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014047s ]
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 '2111%' OR `brand` LIKE '2111%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015851s ]
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 '2111%' OR `brand` LIKE '2111%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001854s ]
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 '2111%' OR `brand` LIKE '2111%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003728s ]
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 '2111%' OR `brand` LIKE '2111%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022518s ]
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 '2111%' OR `brand` LIKE '2111%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006447s ]
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 '2111%' OR `brand` LIKE '2111%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012912s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2111%' OR `brand` LIKE '2111%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007194s ]