SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001256s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=IR2153&search=1' [ RunTime:0.029271s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001362s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.015815s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001626s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.015904s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002060s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002852s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003056s ]
SELECT * FROM `stock_search` WHERE `partno` = 'IR2153' LIMIT 1 [ RunTime:0.044690s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-13 17:32:47' WHERE `partno` = 'IR2153' [ RunTime:0.046595s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001559s ]
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 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040283s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19138009 LIMIT 5 [ RunTime:0.040449s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19138009 ORDER BY `minOrder` ASC [ RunTime:0.017541s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19138009 ORDER BY `unit` DESC [ RunTime:0.045560s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19138009 LIMIT 2 [ RunTime:0.008523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19138009 ORDER BY `minOrder` ASC [ RunTime:0.002298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16071894 LIMIT 5 [ RunTime:0.009058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16071894 ORDER BY `minOrder` ASC [ RunTime:0.004067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16071894 ORDER BY `unit` DESC [ RunTime:0.004124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16071894 LIMIT 2 [ RunTime:0.005276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16071894 ORDER BY `minOrder` ASC [ RunTime:0.003444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16071021 LIMIT 5 [ RunTime:0.013718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16071021 ORDER BY `minOrder` ASC [ RunTime:0.010054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16071021 ORDER BY `unit` DESC [ RunTime:0.015033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16071021 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16071021 ORDER BY `minOrder` ASC [ RunTime:0.001350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15316654 LIMIT 5 [ RunTime:0.021511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15316654 ORDER BY `minOrder` ASC [ RunTime:0.016867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15316654 ORDER BY `unit` DESC [ RunTime:0.005840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15316654 LIMIT 2 [ RunTime:0.010818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15316654 ORDER BY `minOrder` ASC [ RunTime:0.002956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19139814 LIMIT 5 [ RunTime:0.012096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19139814 ORDER BY `minOrder` ASC [ RunTime:0.009912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19139814 ORDER BY `unit` DESC [ RunTime:0.012041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19139814 LIMIT 2 [ RunTime:0.018863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19139814 ORDER BY `minOrder` ASC [ RunTime:0.010827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19139629 LIMIT 5 [ RunTime:0.003270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19139629 ORDER BY `minOrder` ASC [ RunTime:0.001106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19139629 ORDER BY `unit` DESC [ RunTime:0.000447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19139629 LIMIT 2 [ RunTime:0.012514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19139629 ORDER BY `minOrder` ASC [ RunTime:0.002323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15316548 LIMIT 5 [ RunTime:0.010082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15316548 ORDER BY `minOrder` ASC [ RunTime:0.028956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15316548 ORDER BY `unit` DESC [ RunTime:0.008129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15316548 LIMIT 2 [ RunTime:0.003446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15316548 ORDER BY `minOrder` ASC [ RunTime:0.003501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16071050 LIMIT 5 [ RunTime:0.004760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16071050 ORDER BY `minOrder` ASC [ RunTime:0.001414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16071050 ORDER BY `unit` DESC [ RunTime:0.000674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16071050 LIMIT 2 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16071050 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9386 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9386 ORDER BY `minOrder` ASC [ RunTime:0.020545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9386 ORDER BY `unit` DESC [ RunTime:0.004085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9386 LIMIT 2 [ RunTime:0.002698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9386 ORDER BY `minOrder` ASC [ RunTime:0.001731s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IR21531STRPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.015942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19139189 LIMIT 5 [ RunTime:0.003486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19139189 ORDER BY `minOrder` ASC [ RunTime:0.011103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19139189 ORDER BY `unit` DESC [ RunTime:0.002865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19139189 LIMIT 2 [ RunTime:0.003093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19139189 ORDER BY `minOrder` ASC [ RunTime:0.003637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19139188 LIMIT 5 [ RunTime:0.003778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19139188 ORDER BY `minOrder` ASC [ RunTime:0.008898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19139188 ORDER BY `unit` DESC [ RunTime:0.001116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19139188 LIMIT 2 [ RunTime:0.000929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19139188 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19139170 LIMIT 5 [ RunTime:0.001062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19139170 ORDER BY `minOrder` ASC [ RunTime:0.002254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19139170 ORDER BY `unit` DESC [ RunTime:0.004569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19139170 LIMIT 2 [ RunTime:0.025312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19139170 ORDER BY `minOrder` ASC [ RunTime:0.000944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19138812 LIMIT 5 [ RunTime:0.003359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19138812 ORDER BY `minOrder` ASC [ RunTime:0.009792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19138812 ORDER BY `unit` DESC [ RunTime:0.004720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19138812 LIMIT 2 [ RunTime:0.006682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19138812 ORDER BY `minOrder` ASC [ RunTime:0.001642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19138574 LIMIT 5 [ RunTime:0.001681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19138574 ORDER BY `minOrder` ASC [ RunTime:0.000797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19138574 ORDER BY `unit` DESC [ RunTime:0.008913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19138574 LIMIT 2 [ RunTime:0.004422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19138574 ORDER BY `minOrder` ASC [ RunTime:0.004182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17095910 LIMIT 5 [ RunTime:0.007222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17095910 ORDER BY `minOrder` ASC [ RunTime:0.015075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17095910 ORDER BY `unit` DESC [ RunTime:0.006941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17095910 LIMIT 2 [ RunTime:0.006402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17095910 ORDER BY `minOrder` ASC [ RunTime:0.006544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16071691 LIMIT 5 [ RunTime:0.011720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16071691 ORDER BY `minOrder` ASC [ RunTime:0.009183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16071691 ORDER BY `unit` DESC [ RunTime:0.006673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16071691 LIMIT 2 [ RunTime:0.022204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16071691 ORDER BY `minOrder` ASC [ RunTime:0.005852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16071451 LIMIT 5 [ RunTime:0.001113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16071451 ORDER BY `minOrder` ASC [ RunTime:0.003097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16071451 ORDER BY `unit` DESC [ RunTime:0.002204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16071451 LIMIT 2 [ RunTime:0.011172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16071451 ORDER BY `minOrder` ASC [ RunTime:0.006701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15316566 LIMIT 5 [ RunTime:0.005554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15316566 ORDER BY `minOrder` ASC [ RunTime:0.009205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15316566 ORDER BY `unit` DESC [ RunTime:0.006831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15316566 LIMIT 2 [ RunTime:0.009712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15316566 ORDER BY `minOrder` ASC [ RunTime:0.005677s ]
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 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004611s ]
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 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63859945 LIMIT 5 [ RunTime:0.001929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63859945 ORDER BY `minOrder` ASC [ RunTime:0.004747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63859945 ORDER BY `unit` DESC [ RunTime:0.004403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63859945 LIMIT 2 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63859945 ORDER BY `minOrder` ASC [ RunTime:0.002139s ]
select * from pdf where partno='IR21531DPBF' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.006657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IR21531DPBF' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.004321s ]
SELECT `id` FROM `stock` WHERE `id` <> 63859945 AND `partno` = 'IR21531DPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.019816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19138009 [ RunTime:0.002522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63857995 LIMIT 5 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63857995 ORDER BY `minOrder` ASC [ RunTime:0.024037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63857995 ORDER BY `unit` DESC [ RunTime:0.008601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63857995 LIMIT 2 [ RunTime:0.033775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63857995 ORDER BY `minOrder` ASC [ RunTime:0.004218s ]
select * from pdf where partno='IR21531STRPBF' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.021434s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IR21531STRPBF' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.028467s ]
SELECT `id` FROM `stock` WHERE `id` <> 63857995 AND `partno` = 'IR21531STRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.021560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16071894 [ RunTime:0.017136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63859739 LIMIT 5 [ RunTime:0.015274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63859739 ORDER BY `minOrder` ASC [ RunTime:0.033602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63859739 ORDER BY `unit` DESC [ RunTime:0.016367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63859739 LIMIT 2 [ RunTime:0.005643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63859739 ORDER BY `minOrder` ASC [ RunTime:0.005453s ]
select * from pdf where partno='IR21531DPBF' and brandshort='International Rectifier' limit 1 [ RunTime:0.000773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IR21531DPBF' OR `brand` LIKE 'International Rectifier%' ) ) LIMIT 1 [ RunTime:0.009990s ]
SELECT `id` FROM `stock` WHERE `id` <> 63859739 AND `partno` = 'IR21531DPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%international rectifier%' ) [ RunTime:0.008451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16071021 [ RunTime:0.011050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63858136 LIMIT 5 [ RunTime:0.007398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63858136 ORDER BY `minOrder` ASC [ RunTime:0.015919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63858136 ORDER BY `unit` DESC [ RunTime:0.003223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63858136 LIMIT 2 [ RunTime:0.002515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63858136 ORDER BY `minOrder` ASC [ RunTime:0.015641s ]
select * from pdf where partno='IR2153SPBF' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.016030s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IR2153SPBF' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.002727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63857648 LIMIT 5 [ RunTime:0.006678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63857648 ORDER BY `minOrder` ASC [ RunTime:0.016630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63857648 ORDER BY `unit` DESC [ RunTime:0.003597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63857648 LIMIT 2 [ RunTime:0.004009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63857648 ORDER BY `minOrder` ASC [ RunTime:0.002577s ]
select * from pdf where partno='IR2153PBF' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.003268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IR2153PBF' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000824s ]
SELECT `id` FROM `stock` WHERE `id` <> 63857648 AND `partno` = 'IR2153PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.007040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19139629 [ RunTime:0.001093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63861730 LIMIT 5 [ RunTime:0.003124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63861730 ORDER BY `minOrder` ASC [ RunTime:0.005518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63861730 ORDER BY `unit` DESC [ RunTime:0.012011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63861730 LIMIT 2 [ RunTime:0.001030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63861730 ORDER BY `minOrder` ASC [ RunTime:0.004154s ]
select * from pdf where partno='IR2153D' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.003531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IR2153D' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.002338s ]
SELECT `id` FROM `stock` WHERE `id` <> 63861730 AND `partno` = 'IR2153D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.010570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19138812 [ RunTime:0.003929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63861342 LIMIT 5 [ RunTime:0.011315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63861342 ORDER BY `minOrder` ASC [ RunTime:0.005512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63861342 ORDER BY `unit` DESC [ RunTime:0.006645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63861342 LIMIT 2 [ RunTime:0.007169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63861342 ORDER BY `minOrder` ASC [ RunTime:0.001799s ]
select * from pdf where partno='IR21531D' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.005117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IR21531D' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.000892s ]
SELECT `id` FROM `stock` WHERE `id` <> 63861342 AND `partno` = 'IR21531D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.002755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19138574 [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63860580 LIMIT 5 [ RunTime:0.009127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63860580 ORDER BY `minOrder` ASC [ RunTime:0.012043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63860580 ORDER BY `unit` DESC [ RunTime:0.009859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63860580 LIMIT 2 [ RunTime:0.005903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63860580 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='IR2153STRPBF' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.011778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IR2153STRPBF' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.007409s ]
SELECT `id` FROM `stock` WHERE `id` <> 63860580 AND `partno` = 'IR2153STRPBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.001585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15316548 [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63859737 LIMIT 5 [ RunTime:0.006296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63859737 ORDER BY `minOrder` ASC [ RunTime:0.011163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63859737 ORDER BY `unit` DESC [ RunTime:0.010001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63859737 LIMIT 2 [ RunTime:0.008339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63859737 ORDER BY `minOrder` ASC [ RunTime:0.003839s ]
select * from pdf where partno='IR21531PBF' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.003817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IR21531PBF' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.012441s ]
SELECT `id` FROM `stock` WHERE `id` <> 63859737 AND `partno` = 'IR21531PBF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.006071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19139814 [ RunTime:0.003610s ]
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 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019353s ]
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 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032946s ]
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 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001597s ]
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 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013481s ]
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 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004614s ]
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 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001314s ]
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 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008411s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'IR2153%' OR `brand` LIKE 'IR2153%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018385s ]