SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001318s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.113' , `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=MC16&search=1' [ RunTime:0.005511s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001936s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003495s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002431s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.113' ) [ RunTime:0.004277s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002159s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002238s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002146s ]
SELECT * FROM `stock_search` WHERE `partno` = 'MC16' LIMIT 1 [ RunTime:0.024653s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-06 22:39:24' WHERE `partno` = 'MC16' [ RunTime:0.015477s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003935s ]
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 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012343s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14234459 LIMIT 5 [ RunTime:0.001555s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14234459 ORDER BY `minOrder` ASC [ RunTime:0.004140s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14234459 ORDER BY `unit` DESC [ RunTime:0.014490s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14234459 LIMIT 2 [ RunTime:0.005898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14234459 ORDER BY `minOrder` ASC [ RunTime:0.001528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14234458 LIMIT 5 [ RunTime:0.004274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14234458 ORDER BY `minOrder` ASC [ RunTime:0.000669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14234458 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14234458 LIMIT 2 [ RunTime:0.002022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14234458 ORDER BY `minOrder` ASC [ RunTime:0.001781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16091335 LIMIT 5 [ RunTime:0.011469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16091335 ORDER BY `minOrder` ASC [ RunTime:0.004890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16091335 ORDER BY `unit` DESC [ RunTime:0.008488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16091335 LIMIT 2 [ RunTime:0.004321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16091335 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19191818 LIMIT 5 [ RunTime:0.006268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19191818 ORDER BY `minOrder` ASC [ RunTime:0.000619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19191818 ORDER BY `unit` DESC [ RunTime:0.006318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19191818 LIMIT 2 [ RunTime:0.009144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19191818 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15329557 LIMIT 5 [ RunTime:0.003030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15329557 ORDER BY `minOrder` ASC [ RunTime:0.015017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15329557 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15329557 LIMIT 2 [ RunTime:0.011384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15329557 ORDER BY `minOrder` ASC [ RunTime:0.006739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19206889 LIMIT 5 [ RunTime:0.002355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19206889 ORDER BY `minOrder` ASC [ RunTime:0.003682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19206889 ORDER BY `unit` DESC [ RunTime:0.016281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19206889 LIMIT 2 [ RunTime:0.010506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19206889 ORDER BY `minOrder` ASC [ RunTime:0.003619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14241787 LIMIT 5 [ RunTime:0.023470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14241787 ORDER BY `minOrder` ASC [ RunTime:0.023558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14241787 ORDER BY `unit` DESC [ RunTime:0.047098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14241787 LIMIT 2 [ RunTime:0.026620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14241787 ORDER BY `minOrder` ASC [ RunTime:0.022756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255684 LIMIT 5 [ RunTime:0.033503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19255684 ORDER BY `minOrder` ASC [ RunTime:0.017276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19255684 ORDER BY `unit` DESC [ RunTime:0.014243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19255684 LIMIT 2 [ RunTime:0.022207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19255684 ORDER BY `minOrder` ASC [ RunTime:0.027121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15329558 LIMIT 5 [ RunTime:0.014372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15329558 ORDER BY `minOrder` ASC [ RunTime:0.046810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15329558 ORDER BY `unit` DESC [ RunTime:0.017504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15329558 LIMIT 2 [ RunTime:0.009362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15329558 ORDER BY `minOrder` ASC [ RunTime:0.003009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19193631 LIMIT 5 [ RunTime:0.025887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19193631 ORDER BY `minOrder` ASC [ RunTime:0.015125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19193631 ORDER BY `unit` DESC [ RunTime:0.024853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19193631 LIMIT 2 [ RunTime:0.023910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19193631 ORDER BY `minOrder` ASC [ RunTime:0.014653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16091338 LIMIT 5 [ RunTime:0.004861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16091338 ORDER BY `minOrder` ASC [ RunTime:0.048524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16091338 ORDER BY `unit` DESC [ RunTime:0.016835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16091338 LIMIT 2 [ RunTime:0.003986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16091338 ORDER BY `minOrder` ASC [ RunTime:0.003026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19176039 LIMIT 5 [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19176039 ORDER BY `minOrder` ASC [ RunTime:0.001724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19176039 ORDER BY `unit` DESC [ RunTime:0.002319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19176039 LIMIT 2 [ RunTime:0.001345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19176039 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16105886 LIMIT 5 [ RunTime:0.004226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16105886 ORDER BY `minOrder` ASC [ RunTime:0.006773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16105886 ORDER BY `unit` DESC [ RunTime:0.010627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16105886 LIMIT 2 [ RunTime:0.005866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16105886 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16098018 LIMIT 5 [ RunTime:0.004490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16098018 ORDER BY `minOrder` ASC [ RunTime:0.000681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16098018 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16098018 LIMIT 2 [ RunTime:0.002596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16098018 ORDER BY `minOrder` ASC [ RunTime:0.003460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17103135 LIMIT 5 [ RunTime:0.008200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17103135 ORDER BY `minOrder` ASC [ RunTime:0.014046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17103135 ORDER BY `unit` DESC [ RunTime:0.001080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17103135 LIMIT 2 [ RunTime:0.009499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17103135 ORDER BY `minOrder` ASC [ RunTime:0.009164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255678 LIMIT 5 [ RunTime:0.004719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19255678 ORDER BY `minOrder` ASC [ RunTime:0.008805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19255678 ORDER BY `unit` DESC [ RunTime:0.000838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19255678 LIMIT 2 [ RunTime:0.002945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19255678 ORDER BY `minOrder` ASC [ RunTime:0.015455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12414218 LIMIT 5 [ RunTime:0.001619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12414218 ORDER BY `minOrder` ASC [ RunTime:0.008557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12414218 ORDER BY `unit` DESC [ RunTime:0.012224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12414218 LIMIT 2 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12414218 ORDER BY `minOrder` ASC [ RunTime:0.003117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17277359 LIMIT 5 [ RunTime:0.002362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17277359 ORDER BY `minOrder` ASC [ RunTime:0.005252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17277359 ORDER BY `unit` DESC [ RunTime:0.000431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17277359 LIMIT 2 [ RunTime:0.006421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17277359 ORDER BY `minOrder` ASC [ RunTime:0.002906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17277358 LIMIT 5 [ RunTime:0.005292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17277358 ORDER BY `minOrder` ASC [ RunTime:0.010036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17277358 ORDER BY `unit` DESC [ RunTime:0.008275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17277358 LIMIT 2 [ RunTime:0.005760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17277358 ORDER BY `minOrder` ASC [ RunTime:0.005859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17276427 LIMIT 5 [ RunTime:0.000821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17276427 ORDER BY `minOrder` ASC [ RunTime:0.007626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17276427 ORDER BY `unit` DESC [ RunTime:0.015640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17276427 LIMIT 2 [ RunTime:0.045340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17276427 ORDER BY `minOrder` ASC [ RunTime:0.006346s ]
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 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51122298 LIMIT 5 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51122298 ORDER BY `minOrder` ASC [ RunTime:0.010269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51122298 ORDER BY `unit` DESC [ RunTime:0.007203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51122298 LIMIT 2 [ RunTime:0.018762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51122298 ORDER BY `minOrder` ASC [ RunTime:0.003203s ]
select * from pdf where partno='mc16-0222sm' and brandshort='marki microwave' limit 1 [ RunTime:0.014231s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mc16-0222sm' OR `brand` LIKE 'marki microwave%' ) ) LIMIT 1 [ RunTime:0.007994s ]
SELECT `id` FROM `stock` WHERE `id` <> 51122298 AND `partno` = 'mc16-0222sm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%marki microwave%' ) [ RunTime:0.016531s ]
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 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63820906 LIMIT 5 [ RunTime:0.001244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820906 ORDER BY `minOrder` ASC [ RunTime:0.013129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63820906 ORDER BY `unit` DESC [ RunTime:0.009619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63820906 LIMIT 2 [ RunTime:0.003979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820906 ORDER BY `minOrder` ASC [ RunTime:0.005282s ]
select * from pdf where partno='MC1658D' and brandshort='onsemi' limit 1 [ RunTime:0.014364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1658D' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.042889s ]
SELECT `id` FROM `stock` WHERE `id` <> 63820906 AND `partno` = 'MC1658D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.022140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14234459 [ RunTime:0.013961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63820903 LIMIT 5 [ RunTime:0.004992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820903 ORDER BY `minOrder` ASC [ RunTime:0.002864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63820903 ORDER BY `unit` DESC [ RunTime:0.012458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63820903 LIMIT 2 [ RunTime:0.022036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820903 ORDER BY `minOrder` ASC [ RunTime:0.011117s ]
select * from pdf where partno='MC1658FN' and brandshort='onsemi' limit 1 [ RunTime:0.009625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1658FN' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.020827s ]
SELECT `id` FROM `stock` WHERE `id` <> 63820903 AND `partno` = 'MC1658FN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.036787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14234458 [ RunTime:0.022567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63820908 LIMIT 5 [ RunTime:0.008572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820908 ORDER BY `minOrder` ASC [ RunTime:0.007771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63820908 ORDER BY `unit` DESC [ RunTime:0.007401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63820908 LIMIT 2 [ RunTime:0.006426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820908 ORDER BY `minOrder` ASC [ RunTime:0.025026s ]
select * from pdf where partno='MC1658ML1' and brandshort='onsemi' limit 1 [ RunTime:0.012404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1658ML1' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.029010s ]
SELECT `id` FROM `stock` WHERE `id` <> 63820908 AND `partno` = 'MC1658ML1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.009718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16091335 [ RunTime:0.015774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63793966 LIMIT 5 [ RunTime:0.015905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63793966 ORDER BY `minOrder` ASC [ RunTime:0.020509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63793966 ORDER BY `unit` DESC [ RunTime:0.023990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63793966 LIMIT 2 [ RunTime:0.013133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63793966 ORDER BY `minOrder` ASC [ RunTime:0.008345s ]
select * from pdf where partno='MC1660L' and brandshort='onsemi' limit 1 [ RunTime:0.018818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1660L' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.034736s ]
SELECT `id` FROM `stock` WHERE `id` <> 63793966 AND `partno` = 'MC1660L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.040933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19191818 [ RunTime:0.040283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63794079 LIMIT 5 [ RunTime:0.008812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63794079 ORDER BY `minOrder` ASC [ RunTime:0.017808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63794079 ORDER BY `unit` DESC [ RunTime:0.036032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63794079 LIMIT 2 [ RunTime:0.007381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63794079 ORDER BY `minOrder` ASC [ RunTime:0.008734s ]
select * from pdf where partno='MC1664F' and brandshort='Motorola' limit 1 [ RunTime:0.002997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1664F' OR `brand` LIKE 'Motorola%' ) ) LIMIT 1 [ RunTime:0.036608s ]
SELECT `id` FROM `stock` WHERE `id` <> 63794079 AND `partno` = 'MC1664F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%motorola%' ) [ RunTime:0.029606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15329557 [ RunTime:0.027681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63554638 LIMIT 5 [ RunTime:0.028914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63554638 ORDER BY `minOrder` ASC [ RunTime:0.011870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63554638 ORDER BY `unit` DESC [ RunTime:0.012603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63554638 LIMIT 2 [ RunTime:0.023262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63554638 ORDER BY `minOrder` ASC [ RunTime:0.007434s ]
select * from pdf where partno='MC16Z1CFC25B1' and brandshort='Motorola' limit 1 [ RunTime:0.015847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC16Z1CFC25B1' OR `brand` LIKE 'Motorola%' ) ) LIMIT 1 [ RunTime:0.004929s ]
SELECT `id` FROM `stock` WHERE `id` <> 63554638 AND `partno` = 'MC16Z1CFC25B1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%motorola%' ) [ RunTime:0.002365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19206889 [ RunTime:0.012813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63554532 LIMIT 5 [ RunTime:0.012112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63554532 ORDER BY `minOrder` ASC [ RunTime:0.020094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63554532 ORDER BY `unit` DESC [ RunTime:0.031356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63554532 LIMIT 2 [ RunTime:0.018832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63554532 ORDER BY `minOrder` ASC [ RunTime:0.000705s ]
select * from pdf where partno='MC16Z3BCAG16' and brandshort='Freescale Semiconductor' limit 1 [ RunTime:0.001147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC16Z3BCAG16' OR `brand` LIKE 'Freescale Semiconductor%' ) ) LIMIT 1 [ RunTime:0.008497s ]
SELECT `id` FROM `stock` WHERE `id` <> 63554532 AND `partno` = 'MC16Z3BCAG16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%freescale semiconductor%' ) [ RunTime:0.008511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14241787 [ RunTime:0.004197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63663016 LIMIT 5 [ RunTime:0.011619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663016 ORDER BY `minOrder` ASC [ RunTime:0.008088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63663016 ORDER BY `unit` DESC [ RunTime:0.016507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63663016 LIMIT 2 [ RunTime:0.011867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663016 ORDER BY `minOrder` ASC [ RunTime:0.018646s ]
select * from pdf where partno='MC1651L' and brandshort='onsemi' limit 1 [ RunTime:0.004032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1651L' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.016929s ]
SELECT `id` FROM `stock` WHERE `id` <> 63663016 AND `partno` = 'MC1651L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.002951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255684 [ RunTime:0.013733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63794080 LIMIT 5 [ RunTime:0.008042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63794080 ORDER BY `minOrder` ASC [ RunTime:0.010595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63794080 ORDER BY `unit` DESC [ RunTime:0.005213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63794080 LIMIT 2 [ RunTime:0.003067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63794080 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
select * from pdf where partno='MC1662F' and brandshort='Motorola' limit 1 [ RunTime:0.016989s ]
select foldpath,foldpath2,filename from pdf_file where id=1629608 limit 1 [ RunTime:0.009936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1662F' OR `brand` LIKE 'Motorola%' ) ) LIMIT 1 [ RunTime:0.013622s ]
SELECT `id` FROM `stock` WHERE `id` <> 63794080 AND `partno` = 'MC1662F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%motorola%' ) [ RunTime:0.019207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15329558 [ RunTime:0.032012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63962243 LIMIT 5 [ RunTime:0.015047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63962243 ORDER BY `minOrder` ASC [ RunTime:0.014135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63962243 ORDER BY `unit` DESC [ RunTime:0.011719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63962243 LIMIT 2 [ RunTime:0.011890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63962243 ORDER BY `minOrder` ASC [ RunTime:0.010465s ]
select * from pdf where partno='MC1660F' and brandshort='Motorola' limit 1 [ RunTime:0.021337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1660F' OR `brand` LIKE 'Motorola%' ) ) LIMIT 1 [ RunTime:0.018364s ]
SELECT `id` FROM `stock` WHERE `id` <> 63962243 AND `partno` = 'MC1660F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%motorola%' ) [ RunTime:0.040092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19193631 [ RunTime:0.028394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63820909 LIMIT 5 [ RunTime:0.015139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820909 ORDER BY `minOrder` ASC [ RunTime:0.006894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63820909 ORDER BY `unit` DESC [ RunTime:0.030430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63820909 LIMIT 2 [ RunTime:0.057154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63820909 ORDER BY `minOrder` ASC [ RunTime:0.033374s ]
select * from pdf where partno='MC1658L' and brandshort='onsemi' limit 1 [ RunTime:0.060340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1658L' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.052928s ]
SELECT `id` FROM `stock` WHERE `id` <> 63820909 AND `partno` = 'MC1658L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.023520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16091338 [ RunTime:0.026974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63802152 LIMIT 5 [ RunTime:0.032639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63802152 ORDER BY `minOrder` ASC [ RunTime:0.014917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63802152 ORDER BY `unit` DESC [ RunTime:0.032331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63802152 LIMIT 2 [ RunTime:0.029953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63802152 ORDER BY `minOrder` ASC [ RunTime:0.005109s ]
select * from pdf where partno='MC1670F' and brandshort='Motorola' limit 1 [ RunTime:0.048002s ]
select foldpath,foldpath2,filename from pdf_file where id=1669058 limit 1 [ RunTime:0.002556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1670F' OR `brand` LIKE 'Motorola%' ) ) LIMIT 1 [ RunTime:0.045569s ]
SELECT `id` FROM `stock` WHERE `id` <> 63802152 AND `partno` = 'MC1670F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%motorola%' ) [ RunTime:0.021782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19176039 [ RunTime:0.007366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63554698 LIMIT 5 [ RunTime:0.034770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63554698 ORDER BY `minOrder` ASC [ RunTime:0.022103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63554698 ORDER BY `unit` DESC [ RunTime:0.037825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63554698 LIMIT 2 [ RunTime:0.008732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63554698 ORDER BY `minOrder` ASC [ RunTime:0.024196s ]
select * from pdf where partno='MC16Z1CPV20B1' and brandshort='Motorola' limit 1 [ RunTime:0.006591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC16Z1CPV20B1' OR `brand` LIKE 'Motorola%' ) ) LIMIT 1 [ RunTime:0.024133s ]
SELECT `id` FROM `stock` WHERE `id` <> 63554698 AND `partno` = 'MC16Z1CPV20B1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%motorola%' ) [ RunTime:0.012062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16105886 [ RunTime:0.012750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63794217 LIMIT 5 [ RunTime:0.013237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63794217 ORDER BY `minOrder` ASC [ RunTime:0.030794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63794217 ORDER BY `unit` DESC [ RunTime:0.017120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63794217 LIMIT 2 [ RunTime:0.001737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63794217 ORDER BY `minOrder` ASC [ RunTime:0.001787s ]
select * from pdf where partno='MC1672F' and brandshort='Motorola' limit 1 [ RunTime:0.001122s ]
select foldpath,foldpath2,filename from pdf_file where id=1629608 limit 1 [ RunTime:0.009275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1672F' OR `brand` LIKE 'Motorola%' ) ) LIMIT 1 [ RunTime:0.012866s ]
SELECT `id` FROM `stock` WHERE `id` <> 63794217 AND `partno` = 'MC1672F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%motorola%' ) [ RunTime:0.035249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16098018 [ RunTime:0.015561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63814377 LIMIT 5 [ RunTime:0.003412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63814377 ORDER BY `minOrder` ASC [ RunTime:0.017232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63814377 ORDER BY `unit` DESC [ RunTime:0.031695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63814377 LIMIT 2 [ RunTime:0.024953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63814377 ORDER BY `minOrder` ASC [ RunTime:0.004454s ]
select * from pdf where partno='MC1692L' and brandshort='onsemi' limit 1 [ RunTime:0.008223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1692L' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.023727s ]
SELECT `id` FROM `stock` WHERE `id` <> 63814377 AND `partno` = 'MC1692L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.013770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17103135 [ RunTime:0.032694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63663011 LIMIT 5 [ RunTime:0.005251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663011 ORDER BY `minOrder` ASC [ RunTime:0.026653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63663011 ORDER BY `unit` DESC [ RunTime:0.010786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63663011 LIMIT 2 [ RunTime:0.004855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63663011 ORDER BY `minOrder` ASC [ RunTime:0.000591s ]
select * from pdf where partno='MC1650L' and brandshort='onsemi' limit 1 [ RunTime:0.006739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC1650L' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.021151s ]
SELECT `id` FROM `stock` WHERE `id` <> 63663011 AND `partno` = 'MC1650L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.017570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19255678 [ RunTime:0.004813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825468 LIMIT 5 [ RunTime:0.025066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825468 ORDER BY `minOrder` ASC [ RunTime:0.007700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825468 ORDER BY `unit` DESC [ RunTime:0.011158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825468 LIMIT 2 [ RunTime:0.018557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825468 ORDER BY `minOrder` ASC [ RunTime:0.020896s ]
select * from pdf where partno='MC16MOSRG' and brandshort='Bulgin' limit 1 [ RunTime:0.016490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC16MOSRG' OR `brand` LIKE 'Bulgin%' ) ) LIMIT 1 [ RunTime:0.015806s ]
SELECT `id` FROM `stock` WHERE `id` <> 43825468 AND `partno` = 'MC16MOSRG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bulgin%' ) [ RunTime:0.015881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825477 LIMIT 5 [ RunTime:0.032775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825477 ORDER BY `minOrder` ASC [ RunTime:0.007637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825477 ORDER BY `unit` DESC [ RunTime:0.007716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825477 LIMIT 2 [ RunTime:0.008459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825477 ORDER BY `minOrder` ASC [ RunTime:0.005479s ]
select * from pdf where partno='MC16MOBRG' and brandshort='Bulgin' limit 1 [ RunTime:0.008790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC16MOBRG' OR `brand` LIKE 'Bulgin%' ) ) LIMIT 1 [ RunTime:0.017657s ]
SELECT `id` FROM `stock` WHERE `id` <> 43825477 AND `partno` = 'MC16MOBRG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bulgin%' ) [ RunTime:0.021612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825478 LIMIT 5 [ RunTime:0.010823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825478 ORDER BY `minOrder` ASC [ RunTime:0.002284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825478 ORDER BY `unit` DESC [ RunTime:0.002670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825478 LIMIT 2 [ RunTime:0.013683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825478 ORDER BY `minOrder` ASC [ RunTime:0.012056s ]
select * from pdf where partno='MC16MOBGR' and brandshort='Bulgin' limit 1 [ RunTime:0.010782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC16MOBGR' OR `brand` LIKE 'Bulgin%' ) ) LIMIT 1 [ RunTime:0.010226s ]
SELECT `id` FROM `stock` WHERE `id` <> 43825478 AND `partno` = 'MC16MOBGR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bulgin%' ) [ RunTime:0.014721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43825471 LIMIT 5 [ RunTime:0.018688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825471 ORDER BY `minOrder` ASC [ RunTime:0.010884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43825471 ORDER BY `unit` DESC [ RunTime:0.008726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43825471 LIMIT 2 [ RunTime:0.002995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43825471 ORDER BY `minOrder` ASC [ RunTime:0.003755s ]
select * from pdf where partno='MC16MOSGR' and brandshort='Bulgin' limit 1 [ RunTime:0.011185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC16MOSGR' OR `brand` LIKE 'Bulgin%' ) ) LIMIT 1 [ RunTime:0.022062s ]
SELECT `id` FROM `stock` WHERE `id` <> 43825471 AND `partno` = 'MC16MOSGR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bulgin%' ) [ RunTime:0.015068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12414218 [ RunTime:0.018359s ]
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 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059146s ]
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 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060024s ]
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 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014596s ]
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 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014887s ]
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 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023380s ]
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 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041347s ]
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 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017733s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MC16%' OR `brand` LIKE 'MC16%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022198s ]