Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.02 ms
(81.47%)
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
  388542
  397900
  398579
  403651
  416467
  419967
  422280
  424129
  425573
  425574
  426485
  426775
  428062
  438506
  440261
  440263
  440963
  441109
  450275
  453316
  457187
  457376
  457743
  458804
  459650
  460581
  485452
  487176
  488948
  509271
  520139
  525247
  528465
  531380
  531557
  532498
  534826
  538537
  539117
  540403
  541052
  541167
  544430
  549648
  563772
  564607
  583662
  591210
  592906
  593790
  603027
  616072
  626342
  635636
  636493
  639845
  643334
  656597
  667353
  669504
  681220
  685263
  685843
  687466
  690034
  693679
  693778
  693806
  694633
  695786
  705083
  713676
  725230
  727587
  730819
  731615
  734587
  738951
  740646
  741382
  741829
  743741
  752742
  756367
  759992
  761531
  761941
  778492
  778498
  780902
  787399
  790178
  790841
  791416
  792021
  793597
  793997
  796183
  796194
  799382
  800028
  801094
  801182
  807325
  809575
  810178
  810383
  811764
  812732
  813787
  813863
  814129
  819938
  823720
  824868
]
16.51 ms
(11.21%)
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
  438506
  453316
  725230
  823720
  564607
  705083
  591210
  793997
  713676
  693806
  583662
  754183
  428062
  813787
  780902
  425573
  440263
  457743
  534826
  539117
  531557
  693679
  603027
  636493
  799382
  790178
  616072
  812732
  397900
  450275
  426775
  457187
  398579
  540403
  520139
  532498
  656597
  667353
  626342
  778492
  809575
  730819
  752742
  761531
  810383
  741551
  751981
  727587
  756367
  681220
  819938
  685843
  793597
  740646
  741382
  807325
  488948
  790841
  425574
  441109
  824868
  457376
  541167
  549648
  778498
  810178
  792021
  731615
  761941
  738951
  764584
  741829
  734587
  743741
  635636
  787399
  791416
  388542
  422280
  528465
  685263
  693778
  485452
  424129
  440261
  416467
  525247
  403651
  541052
  669504
  687466
  695786
  592906
  639845
  643334
  801182
  690034
  814129
  563772
  694633
  801094
  702303
  426485
  440963
  813863
  458804
  459650
  460581
  593790
  796183
  759992
  796194
  800028
  811764
  419967
  509271
  487176
  538537
  531380
  544430
]
3.06 ms
(2.07%)
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
  388542
  397900
  398579
  403651
  416467
  419967
  422280
  424129
  425573
  425574
  426485
  426775
  428062
  438506
  440261
  440263
  440963
  441109
  450275
  453316
  457187
  457376
  457743
  458804
  459650
  460581
  485452
  487176
  488948
  509271
  520139
  525247
  528465
  531380
  531557
  532498
  534826
  538537
  539117
  540403
  541052
  541167
  544430
  549648
  563772
  564607
  583662
  591210
  592906
  593790
  603027
  616072
  626342
  635636
  636493
  639845
  643334
  656597
  667353
  669504
  681220
  685263
  685843
  687466
  690034
  693679
  693778
  693806
  694633
  695786
  705083
  713676
  725230
  727587
  730819
  731615
  734587
  738951
  740646
  741382
  741829
  743741
  752742
  756367
  759992
  761531
  761941
  778492
  778498
  780902
  787399
  790178
  790841
  791416
  792021
  793597
  793997
  796183
  796194
  799382
  800028
  801094
  801182
  807325
  809575
  810178
  810383
  811764
  812732
  813787
  813863
  814129
  819938
  823720
  824868
]
2.05 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf любительск real"
]
1.99 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf amateur real"
]
1.87 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf любительск real"
]
1.82 ms
(1.24%)
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.