34.24 ms (46.71%)
|
4 |
SELECT c.TABLE_NAME, c.COLUMN_NAME AS field,
c.COLUMN_TYPE AS type,
c.IS_NULLABLE AS `null`,
c.COLUMN_KEY AS `key`,
c.COLUMN_DEFAULT AS `default`,
c.EXTRA,
c.COLUMN_COMMENT AS comment,
c.CHARACTER_SET_NAME AS characterset,
c.COLLATION_NAME AS collation
FROM information_schema.COLUMNS c
INNER JOIN information_schema.TABLES t
ON t.TABLE_NAME = c.TABLE_NAME
WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION
Parameters: [
"cmsagencetwco_chanoine"
"cmsagencetwco_chanoine"
]
SELECT c.TABLE_NAME, c.COLUMN_NAME AS field,
c.COLUMN_TYPE AS type,
c.IS_NULLABLE AS `null`,
c.COLUMN_KEY AS `key`,
c.COLUMN_DEFAULT AS `default`,
c.EXTRA,
c.COLUMN_COMMENT AS comment,
c.CHARACTER_SET_NAME AS characterset,
c.COLLATION_NAME AS collation
FROM information_schema.COLUMNS c
INNER JOIN information_schema.TABLES t
ON t.TABLE_NAME = c.TABLE_NAME
WHERE c.TABLE_SCHEMA = 'cmsagencetwco_chanoine' AND t.TABLE_SCHEMA = 'cmsagencetwco_chanoine' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION;
|
19.52 ms (26.63%)
|
4 |
SELECT t.TABLE_NAME,
t.ENGINE,
t.AUTO_INCREMENT,
t.TABLE_COMMENT,
t.CREATE_OPTIONS,
t.TABLE_COLLATION,
ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters: [
"cmsagencetwco_chanoine"
]
SELECT t.TABLE_NAME,
t.ENGINE,
t.AUTO_INCREMENT,
t.TABLE_COMMENT,
t.CREATE_OPTIONS,
t.TABLE_COLLATION,
ccsa.CHARACTER_SET_NAME
FROM information_schema.TABLES t
INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'cmsagencetwco_chanoine' AND t.TABLE_TYPE = 'BASE TABLE';
|
11.87 ms (16.19%)
|
4 |
SELECT DISTINCT k.TABLE_NAME, k.CONSTRAINT_NAME,
k.COLUMN_NAME,
k.REFERENCED_TABLE_NAME,
k.REFERENCED_COLUMN_NAME,
k.ORDINAL_POSITION
FROM information_schema.key_column_usage k WHERE k.TABLE_SCHEMA = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION
Parameters: [
"cmsagencetwco_chanoine"
]
SELECT DISTINCT k.TABLE_NAME, k.CONSTRAINT_NAME,
k.COLUMN_NAME,
k.REFERENCED_TABLE_NAME,
k.REFERENCED_COLUMN_NAME,
k.ORDINAL_POSITION
FROM information_schema.key_column_usage k WHERE k.TABLE_SCHEMA = 'cmsagencetwco_chanoine' AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION;
|
4.95 ms (6.75%)
|
4 |
SELECT TABLE_NAME, NON_UNIQUE AS Non_Unique,
INDEX_NAME AS Key_name,
COLUMN_NAME AS Column_Name,
SUB_PART AS Sub_Part,
INDEX_TYPE AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? ORDER BY SEQ_IN_INDEX
Parameters: [
"cmsagencetwco_chanoine"
]
SELECT TABLE_NAME, NON_UNIQUE AS Non_Unique,
INDEX_NAME AS Key_name,
COLUMN_NAME AS Column_Name,
SUB_PART AS Sub_Part,
INDEX_TYPE AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'cmsagencetwco_chanoine' ORDER BY SEQ_IN_INDEX;
|
1.09 ms (1.49%)
|
4 |
SELECT DATABASE()
|
0.47 ms (0.64%)
|
1 |
SELECT t0.category AS category_1, t0.name AS name_2, t0._key AS _key_3, t0.type AS type_4, t0.value AS value_5, t0.id AS id_6 FROM config t0 WHERE t0._key = ? LIMIT 1
Parameters: [
"404_translation"
]
SELECT t0.category AS category_1, t0.name AS name_2, t0._key AS _key_3, t0.type AS type_4, t0.value AS value_5, t0.id AS id_6 FROM config t0 WHERE t0._key = '404_translation' LIMIT 1;
|
0.44 ms (0.61%)
|
1 |
SELECT l0_.code AS code_0 FROM locale l0_
SELECT l0_.code AS code_0 FROM locale l0_;
|
0.44 ms (0.61%)
|
1 |
SELECT p0_.current_version AS current_version_0, p0_.publish AS publish_1, p0_.publish_date AS publish_date_2, p0_.id AS id_3, p0_.initial_locale AS initial_locale_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.type_id AS type_id_7, p0_.user_id AS user_id_8 FROM page p0_ INNER JOIN page_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.slug = ?)
SELECT p0_.current_version AS current_version_0, p0_.publish AS publish_1, p0_.publish_date AS publish_date_2, p0_.id AS id_3, p0_.initial_locale AS initial_locale_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.type_id AS type_id_7, p0_.user_id AS user_id_8 FROM page p0_ INNER JOIN page_translation p1_ ON p0_.id = p1_.translatable_id AND (p1_.slug = '/');
|
0.28 ms (0.38%)
|
1 |
SELECT t0.code AS code_1, t0.isdefault AS isdefault_2, t0.id AS id_3 FROM locale t0 WHERE t0.isdefault = ? LIMIT 1
SELECT t0.code AS code_1, t0.isdefault AS isdefault_2, t0.id AS id_3 FROM locale t0 WHERE t0.isdefault = 1 LIMIT 1;
|