We use cookies to understand how you use our site and to improve your experience. This includes personalizing content and advertising. To learn more, click here. By continuing to use our site, you accept our use of cookies. Cookie Policy.

Features Partner Sites Information LinkXpress hp
Sign In
Advertise with Us
GLOBETECH PUBLISHING LLC

Download Mobile App




Radiography

Image: Intravascular imaging can improve outcomes for complex stenting procedures in patients with high-risk calcified coronary artery disease (Photo courtesy of Shutterstock)

Intravascular Imaging for Guiding Stent Implantation Ensures Safer Stenting Procedures

New research shows that using IVI to guide stent implantation during complex stenting procedures provides a safer and more effective solution. More...
16 Apr 2025
Image: A 4mm square diamond radiation detector (Photo courtesy of Orbray)

World's Largest Class Single Crystal Diamond Radiation Detector Opens New Possibilities for Diagnostic Imaging

Orbray Co., Ltd. has developed a cutting-edge radiation detector based on its proprietary high-quality, large-diameter single-crystal diamond technology. More...
09 Apr 2025
Image: The AI-powered FFR assessment is comparable to conventional assessment (Photo courtesy of 123RF)

AI-Powered Imaging Technique Shows Promise in Evaluating Patients for PCI

A study to assess the effectiveness of AI-powered FFR assessment in PCI outcomes has met its primary endpoint. More...
01 Apr 2025
Image: A study has linked increased use of chest X-rays to earlier lung cancer diagnosis and improved survival (Photo courtesy of 123RF)

Higher Chest X-Ray Usage Catches Lung Cancer Earlier and Improves Survival

A new study has revealed a strong connection between the frequency of chest X-ray referrals by GPs and earlier lung cancer diagnoses. More...
26 Mar 2025
Image: The deep learning model predicts cardiovascular risk based on mammogram images (Photo courtesy of 123RF)

AI-Powered Mammograms Predict Cardiovascular Risk

A new study suggests that mammograms, when combined with AI models, can reveal much more than just cancer. More...
21 Mar 2025
Image: Examples of chest radiograph interpretations with and without AI–generated reports (Photo courtesy of Radiology, DOI: 10.1148/radiol.241646)

Generative AI Model Significantly Reduces Chest X-Ray Reading Time

A new study has evaluated the clinical value of a domain-specific multimodal generative AI model for interpreting chest radiographs. More...
20 Mar 2025
Image: The INSIGHT MMG AI-powered mammography analysis solution (Photo courtesy of Lunit)

AI-Powered Mammography Screening Boosts Cancer Detection in Single-Reader Settings

An AI-powered solution significantly improves cancer detection in single-reader mammography settings without increasing recall rates. More...
12 Mar 2025
Gold Member
Electrode Solution and Skin Prep
Signaspray
Gold Member
Ultrasound System
FUTUS LE
X-Ray Generator
RF Series
Double Sided Apron
Maxima


The MedImaging Radiology channel covers fluoroscopy, digital radiography, computerized tomography, mammography, interventional radiology, and other medical uses of X-ray imaging as well as related instrumentation, trends and safety issues.
Copyright © 2000-2025 Globetech Media. All rights reserved.

Notice: The user specified as a definer ('admin'@'%') does not exist in /home/www/medsites/shared/includes/database.php on line 307

/home/www/medsites/shared/includes/post_processing.php:42
/home/www/medsites/shared/includes/post_processing.php:5
/home/www/medsites/medicalimaging/index.php:409104 queries executed
1
(79.870223999023): SET sql_mode = 'MYSQL40'
2 (94.890594482422): SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 (41.007995605469): SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 99999999 ) ORDER BY menuid DESC LIMIT 1
4 (319.9577331543): DELETE FROM jos_session WHERE time < 1753893597 AND guest = 1 AND userid = 0
5 (53.167343139648): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 1
6 (37.908554077148): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 1
7 (41.961669921875): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 1
8 (127.07710266113): SELECT * FROM jos_menu WHERE published = 1 AND link LIKE 'index.php?option=com_channel%'
9 (!!!!! 74687.004089355): SELECT *,created AS date_article FROM jos_deeppockets_archive WHERE 1=1 AND cat=10 AND fid=211 AND (type='deeppockets_item' OR type='content' OR type='deeppockets_item_link') AND published='1' ORDER BY `created` DESC, id DESC LIMIT 0,2
10 (528.81240844727): SELECT name,title,ordering,description FROM jos_deeppockets WHERE id=211 LIMIT 0,1
11 (106.8115234375): SELECT name,title,ordering,description FROM jos_deeppockets WHERE id=211 LIMIT 0,1
12 (!!!!! 1620.0542449951): SELECT *, created AS date_article FROM jos_deeppockets WHERE 1=1 AND cat=10 AND fid=211 AND (type='deeppockets_item' OR type='content' OR type='deeppockets_item_link') AND published='1' ORDER BY `created` DESC, id DESC LIMIT 0,30
13 (318.05038452148): SELECT *, created AS date_article FROM jos_deeppockets WHERE 1=1 AND cat=10 AND fid=211 AND (type='deeppockets_item' OR type='content' OR type='deeppockets_item_link') AND published='1' ORDER BY `created` DESC, id DESC LIMIT 0,30
14 (!!!!! 4145.8606719971): SELECT jos_item.* FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id WHERE 1=1 AND (jos_item.imgMini<>'') AND jos_item.type='P' AND jos_item.numberID= ( SELECT jos_number.id FROM jos_number WHERE jos_number.journalID IN (10) and jos_item.fid=211 and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P') ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC LIMIT 0,1 ) AND (jos_number.channelID=211 OR jos_number.channelID=0) ORDER BY RAND() DESC LIMIT 3
15 (!!!!! 4114.8662567139): SELECT jos_item.* FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id WHERE 1=1 AND (jos_item.imgMini<>'') AND jos_item.type='P' AND jos_item.numberID= ( SELECT jos_number.id FROM jos_number WHERE jos_number.journalID IN (10) and jos_item.fid=211 and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P') ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC LIMIT 0,1 ) AND (jos_number.channelID=211 OR jos_number.channelID=0) ORDER BY RAND() DESC LIMIT 3
16 (!!!!! 2320.0511932373): SELECT jos_item.* FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id WHERE 1=1 AND (jos_item.imgMini<>'') AND jos_item.type='P' AND jos_item.numberID= ( SELECT jos_number.id FROM jos_number WHERE jos_number.journalID IN (5) and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P') ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC LIMIT 0,1 ) AND (jos_number.channelID=211 OR jos_number.channelID=0) ORDER BY RAND() DESC LIMIT 3
17 (!!!!! 1935.9588623047): SELECT jos_item.* FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id WHERE 1=1 AND (jos_item.imgMini<>'') AND jos_item.type='P' AND jos_item.numberID= ( SELECT jos_number.id FROM jos_number WHERE jos_number.journalID IN (5) and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P') ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC LIMIT 0,1 ) AND (jos_number.channelID=211 OR jos_number.channelID=0) ORDER BY RAND() DESC LIMIT 3
18 (!!!!! 1382.1125030518): SELECT id,name,title,ordering FROM jos_deeppockets WHERE cat=10 AND name NOT LIKE "---%" AND TYPE='file_folder' AND published=1 AND ordering > 1 ORDER BY `ordering` LIMIT 0,1
19 (!!!!! 1219.9878692627): SELECT id,name,title FROM jos_deeppockets WHERE 1=1 AND cat=10 AND name LIKE "---%" AND ordering > 1 AND ordering < 2 AND TYPE='file_folder' AND published=1 ORDER BY `ordering`
20 (167.1314239502): SELECT id,name,title FROM jos_deeppockets WHERE 1=1 AND cat=10 AND name LIKE "---%" AND ordering > 1 AND ordering < 2 AND TYPE='file_folder' AND published=1 ORDER BY `ordering`
21 (136.13700866699): SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 99999999 ) ORDER BY ordering
22 (103.95050048828): SELECT conference_items.channel_id, conference_items.tracking_code FROM conference_items LEFT JOIN conference_groups ON conference_groups.id = conference_items.group_id LEFT JOIN jos_deeppockets ON jos_deeppockets.id = conference_items.channel_id LEFT JOIN jos_journal ON jos_journal.cat = jos_deeppockets.cat AND jos_journal.real = 1 AND jos_journal.directory IS NOT NULL WHERE 1 = 1 ORDER BY conference_items.id
23 (581.02607727051): SELECT *, created AS date_article FROM jos_deeppockets WHERE 1=1 AND id=294804675 AND type='deeppockets_item' AND published='1' LIMIT 0,1
24 (335.9317779541): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804677 LIMIT 1
25 (46.014785766602): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804677 LIMIT 1
26 (428.91502380371): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804589 LIMIT 1
27 (71.048736572266): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804589 LIMIT 1
28 (408.88786315918): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804502 LIMIT 1
29 (65.088272094727): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804502 LIMIT 1
30 (351.1905670166): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804453 LIMIT 1
31 (50.067901611328): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804453 LIMIT 1
32 (369.07196044922): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804411 LIMIT 1
33 (46.014785766602): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804411 LIMIT 1
34 (406.98051452637): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804387 LIMIT 1
35 (61.03515625): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804387 LIMIT 1
36 (473.97613525391): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804313 LIMIT 1
37 (62.942504882812): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294804313 LIMIT 1
38 (89.168548583984): SELECT a.* FROM jos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
39 (158.07151794434): select cover from jos_number where journalid in (5) and cover is not null order by left(issue,2)+right(issue,2)*12 desc limit 1
40 (664.94941711426): SELECT id,name,sponsor_text FROM jos_deeppockets dp left outer join jos_channel_sponsor cs on dp.id=cs.fid WHERE cat=10 AND TYPE='file_folder' AND published=1 AND id=211 ORDER BY `ordering`
41 (86.069107055664): select jos_twitters.link from jos_twitters where cat=10
42 (45.061111450195): select jos_facebook.link from jos_facebook where cat=10
43 (44.822692871094): select jos_google_plus.link from jos_google_plus where cat=10
44 (45.7763671875): select jos_linkedin.link from jos_linkedin where cat=10
45 (61.03515625): SELECT id,name,sponsor_text FROM jos_deeppockets dp left outer join jos_channel_sponsor cs on dp.id=cs.fid WHERE cat=10 AND TYPE='file_folder' AND published=1 AND id=211 ORDER BY `ordering`
46 (74.863433837891): SELECT id,name,title FROM jos_deeppockets WHERE cat=10 AND TYPE='file_folder' AND published=1 AND id != 294743300 AND id != 294743301 AND id != 294743302 AND id != 294743303 AND id != 294743304 AND id != 294743305 AND id != 294743306 AND id != 294743307 AND id != 294743308 AND id != 294743309 AND id != 294743310 AND metakey != 'aacc' ORDER BY `ordering`
47 (80.108642578125): SELECT show_live FROM jos_com_show_setting LIMIT 1
48 (46.014785766602): SELECT show_live FROM jos_com_show_setting LIMIT 1
49 (43.869018554688): SELECT show_live FROM jos_com_show_setting LIMIT 1
50 (40.054321289062): SELECT show_live FROM jos_com_show_setting LIMIT 1
51 (40.054321289062): SELECT show_live FROM jos_com_show_setting LIMIT 1
52 (41.007995605469): SELECT show_live FROM jos_com_show_setting LIMIT 1
53 (42.915344238281): SELECT show_live FROM jos_com_show_setting LIMIT 1
54 (39.100646972656): SELECT show_live FROM jos_com_show_setting LIMIT 1
55 (41.961669921875): SELECT show_live FROM jos_com_show_setting LIMIT 1
56 (40.054321289062): SELECT show_live FROM jos_com_show_setting LIMIT 1
57 (39.100646972656): SELECT show_live FROM jos_com_show_setting LIMIT 1
58 (37.908554077148): SELECT show_live FROM jos_com_show_setting LIMIT 1
59 (40.054321289062): SELECT show_live FROM jos_com_show_setting LIMIT 1
60 (39.815902709961): SELECT show_live FROM jos_com_show_setting LIMIT 1
61 (96.08268737793): SELECT id,name,title FROM jos_deeppockets WHERE cat=10 AND TYPE='file_folder' AND published=1 AND id != 294743300 AND id != 294743301 AND id != 294743302 AND id != 294743303 AND id != 294743304 AND id != 294743305 AND id != 294743306 AND id != 294743307 AND id != 294743308 AND id != 294743309 AND id != 294743310 AND metakey != 'aacc' ORDER BY `ordering`
62 (83.92333984375): SELECT show_live FROM jos_com_show_setting LIMIT 1
63 (46.968460083008): SELECT show_live FROM jos_com_show_setting LIMIT 1
64 (41.961669921875): SELECT show_live FROM jos_com_show_setting LIMIT 1
65 (36.954879760742): SELECT show_live FROM jos_com_show_setting LIMIT 1
66 (40.054321289062): SELECT show_live FROM jos_com_show_setting LIMIT 1
67 (37.908554077148): SELECT show_live FROM jos_com_show_setting LIMIT 1
68 (41.961669921875): SELECT show_live FROM jos_com_show_setting LIMIT 1
69 (39.100646972656): SELECT show_live FROM jos_com_show_setting LIMIT 1
70 (36.954879760742): SELECT show_live FROM jos_com_show_setting LIMIT 1
71 (39.100646972656): SELECT show_live FROM jos_com_show_setting LIMIT 1
72 (41.007995605469): SELECT show_live FROM jos_com_show_setting LIMIT 1
73 (38.14697265625): SELECT show_live FROM jos_com_show_setting LIMIT 1
74 (39.815902709961): SELECT show_live FROM jos_com_show_setting LIMIT 1
75 (41.961669921875): SELECT show_live FROM jos_com_show_setting LIMIT 1
76 (773.90670776367): SELECT dp.name, dp.id, dp2.name as channel, ex.name as author_name, ex.specialization, ex.images FROM jos_deeppockets as dp LEFT JOIN jos_experts as ex ON ex.id = dp.author LEFT JOIN jos_deeppockets as dp2 ON dp2.id = dp.fid WHERE dp.author != 0 AND dp.cat = 10 AND dp.published = 1 AND ( (dp.fid = 294743300) OR (dp.fid = 294743301) OR (dp.fid = 294743302) OR (dp.fid = 294743303) OR (dp.fid = 294743304) OR (dp.fid = 294743305) OR (dp.fid = 294743306) OR (dp.fid = 294743307) OR (dp.fid = 294743308) OR (dp.fid = 294743309) OR (dp.fid = 294743310) ) ORDER BY RAND() LIMIT 1
77 (689.98336791992): SELECT dp.name, dp.id, dp2.name as channel, ex.name as author_name, ex.specialization, ex.images FROM jos_deeppockets as dp LEFT JOIN jos_experts as ex ON ex.id = dp.author LEFT JOIN jos_deeppockets as dp2 ON dp2.id = dp.fid WHERE dp.author != 0 AND dp.cat = 10 AND dp.published = 1 AND ( (dp.fid = 294743300) OR (dp.fid = 294743301) OR (dp.fid = 294743302) OR (dp.fid = 294743303) OR (dp.fid = 294743304) OR (dp.fid = 294743305) OR (dp.fid = 294743306) OR (dp.fid = 294743307) OR (dp.fid = 294743308) OR (dp.fid = 294743309) OR (dp.fid = 294743310) ) ORDER BY RAND() LIMIT 1
78 (418.90144348145): SELECT * FROM trending_articles WHERE `journal_id` = 10 AND `timestamp` <= NOW() + INTERVAL 7 DAY ORDER BY `order`
79 (!!!!! 31099.796295166): SELECT * FROM jos_deeppockets WHERE jos_deeppockets.cat = 10 AND jos_deeppockets.type = 'deeppockets_item' AND jos_deeppockets.published = 1 AND jos_deeppockets.created + INTERVAL 14 DAY >= NOW() ORDER BY jos_deeppockets.hits DESC LIMIT 7
80 (123.02398681641): ( SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.video != '' AND dp.video_source != '' AND dp.cat = 10 AND dp.published = 1 AND dp.type != 'deeppockets_item_link' ORDER BY created DESC LIMIT 3 ) UNION ( SELECT dpa.id, dpa.name, dpa.title, dpa.video, dpa.video_source, dpa.created FROM jos_deeppockets_archive AS dpa WHERE dpa.video != '' AND dpa.video_source != '' AND dpa.cat = 10 AND dpa.published = 1 AND dpa.type != 'deeppockets_item_link' ORDER BY created DESC LIMIT 3 ) ORDER BY created DESC LIMIT 3
81 (55.074691772461): ( SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.video != '' AND dp.video_source != '' AND dp.cat = 10 AND dp.published = 1 AND dp.type != 'deeppockets_item_link' ORDER BY created DESC LIMIT 3 ) UNION ( SELECT dpa.id, dpa.name, dpa.title, dpa.video, dpa.video_source, dpa.created FROM jos_deeppockets_archive AS dpa WHERE dpa.video != '' AND dpa.video_source != '' AND dpa.cat = 10 AND dpa.published = 1 AND dpa.type != 'deeppockets_item_link' ORDER BY created DESC LIMIT 3 ) ORDER BY created DESC LIMIT 3
82 (61.988830566406): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294803337 LIMIT 1
83 (42.915344238281): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294803337 LIMIT 1
84 (82.015991210938): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294803276 LIMIT 1
85 (42.915344238281): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294803276 LIMIT 1
86 (39.815902709961): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets_archive AS dp WHERE dp.id = 294803276 LIMIT 1
87 (39.100646972656): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets_archive AS dp WHERE dp.id = 294803276 LIMIT 1
88 (46.014785766602): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294802958 LIMIT 1
89 (39.100646972656): SELECT dp.id, dp.name, dp.title, dp.video, dp.video_source, dp.created FROM jos_deeppockets AS dp WHERE dp.id = 294802958 LIMIT 1
90 (363.11149597168): SELECT name FROM jos_deeppockets WHERE id=211
91 (56.028366088867): SELECT name FROM jos_deeppockets WHERE id=211
92 (!!!!! 1057.1479797363): SELECT *, DATE_FORMAT(publish_up,'%d %b %Y') AS date_publish_up, DATE_FORMAT(publish_down,'%d %b %Y') AS date_publish_down FROM jos_events WHERE state=1 AND publish_up > NOW() and extra_info REGEXP '((;)|(^))211((;)|($))' AND catid IN (0,110) ORDER BY publish_up ASC LIMIT 3
93 (780.10559082031): SELECT *, DATE_FORMAT(publish_up,'%d %b %Y') AS date_publish_up, DATE_FORMAT(publish_down,'%d %b %Y') AS date_publish_down FROM jos_events WHERE state=1 AND publish_up > NOW() and extra_info REGEXP '((;)|(^))211((;)|($))' AND catid IN (0,110) ORDER BY publish_up ASC LIMIT 3
94 (!!!!! 10232.925415039): TRUNCATE TABLE jos_trademed_module
95 (!!!!! 1583.0993652344): SELECT jos_item.* FROM jos_item INNER JOIN jos_number ON jos_item.numberID=jos_number.id WHERE 1=1 AND (jos_item.imgMini<>'') AND jos_item.type='L' AND jos_item.numberID= ( SELECT jos_number.id FROM jos_number WHERE jos_number.journalID IN (10) and jos_number.id in (select distinct jos_number.id from jos_number join jos_item on jos_item.numberid=jos_number.id where jos_item.type='P') ORDER BY (CONVERT(SUBSTRING(issue,1,2),SIGNED) + (CONVERT(SUBSTRING(issue,3,2),SIGNED)*100)) DESC LIMIT 0,1 ) ORDER BY RAND() DESC LIMIT 6
96 (101.08947753906): select distinct links.* from jos_textlinks links join jos_textlinks_placement placement on links.id=placement.link_id where journal_id=(10) and (channel_id=211 or channel_id is null)
97 (41.961669921875): select distinct links.* from jos_textlinks links join jos_textlinks_placement placement on links.id=placement.link_id where journal_id=(10) and (channel_id=211 or channel_id is null)
98 (50.067901611328): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 1
99 (56.982040405273): select jos_twitters.link from jos_twitters where cat=10
100 (42.200088500977): select jos_facebook.link from jos_facebook where cat=10
101 (45.061111450195): select jos_google_plus.link from jos_google_plus where cat=10
102 (41.961669921875): select jos_linkedin.link from jos_linkedin where cat=10
103 (291.10908508301): update jos_bannersmanager_banner set impmade=impmade+1 where id in(14202,14203)
104 (!!!!! 1291.036605835): insert into jos_banners_delta values (14202,'2025-07-30 16:54:58','216.73.216.8','view'),(14203,'2025-07-30 16:54:58','216.73.216.8','view')