Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.47 ms
(89.79%)
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
  383005
  385548
  390707
  391439
  400977
  415736
  446527
  458779
  465002
  491112
  496371
  511493
  527400
  529850
  530388
  532287
  532293
  532501
  534134
  535576
  537095
  537499
  539791
  539941
  546557
  554882
  557882
  557887
  560037
  583406
  584202
  584956
  601382
  608181
  616591
  624085
  628183
  629497
  634859
  650048
  660573
  665758
  680285
  682992
  693431
  702936
  704622
  710880
  722184
  729107
  730740
  731151
  731225
  738750
  744161
  754742
  755364
  761328
  761433
  762522
  763134
  763920
  764877
  766928
  767345
  767720
  767807
  768449
  775530
  779543
  779735
  780105
  780229
  780257
  780281
  781431
  781516
  781521
  781538
  783058
  783061
  784195
  786528
  787213
  787415
  788090
  789131
  789135
  789907
  790057
  790680
  791249
  791733
  792075
  792513
  792518
  792982
  793150
  793763
  793809
  794589
  794660
  797261
  799930
  800140
  801433
  801493
  804844
  807016
  807101
  807302
  810334
  811426
  817530
  819264
  820192
  824293
  825472
  825892
]
11.23 ms
(5.44%)
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
  738750
  722184
  532501
  385548
  415736
  704622
  539791
  560037
  584956
  793809
  783061
  794660
  383005
  807016
  731151
  702936
  710880
  811426
  820192
  824293
  825892
  532287
  786528
  790680
  792075
  793763
  801433
  807101
  779543
  780105
  780229
  780281
  781516
  781521
  787415
  788090
  789131
  790057
  791249
  794589
  800140
  730740
  754742
  767345
  768449
  781431
  781538
  784195
  787213
  789135
  789907
  791733
  793150
  761328
  763920
  762522
  766928
  761433
  767807
  779735
  779746
  783058
  792513
  792518
  804844
  807302
  825472
  810334
  583406
  601382
  792982
  801493
  755364
  767720
  446527
  817530
  819264
  797261
  799930
  458779
  390707
  511493
  465002
  527400
  537499
  391439
  400977
  731225
  775530
  496371
  534134
  535576
  537095
  529850
  530388
  539941
  660573
  650048
  616591
  744161
  629497
  554882
  764877
  491112
  532293
  693431
  729107
  584202
  557887
  557882
  665758
  680285
  628183
  634859
  608181
  624085
  763134
  780257
  682992
  546557
]
3.57 ms
(1.73%)
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
  383005
  385548
  390707
  391439
  400977
  415736
  446527
  458779
  465002
  491112
  496371
  511493
  527400
  529850
  530388
  532287
  532293
  532501
  534134
  535576
  537095
  537499
  539791
  539941
  546557
  554882
  557882
  557887
  560037
  583406
  584202
  584956
  601382
  608181
  616591
  624085
  628183
  629497
  634859
  650048
  660573
  665758
  680285
  682992
  693431
  702936
  704622
  710880
  722184
  729107
  730740
  731151
  731225
  738750
  744161
  754742
  755364
  761328
  761433
  762522
  763134
  763920
  764877
  766928
  767345
  767720
  767807
  768449
  775530
  779543
  779735
  780105
  780229
  780257
  780281
  781431
  781516
  781521
  781538
  783058
  783061
  784195
  786528
  787213
  787415
  788090
  789131
  789135
  789907
  790057
  790680
  791249
  791733
  792075
  792513
  792518
  792982
  793150
  793763
  793809
  794589
  794660
  797261
  799930
  800140
  801433
  801493
  804844
  807016
  807101
  807302
  810334
  811426
  817530
  819264
  820192
  824293
  825472
  825892
]
1.68 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "handjob amateur"
]
1.59 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дрочк член любительск"
]
1.55 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член любительск"
]
1.49 ms
(0.72%)
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.