Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.16 ms
(85.35%)
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
  96636
  383356
  390571
  395686
  397306
  418492
  418724
  421220
  424523
  429668
  431452
  431975
  434286
  443312
  447454
  447759
  447790
  447843
  449060
  451175
  451267
  451559
  452036
  454284
  459805
  460016
  461725
  462379
  463809
  466685
  474487
  474688
  475483
  475933
  476117
  477555
  477557
  478033
  478475
  479728
  480941
  482788
  484821
  489093
  489820
  490267
  491266
  491273
  491286
  493194
  494513
  496722
  497901
  501228
  506287
  506705
  507291
  511020
  511899
  512215
  512830
  514088
  514836
  516771
  517847
  519107
  522072
  522851
  523197
  525020
  526168
  527409
  529854
  530005
  530385
  531131
  533831
  535028
  536335
  537915
  538837
  539278
  540338
  541887
  542591
  543888
  544867
  556307
  560664
  562374
  565800
  571957
  573409
  578299
  583505
  592313
  600225
  620160
  620244
  621853
  628312
  634791
  637746
  639048
  641642
  645016
  647875
  656577
  665918
  665926
  666536
  666541
  678942
  680183
  700284
  716707
  718745
  720882
  793438
  817033
]
18.90 ms
(9.48%)
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
  475483
  645016
  491273
  511899
  529854
  460016
  538837
  565800
  434286
  506287
  506705
  560664
  573409
  390571
  491286
  431975
  451267
  539278
  478475
  527409
  493194
  96636
  600225
  475933
  479728
  531131
  720882
  678942
  641642
  700284
  447843
  522851
  525020
  817033
  583505
  665926
  665918
  620160
  452036
  476117
  466685
  463809
  543888
  716707
  793438
  447790
  592313
  620244
  447759
  462379
  647875
  656577
  477557
  451559
  512830
  680183
  397306
  459805
  497901
  530385
  494513
  512215
  542591
  496722
  454284
  537915
  541887
  666541
  666536
  556307
  639048
  634791
  429668
  474688
  490267
  578299
  621853
  418724
  526168
  533831
  418492
  522072
  530005
  507291
  540338
  517847
  562374
  474487
  480941
  571957
  637746
  447454
  421220
  482788
  544867
  628312
  478033
  477555
  501228
  511020
  491266
  523197
  451175
  449060
  516771
  424523
  443312
  489093
  431452
  489820
  514088
  536335
  535028
  519107
  484821
  383356
  395686
  461725
  514836
  718745
]
2.97 ms
(1.49%)
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
  96636
  383356
  390571
  395686
  397306
  418492
  418724
  421220
  424523
  429668
  431452
  431975
  434286
  443312
  447454
  447759
  447790
  447843
  449060
  451175
  451267
  451559
  452036
  454284
  459805
  460016
  461725
  462379
  463809
  466685
  474487
  474688
  475483
  475933
  476117
  477555
  477557
  478033
  478475
  479728
  480941
  482788
  484821
  489093
  489820
  490267
  491266
  491273
  491286
  493194
  494513
  496722
  497901
  501228
  506287
  506705
  507291
  511020
  511899
  512215
  512830
  514088
  514836
  516771
  517847
  519107
  522072
  522851
  523197
  525020
  526168
  527409
  529854
  530005
  530385
  531131
  533831
  535028
  536335
  537915
  538837
  539278
  540338
  541887
  542591
  543888
  544867
  556307
  560664
  562374
  565800
  571957
  573409
  578299
  583505
  592313
  600225
  620160
  620244
  621853
  628312
  634791
  637746
  639048
  641642
  645016
  647875
  656577
  665918
  665926
  666536
  666541
  678942
  680183
  700284
  716707
  718745
  720882
  793438
  817033
]
2.07 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex slave anal"
]
1.82 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс доминирован анал"
]
1.73 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.85%)
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.