Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.69 ms
(85.28%)
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
  357595
  388537
  391754
  392004
  400480
  414125
  415294
  421820
  421856
  423934
  424248
  424294
  428282
  428883
  429863
  429881
  429889
  429916
  430353
  431028
  432179
  435373
  437635
  437947
  439033
  439125
  439138
  439142
  439325
  439705
  444180
  444527
  447052
  447538
  448489
  448607
  452187
  452964
  456240
  465670
  466475
  467058
  467893
  469092
  470971
  473740
  477246
  480502
  483558
  486189
  486856
  490731
  491952
  492994
  493172
  493849
  496474
  498649
  499288
  502362
  502800
  502856
  504509
  513560
  513629
  516246
  516579
  517272
  517425
  523970
  528143
  528223
  529249
  533653
  538977
  541251
  544404
  544509
  546976
  547703
  551256
  555048
  556335
  556341
  558261
  566766
  579031
  586583
  586962
  590398
  592573
  597190
  600087
  601338
  601519
  607549
  609071
  652966
  654078
  661283
  670997
  679190
  686106
  695393
  699487
  700478
  714665
  716127
  721203
  745136
  747328
  758281
  759340
  785972
  786178
  786911
  790199
  807435
  818025
  827967
]
16.03 ms
(9.13%)
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
  431028
  439033
  528143
  492994
  498649
  502856
  504509
  523970
  579031
  516246
  424294
  546976
  547703
  465670
  429881
  467058
  439142
  437947
  448489
  592573
  428883
  467893
  430353
  437635
  452187
  414125
  447052
  447538
  477246
  456240
  496474
  502362
  679190
  786178
  439138
  586962
  558261
  556341
  555048
  590398
  423934
  448607
  415294
  470971
  429916
  473740
  391754
  429863
  439325
  513629
  541251
  490731
  432179
  421820
  491952
  400480
  424248
  469092
  533653
  538977
  544509
  551256
  566766
  544404
  721203
  686106
  586583
  607549
  609071
  597190
  600087
  785972
  807435
  747328
  759340
  745136
  758281
  786911
  357595
  466475
  388537
  392004
  439125
  444180
  517425
  483558
  493849
  502800
  499288
  517272
  529249
  486189
  493172
  601338
  421856
  428282
  444527
  452964
  429889
  528223
  435373
  516579
  486856
  439705
  513560
  827967
  695393
  716127
  790199
  601519
  818025
  480502
  556335
  652966
  654078
  670997
  699487
  700478
  714665
  661283
]
2.83 ms
(1.61%)
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
  357595
  388537
  391754
  392004
  400480
  414125
  415294
  421820
  421856
  423934
  424248
  424294
  428282
  428883
  429863
  429881
  429889
  429916
  430353
  431028
  432179
  435373
  437635
  437947
  439033
  439125
  439138
  439142
  439325
  439705
  444180
  444527
  447052
  447538
  448489
  448607
  452187
  452964
  456240
  465670
  466475
  467058
  467893
  469092
  470971
  473740
  477246
  480502
  483558
  486189
  486856
  490731
  491952
  492994
  493172
  493849
  496474
  498649
  499288
  502362
  502800
  502856
  504509
  513560
  513629
  516246
  516579
  517272
  517425
  523970
  528143
  528223
  529249
  533653
  538977
  541251
  544404
  544509
  546976
  547703
  551256
  555048
  556335
  556341
  558261
  566766
  579031
  586583
  586962
  590398
  592573
  597190
  600087
  601338
  601519
  607549
  609071
  652966
  654078
  661283
  670997
  679190
  686106
  695393
  699487
  700478
  714665
  716127
  721203
  745136
  747328
  758281
  759340
  785972
  786178
  786911
  790199
  807435
  818025
  827967
]
2.00 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мастурбация русских анал"
]
1.72 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац русск анал"
]
1.56 ms
(0.89%)
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.