Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.17 ms
(85.16%)
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
  46870
  53510
  73926
  145053
  145603
  181096
  185332
  212138
  281450
  383341
  385064
  386099
  387597
  388401
  391317
  394704
  395230
  395562
  395603
  395628
  397256
  398112
  398412
  400956
  401342
  401426
  401881
  403109
  406690
  406799
  408694
  418337
  422859
  425008
  425773
  426535
  429471
  429947
  430247
  430737
  431205
  431687
  434167
  442198
  444735
  446880
  451086
  456725
  457102
  457503
  458036
  458541
  459472
  460611
  460936
  461482
  462967
  463752
  464388
  465157
  465989
  470044
  470048
  471013
  471018
  472727
  476150
  477876
  487268
  487871
  489403
  491589
  492296
  494895
  498874
  504614
  505186
  509102
  509540
  512902
  517545
  517881
  519573
  521363
  527429
  528275
  529060
  533467
  537577
  551290
  552899
  556933
  557921
  559708
  559968
  572121
  583875
  585970
  587247
  588674
  591536
  593878
  598267
  599628
  607497
  612119
  623543
  642216
  662994
  664491
  675341
  707450
  719205
  724482
  734778
  749049
  773058
  817784
  820491
  820591
]
15.43 ms
(8.93%)
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
  556933
  418337
  470044
  406799
  422859
  462967
  73926
  145603
  46870
  53510
  387597
  406690
  446880
  456725
  471018
  460611
  476150
  281450
  391317
  471013
  388401
  398112
  457503
  394704
  458036
  492296
  458541
  664491
  642216
  598267
  607497
  612119
  585970
  734778
  773058
  395230
  527429
  662994
  719205
  599628
  724482
  401426
  464388
  593878
  442198
  397256
  401342
  426535
  451086
  425773
  504614
  519573
  509102
  491589
  517881
  430737
  472727
  465989
  533467
  587247
  385064
  431205
  431687
  461482
  477876
  395628
  398412
  400956
  429947
  470048
  505186
  528275
  521363
  820591
  817784
  820491
  537577
  707450
  583875
  749049
  623543
  401881
  403109
  463752
  512902
  529060
  498874
  517545
  675341
  552899
  588674
  591536
  386099
  434167
  457102
  459472
  395562
  425008
  509540
  383341
  185332
  145053
  430247
  487268
  487871
  494895
  465157
  557921
  559708
  572121
  460936
  181096
  408694
  489403
  212138
  395603
  444735
  429471
  559968
  551290
]
2.91 ms
(1.68%)
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
  46870
  53510
  73926
  145053
  145603
  181096
  185332
  212138
  281450
  383341
  385064
  386099
  387597
  388401
  391317
  394704
  395230
  395562
  395603
  395628
  397256
  398112
  398412
  400956
  401342
  401426
  401881
  403109
  406690
  406799
  408694
  418337
  422859
  425008
  425773
  426535
  429471
  429947
  430247
  430737
  431205
  431687
  434167
  442198
  444735
  446880
  451086
  456725
  457102
  457503
  458036
  458541
  459472
  460611
  460936
  461482
  462967
  463752
  464388
  465157
  465989
  470044
  470048
  471013
  471018
  472727
  476150
  477876
  487268
  487871
  489403
  491589
  492296
  494895
  498874
  504614
  505186
  509102
  509540
  512902
  517545
  517881
  519573
  521363
  527429
  528275
  529060
  533467
  537577
  551290
  552899
  556933
  557921
  559708
  559968
  572121
  583875
  585970
  587247
  588674
  591536
  593878
  598267
  599628
  607497
  612119
  623543
  642216
  662994
  664491
  675341
  707450
  719205
  724482
  734778
  749049
  773058
  817784
  820491
  820591
]
1.89 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая волосатая"
]
1.87 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful hairy"
]
1.86 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.