Symfony Profiler

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL ENDFROM cache_itemsWHERE item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1732502527 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_b2b036ef566ea047a8612c8c5440fe81', 'site_domain_b2b036ef566ea047a8612c8c5440fe81');

SELECT idFROM targeting_target_groupsUNIONSELECT idFROM targeting_rulesLIMIT 1

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;

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 = 'assets_image_thumbnail_cache' */WHERE k.table_name = 'assets_image_thumbnail_cache' AND k.table_schema = 'ID328408_preprodptj' /*!50116 AND c.constraint_schema = 'ID328408_preprodptj' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL

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 = 'assets_image_thumbnail_cache' */ WHERE k.table_name = 'assets_image_thumbnail_cache' AND k.table_schema = 'ID328408_preprodptj' /*!50116 AND c.constraint_schema = 'ID328408_preprodptj' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

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_TypeFROM information_schema.STATISTICSWHERE TABLE_NAME = 'assets_image_thumbnail_cache' AND TABLE_SCHEMA = 'ID328408_preprodptj'ORDER BY SEQ_IN_INDEX ASC

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 = 'assets_image_thumbnail_cache' AND TABLE_SCHEMA = 'ID328408_preprodptj' ORDER BY SEQ_IN_INDEX ASC;

SELECT *FROM redirectsWHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99ORDER BY `priority` DESC

SELECT * FROM redirects WHERE ( (source = '/_default_upload_bucket/images compressées all par page FR/studios de repetition/studios pour batteurs/3158/image-thumb__3158__background-image/banner studio batteur jpeg.jpg' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_default_upload_bucket/images compressées all par page FR/studios de repetition/studios pour batteurs/3158/image-thumb__3158__background-image/banner studio batteur jpeg.jpg' AND `type` = 'path_query') OR (source = 'https://ptj.apik-pp.be/_default_upload_bucket/images compressées all par page FR/studios de repetition/studios pour batteurs/3158/image-thumb__3158__background-image/banner studio batteur jpeg.jpg' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;

SELECT idFROM documentsWHERE path = BINARY :path AND `key` = BINARY :key

SELECT id FROM documents WHERE path = BINARY '/_default_upload_bucket/images compressées all par page FR/studios de repetition/studios pour batteurs/3158/image-thumb__3158__background-image/' AND `key` = BINARY 'banner studio batteur jpeg.jpg';

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 CollationFROM information_schema.COLUMNSWHERE TABLE_SCHEMA = 'ID328408_preprodptj' AND TABLE_NAME = 'assets_image_thumbnail_cache'ORDER BY ORDINAL_POSITION ASC

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 = 'ID328408_preprodptj' AND TABLE_NAME = 'assets_image_thumbnail_cache' ORDER BY ORDINAL_POSITION ASC;

INSERT INTO `assets_image_thumbnail_cache` ( `cid`, `name`, `filename`, `modificationDate`)VALUES (:col0, :col1, :col2, :col3) ON DUPLICATE KEYUPDATE `cid` = :col0, `name` = :col1, `filename` = :col2, `modificationDate` = :col3;

INSERT INTO `assets_image_thumbnail_cache` (`cid`, `name`, `filename`, `modificationDate`) VALUES (:col0, :col1, :col2, :col3) ON DUPLICATE KEY UPDATE `cid` = :col0, `name` = :col1, `filename` = :col2, `modificationDate` = :col3;;

SELECT *FROM settings_storeWHERE id = :id AND scope = :scope

SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONSFROM information_schema.TABLESWHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'assets_image_thumbnail_cache'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONSFROM information_schema.TABLESWHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'assets_image_thumbnail_cache';

SELECT assets.*, tree_locks.lockedFROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset'WHERE assets.id = ?

SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = 3158;

SELECT idFROM documents_pageWHERE prettyUrl = :prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/_default_upload_bucket/images compressées all par page FR/studios de repetition/studios pour batteurs/3158/image-thumb__3158__background-image/banner studio batteur jpeg.jpg';

DELETE FROM lock_keysWHERE key_id = ? AND key_token = ?

DELETE FROM lock_keys WHERE key_id = '82ffe258af86577d462a4f1037389ae1105ab6a2a75959cdddf566f5c84c0c8d' AND key_token = 'kqlcMVvDss2rCvBZRNbuHkbnGcF5+NyIHqwjLaBBO80=';

SELECT *FROM assets_metadataWHERE cid = ?

SELECT * FROM assets_metadata WHERE cid = '3158';

INSERT INTO lock_keys ( key_id, key_token, key_expiration)VALUES ( ?, ?, UNIX_TIMESTAMP() + 300 )

INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES ('82ffe258af86577d462a4f1037389ae1105ab6a2a75959cdddf566f5c84c0c8d', 'kqlcMVvDss2rCvBZRNbuHkbnGcF5+NyIHqwjLaBBO80=', UNIX_TIMESTAMP() + 300);

SELECT 1FROM lock_keysWHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()

SELECT 1 FROM lock_keys WHERE key_id = '82ffe258af86577d462a4f1037389ae1105ab6a2a75959cdddf566f5c84c0c8d' AND key_token = 'kqlcMVvDss2rCvBZRNbuHkbnGcF5+NyIHqwjLaBBO80=' AND key_expiration > UNIX_TIMESTAMP();

UPDATE lock_keysSET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ?WHERE key_id = ? AND ( key_token = ? OR key_expiration <= UNIX_TIMESTAMP() )

UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + 300, key_token = 'kqlcMVvDss2rCvBZRNbuHkbnGcF5+NyIHqwjLaBBO80=' WHERE key_id = '82ffe258af86577d462a4f1037389ae1105ab6a2a75959cdddf566f5c84c0c8d' AND (key_token = 'kqlcMVvDss2rCvBZRNbuHkbnGcF5+NyIHqwjLaBBO80=' OR key_expiration <= UNIX_TIMESTAMP());