1.83 ms
(18.16%)
|
3 |
SELECT * FROM phpcr_nodes
WHERE path = ?
AND workspace_name = ?
ORDER BY depth, sort_order ASC
Parameters: [
"/cmf/website/custom-urls/routes/imagohealthsystems.com/news/training-the-next-generation"
"default_live"
]
SELECT * FROM phpcr_nodes
WHERE path = '/cmf/website/custom-urls/routes/imagohealthsystems.com/news/training-the-next-generation'
AND workspace_name = 'default_live'
ORDER BY depth, sort_order ASC;
|
1.58 ms
(15.68%)
|
1 |
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Parameters: [
"imagohealthsystems.com/{localization}"
"dev"
"website"
]
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'imagohealthsystems.com/{localization}' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'website' ORDER BY w0_.id ASC;
|
1.41 ms
(13.96%)
|
1 |
SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target_id AS target_id_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target_id AS target_id_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target_id = r1_.id WHERE r0_.path = ? AND r0_.locale = ?
Parameters: [
"/news/training-the-next-generation"
"en"
]
SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target_id AS target_id_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target_id AS target_id_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target_id = r1_.id WHERE r0_.path = '/news/training-the-next-generation' AND r0_.locale = 'en';
|
1.29 ms
(12.85%)
|
1 |
SELECT t0.id AS id_1, t0.images AS images_2, t0.type AS type_3, t4.id AS id_5, t4.hide_in_sitemap AS hide_in_sitemap_6, t4.no_follow AS no_follow_7, t4.no_index AS no_index_8, t4.news_id AS news_id_9, t10.id AS id_11, t10.news_id AS news_id_12 FROM app_news t0 LEFT JOIN app_news_seo t4 ON t4.news_id = t0.id LEFT JOIN app_news_excerpt t10 ON t10.news_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.images AS images_2, t0.type AS type_3, t4.id AS id_5, t4.hide_in_sitemap AS hide_in_sitemap_6, t4.no_follow AS no_follow_7, t4.no_index AS no_index_8, t4.news_id AS news_id_9, t10.id AS id_11, t10.news_id AS news_id_12 FROM app_news t0 LEFT JOIN app_news_seo t4 ON t4.news_id = t0.id LEFT JOIN app_news_excerpt t10 ON t10.news_id = t0.id WHERE t0.id = 2;
|
1.27 ms
(12.65%)
|
1 |
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = ? AND t0.locale = ?)
SELECT COUNT(*) FROM app_news_translation t0 WHERE (t0.news_id = 2 AND t0.locale = 'en');
|
1.20 ms
(11.93%)
|
1 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = ? AND t0.locale = ? LIMIT 1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.authored AS authored_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.news_id AS news_id_18, t0.author_id AS author_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23 FROM app_news_translation t0 WHERE t0.news_id = 2 AND t0.locale = 'en' LIMIT 1;
|
1.15 ms
(11.44%)
|
1 |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters: [
"default_live"
]
SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';
|
0.33 ms
(3.32%)
|
1 |
SELECT prefix, uri FROM phpcr_namespaces
SELECT prefix, uri FROM phpcr_namespaces;
|