Query Metrics

7 Database Queries
7 Different statements
196.30 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
164.58 ms
(83.84%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  2189
  38637
  94529
  185606
  191475
  233556
  260590
  326115
  358778
  370875
  381855
  382154
  383418
  383495
  384234
  386323
  386576
  386765
  386852
  389623
  390892
  392024
  392031
  392674
  396215
  398444
  401468
  401678
  401773
  402483
  402926
  403074
  406018
  406650
  407171
  407707
  407816
  408420
  408425
  409882
  410855
  411415
  411941
  420510
  420812
  427012
  427152
  431228
  434361
  437560
  437725
  441215
  443834
  444670
  446080
  447303
  447587
  449236
  451166
  452162
  452682
  452688
  456690
  459192
  460127
  460408
  460601
  460744
  460925
  461478
  461802
  462806
  462905
  465412
  465829
  466052
  466198
  466216
  467191
  467370
  469269
  469862
  470250
  470451
  473068
  479326
  490187
  494575
  495634
  495644
  498104
  503293
  503400
  504172
  504290
  506727
  510677
  516534
  519139
  521228
  523975
  527753
  543835
  548782
  549155
  552206
  553957
  563217
  563613
  566867
  569991
  571637
  573663
  573961
  575766
  576728
  582583
  598710
  607125
  684251
]
20.40 ms
(10.39%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  408420
  460127
  402483
  386576
  390892
  402926
  233556
  411415
  420510
  460601
  516534
  504172
  519139
  495634
  386852
  461802
  569991
  575766
  470250
  389623
  466216
  503400
  437560
  573961
  431228
  427012
  386323
  326115
  407707
  411941
  469862
  571637
  607125
  408425
  392024
  392031
  443834
  467370
  401678
  449236
  552206
  563613
  38637
  407171
  573663
  401468
  185606
  384234
  465829
  358778
  409882
  381855
  504290
  527753
  684251
  370875
  406018
  452162
  410855
  452688
  495644
  521228
  434361
  403074
  447587
  260590
  576728
  427152
  506727
  460744
  386765
  406650
  447303
  444670
  94529
  566867
  383418
  503293
  469269
  392674
  459192
  451166
  466052
  407816
  465412
  563217
  401773
  548782
  462806
  396215
  498104
  383495
  191475
  441215
  543835
  446080
  460925
  398444
  420812
  452682
  460408
  437725
  494575
  470451
  2189
  490187
  553957
  582583
  549155
  598710
  461478
  382154
  466198
  473068
  462905
  456690
  467191
  523975
  479326
  510677
]
3.28 ms
(1.67%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  2189
  38637
  94529
  185606
  191475
  233556
  260590
  326115
  358778
  370875
  381855
  382154
  383418
  383495
  384234
  386323
  386576
  386765
  386852
  389623
  390892
  392024
  392031
  392674
  396215
  398444
  401468
  401678
  401773
  402483
  402926
  403074
  406018
  406650
  407171
  407707
  407816
  408420
  408425
  409882
  410855
  411415
  411941
  420510
  420812
  427012
  427152
  431228
  434361
  437560
  437725
  441215
  443834
  444670
  446080
  447303
  447587
  449236
  451166
  452162
  452682
  452688
  456690
  459192
  460127
  460408
  460601
  460744
  460925
  461478
  461802
  462806
  462905
  465412
  465829
  466052
  466198
  466216
  467191
  467370
  469269
  469862
  470250
  470451
  473068
  479326
  490187
  494575
  495634
  495644
  498104
  503293
  503400
  504172
  504290
  506727
  510677
  516534
  519139
  521228
  523975
  527753
  543835
  548782
  549155
  552206
  553957
  563217
  563613
  566867
  569991
  571637
  573663
  573961
  575766
  576728
  582583
  598710
  607125
  684251
]
2.66 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни делает парень"
]
2.00 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс парен"
]
1.51 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куннилингус оральн секс парен"
]

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

No loaded entities.