Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.96 ms
(86.65%)
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
  7170
  96118
  103696
  182749
  192691
  198857
  393326
  395552
  398041
  404957
  409405
  410940
  415618
  417674
  417829
  421273
  427447
  434443
  445493
  446394
  447470
  448100
  451572
  453358
  454364
  461591
  469764
  476649
  477020
  479818
  481147
  492565
  496270
  502732
  507646
  508180
  510394
  513882
  514069
  516350
  529855
  530060
  531849
  533369
  537675
  537888
  540559
  545305
  545393
  545409
  545410
  565172
  565241
  566786
  572763
  591695
  595977
  598057
  601635
  604420
  613832
  615717
  617410
  617427
  620471
  631163
  632601
  634198
  636293
  637086
  641983
  650373
  655247
  661455
  672710
  673526
  674107
  676022
  677784
  678135
  680100
  680176
  683494
  685775
  686183
  692096
  713113
  717066
  717947
  718159
  727850
  727906
  729288
  734412
  737663
  738121
  738556
  738820
  740269
  740578
  741277
  744390
  748779
  750719
  756830
  764220
  766704
  769885
  774650
  775883
  775896
  775904
  777876
  782439
  783379
  796430
  806580
  811941
  817139
  826623
]
16.82 ms
(8.43%)
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
  565241
  598057
  595977
  601635
  741277
  395552
  445493
  410940
  451572
  469764
  447470
  476649
  514069
  510394
  502732
  507646
  96118
  826623
  683494
  729288
  748779
  737663
  756830
  738556
  744390
  417829
  448100
  513882
  530060
  545305
  572763
  672710
  545393
  637086
  613832
  636293
  434443
  393326
  713113
  686183
  692096
  775883
  783379
  766704
  740269
  604420
  545410
  182749
  650373
  718159
  750719
  727906
  738121
  811941
  540559
  566786
  198857
  192691
  817139
  531849
  673526
  685775
  620471
  782439
  796430
  734412
  740578
  717066
  777876
  661455
  674107
  717947
  775904
  774650
  764220
  738820
  727850
  775896
  427447
  479818
  453358
  508180
  477020
  481147
  565172
  591695
  398041
  496270
  415618
  446394
  454364
  529855
  537675
  678135
  641983
  806580
  617410
  631163
  417674
  421273
  404957
  461591
  516350
  492565
  533369
  676022
  615717
  632601
  7170
  537888
  545409
  680100
  677784
  680176
  634198
  617427
  103696
  409405
  655247
  769885
]
3.11 ms
(1.56%)
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
  7170
  96118
  103696
  182749
  192691
  198857
  393326
  395552
  398041
  404957
  409405
  410940
  415618
  417674
  417829
  421273
  427447
  434443
  445493
  446394
  447470
  448100
  451572
  453358
  454364
  461591
  469764
  476649
  477020
  479818
  481147
  492565
  496270
  502732
  507646
  508180
  510394
  513882
  514069
  516350
  529855
  530060
  531849
  533369
  537675
  537888
  540559
  545305
  545393
  545409
  545410
  565172
  565241
  566786
  572763
  591695
  595977
  598057
  601635
  604420
  613832
  615717
  617410
  617427
  620471
  631163
  632601
  634198
  636293
  637086
  641983
  650373
  655247
  661455
  672710
  673526
  674107
  676022
  677784
  678135
  680100
  680176
  683494
  685775
  686183
  692096
  713113
  717066
  717947
  718159
  727850
  727906
  729288
  734412
  737663
  738121
  738556
  738820
  740269
  740578
  741277
  744390
  748779
  750719
  756830
  764220
  766704
  769885
  774650
  775883
  775896
  775904
  777876
  782439
  783379
  796430
  806580
  811941
  817139
  826623
]
1.83 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double анал teens"
]
1.75 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double anal teens"
]
1.39 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double анал teens"
]

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.