Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.98 ms
(85.99%)
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
  181926
  182139
  182185
  182686
  276646
  382410
  383571
  384829
  385067
  392422
  398116
  414337
  416656
  417980
  418102
  418122
  428308
  428773
  429566
  429598
  430369
  434307
  434313
  434318
  434332
  434345
  435343
  435395
  437605
  439112
  439328
  439424
  446751
  448000
  448065
  450255
  452803
  452817
  452823
  452829
  452833
  453997
  457812
  458761
  461312
  463621
  468237
  468255
  469054
  469176
  469199
  469733
  471125
  471686
  475407
  475457
  476191
  477500
  481961
  485279
  486244
  486768
  494546
  499914
  500789
  502772
  502774
  502776
  502777
  509776
  509978
  510280
  514083
  514117
  516458
  518508
  518885
  521429
  523885
  526492
  542163
  550891
  564170
  564567
  574192
  578301
  585430
  620743
  637197
  642134
  671520
  713500
  715288
  717620
  720160
  723361
  738475
  738476
  738500
  738513
  744383
  752687
  756771
  758324
  758941
  762007
  783034
  788271
  791010
  791549
  791882
  796648
  796694
  796709
  800543
  802182
  803547
  807562
  828500
  828725
]
13.96 ms
(8.23%)
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
  452823
  494546
  502777
  585430
  620743
  429598
  434313
  437605
  439328
  448065
  450255
  510280
  521429
  417980
  418122
  398116
  637197
  791882
  383571
  392422
  416656
  435395
  428308
  429566
  453997
  457812
  486244
  469176
  502774
  509776
  486768
  574192
  717620
  720160
  564170
  807562
  434332
  468255
  471686
  428773
  481961
  502772
  182185
  452833
  476191
  414337
  828500
  756771
  796694
  384829
  181926
  276646
  475457
  713500
  723361
  788271
  758941
  796709
  452817
  475407
  526492
  578301
  468237
  469199
  434307
  738500
  452803
  418102
  182139
  671520
  738475
  796648
  382410
  518508
  430369
  435343
  434345
  469054
  448000
  452829
  500789
  802182
  434318
  463621
  439112
  461312
  469733
  502776
  499914
  509978
  518885
  385067
  791549
  477500
  514083
  514117
  642134
  803547
  783034
  762007
  744383
  791010
  542163
  564567
  752687
  800543
  738476
  182686
  828725
  715288
  738513
  758324
  516458
  550891
  439424
  458761
  446751
  485279
  471125
  523885
]
3.07 ms
(1.81%)
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
  181926
  182139
  182185
  182686
  276646
  382410
  383571
  384829
  385067
  392422
  398116
  414337
  416656
  417980
  418102
  418122
  428308
  428773
  429566
  429598
  430369
  434307
  434313
  434318
  434332
  434345
  435343
  435395
  437605
  439112
  439328
  439424
  446751
  448000
  448065
  450255
  452803
  452817
  452823
  452829
  452833
  453997
  457812
  458761
  461312
  463621
  468237
  468255
  469054
  469176
  469199
  469733
  471125
  471686
  475407
  475457
  476191
  477500
  481961
  485279
  486244
  486768
  494546
  499914
  500789
  502772
  502774
  502776
  502777
  509776
  509978
  510280
  514083
  514117
  516458
  518508
  518885
  521429
  523885
  526492
  542163
  550891
  564170
  564567
  574192
  578301
  585430
  620743
  637197
  642134
  671520
  713500
  715288
  717620
  720160
  723361
  738475
  738476
  738500
  738513
  744383
  752687
  756771
  758324
  758941
  762007
  783034
  788271
  791010
  791549
  791882
  796648
  796694
  796709
  800543
  802182
  803547
  807562
  828500
  828725
]
1.96 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexmachine dildo"
]
1.88 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сексмашин дилд"
]
1.35 ms
(0.79%)
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.