Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.95 ms
(85.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
  150471
  235834
  271756
  325660
  382769
  385100
  386027
  390131
  390263
  390535
  391202
  391487
  396313
  396421
  397656
  404052
  404127
  409958
  411340
  412713
  413789
  418290
  418551
  419248
  420376
  423458
  424009
  424139
  430713
  432887
  441841
  443370
  444258
  447755
  449109
  450447
  452316
  456484
  456499
  456597
  456858
  459811
  463093
  463114
  465865
  466299
  467767
  472471
  473239
  475020
  475869
  477036
  477348
  477492
  477699
  480420
  482566
  484250
  485027
  485600
  485882
  489130
  489721
  489796
  490791
  490837
  492592
  495157
  497524
  500904
  501387
  504036
  504145
  505995
  506844
  509161
  509179
  510779
  515674
  517371
  522515
  526881
  549687
  552059
  553608
  555112
  557268
  557955
  563297
  565863
  566582
  566770
  571734
  573184
  578779
  584438
  590576
  597195
  599586
  622839
  630225
  631054
  632403
  661570
  666432
  689750
  700945
  712631
  712636
  712940
  730367
  737673
  744711
  745257
  748464
  750289
  752831
  758388
  776280
  785767
]
14.01 ms
(8.39%)
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
  632403
  571734
  386027
  271756
  325660
  418551
  430713
  412713
  420376
  424139
  443370
  441841
  482566
  463114
  489796
  459811
  463093
  485027
  456597
  467767
  505995
  495157
  465865
  475869
  490837
  566582
  552059
  566770
  573184
  666432
  700945
  555112
  776280
  730367
  752831
  758388
  745257
  737673
  744711
  748464
  785767
  385100
  391487
  477699
  390131
  404127
  466299
  444258
  235834
  432887
  449109
  475020
  509161
  522515
  485600
  490791
  504145
  506844
  484250
  497524
  404052
  622839
  396313
  411340
  423458
  456858
  447755
  450447
  517371
  509179
  510779
  489721
  563297
  565863
  549687
  557955
  689750
  712631
  712636
  712940
  553608
  557268
  578779
  597195
  750289
  630225
  473239
  390535
  391202
  456499
  477036
  409958
  452316
  501387
  526881
  492592
  485882
  515674
  396421
  397656
  413789
  477348
  424009
  599586
  150471
  419248
  584438
  661570
  590576
  631054
  504036
  456484
  418290
  480420
  472471
  489130
  382769
  477492
  500904
  390263
]
3.06 ms
(1.83%)
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
  150471
  235834
  271756
  325660
  382769
  385100
  386027
  390131
  390263
  390535
  391202
  391487
  396313
  396421
  397656
  404052
  404127
  409958
  411340
  412713
  413789
  418290
  418551
  419248
  420376
  423458
  424009
  424139
  430713
  432887
  441841
  443370
  444258
  447755
  449109
  450447
  452316
  456484
  456499
  456597
  456858
  459811
  463093
  463114
  465865
  466299
  467767
  472471
  473239
  475020
  475869
  477036
  477348
  477492
  477699
  480420
  482566
  484250
  485027
  485600
  485882
  489130
  489721
  489796
  490791
  490837
  492592
  495157
  497524
  500904
  501387
  504036
  504145
  505995
  506844
  509161
  509179
  510779
  515674
  517371
  522515
  526881
  549687
  552059
  553608
  555112
  557268
  557955
  563297
  565863
  566582
  566770
  571734
  573184
  578779
  584438
  590576
  597195
  599586
  622839
  630225
  631054
  632403
  661570
  666432
  689750
  700945
  712631
  712636
  712940
  730367
  737673
  744711
  745257
  748464
  750289
  752831
  758388
  776280
  785767
]
2.00 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur man"
]
1.55 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск мужчин"
]
1.37 ms
(0.82%)
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.