Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

8.58 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	2.26 ms	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 Parameters: [`"robots.txt" 1 1`] View formatted query View runnable query Explain query 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;
2	5.35 ms	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
3	0.97 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

#▲

Time

Info

2.26 ms

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

Parameters:

[
  "robots.txt"
  1
  1
]

View formatted query View runnable query Explain query

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;

5.35 ms

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'

Parameters:

[]

View formatted query View runnable query Explain query

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

0.97 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Group	No errors.
App\Entity\Entitygroup	No errors.
App\Entity\Entity	No errors.
App\Entity\Themeapplication	No errors.
App\Entity\Country	No errors.
App\Entity\Entityemail	No errors.
App\Entity\Printer	No errors.
App\Entity\Firebaseproject	No errors.
App\Entity\Entitytype	No errors.
App\Entity\Area	No errors.
App\Entity\Groupimage	No errors.
App\Entity\Groupconfigapp	No errors.
App\Entity\Entityschedule	No errors.
App\Entity\Entityattribute	No errors.
App\Entity\Entitycontact	No errors.
App\Entity\Entitycrmconfig	No errors.
App\Entity\Entitypaymentconfig	No errors.
App\Entity\Entitydeliveryzone	No errors.
App\Entity\Entitydiscount	No errors.
App\Entity\Entityfee	No errors.
App\Entity\Entityimage	No errors.
App\Entity\Orderpayment	No errors.
App\Entity\Entitycity	No errors.
App\Entity\Productsection	No errors.
App\Entity\Pageformat	No errors.
App\Entity\Printerpdf	No errors.
App\Entity\City	The field App\Entity\City#areas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Area#city does not contain the required 'inversedBy="areas"' attribute.

Symfony Profiler

https://staging.pedidosfree.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping