Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.85 ms
(88.78%)
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
  233618
  425475
  491131
  537636
  540563
  552993
  554117
  560267
  566818
  579642
  584640
  587112
  601855
  605954
  614950
  618143
  620587
  630656
  636628
  640348
  662839
  674256
  683317
  684876
  684886
  686429
  686801
  687354
  694692
  695547
  698920
  708699
  710210
  711616
  715701
  716695
  717103
  717675
  720502
  725043
  731327
  731646
  732976
  734453
  734922
  735388
  735795
  740082
  747273
  748107
  749566
  750358
  751228
  756295
  757301
  758604
  759506
  760092
  762218
  762253
  763274
  763370
  764556
  766001
  768699
  769073
  769429
  771506
  771873
  773809
  775187
  775512
  777198
  779086
  779123
  779132
  779421
  779818
  781212
  781491
  786997
  788551
  789282
  792260
  794623
  794889
  794912
  795243
  795855
  796792
  799544
  799660
  799692
  799868
  800840
  801304
  801690
  801699
  802788
  804843
  805394
  807168
  809755
  809971
  810488
  811555
  811589
  811775
  811819
  813314
  816636
  816712
  824156
  824825
  825401
  826737
  827490
  827828
]
8.97 ms
(5.61%)
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
  734922
  731327
  715701
  813314
  825401
  826023
  816636
  717675
  779086
  779818
  801690
  800840
  805394
  811819
  781491
  795243
  801304
  731646
  759506
  799544
  804843
  552993
  684876
  686429
  711616
  684886
  579642
  601855
  614950
  587112
  605954
  630656
  537636
  540563
  554117
  725043
  788551
  809755
  763370
  799868
  811775
  809971
  799660
  735388
  763274
  811555
  640348
  749566
  827828
  584640
  662839
  674256
  694692
  695547
  708699
  710210
  687354
  698920
  566818
  636628
  618143
  799692
  769429
  824825
  560267
  771506
  824156
  716695
  720502
  781212
  810488
  778565
  801699
  764556
  786997
  807168
  766001
  732976
  762218
  751228
  802788
  811589
  620587
  827490
  775512
  779132
  792260
  794623
  794912
  795855
  775187
  779123
  794889
  750358
  757301
  769073
  734453
  762253
  735795
  747273
  758604
  760092
  768699
  771873
  740082
  748107
  773809
  717103
  789282
  796792
  233618
  777198
  779421
  683317
  425475
  491131
  686801
  756295
  826737
  816712
]
2.62 ms
(1.64%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.22 ms
(1.39%)
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
  233618
  425475
  491131
  537636
  540563
  552993
  554117
  560267
  566818
  579642
  584640
  587112
  601855
  605954
  614950
  618143
  620587
  630656
  636628
  640348
  662839
  674256
  683317
  684876
  684886
  686429
  686801
  687354
  694692
  695547
  698920
  708699
  710210
  711616
  715701
  716695
  717103
  717675
  720502
  725043
  731327
  731646
  732976
  734453
  734922
  735388
  735795
  740082
  747273
  748107
  749566
  750358
  751228
  756295
  757301
  758604
  759506
  760092
  762218
  762253
  763274
  763370
  764556
  766001
  768699
  769073
  769429
  771506
  771873
  773809
  775187
  775512
  777198
  779086
  779123
  779132
  779421
  779818
  781212
  781491
  786997
  788551
  789282
  792260
  794623
  794889
  794912
  795243
  795855
  796792
  799544
  799660
  799692
  799868
  800840
  801304
  801690
  801699
  802788
  804843
  805394
  807168
  809755
  809971
  810488
  811555
  811589
  811775
  811819
  813314
  816636
  816712
  824156
  824825
  825401
  826737
  827490
  827828
]
1.52 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot amateur sex"
]
1.33 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot любительск секс"
]
1.27 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot любительск секс"
]

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.