Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.04 ms
(85.76%)
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
  90485
  382404
  383744
  383773
  384348
  385421
  391603
  397279
  397514
  398236
  398244
  398261
  403315
  404346
  406217
  413117
  414329
  417878
  418577
  420490
  421366
  427089
  429065
  434455
  434803
  438054
  444378
  445776
  446310
  453078
  454387
  457873
  461487
  466969
  467131
  467955
  468031
  470689
  471153
  472811
  480300
  481965
  484058
  485208
  486748
  486751
  486753
  501466
  507591
  509476
  510948
  511262
  511269
  511403
  515058
  517882
  520292
  521171
  521226
  521953
  526046
  528097
  529101
  530942
  532300
  533897
  534279
  535703
  542507
  543596
  545328
  546082
  552800
  552967
  554506
  554527
  554657
  556912
  556920
  557378
  560392
  560447
  560898
  562006
  562714
  564655
  567136
  571841
  579807
  580144
  584049
  622778
  624131
  644813
  659013
  670662
  700975
  708232
  710357
  723075
  732423
  737168
  738480
  741427
  744088
  748552
  749735
  750896
  752876
  770954
  773922
  776493
  777823
  784557
  785024
  785293
  814209
  815354
  815592
  816601
]
17.89 ms
(9.47%)
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
  738480
  750896
  770954
  732423
  744088
  752876
  773922
  737168
  741427
  748552
  749735
  710357
  776493
  777823
  784557
  785024
  785293
  403315
  406217
  427089
  446310
  384348
  397514
  398236
  417878
  467131
  472811
  397279
  445776
  453078
  90485
  414329
  421366
  444378
  470689
  511262
  511403
  526046
  517882
  521171
  484058
  486751
  521953
  571841
  507591
  543596
  556912
  584049
  622778
  624131
  385421
  383744
  383773
  391603
  382404
  398261
  398244
  404346
  420490
  429065
  434803
  438054
  413117
  418577
  434455
  815354
  644813
  814209
  815592
  816601
  485208
  468031
  480300
  486753
  454387
  457873
  466969
  467955
  481965
  501466
  510948
  521226
  529101
  533897
  532300
  534279
  515058
  520292
  530942
  535703
  509476
  511269
  528097
  461487
  471153
  486748
  552967
  554506
  560898
  562714
  567136
  579807
  580144
  542507
  545328
  560447
  562006
  564655
  546082
  554527
  560392
  659013
  670662
  700975
  708232
  723075
  552800
  554657
  556920
  557378
]
2.32 ms
(1.23%)
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
  90485
  382404
  383744
  383773
  384348
  385421
  391603
  397279
  397514
  398236
  398244
  398261
  403315
  404346
  406217
  413117
  414329
  417878
  418577
  420490
  421366
  427089
  429065
  434455
  434803
  438054
  444378
  445776
  446310
  453078
  454387
  457873
  461487
  466969
  467131
  467955
  468031
  470689
  471153
  472811
  480300
  481965
  484058
  485208
  486748
  486751
  486753
  501466
  507591
  509476
  510948
  511262
  511269
  511403
  515058
  517882
  520292
  521171
  521226
  521953
  526046
  528097
  529101
  530942
  532300
  533897
  534279
  535703
  542507
  543596
  545328
  546082
  552800
  552967
  554506
  554527
  554657
  556912
  556920
  557378
  560392
  560447
  560898
  562006
  562714
  564655
  567136
  571841
  579807
  580144
  584049
  622778
  624131
  644813
  659013
  670662
  700975
  708232
  710357
  723075
  732423
  737168
  738480
  741427
  744088
  748552
  749735
  750896
  752876
  770954
  773922
  776493
  777823
  784557
  785024
  785293
  814209
  815354
  815592
  816601
]
1.77 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая очкастые"
]
1.72 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "брюнетка очки"
]
1.60 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.84%)
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.