SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002416s ]
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=MOC5008&search=1' [ RunTime:0.003031s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002257s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000633s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001215s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002968s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002352s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001927s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002425s ]
SELECT * FROM `stock_search` WHERE `partno` = 'MOC5008' LIMIT 1 [ RunTime:0.007593s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-23 09:23:49' WHERE `partno` = 'MOC5008' [ RunTime:0.004841s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002533s ]
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 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016323s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12157099 LIMIT 5 [ RunTime:0.000796s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157099 ORDER BY `minOrder` ASC [ RunTime:0.007397s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12157099 ORDER BY `unit` DESC [ RunTime:0.011138s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12157099 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12157099 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176298 LIMIT 5 [ RunTime:0.002198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176298 ORDER BY `minOrder` ASC [ RunTime:0.002084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11176298 ORDER BY `unit` DESC [ RunTime:0.001576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11176298 LIMIT 2 [ RunTime:0.007558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176298 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156114 LIMIT 5 [ RunTime:0.001337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156114 ORDER BY `minOrder` ASC [ RunTime:0.002398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12156114 ORDER BY `unit` DESC [ RunTime:0.003065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12156114 LIMIT 2 [ RunTime:0.004275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156114 ORDER BY `minOrder` ASC [ RunTime:0.002848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156097 LIMIT 5 [ RunTime:0.000962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156097 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12156097 ORDER BY `unit` DESC [ RunTime:0.006505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12156097 LIMIT 2 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156097 ORDER BY `minOrder` ASC [ RunTime:0.001909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156094 LIMIT 5 [ RunTime:0.008365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156094 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12156094 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12156094 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12156094 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176355 LIMIT 5 [ RunTime:0.000928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176355 ORDER BY `minOrder` ASC [ RunTime:0.015986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11176355 ORDER BY `unit` DESC [ RunTime:0.000690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11176355 LIMIT 2 [ RunTime:0.001406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176355 ORDER BY `minOrder` ASC [ RunTime:0.003852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176354 LIMIT 5 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176354 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11176354 ORDER BY `unit` DESC [ RunTime:0.001440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11176354 LIMIT 2 [ RunTime:0.032011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176354 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176351 LIMIT 5 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176351 ORDER BY `minOrder` ASC [ RunTime:0.002495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11176351 ORDER BY `unit` DESC [ RunTime:0.019346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11176351 LIMIT 2 [ RunTime:0.006409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176351 ORDER BY `minOrder` ASC [ RunTime:0.001486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176349 LIMIT 5 [ RunTime:0.003311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176349 ORDER BY `minOrder` ASC [ RunTime:0.000982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11176349 ORDER BY `unit` DESC [ RunTime:0.016041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11176349 LIMIT 2 [ RunTime:0.008218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11176349 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
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 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002176s ]
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 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258015 LIMIT 5 [ RunTime:0.002045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258015 ORDER BY `minOrder` ASC [ RunTime:0.003142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258015 ORDER BY `unit` DESC [ RunTime:0.005403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258015 LIMIT 2 [ RunTime:0.015239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258015 ORDER BY `minOrder` ASC [ RunTime:0.018279s ]
select * from pdf where partno='MOC5008' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.004859s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006969s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258015 AND `partno` = 'MOC5008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.001191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12157099 [ RunTime:0.008159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258481 LIMIT 5 [ RunTime:0.003254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258481 ORDER BY `minOrder` ASC [ RunTime:0.008748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258481 ORDER BY `unit` DESC [ RunTime:0.007301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258481 LIMIT 2 [ RunTime:0.001823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258481 ORDER BY `minOrder` ASC [ RunTime:0.004833s ]
select * from pdf where partno='MOC5008SM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.004831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008SM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.007962s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258481 AND `partno` = 'MOC5008SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.005156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176298 [ RunTime:0.000571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258522 LIMIT 5 [ RunTime:0.002934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258522 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258522 ORDER BY `unit` DESC [ RunTime:0.003721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258522 LIMIT 2 [ RunTime:0.003509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258522 ORDER BY `minOrder` ASC [ RunTime:0.003643s ]
select * from pdf where partno='MOC5008G' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.009533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008G' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.007253s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258522 AND `partno` = 'MOC5008G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.006941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258725 LIMIT 5 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258725 ORDER BY `minOrder` ASC [ RunTime:0.005974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258725 ORDER BY `unit` DESC [ RunTime:0.001022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258725 LIMIT 2 [ RunTime:0.006185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258725 ORDER BY `minOrder` ASC [ RunTime:0.001689s ]
select * from pdf where partno='MOC5008FVM' and brandshort='onsemi' limit 1 [ RunTime:0.006842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008FVM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.008791s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258725 AND `partno` = 'MOC5008FVM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.003337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176355 [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258724 LIMIT 5 [ RunTime:0.011294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258724 ORDER BY `minOrder` ASC [ RunTime:0.004598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258724 ORDER BY `unit` DESC [ RunTime:0.007085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258724 LIMIT 2 [ RunTime:0.006981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258724 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='MOC5008FM' and brandshort='onsemi' limit 1 [ RunTime:0.000621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008FM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.018643s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258724 AND `partno` = 'MOC5008FM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.006015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176354 [ RunTime:0.006195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258704 LIMIT 5 [ RunTime:0.005996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258704 ORDER BY `minOrder` ASC [ RunTime:0.014942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258704 ORDER BY `unit` DESC [ RunTime:0.009951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258704 LIMIT 2 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258704 ORDER BY `minOrder` ASC [ RunTime:0.008856s ]
select * from pdf where partno='MOC5008VM' and brandshort='onsemi' limit 1 [ RunTime:0.012409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.019944s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258704 AND `partno` = 'MOC5008VM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.001301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156114 [ RunTime:0.014198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258703 LIMIT 5 [ RunTime:0.029766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258703 ORDER BY `minOrder` ASC [ RunTime:0.002116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258703 ORDER BY `unit` DESC [ RunTime:0.000549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258703 LIMIT 2 [ RunTime:0.004034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258703 ORDER BY `minOrder` ASC [ RunTime:0.016121s ]
select * from pdf where partno='MOC5008TVM' and brandshort='onsemi' limit 1 [ RunTime:0.004179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008TVM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.029175s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258703 AND `partno` = 'MOC5008TVM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.020944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176351 [ RunTime:0.014048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258702 LIMIT 5 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258702 ORDER BY `minOrder` ASC [ RunTime:0.023256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258702 ORDER BY `unit` DESC [ RunTime:0.008550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258702 LIMIT 2 [ RunTime:0.007085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258702 ORDER BY `minOrder` ASC [ RunTime:0.002204s ]
select * from pdf where partno='MOC5008SVM' and brandshort='onsemi' limit 1 [ RunTime:0.005344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008SVM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.026553s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258702 AND `partno` = 'MOC5008SVM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.014146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258701 LIMIT 5 [ RunTime:0.005128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258701 ORDER BY `minOrder` ASC [ RunTime:0.004024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258701 ORDER BY `unit` DESC [ RunTime:0.004379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258701 LIMIT 2 [ RunTime:0.023194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258701 ORDER BY `minOrder` ASC [ RunTime:0.006961s ]
select * from pdf where partno='MOC5008SM' and brandshort='onsemi' limit 1 [ RunTime:0.018018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008SM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.028673s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258701 AND `partno` = 'MOC5008SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.023611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258696 LIMIT 5 [ RunTime:0.000886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258696 ORDER BY `minOrder` ASC [ RunTime:0.007345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258696 ORDER BY `unit` DESC [ RunTime:0.008668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258696 LIMIT 2 [ RunTime:0.003466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258696 ORDER BY `minOrder` ASC [ RunTime:0.002388s ]
select * from pdf where partno='MOC5008M' and brandshort='onsemi' limit 1 [ RunTime:0.023938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.030716s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258696 AND `partno` = 'MOC5008M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11176349 [ RunTime:0.019985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258649 LIMIT 5 [ RunTime:0.004725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258649 ORDER BY `minOrder` ASC [ RunTime:0.010909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258649 ORDER BY `unit` DESC [ RunTime:0.026762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258649 LIMIT 2 [ RunTime:0.010329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258649 ORDER BY `minOrder` ASC [ RunTime:0.007792s ]
select * from pdf where partno='MOC5008SR2VM' and brandshort='onsemi' limit 1 [ RunTime:0.002220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008SR2VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.013052s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258649 AND `partno` = 'MOC5008SR2VM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.001465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156097 [ RunTime:0.002010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64258647 LIMIT 5 [ RunTime:0.000574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258647 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64258647 ORDER BY `unit` DESC [ RunTime:0.000932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64258647 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64258647 ORDER BY `minOrder` ASC [ RunTime:0.001585s ]
select * from pdf where partno='MOC5008SMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.006243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC5008SMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.002380s ]
SELECT `id` FROM `stock` WHERE `id` <> 64258647 AND `partno` = 'MOC5008SMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.003972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12156094 [ RunTime:0.005612s ]
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 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015280s ]
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 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008165s ]
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 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017249s ]
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 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001162s ]
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 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031744s ]
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 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013988s ]
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 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016265s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MOC5008%' OR `brand` LIKE 'MOC5008%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000933s ]