Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.content AS content_4,
  t0.meta_title AS meta_title_5,
  t0.meta_content AS meta_content_6,
  t0.url_rewrite AS url_rewrite_7,
  t0.is_active AS is_active_8,
  t0.content_small AS content_small_9,
  t0.ref_cfg_langues_id AS ref_cfg_langues_id_10
FROM
  sector t0
WHERE
  t0.id = ?
  AND t0.ref_cfg_langues_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.content AS content_4, t0.meta_title AS meta_title_5, t0.meta_content AS meta_content_6, t0.url_rewrite AS url_rewrite_7, t0.is_active AS is_active_8, t0.content_small AS content_small_9, t0.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM sector t0 WHERE t0.id = 2 AND t0.ref_cfg_langues_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.message AS message_2,
  t0.code AS code_3,
  t0.file AS file_4,
  t0.trace AS trace_5,
  t0.line AS line_6,
  t0.class_name AS class_name_7,
  t0.path AS path_8
FROM
  exceptions_logs t0

SELECT t0.id AS id_1, t0.message AS message_2, t0.code AS code_3, t0.file AS file_4, t0.trace AS trace_5, t0.line AS line_6, t0.class_name AS class_name_7, t0.path AS path_8 FROM exceptions_logs t0;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.site_name AS site_name_2,
  p0_.content_small AS content_small_3,
  p0_.content AS content_4,
  p0_.image AS image_5,
  p0_.rank_order AS rank_order_6,
  p0_.is_active AS is_active_7,
  p0_.meta_title AS meta_title_8,
  p0_.meta_content AS meta_content_9,
  p0_.meta_og_title AS meta_og_title_10,
  p0_.meta_og_image AS meta_og_image_11,
  p0_.meta_twitter_title AS meta_twitter_title_12,
  p0_.meta_twitter_image AS meta_twitter_image_13,
  p0_.rewrite AS rewrite_14,
  p0_.date_update AS date_update_15,
  p0_.ref_pages_id AS ref_pages_id_16,
  p0_.ref_cfg_langues_id AS ref_cfg_langues_id_17
FROM
  pages p0_
  LEFT JOIN cfg_langues c1_ ON p0_.ref_cfg_langues_id = c1_.id
WHERE
  p0_.is_active = 1
  AND p0_.id = ?
  AND c1_.iso = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.site_name AS site_name_2, p0_.content_small AS content_small_3, p0_.content AS content_4, p0_.image AS image_5, p0_.rank_order AS rank_order_6, p0_.is_active AS is_active_7, p0_.meta_title AS meta_title_8, p0_.meta_content AS meta_content_9, p0_.meta_og_title AS meta_og_title_10, p0_.meta_og_image AS meta_og_image_11, p0_.meta_twitter_title AS meta_twitter_title_12, p0_.meta_twitter_image AS meta_twitter_image_13, p0_.rewrite AS rewrite_14, p0_.date_update AS date_update_15, p0_.ref_pages_id AS ref_pages_id_16, p0_.ref_cfg_langues_id AS ref_cfg_langues_id_17 FROM pages p0_ LEFT JOIN cfg_langues c1_ ON p0_.ref_cfg_langues_id = c1_.id WHERE p0_.is_active = 1 AND p0_.id = 12 AND c1_.iso = 'fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.name AS name_3,
  t0.image AS image_4,
  t0.content AS content_5,
  t0.content_small AS content_small_6,
  t0.utilization AS utilization_7,
  t0.benefit AS benefit_8,
  t0.packaging AS packaging_9,
  t0.color AS color_10,
  t0.meta_title AS meta_title_11,
  t0.meta_content AS meta_content_12,
  t0.url_rewrite AS url_rewrite_13,
  t0.is_active AS is_active_14,
  t0.ref_cfg_langues_id AS ref_cfg_langues_id_15,
  t0.ref_product_type_id AS ref_product_type_id_16
FROM
  product t0
WHERE
  t0.id = ?
  AND t0.ref_cfg_langues_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.name AS name_3, t0.image AS image_4, t0.content AS content_5, t0.content_small AS content_small_6, t0.utilization AS utilization_7, t0.benefit AS benefit_8, t0.packaging AS packaging_9, t0.color AS color_10, t0.meta_title AS meta_title_11, t0.meta_content AS meta_content_12, t0.url_rewrite AS url_rewrite_13, t0.is_active AS is_active_14, t0.ref_cfg_langues_id AS ref_cfg_langues_id_15, t0.ref_product_type_id AS ref_product_type_id_16 FROM product t0 WHERE t0.id = 1 AND t0.ref_cfg_langues_id = 1 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.image AS image_2,
  s0_.content AS content_3,
  s0_.meta_title AS meta_title_4,
  s0_.meta_content AS meta_content_5,
  s0_.url_rewrite AS url_rewrite_6,
  s0_.is_active AS is_active_7,
  s0_.content_small AS content_small_8,
  s0_.ref_cfg_langues_id AS ref_cfg_langues_id_9
FROM
  sector s0_
WHERE
  s0_.is_active = ?
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image AS image_2, s0_.content AS content_3, s0_.meta_title AS meta_title_4, s0_.meta_content AS meta_content_5, s0_.url_rewrite AS url_rewrite_6, s0_.is_active AS is_active_7, s0_.content_small AS content_small_8, s0_.ref_cfg_langues_id AS ref_cfg_langues_id_9 FROM sector s0_ WHERE s0_.is_active = 1 ORDER BY s0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.tag AS tag_2,
  t0.name AS name_3,
  t0.class AS class_4,
  t0.has_parent_link AS has_parent_link_5,
  t0.has_leveling AS has_leveling_6,
  t0.has_ssmenu AS has_ssmenu_7,
  t0.config AS config_8,
  t0.is_in_sitemap AS is_in_sitemap_9,
  t0.ref_cfg_langues_id AS ref_cfg_langues_id_10
FROM
  cfg_menus t0
WHERE
  t0.tag = ?
  AND t0.ref_cfg_langues_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.tag AS tag_2, t0.name AS name_3, t0.class AS class_4, t0.has_parent_link AS has_parent_link_5, t0.has_leveling AS has_leveling_6, t0.has_ssmenu AS has_ssmenu_7, t0.config AS config_8, t0.is_in_sitemap AS is_in_sitemap_9, t0.ref_cfg_langues_id AS ref_cfg_langues_id_10 FROM cfg_menus t0 WHERE t0.tag = 'menu_haut' AND t0.ref_cfg_langues_id = 1 LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.rank_order AS rank_order_2,
  n0_.is_target_blank AS is_target_blank_3,
  n0_.link_type AS link_type_4,
  n0_.image AS image_5,
  n0_.custom AS custom_6,
  n0_.link AS link_7,
  n0_.ref_cfg_menus_id AS ref_cfg_menus_id_8,
  n0_.ref_navigation_id AS ref_navigation_id_9
FROM
  navigation n0_
WHERE
  n0_.ref_cfg_menus_id = ?
ORDER BY
  n0_.rank_order ASC

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.rank_order AS rank_order_2, n0_.is_target_blank AS is_target_blank_3, n0_.link_type AS link_type_4, n0_.image AS image_5, n0_.custom AS custom_6, n0_.link AS link_7, n0_.ref_cfg_menus_id AS ref_cfg_menus_id_8, n0_.ref_navigation_id AS ref_navigation_id_9 FROM navigation n0_ WHERE n0_.ref_cfg_menus_id = 1 ORDER BY n0_.rank_order ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.image AS image_2,
  a0_.content AS content_3,
  a0_.is_active AS is_active_4,
  a0_.application_support AS application_support_5,
  a0_.finish AS finish_6,
  a0_.technical_file AS technical_file_7,
  a0_.meta_title AS meta_title_8,
  a0_.meta_content AS meta_content_9,
  a0_.url_rewrite AS url_rewrite_10,
  a0_.ref_cfg_langues_id AS ref_cfg_langues_id_11,
  a0_.ref_sector_id AS ref_sector_id_12
FROM
  application a0_
WHERE
  a0_.is_active = ?
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.image AS image_2, a0_.content AS content_3, a0_.is_active AS is_active_4, a0_.application_support AS application_support_5, a0_.finish AS finish_6, a0_.technical_file AS technical_file_7, a0_.meta_title AS meta_title_8, a0_.meta_content AS meta_content_9, a0_.url_rewrite AS url_rewrite_10, a0_.ref_cfg_langues_id AS ref_cfg_langues_id_11, a0_.ref_sector_id AS ref_sector_id_12 FROM application a0_ WHERE a0_.is_active = 1 ORDER BY a0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.address_comp AS address_comp_4,
  t0.zip_code AS zip_code_5,
  t0.town AS town_6,
  t0.country AS country_7,
  t0.coordinates AS coordinates_8,
  t0.phone AS phone_9,
  t0.phone2 AS phone2_10,
  t0.fax AS fax_11,
  t0.is_active AS is_active_12
FROM
  cfg_client_addresses t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.address_comp AS address_comp_4, t0.zip_code AS zip_code_5, t0.town AS town_6, t0.country AS country_7, t0.coordinates AS coordinates_8, t0.phone AS phone_9, t0.phone2 AS phone2_10, t0.fax AS fax_11, t0.is_active AS is_active_12 FROM cfg_client_addresses t0 WHERE t0.is_active = 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.image AS image_2,
  p0_.link AS link_3,
  p0_.is_active AS is_active_4
FROM
  partner p0_
WHERE
  p0_.is_active = ?
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image AS image_2, p0_.link AS link_3, p0_.is_active AS is_active_4 FROM partner p0_ WHERE p0_.is_active = 1 ORDER BY p0_.id ASC;

SELECT
  n0_.id AS id_0,
  n0_.is_top AS is_top_1,
  n0_.name AS name_2,
  n0_.catch_phrase AS catch_phrase_3,
  n0_.content AS content_4,
  n0_.date_add AS date_add_5,
  n0_.link AS link_6,
  n0_.image_list AS image_list_7,
  n0_.meta_title AS meta_title_8,
  n0_.meta_keywords AS meta_keywords_9,
  n0_.meta_content AS meta_content_10,
  n0_.rewrite AS rewrite_11,
  n0_.date_update AS date_update_12,
  n0_.is_active AS is_active_13,
  n0_.ref_cfg_langues_id AS ref_cfg_langues_id_14
FROM
  news n0_
  INNER JOIN cfg_langues c1_ ON n0_.ref_cfg_langues_id = c1_.id
WHERE
  c1_.id = ?
  AND n0_.is_top = 1
  AND n0_.is_active = 1
ORDER BY
  n0_.date_add DESC
LIMIT
  3

SELECT n0_.id AS id_0, n0_.is_top AS is_top_1, n0_.name AS name_2, n0_.catch_phrase AS catch_phrase_3, n0_.content AS content_4, n0_.date_add AS date_add_5, n0_.link AS link_6, n0_.image_list AS image_list_7, n0_.meta_title AS meta_title_8, n0_.meta_keywords AS meta_keywords_9, n0_.meta_content AS meta_content_10, n0_.rewrite AS rewrite_11, n0_.date_update AS date_update_12, n0_.is_active AS is_active_13, n0_.ref_cfg_langues_id AS ref_cfg_langues_id_14 FROM news n0_ INNER JOIN cfg_langues c1_ ON n0_.ref_cfg_langues_id = c1_.id WHERE c1_.id = 1 AND n0_.is_top = 1 AND n0_.is_active = 1 ORDER BY n0_.date_add DESC LIMIT 3;

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.image AS image_2,
  c0_.file AS file_3,
  c0_.rank_order AS rank_order_4,
  c0_.is_active AS is_active_5,
  c0_.ref_cfg_langues_id AS ref_cfg_langues_id_6
FROM
  certification c0_
  INNER JOIN cfg_langues c1_ ON c0_.ref_cfg_langues_id = c1_.id
WHERE
  c1_.id = ?
  AND c0_.is_active = ?
ORDER BY
  c0_.rank_order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.image AS image_2, c0_.file AS file_3, c0_.rank_order AS rank_order_4, c0_.is_active AS is_active_5, c0_.ref_cfg_langues_id AS ref_cfg_langues_id_6 FROM certification c0_ INNER JOIN cfg_langues c1_ ON c0_.ref_cfg_langues_id = c1_.id WHERE c1_.id = 1 AND c0_.is_active = 1 ORDER BY c0_.rank_order ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.iso AS iso_2,
  c0_.image AS image_3,
  c0_.is_active AS is_active_4,
  c0_.is_default AS is_default_5,
  c0_.ref_pages_id AS ref_pages_id_6
FROM
  cfg_langues c0_
WHERE
  c0_.is_active = ?
  AND c0_.iso IS NOT NULL
  AND c0_.ref_pages_id IS NOT NULL
ORDER BY
  c0_.is_default DESC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.iso AS iso_2, c0_.image AS image_3, c0_.is_active AS is_active_4, c0_.is_default AS is_default_5, c0_.ref_pages_id AS ref_pages_id_6 FROM cfg_langues c0_ WHERE c0_.is_active = 1 AND c0_.iso IS NOT NULL AND c0_.ref_pages_id IS NOT NULL ORDER BY c0_.is_default DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.commentary AS commentary_4,
  t0.is_active AS is_active_5
FROM
  cfg_constants t0
WHERE
  t0.is_active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.commentary AS commentary_4, t0.is_active AS is_active_5 FROM cfg_constants t0 WHERE t0.is_active = 1;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.tinymce_classes AS tinymce_classes_3,
  t0.analytics AS analytics_4,
  t0.password AS password_5,
  t0.captcha_key AS captcha_key_6,
  t0.captcha_key_secret AS captcha_key_secret_7,
  t0.is_active AS is_active_8,
  t0.ips_auth AS ips_auth_9,
  t0.js_additional AS js_additional_10
FROM
  cfg_site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.tinymce_classes AS tinymce_classes_3, t0.analytics AS analytics_4, t0.password AS password_5, t0.captcha_key AS captcha_key_6, t0.captcha_key_secret AS captcha_key_secret_7, t0.is_active AS is_active_8, t0.ips_auth AS ips_auth_9, t0.js_additional AS js_additional_10 FROM cfg_site t0 WHERE t0.id = 1;

INSERT INTO exceptions_logs (
  message, code, file, trace, line, class_name,
  path
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO exceptions_logs (message, code, file, trace, line, class_name, path) VALUES ('An exception has been thrown during the rendering of a template (\"Some mandatory parameters are missing (\"rewrite\") to generate a URL for route \"web_application_detail\".\").', 0, '/home/vpehcbe/dev/src/Modules/Application/Templates/index.html.twig', '#0 /home/vpehcbe/dev/var/cache/dev/twig/3b/3b9a09a33b03d8bb3565cb748323922e.php(135): Twig\\Template->yieldBlock(\'body\', Array, Array)
#1 /home/vpehcbe/dev/vendor/twig/twig/src/Extension/CoreExtension.php(2079): __TwigTemplate_a275e570632ff4e08187abc3fc9735f4->{closure:{closure:__TwigTemplate_a275e570632ff4e08187abc3fc9735f4::doDisplay():49}:82}()
#2 /home/vpehcbe/dev/var/cache/dev/twig/3b/3b9a09a33b03d8bb3565cb748323922e.php(82): Twig\\Extension\\CoreExtension::captureOutput(Object(Generator))
#3 /home/vpehcbe/dev/vendor/twig/twig/src/Extension/CoreExtension.php(2079): __TwigTemplate_a275e570632ff4e08187abc3fc9735f4->{closure:__TwigTemplate_a275e570632ff4e08187abc3fc9735f4::doDisplay():49}()
#4 /home/vpehcbe/dev/var/cache/dev/twig/3b/3b9a09a33b03d8bb3565cb748323922e.php(49): Twig\\Extension\\CoreExtension::captureOutput(Object(Generator))
#5 /home/vpehcbe/dev/vendor/twig/twig/src/Template.php(388): __TwigTemplate_a275e570632ff4e08187abc3fc9735f4->doDisplay(Array, Array)
#6 /home/vpehcbe/dev/var/cache/dev/twig/8e/8ec3ac00c0f5ce49bcafbfcef043445f.php(54): Twig\\Template->yield(Array, Array)
#7 /home/vpehcbe/dev/vendor/twig/twig/src/Template.php(388): __TwigTemplate_c53124fe7ae59b46d389c67230b5d256->doDisplay(Array, Array)
#8 /home/vpehcbe/dev/vendor/twig/twig/src/Template.php(344): Twig\\Template->yield(Array, Array)
#9 /home/vpehcbe/dev/vendor/twig/twig/src/Template.php(359): Twig\\Template->display(Array)
#10 /home/vpehcbe/dev/vendor/twig/twig/src/TemplateWrapper.php(51): Twig\\Template->render(Array)
#11 /home/vpehcbe/dev/vendor/twig/twig/src/Environment.php(334): Twig\\TemplateWrapper->render(Array)
#12 /home/vpehcbe/dev/vendor/symfony/framework-bundle/Controller/AbstractController.php(431): Twig\\Environment->render(\'@modules/Applic...\', Array)
#13 /home/vpehcbe/dev/vendor/symfony/framework-bundle/Controller/AbstractController.php(436): Symfony\\Bundle\\FrameworkBundle\\Controller\\AbstractController->doRenderView(\'@modules/Applic...\', NULL, Array, \'render\')
#14 /home/vpehcbe/dev/vendor/symfony/framework-bundle/Controller/AbstractController.php(250): Symfony\\Bundle\\FrameworkBundle\\Controller\\AbstractController->doRender(\'@modules/Applic...\', NULL, Array, NULL, \'render\')
#15 /home/vpehcbe/dev/src/Modules/Application/Controller/ApplicationController.php(23): Symfony\\Bundle\\FrameworkBundle\\Controller\\AbstractController->render(\'@modules/Applic...\', Array)
#16 /home/vpehcbe/dev/vendor/symfony/http-kernel/HttpKernel.php(183): App\\Modules\\Application\\Controller\\ApplicationController->indexApplicationList()
#17 /home/vpehcbe/dev/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw(Object(Symfony\\Component\\HttpFoundation\\Request), 1)
#18 /home/vpehcbe/dev/vendor/symfony/http-kernel/Kernel.php(182): Symfony\\Component\\HttpKernel\\HttpKernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request), 1, true)
#19 /home/vpehcbe/dev/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle(Object(Symfony\\Component\\HttpFoundation\\Request))
#20 /home/vpehcbe/dev/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#21 /home/vpehcbe/dev/public/index.php(11): require_once(\'/home/vpehcbe/d...\')
#22 {main}', 13, 'Twig\\Error\\RuntimeError', '/fr/application');

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.favicon AS favicon_3,
  t0.email AS email_4,
  t0.name AS name_5,
  t0.seo_baseline AS seo_baseline_6,
  t0.social_linked_in AS social_linked_in_7,
  t0.social_facebook AS social_facebook_8,
  t0.social_twitter AS social_twitter_9,
  t0.social_youtube AS social_youtube_10,
  t0.social_instagram AS social_instagram_11,
  t0.social_snapchat AS social_snapchat_12,
  t0.social_tik_tok AS social_tik_tok_13,
  t0.maintenance_background AS maintenance_background_14,
  t0.maintenance_color AS maintenance_color_15,
  t0.maintenance_content AS maintenance_content_16
FROM
  cfg_client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.favicon AS favicon_3, t0.email AS email_4, t0.name AS name_5, t0.seo_baseline AS seo_baseline_6, t0.social_linked_in AS social_linked_in_7, t0.social_facebook AS social_facebook_8, t0.social_twitter AS social_twitter_9, t0.social_youtube AS social_youtube_10, t0.social_instagram AS social_instagram_11, t0.social_snapchat AS social_snapchat_12, t0.social_tik_tok AS social_tik_tok_13, t0.maintenance_background AS maintenance_background_14, t0.maintenance_color AS maintenance_color_15, t0.maintenance_content AS maintenance_content_16 FROM cfg_client t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.url_rewrite AS url_rewrite_2,
  t0.name AS name_3,
  t0.ref_cfg_langues_id AS ref_cfg_langues_id_4
FROM
  product_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url_rewrite AS url_rewrite_2, t0.name AS name_3, t0.ref_cfg_langues_id AS ref_cfg_langues_id_4 FROM product_type t0 WHERE t0.id = 1;

DELETE FROM
  exceptions_logs
WHERE
  id = ?

DELETE FROM exceptions_logs WHERE id = 6452;

"START TRANSACTION"

"START TRANSACTION";