Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.69 ms
(88.43%)
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
  210768
  282652
  382594
  388424
  389093
  393331
  396235
  396501
  397425
  401139
  401558
  401946
  404695
  409249
  420384
  420621
  424908
  425474
  429901
  447656
  448375
  451254
  452625
  453773
  454603
  455822
  455855
  467953
  472450
  474487
  477742
  483814
  485715
  489648
  494072
  494174
  503117
  506518
  513484
  514721
  522861
  524002
  531290
  538026
  545765
  552535
  554192
  554892
  556474
  559581
  563333
  563969
  565166
  566858
  569981
  572891
  573191
  573202
  579394
  584709
  593207
  599400
  612039
  614237
  614292
  618923
  619012
  628115
  652274
  660999
  661287
  666661
  671032
  672038
  672938
  685389
  685479
  685818
  690896
  690913
  694062
  697258
  699695
  703070
  703086
  703535
  712786
  713486
  717849
  729929
  730418
  741591
  743131
  744284
  745912
  747129
  747503
  750123
  755030
  757636
  760012
  761157
  770304
  786458
  787563
  792871
  793219
  794783
  802491
  811649
  817009
  819053
  821071
  821436
  821942
  822260
  822441
  823306
  824580
  827533
]
13.78 ms
(6.89%)
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
  743131
  524002
  425474
  661287
  397425
  503117
  483814
  787563
  599400
  401946
  584709
  485715
  404695
  559581
  672938
  793219
  573202
  690896
  792871
  703070
  401139
  429901
  506518
  569981
  619012
  612039
  448375
  566858
  671032
  396235
  455822
  494072
  618923
  409249
  556474
  755030
  685818
  451254
  514721
  452625
  712786
  554192
  420621
  472450
  717849
  388424
  393331
  396501
  401558
  823306
  821436
  822260
  573191
  703086
  628115
  786458
  760012
  741591
  757636
  545765
  747129
  424908
  572891
  389093
  489648
  552535
  563333
  382594
  822441
  821942
  827533
  817009
  821071
  824580
  538026
  666661
  672038
  690913
  652274
  660999
  697258
  802491
  730418
  744284
  750123
  703535
  729929
  761157
  531290
  713486
  699695
  554892
  614237
  794783
  747503
  745912
  770304
  614292
  477742
  453773
  447656
  685479
  210768
  513484
  819053
  694062
  811649
  593207
  494174
  685389
  474487
  579394
  455855
  282652
  420384
  454603
  522861
  467953
  563969
  565166
]
2.84 ms
(1.42%)
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
  210768
  282652
  382594
  388424
  389093
  393331
  396235
  396501
  397425
  401139
  401558
  401946
  404695
  409249
  420384
  420621
  424908
  425474
  429901
  447656
  448375
  451254
  452625
  453773
  454603
  455822
  455855
  467953
  472450
  474487
  477742
  483814
  485715
  489648
  494072
  494174
  503117
  506518
  513484
  514721
  522861
  524002
  531290
  538026
  545765
  552535
  554192
  554892
  556474
  559581
  563333
  563969
  565166
  566858
  569981
  572891
  573191
  573202
  579394
  584709
  593207
  599400
  612039
  614237
  614292
  618923
  619012
  628115
  652274
  660999
  661287
  666661
  671032
  672038
  672938
  685389
  685479
  685818
  690896
  690913
  694062
  697258
  699695
  703070
  703086
  703535
  712786
  713486
  717849
  729929
  730418
  741591
  743131
  744284
  745912
  747129
  747503
  750123
  755030
  757636
  760012
  761157
  770304
  786458
  787563
  792871
  793219
  794783
  802491
  811649
  817009
  819053
  821071
  821436
  821942
  822260
  822441
  823306
  824580
  827533
]
1.97 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public teen anal"
]
1.55 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на teen улиц анал"
]
1.51 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на teen улиц анал"
]
1.47 ms
(0.74%)
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.