SELECT * FROM sessions WHERE session_id = u1d1jtrrn6ad4cb9ognknvdpn3
Speed: 9.669 ms
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(u1d1jtrrn6ad4cb9ognknvdpn3, 3.134.245.35, Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), 1740295094, 1740295094, 0, , journal.uinsgd.ac.id
Speed: 1.487 ms
|
SELECT * FROM journals WHERE path = Re
Speed: 4.406 ms
|
Speed: 1.664 ms
|
Speed: 104.596 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.272 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 0.221 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.247 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.207 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.209 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.223 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.204 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.200 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.226 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
INNER JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 24501
Speed: 17.777 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 24501
Speed: 1.263 ms
|
Speed: 3.418 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9818
Speed: 1.106 ms
|
SELECT * FROM article_settings WHERE article_id = 24501
Speed: 1.113 ms
|
Speed: 0.941 ms
|
SELECT i.*
FROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id
WHERE ist.setting_name = pub-id::publisher-id AND ist.setting_value = 1209
Speed: 2.990 ms
|
Speed: 0.219 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1209
Speed: 0.996 ms
|
SELECT iss.subscription_id
FROM
institutional_subscriptions iss,
subscriptions s,
subscription_types st
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(ec2-3-134-245-35.us-east-2.compute.amazonaws.com, LENGTH(ec2-3-134-245-35.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 34
Speed: 0.386 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 59176227 >= isip.ip_start AND 59176227 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 34
AND s.status = 1
AND s.type_id = st.type_id
AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-02-23 07:18:14' >= s.date_start AND '2025-02-23 07:18:14' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 59176227 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 34
Speed: 3.284 ms
|
SELECT * FROM sections WHERE section_id = 36
Speed: 7.688 ms
|
SELECT * FROM section_settings WHERE section_id = 36
Speed: 0.320 ms
|
SELECT * FROM sections WHERE section_id = 36
Speed: 12.816 ms
|
SELECT * FROM section_settings WHERE section_id = 36
Speed: 0.325 ms
|
SELECT g.*,
af.file_name, af.original_file_name, af.file_stage, af.file_type, af.file_size, af.date_uploaded, af.date_modified
FROM article_galleys g
LEFT JOIN article_files af ON (g.file_id = af.file_id)
INNER JOIN articles a ON a.article_id = g.article_id
LEFT JOIN published_articles pa ON g.article_id = pa.article_id INNER JOIN article_galley_settings gs ON g.galley_id = gs.galley_id
WHERE gs.setting_name = pub-id::publisher-id AND gs.setting_value = 0 AND g.article_id = 24501
Speed: 0.617 ms
|
SELECT g.*,
a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.galley_id = 0 AND g.article_id = 24501
Speed: 0.243 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
INNER JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 24501
Speed: 9.504 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 24501
Speed: 0.617 ms
|
Speed: 0.413 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9818
Speed: 0.291 ms
|
SELECT * FROM article_settings WHERE article_id = 24501
Speed: 0.415 ms
|
Speed: 0.314 ms
|
SELECT iss.subscription_id
FROM
institutional_subscriptions iss,
subscriptions s,
subscription_types st
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(ec2-3-134-245-35.us-east-2.compute.amazonaws.com, LENGTH(ec2-3-134-245-35.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 34
Speed: 0.332 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 59176227 >= isip.ip_start AND 59176227 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 34
AND s.status = 1
AND s.type_id = st.type_id
AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-02-23 07:18:15' >= s.date_start AND '2025-02-23 07:18:15' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 59176227 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 34
Speed: 0.314 ms
|
SELECT *
FROM citations
WHERE assoc_type = 257 AND assoc_id = 24501 AND citation_state >= 0 AND citation_state <= 5
Speed: 36.770 ms
|
SELECT * FROM sections WHERE section_id = 36
Speed: 0.483 ms
|
SELECT * FROM section_settings WHERE section_id = 36
Speed: 0.285 ms
|
Speed: 70.092 ms
|
Speed: 11.073 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1377
Speed: 0.401 ms
|
Speed: 9.261 ms
|
SELECT * FROM author_settings WHERE author_id = 39079
Speed: 7.001 ms
|
SELECT * FROM author_settings WHERE author_id = 46803
Speed: 0.357 ms
|
SELECT * FROM author_settings WHERE author_id = 46804
Speed: 0.286 ms
|
SELECT * FROM author_settings WHERE author_id = 46805
Speed: 0.293 ms
|
SELECT * FROM author_settings WHERE author_id = 46806
Speed: 0.267 ms
|
Speed: 1.065 ms
|
SELECT * FROM author_settings WHERE author_id = 39079
Speed: 1.110 ms
|
SELECT * FROM author_settings WHERE author_id = 46803
Speed: 0.830 ms
|
SELECT * FROM author_settings WHERE author_id = 46804
Speed: 0.307 ms
|
SELECT * FROM author_settings WHERE author_id = 46805
Speed: 0.889 ms
|
SELECT * FROM author_settings WHERE author_id = 46806
Speed: 0.866 ms
|
Speed: 10.020 ms
|
SELECT * FROM author_settings WHERE author_id = 39079
Speed: 0.979 ms
|
SELECT * FROM author_settings WHERE author_id = 46803
Speed: 1.044 ms
|
SELECT * FROM author_settings WHERE author_id = 46804
Speed: 0.838 ms
|
SELECT * FROM author_settings WHERE author_id = 46805
Speed: 0.880 ms
|
SELECT * FROM author_settings WHERE author_id = 46806
Speed: 0.880 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
LEFT JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN issues i ON pa.issue_id = i.issue_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE i.published = 1
AND a.journal_id = 34
Speed: 65.367 ms
|
Speed: 0.467 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 962
Speed: 0.281 ms
|
SELECT * FROM article_settings WHERE article_id = 1374
Speed: 0.380 ms
|
Speed: 0.425 ms
|
Speed: 2.347 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 965
Speed: 1.127 ms
|
SELECT * FROM article_settings WHERE article_id = 1366
Speed: 0.445 ms
|
Speed: 0.294 ms
|
Speed: 0.359 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 961
Speed: 0.334 ms
|
SELECT * FROM article_settings WHERE article_id = 1359
Speed: 0.411 ms
|
Speed: 0.596 ms
|
Speed: 0.342 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 963
Speed: 10.206 ms
|
SELECT * FROM article_settings WHERE article_id = 1360
Speed: 0.427 ms
|
Speed: 0.324 ms
|
Speed: 0.362 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 966
Speed: 0.265 ms
|
SELECT * FROM article_settings WHERE article_id = 1371
Speed: 0.399 ms
|
Speed: 0.309 ms
|
Speed: 0.347 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 964
Speed: 0.261 ms
|
SELECT * FROM article_settings WHERE article_id = 1372
Speed: 0.385 ms
|
Speed: 0.304 ms
|
Speed: 0.339 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 967
Speed: 0.271 ms
|
SELECT * FROM article_settings WHERE article_id = 1370
Speed: 0.379 ms
|
Speed: 0.312 ms
|
Speed: 0.339 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 960
Speed: 0.263 ms
|
SELECT * FROM article_settings WHERE article_id = 1382
Speed: 0.374 ms
|
Speed: 0.293 ms
|
Speed: 0.357 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1574
Speed: 0.272 ms
|
SELECT * FROM article_settings WHERE article_id = 1934
Speed: 0.422 ms
|
Speed: 0.293 ms
|
Speed: 0.365 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1150
Speed: 0.314 ms
|
SELECT * FROM article_settings WHERE article_id = 1357
Speed: 0.388 ms
|
Speed: 0.294 ms
|
Speed: 0.345 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1149
Speed: 0.279 ms
|
SELECT * FROM article_settings WHERE article_id = 1389
Speed: 0.382 ms
|
Speed: 0.305 ms
|
Speed: 0.343 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1151
Speed: 0.279 ms
|
SELECT * FROM article_settings WHERE article_id = 1390
Speed: 0.384 ms
|
Speed: 0.300 ms
|
Speed: 0.338 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1152
Speed: 0.259 ms
|
SELECT * FROM article_settings WHERE article_id = 1391
Speed: 0.401 ms
|
Speed: 0.282 ms
|
Speed: 0.343 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1154
Speed: 0.257 ms
|
SELECT * FROM article_settings WHERE article_id = 1392
Speed: 0.387 ms
|
Speed: 0.295 ms
|
Speed: 0.347 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1153
Speed: 0.255 ms
|
SELECT * FROM article_settings WHERE article_id = 1393
Speed: 0.402 ms
|
Speed: 12.370 ms
|
Speed: 0.405 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1156
Speed: 0.280 ms
|
SELECT * FROM article_settings WHERE article_id = 1395
Speed: 0.407 ms
|
Speed: 0.304 ms
|
Speed: 0.354 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1155
Speed: 0.261 ms
|
SELECT * FROM article_settings WHERE article_id = 1394
Speed: 0.410 ms
|
Speed: 1.279 ms
|
Speed: 10.044 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1575
Speed: 0.324 ms
|
SELECT * FROM article_settings WHERE article_id = 2145
Speed: 0.401 ms
|
Speed: 0.302 ms
|
Speed: 0.381 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1576
Speed: 0.295 ms
|
SELECT * FROM article_settings WHERE article_id = 2213
Speed: 0.412 ms
|
Speed: 0.300 ms
|
Speed: 0.358 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1577
Speed: 0.280 ms
|
SELECT * FROM article_settings WHERE article_id = 2214
Speed: 0.387 ms
|
Speed: 0.293 ms
|
Speed: 0.351 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1580
Speed: 0.315 ms
|
SELECT * FROM article_settings WHERE article_id = 2217
Speed: 0.388 ms
|
Speed: 0.295 ms
|
Speed: 0.348 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1581
Speed: 0.280 ms
|
SELECT * FROM article_settings WHERE article_id = 2361
Speed: 0.399 ms
|
Speed: 0.301 ms
|
Speed: 0.338 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1578
Speed: 0.287 ms
|
SELECT * FROM article_settings WHERE article_id = 2215
Speed: 0.364 ms
|
Speed: 0.292 ms
|
Speed: 0.344 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1579
Speed: 0.274 ms
|
SELECT * FROM article_settings WHERE article_id = 2216
Speed: 0.383 ms
|
Speed: 1.606 ms
|
Speed: 11.246 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1929
Speed: 0.333 ms
|
SELECT * FROM article_settings WHERE article_id = 3105
Speed: 0.400 ms
|
Speed: 0.334 ms
|
Speed: 0.357 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1924
Speed: 0.386 ms
|
SELECT * FROM article_settings WHERE article_id = 3097
Speed: 0.425 ms
|
Speed: 0.309 ms
|
Speed: 0.361 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1926
Speed: 0.302 ms
|
SELECT * FROM article_settings WHERE article_id = 3099
Speed: 0.425 ms
|
Speed: 0.307 ms
|
Speed: 0.403 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1925
Speed: 0.321 ms
|
SELECT * FROM article_settings WHERE article_id = 3098
Speed: 0.441 ms
|
Speed: 0.291 ms
|
Speed: 0.352 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1927
Speed: 0.271 ms
|
SELECT * FROM article_settings WHERE article_id = 3100
Speed: 0.409 ms
|
Speed: 0.378 ms
|
Speed: 0.362 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1931
Speed: 0.288 ms
|
SELECT * FROM article_settings WHERE article_id = 3101
Speed: 0.371 ms
|
Speed: 0.308 ms
|
Speed: 0.339 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1930
Speed: 0.299 ms
|
SELECT * FROM article_settings WHERE article_id = 3102
Speed: 0.363 ms
|
Speed: 0.289 ms
|
Speed: 0.336 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1928
Speed: 0.818 ms
|
SELECT * FROM article_settings WHERE article_id = 3104
Speed: 22.741 ms
|
Speed: 1.054 ms
|
Speed: 1.077 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2435
Speed: 0.830 ms
|
SELECT * FROM article_settings WHERE article_id = 3495
Speed: 11.984 ms
|
Speed: 1.171 ms
|
Speed: 1.150 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2443
Speed: 0.841 ms
|
SELECT * FROM article_settings WHERE article_id = 3314
Speed: 1.095 ms
|
Speed: 0.855 ms
|
Speed: 0.968 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2438
Speed: 0.558 ms
|
SELECT * FROM article_settings WHERE article_id = 3460
Speed: 0.433 ms
|
Speed: 0.310 ms
|
Speed: 0.347 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2442
Speed: 0.289 ms
|
SELECT * FROM article_settings WHERE article_id = 3673
Speed: 0.393 ms
|
Speed: 0.322 ms
|
Speed: 2.830 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2439
Speed: 0.280 ms
|
SELECT * FROM article_settings WHERE article_id = 3786
Speed: 0.436 ms
|
Speed: 0.319 ms
|
Speed: 13.305 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2441
Speed: 0.393 ms
|
SELECT * FROM article_settings WHERE article_id = 3888
Speed: 0.452 ms
|
Speed: 0.341 ms
|
Speed: 0.403 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2440
Speed: 0.374 ms
|
SELECT * FROM article_settings WHERE article_id = 3918
Speed: 0.421 ms
|
Speed: 0.314 ms
|
Speed: 0.339 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2444
Speed: 0.299 ms
|
SELECT * FROM article_settings WHERE article_id = 4099
Speed: 0.438 ms
|
Speed: 0.304 ms
|
Speed: 0.373 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3448
Speed: 0.299 ms
|
SELECT * FROM article_settings WHERE article_id = 4404
Speed: 0.482 ms
|
Speed: 0.394 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 556
Speed: 0.367 ms
|
Speed: 0.395 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2736
Speed: 0.308 ms
|
SELECT * FROM article_settings WHERE article_id = 4626
Speed: 0.518 ms
|
Speed: 0.316 ms
|
Speed: 0.387 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2738
Speed: 0.306 ms
|
SELECT * FROM article_settings WHERE article_id = 4712
Speed: 0.455 ms
|
Speed: 0.313 ms
|
Speed: 2.643 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2737
Speed: 0.305 ms
|
SELECT * FROM article_settings WHERE article_id = 4717
Speed: 0.472 ms
|
Speed: 0.610 ms
|
Speed: 0.364 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3447
Speed: 2.770 ms
|
SELECT * FROM article_settings WHERE article_id = 4739
Speed: 0.438 ms
|
Speed: 0.322 ms
|
Speed: 0.361 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3449
Speed: 0.309 ms
|
SELECT * FROM article_settings WHERE article_id = 4799
Speed: 0.405 ms
|
Speed: 0.298 ms
|
Speed: 0.355 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3446
Speed: 0.282 ms
|
SELECT * FROM article_settings WHERE article_id = 5095
Speed: 0.402 ms
|
Speed: 0.307 ms
|
Speed: 0.390 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3788
Speed: 0.301 ms
|
SELECT * FROM article_settings WHERE article_id = 7296
Speed: 0.485 ms
|
Speed: 0.408 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1097
Speed: 0.376 ms
|
Speed: 0.374 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3789
Speed: 0.327 ms
|
SELECT * FROM article_settings WHERE article_id = 6432
Speed: 0.472 ms
|
Speed: 0.302 ms
|
Speed: 0.381 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3786
Speed: 0.281 ms
|
SELECT * FROM article_settings WHERE article_id = 6442
Speed: 0.515 ms
|
Speed: 2.044 ms
|
Speed: 0.389 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3787
Speed: 0.283 ms
|
SELECT * FROM article_settings WHERE article_id = 7297
Speed: 0.451 ms
|
Speed: 0.387 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1098
Speed: 2.006 ms
|
Speed: 0.433 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3923
Speed: 0.320 ms
|
SELECT * FROM article_settings WHERE article_id = 7605
Speed: 0.567 ms
|
Speed: 0.347 ms
|
Speed: 0.353 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3784
Speed: 0.288 ms
|
SELECT * FROM article_settings WHERE article_id = 7614
Speed: 0.455 ms
|
Speed: 0.311 ms
|
Speed: 0.366 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3785
Speed: 0.287 ms
|
SELECT * FROM article_settings WHERE article_id = 7653
Speed: 0.450 ms
|
Speed: 0.304 ms
|
Speed: 0.399 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4134
Speed: 0.342 ms
|
SELECT * FROM article_settings WHERE article_id = 8592
Speed: 0.434 ms
|
Speed: 0.340 ms
|
Speed: 0.367 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4109
Speed: 0.300 ms
|
SELECT * FROM article_settings WHERE article_id = 8597
Speed: 0.458 ms
|
Speed: 0.306 ms
|
Speed: 0.377 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4128
Speed: 0.302 ms
|
SELECT * FROM article_settings WHERE article_id = 8250
Speed: 0.607 ms
|
Speed: 0.326 ms
|
Speed: 0.377 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4135
Speed: 0.315 ms
|
SELECT * FROM article_settings WHERE article_id = 8593
Speed: 0.538 ms
|
Speed: 0.320 ms
|
Speed: 0.423 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4133
Speed: 0.330 ms
|
SELECT * FROM article_settings WHERE article_id = 8596
Speed: 0.443 ms
|
Speed: 0.310 ms
|
Speed: 0.367 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4127
Speed: 0.318 ms
|
SELECT * FROM article_settings WHERE article_id = 8598
Speed: 0.454 ms
|
Speed: 0.307 ms
|
Speed: 0.371 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4849
Speed: 0.337 ms
|
SELECT * FROM article_settings WHERE article_id = 9592
Speed: 0.452 ms
|
Speed: 0.323 ms
|
Speed: 0.382 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4850
Speed: 2.776 ms
|
SELECT * FROM article_settings WHERE article_id = 9444
Speed: 0.495 ms
|
Speed: 0.334 ms
|
Speed: 0.380 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4841
Speed: 0.304 ms
|
SELECT * FROM article_settings WHERE article_id = 9814
Speed: 0.451 ms
|
Speed: 0.310 ms
|
Speed: 0.663 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4851
Speed: 0.332 ms
|
SELECT * FROM article_settings WHERE article_id = 9593
Speed: 0.452 ms
|
Speed: 0.304 ms
|
Speed: 0.386 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4842
Speed: 0.295 ms
|
SELECT * FROM article_settings WHERE article_id = 8079
Speed: 0.472 ms
|
Speed: 0.315 ms
|
Speed: 0.348 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4853
Speed: 0.329 ms
|
SELECT * FROM article_settings WHERE article_id = 8880
Speed: 0.437 ms
|
Speed: 0.310 ms
|
Speed: 0.350 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4852
Speed: 0.318 ms
|
SELECT * FROM article_settings WHERE article_id = 9617
Speed: 0.450 ms
|
Speed: 0.301 ms
|
Speed: 0.381 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5184
Speed: 0.273 ms
|
SELECT * FROM article_settings WHERE article_id = 10039
Speed: 0.483 ms
|
Speed: 0.337 ms
|
Speed: 0.368 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5179
Speed: 0.298 ms
|
SELECT * FROM article_settings WHERE article_id = 10256
Speed: 2.270 ms
|
Speed: 1.692 ms
|
Speed: 0.390 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5185
Speed: 0.281 ms
|
SELECT * FROM article_settings WHERE article_id = 9206
Speed: 0.453 ms
|
Speed: 0.318 ms
|
Speed: 0.389 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5192
Speed: 0.309 ms
|
SELECT * FROM article_settings WHERE article_id = 9449
Speed: 0.477 ms
|
Speed: 0.314 ms
|
Speed: 0.408 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5183
Speed: 0.275 ms
|
SELECT * FROM article_settings WHERE article_id = 10476
Speed: 0.429 ms
|
Speed: 0.309 ms
|
Speed: 0.381 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5459
Speed: 0.307 ms
|
SELECT * FROM article_settings WHERE article_id = 10268
Speed: 0.522 ms
|
Speed: 0.315 ms
|
Speed: 0.372 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5452
Speed: 0.295 ms
|
SELECT * FROM article_settings WHERE article_id = 11164
Speed: 0.601 ms
|
Speed: 0.335 ms
|
Speed: 0.379 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5461
Speed: 0.304 ms
|
SELECT * FROM article_settings WHERE article_id = 11788
Speed: 0.473 ms
|
Speed: 0.311 ms
|
Speed: 0.374 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5462
Speed: 0.284 ms
|
SELECT * FROM article_settings WHERE article_id = 9685
Speed: 0.436 ms
|
Speed: 2.471 ms
|
Speed: 0.396 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5555
Speed: 0.303 ms
|
SELECT * FROM article_settings WHERE article_id = 9817
Speed: 0.455 ms
|
Speed: 0.300 ms
|
Speed: 0.377 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5574
Speed: 0.288 ms
|
SELECT * FROM article_settings WHERE article_id = 10755
Speed: 0.492 ms
|
Speed: 0.318 ms
|
Speed: 2.451 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5572
Speed: 0.315 ms
|
SELECT * FROM article_settings WHERE article_id = 8920
Speed: 0.454 ms
|
Speed: 0.309 ms
|
Speed: 0.383 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5573
Speed: 0.274 ms
|
SELECT * FROM article_settings WHERE article_id = 10378
Speed: 0.489 ms
|
Speed: 0.329 ms
|
Speed: 0.401 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5575
Speed: 0.306 ms
|
SELECT * FROM article_settings WHERE article_id = 11615
Speed: 0.426 ms
|
Speed: 0.315 ms
|
Speed: 0.366 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5842
Speed: 0.311 ms
|
SELECT * FROM article_settings WHERE article_id = 10097
Speed: 0.465 ms
|
Speed: 0.311 ms
|
Speed: 0.382 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5848
Speed: 0.289 ms
|
SELECT * FROM article_settings WHERE article_id = 10456
Speed: 0.489 ms
|
Speed: 0.327 ms
|
Speed: 0.360 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5856
Speed: 0.307 ms
|
SELECT * FROM article_settings WHERE article_id = 10691
Speed: 0.491 ms
|
Speed: 0.302 ms
|
Speed: 0.380 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5947
Speed: 0.286 ms
|
SELECT * FROM article_settings WHERE article_id = 11436
Speed: 0.460 ms
|
Speed: 0.298 ms
|
Speed: 0.362 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5946
Speed: 0.595 ms
|
SELECT * FROM article_settings WHERE article_id = 10190
Speed: 0.489 ms
|
Speed: 0.305 ms
|
Speed: 2.197 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5948
Speed: 2.394 ms
|
SELECT * FROM article_settings WHERE article_id = 11847
Speed: 0.502 ms
|
Speed: 0.320 ms
|
Speed: 0.382 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5958
Speed: 0.311 ms
|
SELECT * FROM article_settings WHERE article_id = 9521
Speed: 0.450 ms
|
Speed: 0.308 ms
|
Speed: 0.368 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5952
Speed: 0.278 ms
|
SELECT * FROM article_settings WHERE article_id = 11116
Speed: 0.470 ms
|
Speed: 0.371 ms
|
Speed: 0.369 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5949
Speed: 0.290 ms
|
SELECT * FROM article_settings WHERE article_id = 11343
Speed: 0.449 ms
|
Speed: 0.352 ms
|
Speed: 0.380 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5955
Speed: 0.280 ms
|
SELECT * FROM article_settings WHERE article_id = 11350
Speed: 0.476 ms
|
Speed: 0.304 ms
|
Speed: 0.376 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5961
Speed: 0.297 ms
|
SELECT * FROM article_settings WHERE article_id = 12636
Speed: 0.395 ms
|
Speed: 0.318 ms
|
Speed: 0.374 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5959
Speed: 0.272 ms
|
SELECT * FROM article_settings WHERE article_id = 12339
Speed: 7.118 ms
|
Speed: 0.383 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2339
Speed: 0.414 ms
|
Speed: 0.398 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5960
Speed: 0.306 ms
|
SELECT * FROM article_settings WHERE article_id = 12677
Speed: 0.426 ms
|
Speed: 0.305 ms
|
Speed: 0.385 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5989
Speed: 0.286 ms
|
SELECT * FROM article_settings WHERE article_id = 11661
Speed: 0.460 ms
|
Speed: 0.325 ms
|
Speed: 0.364 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5980
Speed: 0.292 ms
|
SELECT * FROM article_settings WHERE article_id = 11627
Speed: 0.475 ms
|
Speed: 0.325 ms
|
Speed: 0.397 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5988
Speed: 0.307 ms
|
SELECT * FROM article_settings WHERE article_id = 11645
Speed: 0.446 ms
|
Speed: 0.311 ms
|
Speed: 0.363 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6060
Speed: 0.306 ms
|
SELECT * FROM article_settings WHERE article_id = 13804
Speed: 0.426 ms
|
Speed: 0.305 ms
|
Speed: 0.390 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6719
Speed: 0.301 ms
|
SELECT * FROM article_settings WHERE article_id = 12500
Speed: 1.762 ms
|
Speed: 0.331 ms
|
Speed: 0.370 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6731
Speed: 0.318 ms
|
SELECT * FROM article_settings WHERE article_id = 13605
Speed: 0.452 ms
|
Speed: 0.590 ms
|
Speed: 0.388 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6729
Speed: 0.285 ms
|
SELECT * FROM article_settings WHERE article_id = 13463
Speed: 0.420 ms
|
Speed: 0.319 ms
|
Speed: 0.346 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6733
Speed: 0.310 ms
|
SELECT * FROM article_settings WHERE article_id = 13791
Speed: 0.405 ms
|
Speed: 0.303 ms
|
Speed: 0.361 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6732
Speed: 0.296 ms
|
SELECT * FROM article_settings WHERE article_id = 14578
Speed: 0.441 ms
|
Speed: 0.300 ms
|
Speed: 0.365 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6716
Speed: 0.271 ms
|
SELECT * FROM article_settings WHERE article_id = 11533
Speed: 0.435 ms
|
Speed: 0.307 ms
|
Speed: 0.371 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6548
Speed: 0.283 ms
|
SELECT * FROM article_settings WHERE article_id = 12062
Speed: 0.437 ms
|
Speed: 0.372 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2327
Speed: 0.418 ms
|
Speed: 0.398 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6853
Speed: 0.316 ms
|
SELECT * FROM article_settings WHERE article_id = 12652
Speed: 6.125 ms
|
Speed: 0.405 ms
|
Speed: 0.388 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6551
Speed: 0.293 ms
|
SELECT * FROM article_settings WHERE article_id = 13302
Speed: 0.450 ms
|
Speed: 0.325 ms
|
Speed: 0.381 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6796
Speed: 0.284 ms
|
SELECT * FROM article_settings WHERE article_id = 13075
Speed: 0.470 ms
|
Speed: 0.320 ms
|
Speed: 0.378 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7398
Speed: 0.316 ms
|
SELECT * FROM article_settings WHERE article_id = 17041
Speed: 5.438 ms
|
Speed: 0.409 ms
|
Speed: 0.423 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7316
Speed: 0.282 ms
|
SELECT * FROM article_settings WHERE article_id = 17571
Speed: 0.467 ms
|
Speed: 0.320 ms
|
Speed: 0.374 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7383
Speed: 0.337 ms
|
SELECT * FROM article_settings WHERE article_id = 11817
Speed: 0.464 ms
|
Speed: 0.307 ms
|
Speed: 0.355 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7385
Speed: 0.297 ms
|
SELECT * FROM article_settings WHERE article_id = 13802
Speed: 0.456 ms
|
Speed: 0.301 ms
|
Speed: 0.370 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7327
Speed: 0.285 ms
|
SELECT * FROM article_settings WHERE article_id = 13937
Speed: 0.411 ms
|
Speed: 0.329 ms
|
Speed: 0.359 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7251
Speed: 0.306 ms
|
SELECT * FROM article_settings WHERE article_id = 14718
Speed: 0.467 ms
|
Speed: 0.310 ms
|
Speed: 0.384 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7295
Speed: 0.307 ms
|
SELECT * FROM article_settings WHERE article_id = 16739
Speed: 4.623 ms
|
Speed: 0.351 ms
|
Speed: 0.359 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7296
Speed: 0.307 ms
|
SELECT * FROM article_settings WHERE article_id = 10212
Speed: 0.447 ms
|
Speed: 0.369 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1853
Speed: 0.413 ms
|
Speed: 0.437 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7275
Speed: 0.288 ms
|
SELECT * FROM article_settings WHERE article_id = 13476
Speed: 0.454 ms
|
Speed: 0.305 ms
|
Speed: 0.357 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7274
Speed: 0.311 ms
|
SELECT * FROM article_settings WHERE article_id = 15113
Speed: 7.683 ms
|
Speed: 0.337 ms
|
Speed: 0.369 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8011
Speed: 0.287 ms
|
SELECT * FROM article_settings WHERE article_id = 17395
Speed: 0.467 ms
|
Speed: 0.319 ms
|
Speed: 0.374 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7716
Speed: 0.294 ms
|
SELECT * FROM article_settings WHERE article_id = 14267
Speed: 0.478 ms
|
Speed: 0.307 ms
|
Speed: 0.373 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7790
Speed: 0.302 ms
|
SELECT * FROM article_settings WHERE article_id = 15058
Speed: 0.405 ms
|
Speed: 0.302 ms
|
Speed: 0.354 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8037
Speed: 0.320 ms
|
SELECT * FROM article_settings WHERE article_id = 17587
Speed: 0.449 ms
|
Speed: 0.305 ms
|
Speed: 0.387 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7839
Speed: 0.306 ms
|
SELECT * FROM article_settings WHERE article_id = 20249
Speed: 0.455 ms
|
Speed: 0.311 ms
|
Speed: 0.391 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8035
Speed: 0.560 ms
|
SELECT * FROM article_settings WHERE article_id = 16364
Speed: 0.463 ms
|
Speed: 0.301 ms
|
Speed: 0.354 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8036
Speed: 0.284 ms
|
SELECT * FROM article_settings WHERE article_id = 21396
Speed: 0.474 ms
|
Speed: 0.297 ms
|
Speed: 0.684 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7681
Speed: 0.300 ms
|
SELECT * FROM article_settings WHERE article_id = 19746
Speed: 0.462 ms
|
Speed: 0.299 ms
|
Speed: 0.398 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8055
Speed: 0.305 ms
|
SELECT * FROM article_settings WHERE article_id = 12679
Speed: 0.457 ms
|
Speed: 0.305 ms
|
Speed: 0.363 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8056
Speed: 0.321 ms
|
SELECT * FROM article_settings WHERE article_id = 15610
Speed: 0.449 ms
|
Speed: 0.324 ms
|
Speed: 0.398 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8058
Speed: 0.347 ms
|
SELECT * FROM article_settings WHERE article_id = 22151
Speed: 0.449 ms
|
Speed: 0.296 ms
|
Speed: 0.355 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8054
Speed: 0.327 ms
|
SELECT * FROM article_settings WHERE article_id = 20246
Speed: 0.431 ms
|
Speed: 0.320 ms
|
Speed: 0.355 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8059
Speed: 0.306 ms
|
SELECT * FROM article_settings WHERE article_id = 22139
Speed: 0.438 ms
|
Speed: 0.310 ms
|
Speed: 2.149 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8057
Speed: 0.308 ms
|
SELECT * FROM article_settings WHERE article_id = 21439
Speed: 0.481 ms
|
Speed: 0.310 ms
|
Speed: 0.381 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8063
Speed: 0.309 ms
|
SELECT * FROM article_settings WHERE article_id = 16789
Speed: 7.498 ms
|
Speed: 0.334 ms
|
Speed: 0.403 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8066
Speed: 0.308 ms
|
SELECT * FROM article_settings WHERE article_id = 19354
Speed: 0.456 ms
|
Speed: 0.374 ms
|
Speed: 0.381 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8071
Speed: 0.301 ms
|
SELECT * FROM article_settings WHERE article_id = 21360
Speed: 0.511 ms
|
Speed: 0.315 ms
|
Speed: 0.389 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8709
Speed: 0.292 ms
|
SELECT * FROM article_settings WHERE article_id = 24250
Speed: 0.461 ms
|
Speed: 0.337 ms
|
Speed: 0.398 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8935
Speed: 0.320 ms
|
SELECT * FROM article_settings WHERE article_id = 21409
Speed: 0.452 ms
|
Speed: 0.305 ms
|
Speed: 0.386 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9603
Speed: 0.305 ms
|
SELECT * FROM article_settings WHERE article_id = 22648
Speed: 0.488 ms
|
Speed: 0.338 ms
|
Speed: 0.354 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9066
Speed: 0.341 ms
|
SELECT * FROM article_settings WHERE article_id = 25182
Speed: 0.456 ms
|
Speed: 0.311 ms
|
Speed: 0.408 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9073
Speed: 0.307 ms
|
SELECT * FROM article_settings WHERE article_id = 24898
Speed: 0.466 ms
|
Speed: 0.315 ms
|
Speed: 0.383 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8936
Speed: 0.339 ms
|
SELECT * FROM article_settings WHERE article_id = 25232
Speed: 0.491 ms
|
Speed: 0.311 ms
|
Speed: 0.385 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9210
Speed: 0.291 ms
|
SELECT * FROM article_settings WHERE article_id = 21446
Speed: 0.460 ms
|
Speed: 0.301 ms
|
Speed: 0.373 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10687
Speed: 2.452 ms
|
SELECT * FROM article_settings WHERE article_id = 28773
Speed: 0.487 ms
|
Speed: 0.332 ms
|
Speed: 0.379 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10686
Speed: 0.304 ms
|
SELECT * FROM article_settings WHERE article_id = 27677
Speed: 1.676 ms
|
Speed: 0.422 ms
|
Speed: 0.371 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10685
Speed: 0.321 ms
|
SELECT * FROM article_settings WHERE article_id = 23668
Speed: 0.513 ms
|
Speed: 0.420 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4562
Speed: 0.889 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4563
Speed: 0.358 ms
|
Speed: 0.400 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9818
Speed: 0.336 ms
|
SELECT * FROM article_settings WHERE article_id = 24501
Speed: 0.474 ms
|
Speed: 0.359 ms
|
Speed: 0.386 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9810
Speed: 0.300 ms
|
SELECT * FROM article_settings WHERE article_id = 25203
Speed: 0.478 ms
|
Speed: 0.314 ms
|
Speed: 1.545 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9646
Speed: 0.330 ms
|
SELECT * FROM article_settings WHERE article_id = 21851
Speed: 0.474 ms
|
Speed: 0.341 ms
|
Speed: 0.379 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9819
Speed: 0.310 ms
|
SELECT * FROM article_settings WHERE article_id = 23321
Speed: 0.485 ms
|
Speed: 0.316 ms
|
Speed: 0.379 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10650
Speed: 0.304 ms
|
SELECT * FROM article_settings WHERE article_id = 25281
Speed: 0.488 ms
|
Speed: 0.322 ms
|
Speed: 0.396 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9811
Speed: 0.308 ms
|
SELECT * FROM article_settings WHERE article_id = 28311
Speed: 0.477 ms
|
Speed: 0.375 ms
|
Speed: 0.399 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9817
Speed: 0.288 ms
|
SELECT * FROM article_settings WHERE article_id = 29658
Speed: 0.470 ms
|
Speed: 0.318 ms
|
Speed: 0.408 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10937
Speed: 0.309 ms
|
SELECT * FROM article_settings WHERE article_id = 23342
Speed: 0.505 ms
|
Speed: 0.323 ms
|
Speed: 0.370 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10741
Speed: 0.309 ms
|
SELECT * FROM article_settings WHERE article_id = 24254
Speed: 0.496 ms
|
Speed: 0.311 ms
|
Speed: 0.380 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10815
Speed: 2.123 ms
|
SELECT * FROM article_settings WHERE article_id = 20840
Speed: 0.477 ms
|
Speed: 0.338 ms
|
Speed: 0.378 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10843
Speed: 0.313 ms
|
SELECT * FROM article_settings WHERE article_id = 21424
Speed: 0.438 ms
|
Speed: 0.306 ms
|
Speed: 0.414 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10836
Speed: 0.298 ms
|
SELECT * FROM article_settings WHERE article_id = 23623
Speed: 0.470 ms
|
Speed: 0.309 ms
|
Speed: 0.366 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10936
Speed: 0.312 ms
|
SELECT * FROM article_settings WHERE article_id = 30828
Speed: 0.397 ms
|
Speed: 0.327 ms
|
Speed: 0.381 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11691
Speed: 0.383 ms
|
SELECT * FROM article_settings WHERE article_id = 24813
Speed: 0.467 ms
|
Speed: 0.364 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4716
Speed: 0.363 ms
|
Speed: 0.375 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11681
Speed: 0.325 ms
|
SELECT * FROM article_settings WHERE article_id = 11657
Speed: 0.438 ms
|
Speed: 0.385 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2089
Speed: 0.366 ms
|
Speed: 0.382 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11708
Speed: 0.304 ms
|
SELECT * FROM article_settings WHERE article_id = 38927
Speed: 0.408 ms
|
Speed: 0.330 ms
|
Speed: 0.368 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11698
Speed: 0.576 ms
|
SELECT * FROM article_settings WHERE article_id = 25543
Speed: 0.471 ms
|
Speed: 0.315 ms
|
Speed: 0.368 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11273
Speed: 0.314 ms
|
SELECT * FROM article_settings WHERE article_id = 29532
Speed: 1.012 ms
|
Speed: 0.441 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5692
Speed: 0.683 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5852
Speed: 5.000 ms
|
Speed: 0.408 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11277
Speed: 0.304 ms
|
SELECT * FROM article_settings WHERE article_id = 35241
Speed: 0.468 ms
|
Speed: 0.339 ms
|
Speed: 0.389 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11706
Speed: 0.294 ms
|
SELECT * FROM article_settings WHERE article_id = 33664
Speed: 0.473 ms
|
Speed: 0.311 ms
|
Speed: 0.651 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11707
Speed: 1.699 ms
|
SELECT * FROM article_settings WHERE article_id = 30830
Speed: 0.999 ms
|
Speed: 1.711 ms
|
Speed: 0.409 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11700
Speed: 0.300 ms
|
SELECT * FROM article_settings WHERE article_id = 34224
Speed: 0.921 ms
|
Speed: 0.779 ms
|
Speed: 2.704 ms
|
SELECT * FROM author_settings WHERE author_id = 39079
Speed: 0.406 ms
|
SELECT * FROM author_settings WHERE author_id = 46803
Speed: 0.324 ms
|
SELECT * FROM author_settings WHERE author_id = 46804
Speed: 11.173 ms
|
SELECT * FROM author_settings WHERE author_id = 46805
Speed: 0.393 ms
|
SELECT * FROM author_settings WHERE author_id = 46806
Speed: 0.353 ms
|
Speed: 2.558 ms
|
SELECT * FROM author_settings WHERE author_id = 39079
Speed: 0.409 ms
|
SELECT * FROM author_settings WHERE author_id = 46803
Speed: 0.306 ms
|
SELECT * FROM author_settings WHERE author_id = 46804
Speed: 0.282 ms
|
SELECT * FROM author_settings WHERE author_id = 46805
Speed: 0.757 ms
|
SELECT * FROM author_settings WHERE author_id = 46806
Speed: 0.800 ms
|
Speed: 6.270 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1377
Speed: 1.467 ms
|
Speed: 8.403 ms
|
SELECT * FROM author_settings WHERE author_id = 39079
Speed: 0.371 ms
|
SELECT * FROM author_settings WHERE author_id = 46803
Speed: 0.295 ms
|
SELECT * FROM author_settings WHERE author_id = 46804
Speed: 0.694 ms
|
SELECT * FROM author_settings WHERE author_id = 46805
Speed: 0.451 ms
|
SELECT * FROM author_settings WHERE author_id = 46806
Speed: 0.809 ms
|
Speed: 4.963 ms
|
SELECT * FROM author_settings WHERE author_id = 39079
Speed: 0.397 ms
|
SELECT * FROM author_settings WHERE author_id = 46803
Speed: 0.285 ms
|
SELECT * FROM author_settings WHERE author_id = 46804
Speed: 0.288 ms
|
SELECT * FROM author_settings WHERE author_id = 46805
Speed: 0.270 ms
|
SELECT * FROM author_settings WHERE author_id = 46806
Speed: 0.867 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351448
Speed: 2.191 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351448
Speed: 1.413 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351449
Speed: 11.848 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351449
Speed: 0.331 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351450
Speed: 0.294 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351450
Speed: 0.273 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351451
Speed: 0.282 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351451
Speed: 0.575 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351452
Speed: 0.292 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351452
Speed: 0.263 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351453
Speed: 0.273 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351453
Speed: 0.261 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351454
Speed: 0.284 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351454
Speed: 0.262 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351455
Speed: 0.354 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351455
Speed: 0.280 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351456
Speed: 0.270 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351456
Speed: 0.277 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351457
Speed: 2.109 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351457
Speed: 0.283 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351458
Speed: 10.853 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351458
Speed: 0.327 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351459
Speed: 0.295 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351459
Speed: 0.278 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351460
Speed: 0.272 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351460
Speed: 0.272 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351461
Speed: 0.269 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351461
Speed: 0.269 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351462
Speed: 0.295 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351462
Speed: 0.253 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351463
Speed: 0.266 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351463
Speed: 0.262 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351464
Speed: 0.268 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351464
Speed: 0.266 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351465
Speed: 0.296 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351465
Speed: 0.265 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351466
Speed: 0.352 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351466
Speed: 0.276 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351467
Speed: 0.289 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351467
Speed: 0.261 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351468
Speed: 12.738 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351468
Speed: 0.347 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351469
Speed: 0.316 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351469
Speed: 0.268 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351470
Speed: 0.271 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351470
Speed: 0.258 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351471
Speed: 0.286 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351471
Speed: 0.253 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351472
Speed: 0.270 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351472
Speed: 0.252 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351473
Speed: 0.284 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351473
Speed: 0.265 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351474
Speed: 0.311 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351474
Speed: 0.255 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351475
Speed: 0.270 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351475
Speed: 0.291 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351476
Speed: 0.284 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351476
Speed: 0.260 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351477
Speed: 10.775 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351477
Speed: 10.852 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351478
Speed: 0.315 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351478
Speed: 0.283 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351479
Speed: 5.897 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351479
Speed: 0.286 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351480
Speed: 0.300 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351480
Speed: 0.262 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351481
Speed: 0.271 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351481
Speed: 0.275 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351482
Speed: 0.294 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351482
Speed: 0.260 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351483
Speed: 0.279 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351483
Speed: 0.254 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351484
Speed: 0.977 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351484
Speed: 0.771 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351485
Speed: 2.465 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351485
Speed: 1.128 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351486
Speed: 1.998 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351486
Speed: 0.276 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351487
Speed: 1.932 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351487
Speed: 0.270 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351488
Speed: 2.101 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351488
Speed: 0.268 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351489
Speed: 1.961 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351489
Speed: 0.836 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351490
Speed: 2.018 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351490
Speed: 0.742 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351491
Speed: 5.569 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351491
Speed: 0.814 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351492
Speed: 1.847 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351492
Speed: 0.273 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351493
Speed: 2.371 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351493
Speed: 0.264 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351494
Speed: 2.289 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351494
Speed: 0.737 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351495
Speed: 2.007 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351495
Speed: 0.254 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351496
Speed: 1.927 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351496
Speed: 0.861 ms
|
SELECT * FROM citation_settings WHERE citation_id = 351497
Speed: 1.433 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 351497
Speed: 0.775 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
INNER JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 24501
Speed: 3.488 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 24501
Speed: 1.044 ms
|
Speed: 1.485 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9818
Speed: 0.900 ms
|
SELECT * FROM article_settings WHERE article_id = 24501
Speed: 0.925 ms
|
Speed: 0.882 ms
|
SELECT r.*
FROM referrals r
WHERE r.article_id = 24501 AND
r.status = 2
Speed: 8.985 ms
|