Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.96 ms
(82.63%)
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
  392990
  395922
  398364
  401899
  421426
  421855
  421866
  421875
  422237
  423909
  424047
  429362
  436490
  439809
  442231
  442947
  444115
  445178
  445493
  448227
  451634
  456308
  458069
  460109
  462108
  462536
  463634
  466201
  468163
  468670
  470599
  470708
  472302
  475017
  475234
  475614
  478519
  480353
  483369
  483647
  484277
  487156
  487163
  487620
  490695
  493006
  494442
  494598
  497573
  497909
  499746
  500518
  500983
  501905
  502648
  504299
  505579
  505966
  506179
  506448
  510743
  511289
  515994
  516483
  520081
  520304
  523428
  523441
  523514
  523691
  525984
  527832
  527853
  528660
  543310
  543820
  547035
  547835
  548158
  549560
  552804
  552811
  553954
  556726
  560318
  560894
  563776
  566751
  567372
  568214
  569788
  570086
  570873
  577513
  577997
  581503
  582566
  584159
  584795
  587097
  599504
  619097
  623404
  631961
  643817
  656891
  659370
  675866
  690936
  736830
  738435
  744966
  745804
  764627
  766830
  775466
  791731
  793295
  811093
  811879
]
17.56 ms
(11.17%)
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
  445493
  569788
  442947
  568214
  570873
  577513
  587097
  793295
  421866
  458069
  504299
  487620
  484277
  527853
  506179
  738435
  775466
  631961
  505579
  497909
  552804
  566751
  811879
  745804
  764627
  811093
  475614
  470708
  478519
  501905
  494598
  499746
  523514
  483647
  424047
  472302
  659370
  520081
  581503
  392990
  401899
  511289
  525984
  421875
  516483
  582566
  502648
  460109
  506448
  395922
  475017
  556726
  643817
  463634
  444115
  500983
  549560
  439809
  470599
  494442
  429362
  560318
  675866
  599504
  422237
  421855
  487163
  497573
  423909
  421426
  553954
  577997
  791731
  451634
  445178
  462536
  448227
  475234
  466201
  500518
  527832
  398364
  480353
  656891
  736830
  468163
  462108
  515994
  584159
  493006
  487156
  468670
  456308
  543820
  552811
  548158
  510743
  528660
  523691
  623404
  619097
  483369
  523428
  442231
  523441
  570086
  520304
  547035
  584795
  563776
  560894
  744966
  766830
  690936
  505966
  436490
  490695
  543310
  567372
  547835
]
2.53 ms
(1.61%)
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
  392990
  395922
  398364
  401899
  421426
  421855
  421866
  421875
  422237
  423909
  424047
  429362
  436490
  439809
  442231
  442947
  444115
  445178
  445493
  448227
  451634
  456308
  458069
  460109
  462108
  462536
  463634
  466201
  468163
  468670
  470599
  470708
  472302
  475017
  475234
  475614
  478519
  480353
  483369
  483647
  484277
  487156
  487163
  487620
  490695
  493006
  494442
  494598
  497573
  497909
  499746
  500518
  500983
  501905
  502648
  504299
  505579
  505966
  506179
  506448
  510743
  511289
  515994
  516483
  520081
  520304
  523428
  523441
  523514
  523691
  525984
  527832
  527853
  528660
  543310
  543820
  547035
  547835
  548158
  549560
  552804
  552811
  553954
  556726
  560318
  560894
  563776
  566751
  567372
  568214
  569788
  570086
  570873
  577513
  577997
  581503
  582566
  584159
  584795
  587097
  599504
  619097
  623404
  631961
  643817
  656891
  659370
  675866
  690936
  736830
  738435
  744966
  745804
  764627
  766830
  775466
  791731
  793295
  811093
  811879
]
2.01 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашний секс рыжая"
]
1.76 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск секс рыжая"
]
1.74 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск секс рыжая"
]
1.71 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.