Symfony Profiler

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  g0_.IDGROUP AS IDGROUP_0,
  g0_.NAME AS NAME_1,
  g0_.URLPATH AS URLPATH_2,
  g0_.TYPEAPPLICATION AS TYPEAPPLICATION_3,
  g0_.FOLDERIMAGENAME AS FOLDERIMAGENAME_4,
  g0_.HASAPPMOBILE AS HASAPPMOBILE_5,
  g0_.FORCELOGINMOBILE AS FORCELOGINMOBILE_6,
  g0_.DESCRIPTION AS DESCRIPTION_7,
  g0_.FACEBOOKPAGE AS FACEBOOKPAGE_8,
  g0_.APPLESTOREURL AS APPLESTOREURL_9,
  g0_.APPLESTOREVERSION AS APPLESTOREVERSION_10,
  g0_.PLAYSTOREVERSION AS PLAYSTOREVERSION_11,
  g0_.PLAYSTOREURL AS PLAYSTOREURL_12,
  g0_.MODEMAINTENANCE AS MODEMAINTENANCE_13,
  g0_.MAINTENANCEMESSAGE AS MAINTENANCEMESSAGE_14,
  g0_.TIMEZONE AS TIMEZONE_15,
  g0_.ACTIVE AS ACTIVE_16,
  g0_.FIREBASETOPIC AS FIREBASETOPIC_17,
  e1_.IDENTITYGROUP AS IDENTITYGROUP_18,
  e1_.ACTIVE AS ACTIVE_19,
  e1_.ORDERSECUENCIAL AS ORDERSECUENCIAL_20,
  e2_.IDENTITY AS IDENTITY_21,
  e2_.NAME AS NAME_22,
  e2_.STREET AS STREET_23,
  e2_.STREETNUMBER AS STREETNUMBER_24,
  e2_.PHONE AS PHONE_25,
  e2_.LATITUDE AS LATITUDE_26,
  e2_.LONGITUDE AS LONGITUDE_27,
  e2_.AMOUNTMIN AS AMOUNTMIN_28,
  e2_.URLPATH AS URLPATH_29,
  e2_.BASEPATHIMAGE AS BASEPATHIMAGE_30,
  e2_.ERPVENDOR AS ERPVENDOR_31,
  e2_.RECEIVEDVENDOR AS RECEIVEDVENDOR_32,
  e2_.DEFAULTPRINT AS DEFAULTPRINT_33,
  e2_.SLOGAN AS SLOGAN_34,
  e2_.WEBSITE AS WEBSITE_35,
  e2_.FOLDERIMAGENAME AS FOLDERIMAGENAME_36,
  e2_.ACTIVE AS ACTIVE_37,
  e2_.FIREBASETOPIC AS FIREBASETOPIC_38,
  e2_.MODEMAINTENANCE AS MODEMAINTENANCE_39,
  e2_.MAINTENANCEMESSAGE AS MAINTENANCEMESSAGE_40,
  e2_.SHIPPINGINFORMATION AS SHIPPINGINFORMATION_41,
  e2_.SCHEDULETYPE AS SCHEDULETYPE_42,
  e2_.SCHEDULEDESCRIPTION AS SCHEDULEDESCRIPTION_43,
  e2_.SCHEDULEDESCRIPTIONLABEL AS SCHEDULEDESCRIPTIONLABEL_44,
  e2_.NOTIFICATIONQTYMAX AS NOTIFICATIONQTYMAX_45,
  e2_.PRODUCTCHARGEMAX AS PRODUCTCHARGEMAX_46,
  g0_.IDTHEMEAPPLICATION AS IDTHEMEAPPLICATION_47,
  g0_.IDCOUNTRY AS IDCOUNTRY_48,
  e1_.IDGROUP AS IDGROUP_49,
  e1_.IDENTITY AS IDENTITY_50,
  e2_.IDENTITYEMAIL AS IDENTITYEMAIL_51,
  e2_.IDPRINTER AS IDPRINTER_52,
  e2_.IDFIREBASEPROJECT AS IDFIREBASEPROJECT_53,
  e2_.IDENTITYTYPE AS IDENTITYTYPE_54,
  e2_.IDAREA AS IDAREA_55
FROM
  `groups` g0_
  LEFT JOIN entitygroup e1_ ON g0_.IDGROUP = e1_.IDGROUP
  LEFT JOIN entity e2_ ON e1_.IDENTITY = e2_.IDENTITY
WHERE
  g0_.URLPATH = ?
  AND e2_.ACTIVE = ?
  AND g0_.ACTIVE = ?
ORDER BY
  e1_.ORDERSECUENCIAL ASC

SELECT g0_.IDGROUP AS IDGROUP_0, g0_.NAME AS NAME_1, g0_.URLPATH AS URLPATH_2, g0_.TYPEAPPLICATION AS TYPEAPPLICATION_3, g0_.FOLDERIMAGENAME AS FOLDERIMAGENAME_4, g0_.HASAPPMOBILE AS HASAPPMOBILE_5, g0_.FORCELOGINMOBILE AS FORCELOGINMOBILE_6, g0_.DESCRIPTION AS DESCRIPTION_7, g0_.FACEBOOKPAGE AS FACEBOOKPAGE_8, g0_.APPLESTOREURL AS APPLESTOREURL_9, g0_.APPLESTOREVERSION AS APPLESTOREVERSION_10, g0_.PLAYSTOREVERSION AS PLAYSTOREVERSION_11, g0_.PLAYSTOREURL AS PLAYSTOREURL_12, g0_.MODEMAINTENANCE AS MODEMAINTENANCE_13, g0_.MAINTENANCEMESSAGE AS MAINTENANCEMESSAGE_14, g0_.TIMEZONE AS TIMEZONE_15, g0_.ACTIVE AS ACTIVE_16, g0_.FIREBASETOPIC AS FIREBASETOPIC_17, e1_.IDENTITYGROUP AS IDENTITYGROUP_18, e1_.ACTIVE AS ACTIVE_19, e1_.ORDERSECUENCIAL AS ORDERSECUENCIAL_20, e2_.IDENTITY AS IDENTITY_21, e2_.NAME AS NAME_22, e2_.STREET AS STREET_23, e2_.STREETNUMBER AS STREETNUMBER_24, e2_.PHONE AS PHONE_25, e2_.LATITUDE AS LATITUDE_26, e2_.LONGITUDE AS LONGITUDE_27, e2_.AMOUNTMIN AS AMOUNTMIN_28, e2_.URLPATH AS URLPATH_29, e2_.BASEPATHIMAGE AS BASEPATHIMAGE_30, e2_.ERPVENDOR AS ERPVENDOR_31, e2_.RECEIVEDVENDOR AS RECEIVEDVENDOR_32, e2_.DEFAULTPRINT AS DEFAULTPRINT_33, e2_.SLOGAN AS SLOGAN_34, e2_.WEBSITE AS WEBSITE_35, e2_.FOLDERIMAGENAME AS FOLDERIMAGENAME_36, e2_.ACTIVE AS ACTIVE_37, e2_.FIREBASETOPIC AS FIREBASETOPIC_38, e2_.MODEMAINTENANCE AS MODEMAINTENANCE_39, e2_.MAINTENANCEMESSAGE AS MAINTENANCEMESSAGE_40, e2_.SHIPPINGINFORMATION AS SHIPPINGINFORMATION_41, e2_.SCHEDULETYPE AS SCHEDULETYPE_42, e2_.SCHEDULEDESCRIPTION AS SCHEDULEDESCRIPTION_43, e2_.SCHEDULEDESCRIPTIONLABEL AS SCHEDULEDESCRIPTIONLABEL_44, e2_.NOTIFICATIONQTYMAX AS NOTIFICATIONQTYMAX_45, e2_.PRODUCTCHARGEMAX AS PRODUCTCHARGEMAX_46, g0_.IDTHEMEAPPLICATION AS IDTHEMEAPPLICATION_47, g0_.IDCOUNTRY AS IDCOUNTRY_48, e1_.IDGROUP AS IDGROUP_49, e1_.IDENTITY AS IDENTITY_50, e2_.IDENTITYEMAIL AS IDENTITYEMAIL_51, e2_.IDPRINTER AS IDPRINTER_52, e2_.IDFIREBASEPROJECT AS IDFIREBASEPROJECT_53, e2_.IDENTITYTYPE AS IDENTITYTYPE_54, e2_.IDAREA AS IDAREA_55 FROM `groups` g0_ LEFT JOIN entitygroup e1_ ON g0_.IDGROUP = e1_.IDGROUP LEFT JOIN entity e2_ ON e1_.IDENTITY = e2_.IDENTITY WHERE g0_.URLPATH = 'robots.txt' AND e2_.ACTIVE = 1 AND g0_.ACTIVE = 1 ORDER BY e1_.ORDERSECUENCIAL ASC;

SELECT
  DATABASE()

SELECT DATABASE();