SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001696s ]
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=MOC3052S&search=1' [ RunTime:0.004099s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002554s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000534s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001418s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000273s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001264s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003663s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002528s ]
SELECT * FROM `stock_search` WHERE `partno` = 'MOC3052S' LIMIT 1 [ RunTime:0.000850s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-19 13:29:08' WHERE `partno` = 'MOC3052S' [ RunTime:0.005611s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001519s ]
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 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031562s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18696163 LIMIT 5 [ RunTime:0.009740s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18696163 ORDER BY `minOrder` ASC [ RunTime:0.007886s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18696163 ORDER BY `unit` DESC [ RunTime:0.007362s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18696163 LIMIT 2 [ RunTime:0.014690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18696163 ORDER BY `minOrder` ASC [ RunTime:0.002799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20146950 LIMIT 5 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146950 ORDER BY `minOrder` ASC [ RunTime:0.014254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20146950 ORDER BY `unit` DESC [ RunTime:0.038812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20146950 LIMIT 2 [ RunTime:0.038646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146950 ORDER BY `minOrder` ASC [ RunTime:0.014230s ]
select * from pdf where partno='MOC3052SM(UMW)' and brandshort='UMW' limit 1 [ RunTime:0.023029s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SM(UMW)' OR `brand` LIKE 'UMW(友台半导体)%' ) ) LIMIT 1 [ RunTime:0.018562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171777 LIMIT 5 [ RunTime:0.012057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171777 ORDER BY `minOrder` ASC [ RunTime:0.007297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171777 ORDER BY `unit` DESC [ RunTime:0.004098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171777 LIMIT 2 [ RunTime:0.012332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171777 ORDER BY `minOrder` ASC [ RunTime:0.002196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695358 LIMIT 5 [ RunTime:0.007584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695358 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695358 ORDER BY `unit` DESC [ RunTime:0.017082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695358 LIMIT 2 [ RunTime:0.001405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695358 ORDER BY `minOrder` ASC [ RunTime:0.001921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695343 LIMIT 5 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695343 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695343 ORDER BY `unit` DESC [ RunTime:0.012806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695343 LIMIT 2 [ RunTime:0.025149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695343 ORDER BY `minOrder` ASC [ RunTime:0.015082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18696138 LIMIT 5 [ RunTime:0.016958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18696138 ORDER BY `minOrder` ASC [ RunTime:0.006985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18696138 ORDER BY `unit` DESC [ RunTime:0.007530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18696138 LIMIT 2 [ RunTime:0.007197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18696138 ORDER BY `minOrder` ASC [ RunTime:0.003024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18696020 LIMIT 5 [ RunTime:0.006106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18696020 ORDER BY `minOrder` ASC [ RunTime:0.006251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18696020 ORDER BY `unit` DESC [ RunTime:0.022966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18696020 LIMIT 2 [ RunTime:0.004729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18696020 ORDER BY `minOrder` ASC [ RunTime:0.013799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695939 LIMIT 5 [ RunTime:0.017874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695939 ORDER BY `minOrder` ASC [ RunTime:0.006314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695939 ORDER BY `unit` DESC [ RunTime:0.004132s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695939 LIMIT 2 [ RunTime:0.022763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695939 ORDER BY `minOrder` ASC [ RunTime:0.007998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695834 LIMIT 5 [ RunTime:0.005811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695834 ORDER BY `minOrder` ASC [ RunTime:0.004194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695834 ORDER BY `unit` DESC [ RunTime:0.000445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695834 LIMIT 2 [ RunTime:0.003054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695834 ORDER BY `minOrder` ASC [ RunTime:0.006868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695579 LIMIT 5 [ RunTime:0.006324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695579 ORDER BY `minOrder` ASC [ RunTime:0.000976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695579 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695579 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695579 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695570 LIMIT 5 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695570 ORDER BY `minOrder` ASC [ RunTime:0.004226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695570 ORDER BY `unit` DESC [ RunTime:0.001042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695570 LIMIT 2 [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695570 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695519 LIMIT 5 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695519 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695519 ORDER BY `unit` DESC [ RunTime:0.000461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695519 LIMIT 2 [ RunTime:0.001864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695519 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16992609 LIMIT 5 [ RunTime:0.005263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16992609 ORDER BY `minOrder` ASC [ RunTime:0.002924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16992609 ORDER BY `unit` DESC [ RunTime:0.000435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16992609 LIMIT 2 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16992609 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204914 LIMIT 5 [ RunTime:0.000791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204914 ORDER BY `minOrder` ASC [ RunTime:0.000782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204914 ORDER BY `unit` DESC [ RunTime:0.000542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204914 LIMIT 2 [ RunTime:0.006243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204914 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171844 LIMIT 5 [ RunTime:0.001544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171844 ORDER BY `minOrder` ASC [ RunTime:0.001282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171844 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171844 LIMIT 2 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171844 ORDER BY `minOrder` ASC [ RunTime:0.001110s ]
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 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001468s ]
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 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64271274 LIMIT 5 [ RunTime:0.001985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64271274 ORDER BY `minOrder` ASC [ RunTime:0.001641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64271274 ORDER BY `unit` DESC [ RunTime:0.009560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64271274 LIMIT 2 [ RunTime:0.031373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64271274 ORDER BY `minOrder` ASC [ RunTime:0.004854s ]
select * from pdf where partno='MOC3052SR2VM' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.012858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SR2VM' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.006239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270832 LIMIT 5 [ RunTime:0.005840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270832 ORDER BY `minOrder` ASC [ RunTime:0.009772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270832 ORDER BY `unit` DESC [ RunTime:0.020105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270832 LIMIT 2 [ RunTime:0.020984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270832 ORDER BY `minOrder` ASC [ RunTime:0.016498s ]
select * from pdf where partno='MOC3052SM' and brandshort='onsemi' limit 1 [ RunTime:0.013953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.024396s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270832 AND `partno` = 'MOC3052SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.014796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695939 [ RunTime:0.006179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270823 LIMIT 5 [ RunTime:0.010020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270823 ORDER BY `minOrder` ASC [ RunTime:0.006847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270823 ORDER BY `unit` DESC [ RunTime:0.006909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270823 LIMIT 2 [ RunTime:0.031316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270823 ORDER BY `minOrder` ASC [ RunTime:0.015430s ]
select * from pdf where partno='MOC3052S' and brandshort='Lite-On Inc.' limit 1 [ RunTime:0.001446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052S' OR `brand` LIKE 'Lite-On Inc.%' ) ) LIMIT 1 [ RunTime:0.001864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270860 LIMIT 5 [ RunTime:0.005804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270860 ORDER BY `minOrder` ASC [ RunTime:0.007226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270860 ORDER BY `unit` DESC [ RunTime:0.000708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270860 LIMIT 2 [ RunTime:0.002019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270860 ORDER BY `minOrder` ASC [ RunTime:0.000881s ]
select * from pdf where partno='MOC3052SR2VM' and brandshort='onsemi' limit 1 [ RunTime:0.012003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SR2VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.027529s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270860 AND `partno` = 'MOC3052SR2VM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.009335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171777 [ RunTime:0.006152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270826 LIMIT 5 [ RunTime:0.000880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270826 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270826 ORDER BY `unit` DESC [ RunTime:0.005409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270826 LIMIT 2 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270826 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='MOC3052S-TA1' and brandshort='Lite-On Inc.' limit 1 [ RunTime:0.005118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052S-TA1' OR `brand` LIKE 'Lite-On Inc.%' ) ) LIMIT 1 [ RunTime:0.006597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64271229 LIMIT 5 [ RunTime:0.001597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64271229 ORDER BY `minOrder` ASC [ RunTime:0.006114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64271229 ORDER BY `unit` DESC [ RunTime:0.008355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64271229 LIMIT 2 [ RunTime:0.019847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64271229 ORDER BY `minOrder` ASC [ RunTime:0.013323s ]
select * from pdf where partno='MOC3052SR2M' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.020019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SR2M' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64271195 LIMIT 5 [ RunTime:0.003849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64271195 ORDER BY `minOrder` ASC [ RunTime:0.003686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64271195 ORDER BY `unit` DESC [ RunTime:0.020688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64271195 LIMIT 2 [ RunTime:0.008244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64271195 ORDER BY `minOrder` ASC [ RunTime:0.001925s ]
select * from pdf where partno='MOC3052SM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.028042s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.024317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270854 LIMIT 5 [ RunTime:0.011634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270854 ORDER BY `minOrder` ASC [ RunTime:0.023340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270854 ORDER BY `unit` DESC [ RunTime:0.014743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270854 LIMIT 2 [ RunTime:0.026317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270854 ORDER BY `minOrder` ASC [ RunTime:0.009113s ]
select * from pdf where partno='MOC3052SR2M' and brandshort='onsemi' limit 1 [ RunTime:0.036254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SR2M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.025081s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270854 AND `partno` = 'MOC3052SR2M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.027613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695358 [ RunTime:0.038294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64271457 LIMIT 5 [ RunTime:0.032763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64271457 ORDER BY `minOrder` ASC [ RunTime:0.067404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64271457 ORDER BY `unit` DESC [ RunTime:0.096157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64271457 LIMIT 2 [ RunTime:0.017701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64271457 ORDER BY `minOrder` ASC [ RunTime:0.021337s ]
select * from pdf where partno='MOC3052SVM' and brandshort='onsemi' limit 1 [ RunTime:0.049221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SVM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.057459s ]
SELECT `id` FROM `stock` WHERE `id` <> 64271457 AND `partno` = 'MOC3052SVM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.045593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18696020 [ RunTime:0.050977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64272020 LIMIT 5 [ RunTime:0.042947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64272020 ORDER BY `minOrder` ASC [ RunTime:0.074873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64272020 ORDER BY `unit` DESC [ RunTime:0.090522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64272020 LIMIT 2 [ RunTime:0.084885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64272020 ORDER BY `minOrder` ASC [ RunTime:0.045202s ]
select * from pdf where partno='MOC3052SR2VM_F132' and brandshort='onsemi' limit 1 [ RunTime:0.043531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SR2VM_F132' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.030643s ]
SELECT `id` FROM `stock` WHERE `id` <> 64272020 AND `partno` = 'MOC3052SR2VM_F132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.089158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695579 [ RunTime:0.035613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64272019 LIMIT 5 [ RunTime:0.029768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64272019 ORDER BY `minOrder` ASC [ RunTime:0.029850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64272019 ORDER BY `unit` DESC [ RunTime:0.048976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64272019 LIMIT 2 [ RunTime:0.013288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64272019 ORDER BY `minOrder` ASC [ RunTime:0.006012s ]
select * from pdf where partno='MOC3052SR2M_F132' and brandshort='onsemi' limit 1 [ RunTime:0.027361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SR2M_F132' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.055937s ]
SELECT `id` FROM `stock` WHERE `id` <> 64272019 AND `partno` = 'MOC3052SR2M_F132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.032144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204914 [ RunTime:0.094364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64272006 LIMIT 5 [ RunTime:0.044613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64272006 ORDER BY `minOrder` ASC [ RunTime:0.076673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64272006 ORDER BY `unit` DESC [ RunTime:0.062912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64272006 LIMIT 2 [ RunTime:0.034452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64272006 ORDER BY `minOrder` ASC [ RunTime:0.036262s ]
select * from pdf where partno='MOC3052SM_F132' and brandshort='onsemi' limit 1 [ RunTime:0.053683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SM_F132' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.096227s ]
SELECT `id` FROM `stock` WHERE `id` <> 64272006 AND `partno` = 'MOC3052SM_F132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.059641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695570 [ RunTime:0.071352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64271953 LIMIT 5 [ RunTime:0.107735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64271953 ORDER BY `minOrder` ASC [ RunTime:0.159534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64271953 ORDER BY `unit` DESC [ RunTime:0.062819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64271953 LIMIT 2 [ RunTime:0.020254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64271953 ORDER BY `minOrder` ASC [ RunTime:0.003765s ]
select * from pdf where partno='MOC3052SMT&R' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.008180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MOC3052SMT&R' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.038528s ]
SELECT `id` FROM `stock` WHERE `id` <> 64271953 AND `partno` = 'MOC3052SMT&R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.039152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695519 [ RunTime:0.027409s ]
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 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.119605s ]
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 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060983s ]
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 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.080917s ]
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 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044262s ]
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 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.080438s ]
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 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036627s ]
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 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068534s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MOC3052S%' OR `brand` LIKE 'MOC3052S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.034113s ]