SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002170s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=SM6T22A&search=1' [ RunTime:0.005568s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003071s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004220s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002778s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.001649s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002374s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007376s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002496s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SM6T22A' LIMIT 1 [ RunTime:0.014806s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-18 05:11:46' WHERE `partno` = 'SM6T22A' [ RunTime:0.023929s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002689s ]
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 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027163s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805715 LIMIT 5 [ RunTime:0.022163s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805715 ORDER BY `minOrder` ASC [ RunTime:0.016922s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14805715 ORDER BY `unit` DESC [ RunTime:0.036012s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14805715 LIMIT 2 [ RunTime:0.051288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14805715 ORDER BY `minOrder` ASC [ RunTime:0.025181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833997 LIMIT 5 [ RunTime:0.040525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833997 ORDER BY `minOrder` ASC [ RunTime:0.042420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14833997 ORDER BY `unit` DESC [ RunTime:0.065720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14833997 LIMIT 2 [ RunTime:0.063194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14833997 ORDER BY `minOrder` ASC [ RunTime:0.010657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664855 LIMIT 5 [ RunTime:0.037970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664855 ORDER BY `minOrder` ASC [ RunTime:0.032639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16664855 ORDER BY `unit` DESC [ RunTime:0.097418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16664855 LIMIT 2 [ RunTime:0.050032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16664855 ORDER BY `minOrder` ASC [ RunTime:0.024809s ]
select * from pdf where partno='SM6T22A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.027681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16692241 LIMIT 5 [ RunTime:0.030418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692241 ORDER BY `minOrder` ASC [ RunTime:0.029318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16692241 ORDER BY `unit` DESC [ RunTime:0.068626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16692241 LIMIT 2 [ RunTime:0.013571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16692241 ORDER BY `minOrder` ASC [ RunTime:0.033428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688847 LIMIT 5 [ RunTime:0.002858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688847 ORDER BY `minOrder` ASC [ RunTime:0.019924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688847 ORDER BY `unit` DESC [ RunTime:0.053119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688847 LIMIT 2 [ RunTime:0.026521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688847 ORDER BY `minOrder` ASC [ RunTime:0.018214s ]
select * from pdf where partno='SM6T22AHE3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.037560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671552 LIMIT 5 [ RunTime:0.052647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671552 ORDER BY `minOrder` ASC [ RunTime:0.016495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671552 ORDER BY `unit` DESC [ RunTime:0.029458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671552 LIMIT 2 [ RunTime:0.031998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671552 ORDER BY `minOrder` ASC [ RunTime:0.042893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671497 LIMIT 5 [ RunTime:0.042420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671497 ORDER BY `minOrder` ASC [ RunTime:0.025483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671497 ORDER BY `unit` DESC [ RunTime:0.043637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671497 LIMIT 2 [ RunTime:0.051010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671497 ORDER BY `minOrder` ASC [ RunTime:0.024829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671262 LIMIT 5 [ RunTime:0.008863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671262 ORDER BY `minOrder` ASC [ RunTime:0.057009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671262 ORDER BY `unit` DESC [ RunTime:0.008205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671262 LIMIT 2 [ RunTime:0.033894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671262 ORDER BY `minOrder` ASC [ RunTime:0.013790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670227 LIMIT 5 [ RunTime:0.040010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670227 ORDER BY `minOrder` ASC [ RunTime:0.007891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670227 ORDER BY `unit` DESC [ RunTime:0.017506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670227 LIMIT 2 [ RunTime:0.077565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670227 ORDER BY `minOrder` ASC [ RunTime:0.023185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670122 LIMIT 5 [ RunTime:0.024874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670122 ORDER BY `minOrder` ASC [ RunTime:0.062825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670122 ORDER BY `unit` DESC [ RunTime:0.037334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670122 LIMIT 2 [ RunTime:0.058113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670122 ORDER BY `minOrder` ASC [ RunTime:0.001812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669764 LIMIT 5 [ RunTime:0.014582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669764 ORDER BY `minOrder` ASC [ RunTime:0.022792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16669764 ORDER BY `unit` DESC [ RunTime:0.016699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16669764 LIMIT 2 [ RunTime:0.068818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16669764 ORDER BY `minOrder` ASC [ RunTime:0.032102s ]
select * from pdf where partno='SM6T22A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.042942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14832670 LIMIT 5 [ RunTime:0.045704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832670 ORDER BY `minOrder` ASC [ RunTime:0.022931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14832670 ORDER BY `unit` DESC [ RunTime:0.052757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14832670 LIMIT 2 [ RunTime:0.016385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14832670 ORDER BY `minOrder` ASC [ RunTime:0.008919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811809 LIMIT 5 [ RunTime:0.062048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811809 ORDER BY `minOrder` ASC [ RunTime:0.018639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811809 ORDER BY `unit` DESC [ RunTime:0.107909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811809 LIMIT 2 [ RunTime:0.050160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811809 ORDER BY `minOrder` ASC [ RunTime:0.001605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810934 LIMIT 5 [ RunTime:0.083024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810934 ORDER BY `minOrder` ASC [ RunTime:0.055191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810934 ORDER BY `unit` DESC [ RunTime:0.043182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810934 LIMIT 2 [ RunTime:0.052015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810934 ORDER BY `minOrder` ASC [ RunTime:0.023421s ]
select * from pdf where partno='SM6T22A-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.079521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13930025 LIMIT 5 [ RunTime:0.026456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930025 ORDER BY `minOrder` ASC [ RunTime:0.050074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13930025 ORDER BY `unit` DESC [ RunTime:0.036495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13930025 LIMIT 2 [ RunTime:0.064857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13930025 ORDER BY `minOrder` ASC [ RunTime:0.021457s ]
select * from pdf where partno='SM6T22AHE3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.012926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915024 LIMIT 5 [ RunTime:0.043527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915024 ORDER BY `minOrder` ASC [ RunTime:0.034443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915024 ORDER BY `unit` DESC [ RunTime:0.002737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915024 LIMIT 2 [ RunTime:0.031426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915024 ORDER BY `minOrder` ASC [ RunTime:0.029689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914415 LIMIT 5 [ RunTime:0.048464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914415 ORDER BY `minOrder` ASC [ RunTime:0.088120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13914415 ORDER BY `unit` DESC [ RunTime:0.009195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13914415 LIMIT 2 [ RunTime:0.021830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13914415 ORDER BY `minOrder` ASC [ RunTime:0.002561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912806 LIMIT 5 [ RunTime:0.053968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912806 ORDER BY `minOrder` ASC [ RunTime:0.051495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13912806 ORDER BY `unit` DESC [ RunTime:0.012146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13912806 LIMIT 2 [ RunTime:0.077936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13912806 ORDER BY `minOrder` ASC [ RunTime:0.039067s ]
select * from pdf where partno='SM6T22A-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.066103s ]
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 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018543s ]
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 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42103009 LIMIT 5 [ RunTime:0.007204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103009 ORDER BY `minOrder` ASC [ RunTime:0.011814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42103009 ORDER BY `unit` DESC [ RunTime:0.006078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42103009 LIMIT 2 [ RunTime:0.020250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42103009 ORDER BY `minOrder` ASC [ RunTime:0.003134s ]
select * from pdf where partno='SM6T22A' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.077909s ]
select foldpath,foldpath2,filename from pdf_file where id=341668 limit 1 [ RunTime:0.029097s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22A' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.029959s ]
SELECT `id` FROM `stock` WHERE `id` <> 42103009 AND `partno` = 'SM6T22A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.034949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14805715 [ RunTime:0.018476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170359 LIMIT 5 [ RunTime:0.031329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170359 ORDER BY `minOrder` ASC [ RunTime:0.023527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170359 ORDER BY `unit` DESC [ RunTime:0.066970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170359 LIMIT 2 [ RunTime:0.035512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170359 ORDER BY `minOrder` ASC [ RunTime:0.016862s ]
select * from pdf where partno='SM6T22A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22A-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.021478s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170359 AND `partno` = 'SM6T22A-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.034974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16664855 [ RunTime:0.044731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42179363 LIMIT 5 [ RunTime:0.007305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42179363 ORDER BY `minOrder` ASC [ RunTime:0.042247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42179363 ORDER BY `unit` DESC [ RunTime:0.028134s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42179363 LIMIT 2 [ RunTime:0.032938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42179363 ORDER BY `minOrder` ASC [ RunTime:0.003997s ]
select * from pdf where partno='SM6T22AY' and brandshort='STMicroelectronics' limit 1 [ RunTime:0.026319s ]
select foldpath,foldpath2,filename from pdf_file where id=1044800 limit 1 [ RunTime:0.028294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22AY' OR `brand` LIKE 'STMicroelectronics%' ) ) LIMIT 1 [ RunTime:0.012166s ]
SELECT `id` FROM `stock` WHERE `id` <> 42179363 AND `partno` = 'SM6T22AY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.043569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14833997 [ RunTime:0.058675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42237344 LIMIT 5 [ RunTime:0.059564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237344 ORDER BY `minOrder` ASC [ RunTime:0.018352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42237344 ORDER BY `unit` DESC [ RunTime:0.033122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42237344 LIMIT 2 [ RunTime:0.030316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237344 ORDER BY `minOrder` ASC [ RunTime:0.016123s ]
select * from pdf where partno='SM6T22AHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.033925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22AHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.048048s ]
SELECT `id` FROM `stock` WHERE `id` <> 42237344 AND `partno` = 'SM6T22AHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.066718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914415 [ RunTime:0.079751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42237330 LIMIT 5 [ RunTime:0.018237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237330 ORDER BY `minOrder` ASC [ RunTime:0.039147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42237330 ORDER BY `unit` DESC [ RunTime:0.047350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42237330 LIMIT 2 [ RunTime:0.046160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237330 ORDER BY `minOrder` ASC [ RunTime:0.042371s ]
select * from pdf where partno='SM6T22AHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.040264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22AHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.048762s ]
SELECT `id` FROM `stock` WHERE `id` <> 42237330 AND `partno` = 'SM6T22AHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.039027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671552 [ RunTime:0.038600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42236971 LIMIT 5 [ RunTime:0.030291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236971 ORDER BY `minOrder` ASC [ RunTime:0.056709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42236971 ORDER BY `unit` DESC [ RunTime:0.020699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42236971 LIMIT 2 [ RunTime:0.036109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42236971 ORDER BY `minOrder` ASC [ RunTime:0.005160s ]
select * from pdf where partno='SM6T22AHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.023976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22AHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.017312s ]
SELECT `id` FROM `stock` WHERE `id` <> 42236971 AND `partno` = 'SM6T22AHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.035149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915024 [ RunTime:0.021189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42235534 LIMIT 5 [ RunTime:0.003218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42235534 ORDER BY `minOrder` ASC [ RunTime:0.003067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42235534 ORDER BY `unit` DESC [ RunTime:0.029934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42235534 LIMIT 2 [ RunTime:0.008381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42235534 ORDER BY `minOrder` ASC [ RunTime:0.013555s ]
select * from pdf where partno='SM6T22AHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.041265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22AHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.025063s ]
SELECT `id` FROM `stock` WHERE `id` <> 42235534 AND `partno` = 'SM6T22AHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.019406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811809 [ RunTime:0.058617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42229916 LIMIT 5 [ RunTime:0.060452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42229916 ORDER BY `minOrder` ASC [ RunTime:0.033050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42229916 ORDER BY `unit` DESC [ RunTime:0.048671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42229916 LIMIT 2 [ RunTime:0.025350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42229916 ORDER BY `minOrder` ASC [ RunTime:0.021266s ]
select * from pdf where partno='SM6T22AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.065102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019546s ]
SELECT `id` FROM `stock` WHERE `id` <> 42229916 AND `partno` = 'SM6T22AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.029709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671497 [ RunTime:0.073198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42228287 LIMIT 5 [ RunTime:0.050690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228287 ORDER BY `minOrder` ASC [ RunTime:0.027968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42228287 ORDER BY `unit` DESC [ RunTime:0.056865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42228287 LIMIT 2 [ RunTime:0.017573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42228287 ORDER BY `minOrder` ASC [ RunTime:0.032245s ]
select * from pdf where partno='SM6T22AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.037520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.031691s ]
SELECT `id` FROM `stock` WHERE `id` <> 42228287 AND `partno` = 'SM6T22AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.058011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671262 [ RunTime:0.057567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42225190 LIMIT 5 [ RunTime:0.049734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225190 ORDER BY `minOrder` ASC [ RunTime:0.027060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42225190 ORDER BY `unit` DESC [ RunTime:0.084619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42225190 LIMIT 2 [ RunTime:0.030422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225190 ORDER BY `minOrder` ASC [ RunTime:0.009436s ]
select * from pdf where partno='SM6T22A-E3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22A-E3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.042858s ]
SELECT `id` FROM `stock` WHERE `id` <> 42225190 AND `partno` = 'SM6T22A-E3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.041197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810934 [ RunTime:0.103043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221628 LIMIT 5 [ RunTime:0.112830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221628 ORDER BY `minOrder` ASC [ RunTime:0.031218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221628 ORDER BY `unit` DESC [ RunTime:0.017137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221628 LIMIT 2 [ RunTime:0.017095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221628 ORDER BY `minOrder` ASC [ RunTime:0.025245s ]
select * from pdf where partno='SM6T22AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.063289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.033418s ]
SELECT `id` FROM `stock` WHERE `id` <> 42221628 AND `partno` = 'SM6T22AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.063960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670227 [ RunTime:0.045772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221533 LIMIT 5 [ RunTime:0.025537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221533 ORDER BY `minOrder` ASC [ RunTime:0.084402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221533 ORDER BY `unit` DESC [ RunTime:0.042560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221533 LIMIT 2 [ RunTime:0.047349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221533 ORDER BY `minOrder` ASC [ RunTime:0.026738s ]
select * from pdf where partno='SM6T22A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.027014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22A-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.038308s ]
SELECT `id` FROM `stock` WHERE `id` <> 42221533 AND `partno` = 'SM6T22A-M3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16669764 [ RunTime:0.025383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221092 LIMIT 5 [ RunTime:0.026492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221092 ORDER BY `minOrder` ASC [ RunTime:0.037031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221092 ORDER BY `unit` DESC [ RunTime:0.007908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221092 LIMIT 2 [ RunTime:0.021485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221092 ORDER BY `minOrder` ASC [ RunTime:0.017884s ]
select * from pdf where partno='SM6T22AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.013916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.004060s ]
SELECT `id` FROM `stock` WHERE `id` <> 42221092 AND `partno` = 'SM6T22AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.014892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670122 [ RunTime:0.021607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42218112 LIMIT 5 [ RunTime:0.008876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42218112 ORDER BY `minOrder` ASC [ RunTime:0.029154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42218112 ORDER BY `unit` DESC [ RunTime:0.044449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42218112 LIMIT 2 [ RunTime:0.057201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42218112 ORDER BY `minOrder` ASC [ RunTime:0.010121s ]
select * from pdf where partno='SM6T22A-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.004829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SM6T22A-M3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.038331s ]
SELECT `id` FROM `stock` WHERE `id` <> 42218112 AND `partno` = 'SM6T22A-M3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.027238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912806 [ RunTime:0.030880s ]
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 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042232s ]
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 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052843s ]
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 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038312s ]
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 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041872s ]
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 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017595s ]
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 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025426s ]
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 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026791s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SM6T22A%' OR `brand` LIKE 'SM6T22A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025707s ]