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.
Zero-Footprint Interoperable Image-Viewing Software Uses Data More Effectively
By MedImaging International staff writers Posted on 29 Feb 2012
New image viewing software provides interoperable image exchange and management, and is an enabling technology that reduces or eliminates many hurdles to efficiency in healthcare organizations.
Merge Healthcare (Chicago, IL, USA), a provider of enterprise imaging and interoperability solutions, announced that Merge iConnect was presented at the HIMSS12 Interoperability Showcase at the 2012’s HIMSS (Healthcare Information and Management Systems Society) conference in Las Vegas, February 21-24, 2012.
“We’re proud that iConnect is part of the Interoperability Showcase at HIMSS, and of the collaborative effort that is taking place among healthcare IT [information technology] vendors to ensure interoperability among the myriad of systems and interfaces hospitals use to share data,” said Jeff Surges, CEO, Merge Healthcare. “Attendees will see first-hand how interoperable systems, like iConnect Access, communicate with one another better, are easier to implement, and enable providers to use information more effectively.”
Merge iConnect Access provides a true zero-footprint image viewing capability and can be embedded into many third-party products. iConnect Access is part of the iConnect product range, which is the only comprehensive solution for collecting, archiving, viewing, sharing, and exchanging any type of image, anywhere, any time.
Merge’s client base covers 1,500 hospitals and 6,000 clinics. iConnect is in use at some of the largest and most prestigious hospitals and healthcare systems. Merge iConnect Access successfully completed testing for all registered Integration Profiles at the Integrating the Healthcare Enterprise Connectathon held January 2012 in Chicago, IL, USA. Merge Healthcare successfully assessed with 25 different vendors and its solutions met all required functionality and interoperability requirements including the IHE ATNA (Integrating the Healthcare- Enterprise Audit Trail and Node Authentication) security profile.
Merge completed six IHE Integration Profiles, including consistent time (CT), ATNA, cross-enterprise document sharing-b (XDS.b), cross-enterprise document sharing for imaging (XDS-I.b), patient identifier cross-referencing (PIX), and patient demographics query (PDQ). This confirms that Merge iConnect Access can be used in IHE XDS (cross enterprise document sharing) solutions including Health Information Exchanges (HIE) and Accountable Care Organizations (ACO) around the world.
The IHE Connectathon is the healthcare IT industry’s only large-scale interoperability testing event. It provides detailed validation of the participants’ interoperability and compliance with IHE profiles. During the Connectathon systems exchange information with complementary systems from multiple vendors, performing all of the transactions required for the roles they have selected, called IHE Actors, in support of defined clinical use cases, called IHE Profiles. Thousands of vendor-to-vendor connections have been tested overall, and tens of thousands of transactions passed among the systems tested.
Related Links: Merge Healthcare
1
(!!!!! 2115.01121521): SET sql_mode = 'MYSQL40'2
(105.85784912109): SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering3
(308.99047851562): SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 294739530 )
ORDER BY menuid DESC
LIMIT 14
(188.82751464844): DELETE FROM jos_session
WHERE
time < 1758229233
AND guest = 1
AND userid = 05
(36.954879760742): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 16
(30.994415283203): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 17
(36.954879760742): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 18
(280.85708618164): SELECT *
FROM jos_menu
WHERE id = 2947395309
(474.21455383301): SELECT dp.*,
ch.title as channel,
ch.name as channel_name,
exp.name as author_name,
exp.specialization as author_specialization, exp.images as author_photo
FROM jos_deeppockets as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
#AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 110
(770.80726623535): SELECT dp.*,
ch.title as channel,
ch.name as channel_name,
exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo
FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
#AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 111
(67.949295043945): SELECT dp.*,
ch.title as channel,
ch.name as channel_name,
exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo
FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
#AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 112
(784.15870666504): SELECT *
FROM jos_deeppockets
WHERE 1=1
AND cat=10
AND type='deeppockets_item'
AND published='1'
AND (id<>294739530)
AND (fid=216)
ORDER BY id DESC, `created` DESC
LIMIT 0,1613
(!!!!! 3070.8312988281): SELECT *
FROM jos_deeppockets
WHERE 1=1
AND cat=10
AND type='deeppockets_item'
AND published='1'
AND (id<>294739530)
AND (fid=216)
ORDER BY id DESC, `created` DESC
LIMIT 0,1614
(!!!!! 2862.9302978516): 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=216
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=294739530 OR jos_number.channelID=0)
ORDER BY RAND() DESC LIMIT 315
(!!!!! 5248.0697631836): 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=216
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=294739530 OR jos_number.channelID=0)
ORDER BY RAND() DESC LIMIT 316
(!!!!! 4951.000213623): 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_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=294739530 OR jos_number.channelID=0)
ORDER BY RAND() DESC LIMIT 317
(!!!!! 1080.9898376465): 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_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=294739530 OR jos_number.channelID=0)
ORDER BY RAND() DESC LIMIT 318
(!!!!! 1788.1393432617): SELECT name,id,title FROM jos_deeppockets WHERE id=216 LIMIT 119
(45.061111450195): SELECT name,id,title FROM jos_deeppockets WHERE id=216 LIMIT 120
(693.08280944824): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 121
(!!!!! 3008.1272125244): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 122
(68.187713623047): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 123
(65.803527832031): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 124
(529.05082702637): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 125
(476.83715820312): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 126
(61.988830566406): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 127
(49.829483032227): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 128
(49.114227294922): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 129
(46.014785766602): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 130
(56.982040405273): 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.id31
(250.81634521484): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294739530
LIMIT 132
(35.04753112793): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294739530
LIMIT 133
(244.140625): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets_archive AS dp
WHERE
dp.id = 294739530
LIMIT 134
(36.001205444336): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets_archive AS dp
WHERE
dp.id = 294739530
LIMIT 135
(42.915344238281): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294739530
LIMIT 136
(32.901763916016): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294739530
LIMIT 137
(30.994415283203): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets_archive AS dp
WHERE
dp.id = 294739530
LIMIT 138
(36.001205444336): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets_archive AS dp
WHERE
dp.id = 294739530
LIMIT 139
(741.95861816406): 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 = 294739530 )
ORDER BY ordering40
(!!!!! 1159.9063873291): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 141
(56.028366088867): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 142
(!!!!! 3633.0223083496): SELECT
*
FROM
jos_bannersmanager_banner
WHERE
`groupid` = 98
AND
`site_id` = 10
AND
`published` = 143
(!!!!! 13309.001922607): SELECT
*
FROM
jos_bannersmanager_banner
WHERE
`groupid` = 99
AND
`site_id` = 10
AND
`published` = 144
(117.06352233887): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 145
(70.810317993164): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 146
(180.95970153809): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 147
(82.969665527344): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 148
(63.180923461914): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 149
(43.869018554688): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 150
(77.962875366211): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 151
(46.014785766602): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 152
(!!!!! 2031.0878753662): SELECT name FROM jos_deeppockets WHERE id=294739530 LIMIT 153
(382.90023803711): SELECT name FROM jos_deeppockets_archive WHERE id=294739530 LIMIT 154
(83.92333984375): 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'55
(67.949295043945): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 156
(576.97296142578): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 157
(!!!!! 1060.0090026855): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 158
(339.03121948242): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 159
(102.99682617188): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 160
(55.074691772461): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 161
(108.00361633301): 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 162
(368.11828613281): SELECT fid FROM jos_deeppockets WHERE id=294739530 AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE id=294739530 AND published='1' LIMIT 163
(313.99726867676): 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=216
ORDER BY `ordering`64
(52.213668823242): select jos_twitters.link from jos_twitters where cat=1065
(27.894973754883): select jos_facebook.link from jos_facebook where cat=1066
(29.087066650391): select jos_google_plus.link from jos_google_plus where cat=1067
(27.179718017578): select jos_linkedin.link from jos_linkedin where cat=1068
(29.087066650391): SELECT fid FROM jos_deeppockets WHERE id=294739530 AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE id=294739530 AND published='1' LIMIT 169
(30.040740966797): 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=216
ORDER BY `ordering`70
(164.03198242188): SELECT fid FROM jos_deeppockets
WHERE cat=10
AND id=294739530
AND (type='deeppockets_item' OR type='deeppockets_item_link')
AND published='1'
LIMIT 171
(128.03077697754): SELECT fid FROM jos_deeppockets_archive WHERE cat=10 AND id=294739530 AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 172
(36.001205444336): 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`73
(48.160552978516): SELECT show_live FROM jos_com_show_setting LIMIT 174
(30.040740966797): SELECT show_live FROM jos_com_show_setting LIMIT 175
(27.179718017578): SELECT show_live FROM jos_com_show_setting LIMIT 176
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 177
(27.894973754883): SELECT show_live FROM jos_com_show_setting LIMIT 178
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 179
(24.795532226562): SELECT show_live FROM jos_com_show_setting LIMIT 180
(27.179718017578): SELECT show_live FROM jos_com_show_setting LIMIT 181
(25.033950805664): SELECT show_live FROM jos_com_show_setting LIMIT 182
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 183
(26.226043701172): SELECT show_live FROM jos_com_show_setting LIMIT 184
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 185
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 186
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 187
(40.054321289062): SELECT fid FROM jos_deeppockets
WHERE cat=10
AND id=294739530
AND (type='deeppockets_item' OR type='deeppockets_item_link')
AND published='1'
LIMIT 188
(26.941299438477): SELECT fid FROM jos_deeppockets_archive WHERE cat=10 AND id=294739530 AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 189
(31.948089599609): 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`90
(55.074691772461): SELECT show_live FROM jos_com_show_setting LIMIT 191
(43.153762817383): SELECT show_live FROM jos_com_show_setting LIMIT 192
(29.087066650391): SELECT show_live FROM jos_com_show_setting LIMIT 193
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 194
(25.033950805664): SELECT show_live FROM jos_com_show_setting LIMIT 195
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 196
(43.869018554688): SELECT show_live FROM jos_com_show_setting LIMIT 197
(32.186508178711): SELECT show_live FROM jos_com_show_setting LIMIT 198
(27.179718017578): SELECT show_live FROM jos_com_show_setting LIMIT 199
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 1100
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 1101
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 1102
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 1103
(25.98762512207): SELECT show_live FROM jos_com_show_setting LIMIT 1104
(61.988830566406): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1105
(42.200088500977): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1106
(!!!!! 4397.1538543701): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 1107
(107.0499420166): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 1108
(75.101852416992): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1109
(45.061111450195): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1110
(46.014785766602): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 1111
(388.14544677734): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 1112
(552.89268493652): 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 1113
(358.81996154785): 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 1114
(74.863433837891): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1115
(46.968460083008): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1116
(46.968460083008): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1117
(41.007995605469): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1118
(46.014785766602): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1119
(38.862228393555): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1120
(45.061111450195): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1121
(39.100646972656): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1122
(301.12266540527): SELECT * FROM trending_articles WHERE `journal_id` = 10 AND `timestamp` <= NOW() + INTERVAL 7 DAY ORDER BY `order`123
(!!!!! 24838.209152222): 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
7124
(489.95018005371): SELECT fid FROM jos_deeppockets WHERE cat=10 AND id=294739530 AND type='deeppockets_item' AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE cat=10 AND id=294739530 AND type='deeppockets_item' AND published='1' LIMIT 1125
(!!!!! 8643.1503295898): (
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
3126
(99.18212890625): (
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
3127
(83.92333984375): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294803337
LIMIT 1128
(46.968460083008): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294803337
LIMIT 1129
(64.849853515625): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294803276
LIMIT 1130
(43.153762817383): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294803276
LIMIT 1131
(370.97930908203): 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 1132
(56.028366088867): 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 1133
(57.93571472168): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294802958
LIMIT 1134
(36.954879760742): SELECT
dp.id,
dp.name,
dp.title,
dp.video,
dp.video_source,
dp.created
FROM
jos_deeppockets AS dp
WHERE
dp.id = 294802958
LIMIT 1135
(456.09474182129): SELECT *
FROM jos_deeppockets
WHERE 1=1
AND id=294739530
AND (type='deeppockets_item' OR type='deeppockets_item_link')
AND published='1'
LIMIT 1136
(300.16899108887): SELECT *
FROM jos_deeppockets_archive
WHERE 1=1
AND id=294739530
AND (type='deeppockets_item' OR type='deeppockets_item_link')
AND published='1'
LIMIT 1137
(200.98686218262): SELECT name FROM jos_deeppockets WHERE id=216138
(50.067901611328): SELECT name FROM jos_deeppockets WHERE id=216139
(530.95817565918): 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 '((;)|(^))216((;)|($))' AND catid IN (0,110)
ORDER BY publish_up ASC LIMIT 3140
(442.0280456543): 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 '((;)|(^))216((;)|($))' AND catid IN (0,110)
ORDER BY publish_up ASC LIMIT 3141
(90.122222900391): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1142
(62.942504882812): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1143
(!!!!! 8745.9087371826): TRUNCATE TABLE jos_trademed_module144
(82.015991210938): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 1145
(56.028366088867): SELECT dp.*, ch.title as channel, exp.name as author_name, exp.specialization as author_specialization, exp.images as author_photo FROM jos_deeppockets_archive as dp
LEFT JOIN jos_experts as exp
ON exp.id = dp.author
LEFT JOIN jos_deeppockets as ch
ON dp.fid = ch.id
WHERE 1=1
AND dp.cat=10
AND dp.id=294739530
AND (dp.type='deeppockets_item' OR dp.type='deeppockets_item_link')
AND dp.published='1' LIMIT 1146
(!!!!! 1040.9355163574): SELECT *
FROM jos_deeppockets
WHERE 1=1
AND id=294739530
AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1147
(83.208084106445): SELECT *
FROM jos_deeppockets
WHERE 1=1
AND id=294739530
AND (type='deeppockets_item' OR type='deeppockets_item_link') AND published='1' LIMIT 1148
(102.99682617188): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1149
(63.180923461914): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1150
(!!!!! 1472.9499816895): 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 6151
(82.969665527344): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1152
(44.107437133789): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1153
(37.908554077148): SELECT fid FROM jos_deeppockets WHERE cat=10 AND id=294739530 AND type='deeppockets_item' AND published='1' union SELECT fid FROM jos_deeppockets_archive WHERE cat=10 AND id=294739530 AND type='deeppockets_item' AND published='1' LIMIT 1154
(30.994415283203): 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=216 or channel_id is null)155
(27.894973754883): 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=216 or channel_id is null)156
(30.040740966797): SELECT livesite FROM jos_dp_categories WHERE id=10 AND published='1' LIMIT 1157
(60.796737670898): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1158
(43.153762817383): SELECT * FROM jos_deeppockets WHERE 1=1 AND id=294739530 AND published='1'
union
SELECT * FROM jos_deeppockets_archive WHERE 1=1 AND id=294739530 AND published='1'
LIMIT 1159
(61.03515625): select jos_twitters.link from jos_twitters where cat=10160
(42.915344238281): select jos_facebook.link from jos_facebook where cat=10161
(40.769577026367): select jos_google_plus.link from jos_google_plus where cat=10162
(41.007995605469): select jos_linkedin.link from jos_linkedin where cat=10163
(298.02322387695): update jos_bannersmanager_banner
set impmade=impmade+1
where id in(14202,14203)164
(949.85961914062): insert into jos_banners_delta values (14202,'2025-09-18 21:15:34','216.73.216.184','view'),(14203,'2025-09-18 21:15:34','216.73.216.184','view')