Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.10 ms
(84.15%)
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
  16851
  401052
  409795
  415834
  417835
  418883
  421840
  421861
  421875
  422141
  422152
  424124
  434335
  437960
  438018
  438316
  439685
  439712
  439763
  439813
  440265
  440601
  440693
  440954
  442629
  447094
  449190
  454801
  455333
  455343
  455798
  455993
  457194
  458348
  459457
  459513
  460562
  463191
  464628
  465344
  465381
  467569
  469494
  470559
  474146
  476707
  478991
  481406
  484440
  485666
  486854
  486859
  487228
  490517
  490996
  494421
  494938
  495686
  502868
  503476
  504450
  509609
  510930
  516483
  516780
  517885
  518941
  521168
  523902
  525713
  527955
  534020
  534023
  539561
  543708
  553653
  553921
  557267
  557810
  558814
  564377
  564555
  565937
  568317
  570832
  571711
  577080
  577087
  578803
  580159
  580642
  591452
  593785
  598899
  599669
  600411
  601444
  603201
  603420
  603716
  605498
  605529
  607023
  614696
  615721
  623211
  624990
  641059
  652758
  661970
  668139
  719112
  720206
  724637
  732905
  760169
  761088
  792599
  799350
]
15.71 ms
(9.71%)
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
  421861
  424124
  465344
  523902
  623211
  605498
  593785
  495686
  600411
  440693
  439813
  553921
  599106
  591452
  641059
  401052
  474146
  534020
  534023
  580159
  570832
  799350
  719112
  469494
  577080
  577087
  724637
  486854
  437960
  490996
  484440
  543708
  668139
  614696
  624990
  732905
  761088
  603420
  418883
  527955
  409795
  455798
  459513
  440954
  464628
  447094
  509609
  485666
  564377
  564555
  578803
  652758
  565937
  571711
  598899
  421875
  422141
  481406
  503476
  517885
  494421
  516483
  486859
  504450
  440601
  440265
  459457
  490517
  454801
  457194
  478991
  521168
  510930
  518941
  553653
  558814
  568317
  661970
  557810
  599669
  605529
  603201
  607023
  601444
  421840
  422152
  415834
  439685
  439763
  455333
  455343
  465381
  417835
  434335
  470559
  516780
  487228
  502868
  525713
  438018
  442629
  458348
  449190
  467569
  455993
  476707
  539561
  494938
  557267
  580642
  615721
  603716
  792599
  760169
  720206
  463191
  16851
  438316
  439712
  460562
]
2.76 ms
(1.70%)
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
  16851
  401052
  409795
  415834
  417835
  418883
  421840
  421861
  421875
  422141
  422152
  424124
  434335
  437960
  438018
  438316
  439685
  439712
  439763
  439813
  440265
  440601
  440693
  440954
  442629
  447094
  449190
  454801
  455333
  455343
  455798
  455993
  457194
  458348
  459457
  459513
  460562
  463191
  464628
  465344
  465381
  467569
  469494
  470559
  474146
  476707
  478991
  481406
  484440
  485666
  486854
  486859
  487228
  490517
  490996
  494421
  494938
  495686
  502868
  503476
  504450
  509609
  510930
  516483
  516780
  517885
  518941
  521168
  523902
  525713
  527955
  534020
  534023
  539561
  543708
  553653
  553921
  557267
  557810
  558814
  564377
  564555
  565937
  568317
  570832
  571711
  577080
  577087
  578803
  580159
  580642
  591452
  593785
  598899
  599669
  600411
  601444
  603201
  603420
  603716
  605498
  605529
  607023
  614696
  615721
  623211
  624990
  641059
  652758
  661970
  668139
  719112
  720206
  724637
  732905
  760169
  761088
  792599
  799350
]
2.12 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf amateur real"
]
1.89 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf любительск real"
]
1.41 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf любительск real"
]

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.