SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001475s ]
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=MOCD207&search=1' [ RunTime:0.001681s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001260s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001874s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002123s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002417s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001114s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001665s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001440s ]
SELECT * FROM `stock_search` WHERE `partno` = 'MOCD207' LIMIT 1 [ RunTime:0.018997s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-26 22:23:23' WHERE `partno` = 'MOCD207' [ RunTime:0.023830s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001364s ]
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 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038788s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.027703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991285 LIMIT 5 [ RunTime:0.011084s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991285 ORDER BY `minOrder` ASC [ RunTime:0.020606s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991285 ORDER BY `unit` DESC [ RunTime:0.017882s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991285 LIMIT 2 [ RunTime:0.023802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991285 ORDER BY `minOrder` ASC [ RunTime:0.009915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687911 LIMIT 5 [ RunTime:0.045110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687911 ORDER BY `minOrder` ASC [ RunTime:0.047683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18687911 ORDER BY `unit` DESC [ RunTime:0.069228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18687911 LIMIT 2 [ RunTime:0.055898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18687911 ORDER BY `minOrder` ASC [ RunTime:0.012360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2957 LIMIT 5 [ RunTime:0.016569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2957 ORDER BY `minOrder` ASC [ RunTime:0.029048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2957 ORDER BY `unit` DESC [ RunTime:0.035205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2957 LIMIT 2 [ RunTime:0.037898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2957 ORDER BY `minOrder` ASC [ RunTime:0.011599s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207M.' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.051413s ]
SELECT `id` FROM `stock` WHERE `id` <> 2957 AND `partno` = 'MOCD207M.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.029346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693987 LIMIT 5 [ RunTime:0.041172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693987 ORDER BY `minOrder` ASC [ RunTime:0.014682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693987 ORDER BY `unit` DESC [ RunTime:0.013034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693987 LIMIT 2 [ RunTime:0.007763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693987 ORDER BY `minOrder` ASC [ RunTime:0.011368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204576 LIMIT 5 [ RunTime:0.020789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204576 ORDER BY `minOrder` ASC [ RunTime:0.005521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204576 ORDER BY `unit` DESC [ RunTime:0.005156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204576 LIMIT 2 [ RunTime:0.007819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204576 ORDER BY `minOrder` ASC [ RunTime:0.013824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693326 LIMIT 5 [ RunTime:0.013909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693326 ORDER BY `minOrder` ASC [ RunTime:0.009865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693326 ORDER BY `unit` DESC [ RunTime:0.009620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693326 LIMIT 2 [ RunTime:0.011127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693326 ORDER BY `minOrder` ASC [ RunTime:0.004412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694364 LIMIT 5 [ RunTime:0.033258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694364 ORDER BY `minOrder` ASC [ RunTime:0.006328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694364 ORDER BY `unit` DESC [ RunTime:0.012805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694364 LIMIT 2 [ RunTime:0.011777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694364 ORDER BY `minOrder` ASC [ RunTime:0.002317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693782 LIMIT 5 [ RunTime:0.003468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693782 ORDER BY `minOrder` ASC [ RunTime:0.032125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693782 ORDER BY `unit` DESC [ RunTime:0.023651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693782 LIMIT 2 [ RunTime:0.001000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693782 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693686 LIMIT 5 [ RunTime:0.000952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693686 ORDER BY `minOrder` ASC [ RunTime:0.001402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693686 ORDER BY `unit` DESC [ RunTime:0.002720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693686 LIMIT 2 [ RunTime:0.002526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693686 ORDER BY `minOrder` ASC [ RunTime:0.005726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693667 LIMIT 5 [ RunTime:0.008795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693667 ORDER BY `minOrder` ASC [ RunTime:0.003176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693667 ORDER BY `unit` DESC [ RunTime:0.016093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693667 LIMIT 2 [ RunTime:0.019199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693667 ORDER BY `minOrder` ASC [ RunTime:0.011719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690328 LIMIT 5 [ RunTime:0.007059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690328 ORDER BY `minOrder` ASC [ RunTime:0.009155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690328 ORDER BY `unit` DESC [ RunTime:0.011136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690328 LIMIT 2 [ RunTime:0.034726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690328 ORDER BY `minOrder` ASC [ RunTime:0.020228s ]
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 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005806s ]
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 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64259687 LIMIT 5 [ RunTime:0.009077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64259687 ORDER BY `minOrder` ASC [ RunTime:0.011670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64259687 ORDER BY `unit` DESC [ RunTime:0.011516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64259687 LIMIT 2 [ RunTime:0.007692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64259687 ORDER BY `minOrder` ASC [ RunTime:0.019032s ]
select * from pdf where partno='MOCD207M' and brandshort='onsemi' limit 1 [ RunTime:0.013054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.021270s ]
SELECT `id` FROM `stock` WHERE `id` <> 64259687 AND `partno` = 'MOCD207M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.012013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18687911 [ RunTime:0.018143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64260280 LIMIT 5 [ RunTime:0.019062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260280 ORDER BY `minOrder` ASC [ RunTime:0.048822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64260280 ORDER BY `unit` DESC [ RunTime:0.021535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64260280 LIMIT 2 [ RunTime:0.027482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260280 ORDER BY `minOrder` ASC [ RunTime:0.006558s ]
select * from pdf where partno='MOCD207R2VM' and brandshort='onsemi' limit 1 [ RunTime:0.013718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207R2VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.042101s ]
SELECT `id` FROM `stock` WHERE `id` <> 64260280 AND `partno` = 'MOCD207R2VM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.013110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693987 [ RunTime:0.014895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64260195 LIMIT 5 [ RunTime:0.014133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260195 ORDER BY `minOrder` ASC [ RunTime:0.008276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64260195 ORDER BY `unit` DESC [ RunTime:0.017189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64260195 LIMIT 2 [ RunTime:0.006780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260195 ORDER BY `minOrder` ASC [ RunTime:0.005511s ]
select * from pdf where partno='MOCD207' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.013617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.014393s ]
SELECT `id` FROM `stock` WHERE `id` <> 64260195 AND `partno` = 'MOCD207' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.003313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693326 [ RunTime:0.008752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64260365 LIMIT 5 [ RunTime:0.011472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260365 ORDER BY `minOrder` ASC [ RunTime:0.016650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64260365 ORDER BY `unit` DESC [ RunTime:0.005571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64260365 LIMIT 2 [ RunTime:0.013486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260365 ORDER BY `minOrder` ASC [ RunTime:0.001913s ]
select * from pdf where partno='MOCD207D2M' and brandshort='onsemi' limit 1 [ RunTime:0.021998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207D2M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.040548s ]
SELECT `id` FROM `stock` WHERE `id` <> 64260365 AND `partno` = 'MOCD207D2M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.012313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204576 [ RunTime:0.007970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64261799 LIMIT 5 [ RunTime:0.015245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64261799 ORDER BY `minOrder` ASC [ RunTime:0.016024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64261799 ORDER BY `unit` DESC [ RunTime:0.013719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64261799 LIMIT 2 [ RunTime:0.015066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64261799 ORDER BY `minOrder` ASC [ RunTime:0.018336s ]
select * from pdf where partno='MOCD207VM' and brandshort='onsemi' limit 1 [ RunTime:0.048226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.030327s ]
SELECT `id` FROM `stock` WHERE `id` <> 64261799 AND `partno` = 'MOCD207VM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.042259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690328 [ RunTime:0.019254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64268131 LIMIT 5 [ RunTime:0.020201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64268131 ORDER BY `minOrder` ASC [ RunTime:0.041393s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64268131 ORDER BY `unit` DESC [ RunTime:0.014800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64268131 LIMIT 2 [ RunTime:0.019705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64268131 ORDER BY `minOrder` ASC [ RunTime:0.036202s ]
select * from pdf where partno='MOCD207R1M_F132' and brandshort='onsemi' limit 1 [ RunTime:0.034179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207R1M_F132' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.035394s ]
SELECT `id` FROM `stock` WHERE `id` <> 64268131 AND `partno` = 'MOCD207R1M_F132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.033284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693782 [ RunTime:0.020958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64268026 LIMIT 5 [ RunTime:0.029159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64268026 ORDER BY `minOrder` ASC [ RunTime:0.078659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64268026 ORDER BY `unit` DESC [ RunTime:0.080305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64268026 LIMIT 2 [ RunTime:0.092917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64268026 ORDER BY `minOrder` ASC [ RunTime:0.031076s ]
select * from pdf where partno='MOCD207R2M_F132' and brandshort='onsemi' limit 1 [ RunTime:0.032289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207R2M_F132' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.116548s ]
SELECT `id` FROM `stock` WHERE `id` <> 64268026 AND `partno` = 'MOCD207R2M_F132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.035976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693686 [ RunTime:0.038252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267936 LIMIT 5 [ RunTime:0.022070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267936 ORDER BY `minOrder` ASC [ RunTime:0.023087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267936 ORDER BY `unit` DESC [ RunTime:0.027135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267936 LIMIT 2 [ RunTime:0.035503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267936 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
select * from pdf where partno='MOCD207M_F132' and brandshort='onsemi' limit 1 [ RunTime:0.025781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207M_F132' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.098663s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267936 AND `partno` = 'MOCD207M_F132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.062195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693667 [ RunTime:0.014134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267378 LIMIT 5 [ RunTime:0.032245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267378 ORDER BY `minOrder` ASC [ RunTime:0.011161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267378 ORDER BY `unit` DESC [ RunTime:0.018119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267378 LIMIT 2 [ RunTime:0.032780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267378 ORDER BY `minOrder` ASC [ RunTime:0.047866s ]
select * from pdf where partno='MOCD207R1M' and brandshort='onsemi' limit 1 [ RunTime:0.038622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207R1M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.068009s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267378 AND `partno` = 'MOCD207R1M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.036029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694364 [ RunTime:0.047786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64263594 LIMIT 5 [ RunTime:0.040326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263594 ORDER BY `minOrder` ASC [ RunTime:0.040152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64263594 ORDER BY `unit` DESC [ RunTime:0.011799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64263594 LIMIT 2 [ RunTime:0.045405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64263594 ORDER BY `minOrder` ASC [ RunTime:0.011368s ]
select * from pdf where partno='MOCD207R2M' and brandshort='onsemi' limit 1 [ RunTime:0.038737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOCD207R2M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.091086s ]
SELECT `id` FROM `stock` WHERE `id` <> 64263594 AND `partno` = 'MOCD207R2M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.054358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991285 [ RunTime:0.042942s ]
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 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054487s ]
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 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050995s ]
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 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048316s ]
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 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014479s ]
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 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041012s ]
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 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029156s ]
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 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051211s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MOCD207%' OR `brand` LIKE 'MOCD207%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009479s ]