Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
193.73 ms
(87.49%)
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
  7157
  190869
  383595
  383650
  385474
  385486
  387742
  388856
  397526
  399604
  399633
  399659
  399923
  401052
  401470
  407396
  407627
  418865
  426414
  426464
  429368
  430695
  446135
  447166
  448363
  448962
  462425
  466958
  468545
  478036
  479802
  480381
  480398
  484205
  485132
  498593
  499857
  515768
  645349
  806138
  806174
  807385
  815184
  815195
  815214
  815236
  815256
  815263
  815264
  815299
  815304
  815317
  815339
  815347
  815365
  815369
  815406
  815412
  815425
  815448
  815450
  815454
  815469
  815474
  815478
  815516
  815531
  815540
  815559
  815583
  815598
  815608
  815617
  815699
  815714
  815721
  815723
  815742
  815752
  815759
  815768
  815793
  815797
  815841
  815847
  815865
  815869
  815875
  815895
  815897
  815904
  815952
  815958
  815973
  815979
  815980
  815995
  816001
  816025
  816035
  816040
  816060
  816067
  816083
  816259
  816326
  816360
  816451
  816497
  816510
  816513
  816524
  816534
  816536
  816893
  816905
  816968
  816990
  817396
  821532
]
16.30 ms
(7.36%)
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
  815531
  815768
  815797
  816001
  816035
  816083
  816497
  815973
  815979
  816534
  816893
  815195
  815721
  815793
  815958
  815980
  7157
  399923
  815723
  816360
  448962
  480381
  479802
  806138
  426414
  815412
  815469
  383595
  815516
  815617
  815299
  815865
  816259
  468545
  401470
  407396
  480398
  478036
  388856
  815454
  816513
  387742
  815714
  815897
  815304
  815608
  816067
  816968
  815214
  815559
  815699
  815869
  815184
  815347
  815406
  815752
  815847
  815875
  821532
  515768
  418865
  430695
  485132
  448363
  815317
  815450
  815256
  815448
  815583
  815742
  816025
  816040
  816451
  816990
  815474
  815478
  815895
  815904
  815952
  815995
  816524
  817396
  815339
  815369
  815425
  815540
  816060
  645349
  806174
  815365
  399604
  815236
  815264
  816510
  401052
  466958
  499857
  383650
  397526
  399659
  429368
  816905
  815759
  446135
  462425
  385486
  407627
  447166
  498593
  484205
  190869
  399633
  815263
  816326
  816536
  815841
  807385
  426464
  815598
  385474
]
4.10 ms
(1.85%)
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
  7157
  190869
  383595
  383650
  385474
  385486
  387742
  388856
  397526
  399604
  399633
  399659
  399923
  401052
  401470
  407396
  407627
  418865
  426414
  426464
  429368
  430695
  446135
  447166
  448363
  448962
  462425
  466958
  468545
  478036
  479802
  480381
  480398
  484205
  485132
  498593
  499857
  515768
  645349
  806138
  806174
  807385
  815184
  815195
  815214
  815236
  815256
  815263
  815264
  815299
  815304
  815317
  815339
  815347
  815365
  815369
  815406
  815412
  815425
  815448
  815450
  815454
  815469
  815474
  815478
  815516
  815531
  815540
  815559
  815583
  815598
  815608
  815617
  815699
  815714
  815721
  815723
  815742
  815752
  815759
  815768
  815793
  815797
  815841
  815847
  815865
  815869
  815875
  815895
  815897
  815904
  815952
  815958
  815973
  815979
  815980
  815995
  816001
  816025
  816035
  816040
  816060
  816067
  816083
  816259
  816326
  816360
  816451
  816497
  816510
  816513
  816524
  816534
  816536
  816893
  816905
  816968
  816990
  817396
  821532
]
1.96 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brazzers mother"
]
1.86 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "brazzers мам женщин"
]
1.76 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "brazzers мам женщин"
]

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.