Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.64 ms
(79.59%)
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
  70132
  124345
  282099
  325867
  386746
  397457
  398912
  402160
  410321
  415819
  419123
  424479
  425810
  425993
  427252
  430815
  432878
  433361
  445930
  446738
  447099
  447134
  452634
  453130
  455083
  457234
  457447
  457585
  462003
  465923
  466244
  470522
  478384
  483559
  491639
  493174
  493195
  494463
  495227
  499899
  500623
  502809
  506411
  506835
  510225
  515341
  523013
  523189
  526455
  530739
  530803
  532530
  537882
  544447
  547431
  549237
  549842
  558028
  558301
  559951
  561970
  564162
  565194
  566878
  567605
  577520
  607549
  608041
  612247
  618514
  620851
  623193
  624837
  630435
  675525
  683183
  683297
  697634
  698407
  707556
  710368
  710435
  714247
  716557
  716572
  720621
  724309
  728194
  728200
  728229
  728442
  730315
  737870
  745169
  749920
  752105
  752653
  752676
  754147
  758281
  758792
  761066
  761463
  770127
  770149
  770901
  776339
  784247
  792631
  795403
  796250
  797525
  799351
  805637
  809906
  814236
  814987
  817273
  823306
  827533
]
23.04 ms
(14.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
  427252
  447099
  452634
  547431
  565194
  624837
  730315
  430815
  447134
  457585
  491639
  827533
  544447
  558301
  425993
  814987
  814236
  465923
  455083
  457234
  470522
  530803
  532530
  707556
  683297
  607549
  623193
  618514
  776339
  784247
  792631
  795403
  799351
  752676
  796250
  797525
  758792
  770901
  728229
  752653
  728200
  758281
  770127
  770149
  761066
  714247
  809906
  453130
  478384
  494463
  506411
  710368
  282099
  530739
  523013
  483559
  415819
  515341
  510225
  549237
  564162
  567605
  537882
  558028
  523189
  559951
  728194
  710435
  526455
  425810
  817273
  445930
  499899
  675525
  697634
  683183
  698407
  716557
  720621
  612247
  630435
  737870
  749920
  745169
  754147
  724309
  728442
  752105
  716572
  805637
  620851
  462003
  549842
  577520
  761463
  424479
  432878
  466244
  433361
  457447
  493174
  500623
  493195
  495227
  502809
  446738
  561970
  608041
  419123
  566878
  402160
  823306
  70132
  124345
  397457
  325867
  398912
  410321
  506835
  386746
]
2.33 ms
(1.46%)
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
  70132
  124345
  282099
  325867
  386746
  397457
  398912
  402160
  410321
  415819
  419123
  424479
  425810
  425993
  427252
  430815
  432878
  433361
  445930
  446738
  447099
  447134
  452634
  453130
  455083
  457234
  457447
  457585
  462003
  465923
  466244
  470522
  478384
  483559
  491639
  493174
  493195
  494463
  495227
  499899
  500623
  502809
  506411
  506835
  510225
  515341
  523013
  523189
  526455
  530739
  530803
  532530
  537882
  544447
  547431
  549237
  549842
  558028
  558301
  559951
  561970
  564162
  565194
  566878
  567605
  577520
  607549
  608041
  612247
  618514
  620851
  623193
  624837
  630435
  675525
  683183
  683297
  697634
  698407
  707556
  710368
  710435
  714247
  716557
  716572
  720621
  724309
  728194
  728200
  728229
  728442
  730315
  737870
  745169
  749920
  752105
  752653
  752676
  754147
  758281
  758792
  761066
  761463
  770127
  770149
  770901
  776339
  784247
  792631
  795403
  796250
  797525
  799351
  805637
  809906
  814236
  814987
  817273
  823306
  827533
]
2.11 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большие титьки в анал%…"
]
1.71 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ анал"
]
1.68 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ анал"
]
1.61 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.