Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.34 ms
(82.40%)
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
  13258
  14232
  79388
  148793
  154410
  382238
  388028
  396590
  396706
  396720
  397992
  398528
  399633
  400787
  402876
  404175
  405043
  406322
  408238
  409383
  420695
  421995
  428122
  438576
  445439
  447740
  450309
  451989
  453134
  453543
  457240
  459162
  459249
  459764
  460194
  460243
  460689
  463825
  464018
  464179
  464371
  464410
  464426
  465082
  471814
  477483
  478676
  482780
  483588
  486551
  489373
  503194
  516842
  517741
  518836
  523392
  523418
  529122
  529441
  531155
  532708
  536290
  536357
  536366
  540437
  542209
  543852
  543918
  554927
  565147
  583982
  585971
  600252
  600359
  602534
  604435
  606501
  607814
  609991
  613122
  614993
  616336
  629868
  631194
  631690
  634140
  634528
  637148
  639334
  639742
  640798
  646901
  666582
  673767
  696983
  697014
  699756
  712770
  715555
  721870
  728738
  729644
  732292
  742244
  744651
  756468
  788283
  788928
  793662
  800288
  800296
  802253
  805110
  805607
  806225
  810828
  811826
  811872
  815279
  825241
]
15.82 ms
(10.32%)
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
  613122
  640798
  800288
  742244
  438576
  486551
  607814
  154410
  453134
  631690
  744651
  697014
  409383
  465082
  532708
  673767
  696983
  800296
  788928
  634528
  463825
  396720
  616336
  457240
  811826
  420695
  477483
  518836
  536357
  451989
  602534
  464371
  529441
  489373
  540437
  600252
  464410
  802253
  715555
  398528
  523392
  405043
  428122
  396590
  388028
  543852
  503194
  756468
  460194
  629868
  408238
  445439
  600359
  631194
  404175
  483588
  543918
  639742
  400787
  13258
  464179
  712770
  536290
  614993
  453543
  450309
  634140
  637148
  382238
  523418
  531155
  583982
  639334
  79388
  460689
  788283
  646901
  609991
  604435
  721870
  402876
  810828
  399633
  732292
  14232
  397992
  459162
  565147
  447740
  529122
  811872
  460243
  396706
  459764
  464426
  459249
  815279
  825241
  517741
  536366
  542209
  666582
  806225
  805607
  729644
  805110
  728738
  148793
  478676
  554927
  606501
  793662
  516842
  482780
  471814
  406322
  421995
  464018
  585971
  699756
]
3.71 ms
(2.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
  13258
  14232
  79388
  148793
  154410
  382238
  388028
  396590
  396706
  396720
  397992
  398528
  399633
  400787
  402876
  404175
  405043
  406322
  408238
  409383
  420695
  421995
  428122
  438576
  445439
  447740
  450309
  451989
  453134
  453543
  457240
  459162
  459249
  459764
  460194
  460243
  460689
  463825
  464018
  464179
  464371
  464410
  464426
  465082
  471814
  477483
  478676
  482780
  483588
  486551
  489373
  503194
  516842
  517741
  518836
  523392
  523418
  529122
  529441
  531155
  532708
  536290
  536357
  536366
  540437
  542209
  543852
  543918
  554927
  565147
  583982
  585971
  600252
  600359
  602534
  604435
  606501
  607814
  609991
  613122
  614993
  616336
  629868
  631194
  631690
  634140
  634528
  637148
  639334
  639742
  640798
  646901
  666582
  673767
  696983
  697014
  699756
  712770
  715555
  721870
  728738
  729644
  732292
  742244
  744651
  756468
  788283
  788928
  793662
  800288
  800296
  802253
  805110
  805607
  806225
  810828
  811826
  811872
  815279
  825241
]
2.11 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature blowjob bbc"
]
2.07 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature минет оральн секс bbc"
]
1.69 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature минет оральн секс bbc"
]
1.59 ms
(1.04%)
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.