Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.02 ms
(80.66%)
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
  11991
  53553
  351283
  381867
  382766
  385024
  385229
  385416
  388925
  390493
  391182
  395226
  401975
  403289
  405144
  405472
  405939
  406168
  406476
  410402
  411813
  411883
  411977
  413700
  414222
  415404
  420919
  421350
  423299
  425599
  429250
  430490
  435658
  446348
  448541
  452247
  453354
  453395
  454603
  454824
  454948
  454960
  458609
  464904
  466919
  468712
  468749
  472752
  473195
  474688
  474734
  482366
  484476
  488747
  489242
  504461
  505296
  510403
  513989
  519482
  521363
  523923
  526896
  526908
  528689
  528998
  535057
  538106
  540273
  540677
  550342
  550398
  550404
  551574
  556082
  557376
  558047
  565341
  566061
  566903
  571215
  571219
  575727
  579325
  580712
  582777
  584287
  594912
  596255
  597241
  601309
  603464
  605325
  605326
  605331
  605334
  605342
  609870
  609878
  613485
  619375
  622025
  633474
  633801
  634509
  634512
  634533
  634546
  637012
  637060
  644330
  668986
  671816
  673149
  708465
  714526
  776514
  792813
  810279
  814722
]
23.00 ms
(13.16%)
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
  446348
  810279
  401975
  452247
  535057
  519482
  488747
  565341
  637060
  634546
  634512
  526908
  385416
  351283
  584287
  557376
  603464
  596255
  597241
  605326
  391182
  388925
  430490
  410402
  454948
  792813
  521363
  406476
  420919
  814722
  484476
  466919
  579325
  622025
  489242
  776514
  411883
  425599
  423299
  566061
  405144
  448541
  411977
  472752
  429250
  454824
  510403
  540677
  528998
  540273
  513989
  523923
  550398
  550404
  551574
  556082
  566903
  668986
  671816
  673149
  708465
  633474
  613485
  633801
  634533
  637012
  601309
  634509
  11991
  406168
  474688
  526896
  53553
  385229
  405472
  468712
  468749
  474734
  558047
  575727
  550342
  571215
  571219
  609870
  609878
  605325
  605342
  594912
  605331
  605334
  619375
  644330
  714526
  390493
  403289
  504461
  538106
  395226
  582777
  405939
  414222
  435658
  453395
  454960
  453354
  458609
  454603
  473195
  580712
  464904
  482366
  415404
  505296
  528689
  382766
  385024
  381867
  413700
  411813
  421350
]
2.69 ms
(1.54%)
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
  11991
  53553
  351283
  381867
  382766
  385024
  385229
  385416
  388925
  390493
  391182
  395226
  401975
  403289
  405144
  405472
  405939
  406168
  406476
  410402
  411813
  411883
  411977
  413700
  414222
  415404
  420919
  421350
  423299
  425599
  429250
  430490
  435658
  446348
  448541
  452247
  453354
  453395
  454603
  454824
  454948
  454960
  458609
  464904
  466919
  468712
  468749
  472752
  473195
  474688
  474734
  482366
  484476
  488747
  489242
  504461
  505296
  510403
  513989
  519482
  521363
  523923
  526896
  526908
  528689
  528998
  535057
  538106
  540273
  540677
  550342
  550398
  550404
  551574
  556082
  557376
  558047
  565341
  566061
  566903
  571215
  571219
  575727
  579325
  580712
  582777
  584287
  594912
  596255
  597241
  601309
  603464
  605325
  605326
  605331
  605334
  605342
  609870
  609878
  613485
  619375
  622025
  633474
  633801
  634509
  634512
  634533
  634546
  637012
  637060
  644330
  668986
  671816
  673149
  708465
  714526
  776514
  792813
  810279
  814722
]
2.23 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass casting"
]
2.12 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп кастинг"
]
1.83 ms
(1.05%)
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.