SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.content AS content_2, n0_.slug AS slug_3, n0_.external_link AS external_link_4, n0_.is_published AS is_published_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.user_id AS user_id_8 FROM news n0_ WHERE n0_.is_published = ? ORDER BY n0_.created_at DESC LIMIT 3
SELECT d0_.id AS id_0, d0_.status AS status_1, d0_.description AS description_2, d0_.step AS step_3, d0_.latitude AS latitude_4, d0_.longitude AS longitude_5, d0_.comment AS comment_6, d0_.company_rating AS company_rating_7, d0_.tree_category AS tree_category_8, d0_.number_tree AS number_tree_9, d0_.is_comment_published AS is_comment_published_10, d0_.created_at AS created_at_11, d0_.updated_at AS updated_at_12, d0_.user_id AS user_id_13, d0_.demand_information_id AS demand_information_id_14, d0_.tree_id AS tree_id_15 FROM demand d0_ LEFT JOIN demand_status d1_ ON d0_.id = d1_.demand_id WHERE d0_.comment IS NOT NULL AND d0_.is_comment_published = ? AND d1_.status = ? ORDER BY d1_.created_at DESC LIMIT 6
SELECT t0.id AS id_1, t0.status AS status_2, t0.description AS description_3, t0.step AS step_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.comment AS comment_7, t0.company_rating AS company_rating_8, t0.tree_category AS tree_category_9, t0.number_tree AS number_tree_10, t0.is_comment_published AS is_comment_published_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.user_id AS user_id_14, t0.demand_information_id AS demand_information_id_15, t0.tree_id AS tree_id_16 FROM demand t0
doctrine
deprecation
Deprecated: Constant NumberFormatter::TYPE_CURRENCY is deprecated
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'staging_zinvaziv_re' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
doctrine
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'staging_zinvaziv_re' /*!50116 AND c.constraint_schema = 'staging_zinvaziv_re' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
doctrine
SELECT 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_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'staging_zinvaziv_re' ORDER BY SEQ_IN_INDEX ASC
doctrine
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
doctrine
SELECT * FROM doctrine_migration_versions
doctrine
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
doctrine
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
doctrine
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'staging_zinvaziv_re' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
doctrine
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'staging_zinvaziv_re' /*!50116 AND c.constraint_schema = 'staging_zinvaziv_re' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
doctrine
SELECT 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_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'staging_zinvaziv_re' ORDER BY SEQ_IN_INDEX ASC
doctrine
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
doctrine
SELECT * FROM doctrine_migration_versions
doctrine
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
doctrine
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
doctrine
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'staging_zinvaziv_re' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
doctrine
SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'staging_zinvaziv_re' /*!50116 AND c.constraint_schema = 'staging_zinvaziv_re' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL
doctrine
SELECT 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_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'staging_zinvaziv_re' ORDER BY SEQ_IN_INDEX ASC
doctrine
SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'