Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
347.25 ms
(94.00%)
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
  208554
  387407
  388962
  399908
  401135
  401451
  402807
  410851
  416585
  416832
  418128
  418158
  418334
  418372
  418594
  420647
  421121
  421216
  424270
  428264
  434007
  434328
  435580
  438702
  441233
  441396
  441615
  441742
  443914
  448247
  448522
  449319
  449908
  451249
  452753
  452903
  455134
  456050
  456085
  456127
  461664
  463867
  466028
  467889
  469198
  472378
  473907
  476429
  478101
  482242
  490135
  493594
  493909
  494615
  500875
  501061
  502774
  503834
  504887
  505325
  510741
  510746
  514568
  516570
  516894
  519351
  519679
  528770
  530273
  533561
  540928
  545440
  546987
  555245
  556530
  559368
  561979
  566544
  567077
  567828
  569450
  577253
  579539
  582558
  583807
  584577
  587291
  595612
  596240
  606601
  618306
  618750
  653520
  655517
  666977
  669000
  677838
  678697
  683660
  688818
  697927
  703927
  714238
  722383
  736725
  768229
  772951
  777830
  783903
  783963
  784105
  784416
  785574
  794674
  796194
  797083
  801999
  806911
  809684
  814175
]
13.18 ms
(3.57%)
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
  540928
  449319
  478101
  618306
  794674
  796194
  418128
  514568
  714238
  784105
  809684
  208554
  416832
  448247
  449908
  493909
  669000
  595612
  467889
  418158
  519679
  441396
  559368
  456050
  461664
  502774
  567828
  688818
  655517
  618750
  428264
  434328
  482242
  424270
  545440
  388962
  434007
  772951
  401451
  736725
  516894
  420647
  451249
  504887
  555245
  505325
  500875
  530273
  579539
  583807
  703927
  801999
  783903
  722383
  472378
  677838
  587291
  466028
  519351
  463867
  443914
  421121
  501061
  566544
  441233
  455134
  421216
  814175
  493594
  533561
  797083
  784416
  768229
  418334
  418594
  469198
  606601
  441742
  401135
  441615
  456085
  452903
  456127
  582558
  567077
  561979
  418372
  452753
  490135
  503834
  448522
  528770
  556530
  516570
  510741
  510746
  584577
  783963
  806911
  697927
  476429
  435580
  494615
  387407
  569450
  546987
  596240
  577253
  678697
  666977
  777830
  785574
  438702
  399908
  402807
  416585
  410851
  473907
  653520
  683660
]
2.42 ms
(0.65%)
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
  208554
  387407
  388962
  399908
  401135
  401451
  402807
  410851
  416585
  416832
  418128
  418158
  418334
  418372
  418594
  420647
  421121
  421216
  424270
  428264
  434007
  434328
  435580
  438702
  441233
  441396
  441615
  441742
  443914
  448247
  448522
  449319
  449908
  451249
  452753
  452903
  455134
  456050
  456085
  456127
  461664
  463867
  466028
  467889
  469198
  472378
  473907
  476429
  478101
  482242
  490135
  493594
  493909
  494615
  500875
  501061
  502774
  503834
  504887
  505325
  510741
  510746
  514568
  516570
  516894
  519351
  519679
  528770
  530273
  533561
  540928
  545440
  546987
  555245
  556530
  559368
  561979
  566544
  567077
  567828
  569450
  577253
  579539
  582558
  583807
  584577
  587291
  595612
  596240
  606601
  618306
  618750
  653520
  655517
  666977
  669000
  677838
  678697
  683660
  688818
  697927
  703927
  714238
  722383
  736725
  768229
  772951
  777830
  783903
  783963
  784105
  784416
  785574
  794674
  796194
  797083
  801999
  806911
  809684
  814175
]
1.89 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "оргазм пальцам"
]
1.65 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "оргазм пальц"
]
1.56 ms
(0.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.40%)
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.