Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.56 ms
(85.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
  460903
  470407
  473242
  515014
  519268
  522877
  525529
  541292
  541336
  541388
  541620
  541631
  541674
  541725
  541781
  541822
  541872
  542190
  542198
  542480
  542969
  543480
  544113
  544500
  547607
  549767
  549768
  549779
  550232
  552123
  558172
  559060
  559061
  560076
  560081
  560085
  563166
  564519
  564661
  567382
  567385
  567405
  567419
  567425
  567427
  567432
  567749
  567951
  568306
  570394
  571024
  571056
  571442
  572535
  572537
  572541
  572550
  574235
  574291
  576625
  576643
  576651
  576652
  576676
  576678
  576693
  576694
  576698
  576719
  577355
  577374
  578952
  579296
  580252
  583387
  589640
  590954
  593173
  605305
  606056
  612413
  615726
  615744
  615757
  619082
  619379
  621305
  621318
  621683
  621976
  622379
  622981
  623202
  624358
  624797
  626546
  628292
  628312
  629899
  644005
  644380
  646432
  648204
  648256
  648466
  668943
  672804
  674118
  690902
  692237
  692327
  695201
  699707
  704533
  705881
  707306
  711903
  715670
  725518
  727769
]
16.89 ms
(9.03%)
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
  621976
  626546
  644380
  727769
  699707
  704533
  705881
  470407
  519268
  725518
  541620
  541725
  542190
  542480
  542969
  558172
  560081
  571056
  572541
  572550
  574291
  576643
  576693
  577355
  580252
  547607
  560076
  560085
  564519
  564661
  567419
  567432
  568306
  571024
  571442
  576698
  541674
  541781
  543480
  549768
  567385
  567405
  570394
  576625
  576652
  576676
  576694
  672804
  690902
  692237
  707306
  648204
  648256
  648466
  692327
  711903
  715670
  646432
  668943
  674118
  695201
  549779
  550232
  563166
  567382
  567427
  567749
  572537
  576719
  577374
  579296
  590954
  619082
  619379
  622981
  644005
  621683
  623202
  624358
  628292
  593173
  605305
  606056
  615726
  628312
  589640
  615757
  621305
  621318
  622379
  612413
  615744
  624797
  629899
  473242
  460903
  515014
  525529
  541631
  522877
  541822
  541872
  542198
  544500
  549767
  552123
  559060
  559061
  567425
  567951
  572535
  574235
  576651
  576678
  578952
  583387
  541292
  541336
  541388
  544113
]
2.98 ms
(1.59%)
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
  460903
  470407
  473242
  515014
  519268
  522877
  525529
  541292
  541336
  541388
  541620
  541631
  541674
  541725
  541781
  541822
  541872
  542190
  542198
  542480
  542969
  543480
  544113
  544500
  547607
  549767
  549768
  549779
  550232
  552123
  558172
  559060
  559061
  560076
  560081
  560085
  563166
  564519
  564661
  567382
  567385
  567405
  567419
  567425
  567427
  567432
  567749
  567951
  568306
  570394
  571024
  571056
  571442
  572535
  572537
  572541
  572550
  574235
  574291
  576625
  576643
  576651
  576652
  576676
  576678
  576693
  576694
  576698
  576719
  577355
  577374
  578952
  579296
  580252
  583387
  589640
  590954
  593173
  605305
  606056
  612413
  615726
  615744
  615757
  619082
  619379
  621305
  621318
  621683
  621976
  622379
  622981
  623202
  624358
  624797
  626546
  628292
  628312
  629899
  644005
  644380
  646432
  648204
  648256
  648466
  668943
  672804
  674118
  690902
  692237
  692327
  695201
  699707
  704533
  705881
  707306
  711903
  715670
  725518
  727769
]
1.93 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ретр boobs"
]
1.70 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ретр boobs"
]
1.59 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "retro boobs"
]
1.53 ms
(0.81%)
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.