Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.60 ms
(56.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
139.94 ms
(37.43%)
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
  388559
  405820
  420037
  427117
  456357
  458779
  462507
  512142
  530585
  530594
  533276
  534183
  536852
  537626
  539020
  546096
  547103
  553498
  553636
  554727
  556604
  564998
  577691
  577704
  581275
  585289
  588003
  590017
  590383
  594639
  612250
  616053
  621777
  626235
  626645
  629784
  630624
  634460
  650896
  653290
  656660
  657860
  660716
  664700
  665332
  668064
  669622
  670938
  671256
  672213
  672894
  676196
  677913
  687039
  689180
  689571
  690517
  693789
  695008
  695057
  696380
  696794
  699135
  703625
  703628
  708084
  708294
  713151
  715435
  730784
  733453
  747991
  751372
  752196
  754703
  754966
  759798
  761681
  761847
  762661
  762793
  766151
  766971
  768468
  768578
  778145
  779790
  780400
  781099
  783586
  785970
  786701
  787070
  787083
  790923
  791509
  793332
  794470
  795379
  797023
  797824
  799477
  800745
  800889
  801717
  802892
  807106
  809802
  810012
  811355
  813190
  813365
  813635
  817322
  817464
  824063
  824914
  825392
  827904
]
15.03 ms
(4.02%)
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
  785970
  787083
  797023
  801717
  809802
  811355
  420037
  462507
  405820
  778145
  766971
  693789
  630624
  634460
  626235
  534183
  650896
  708294
  612250
  388559
  813635
  817322
  817464
  824063
  824914
  825392
  458779
  581275
  715435
  781099
  790923
  797824
  807106
  779790
  793332
  800745
  800889
  813365
  766151
  783586
  791509
  802892
  813190
  768578
  733453
  747991
  752196
  754703
  759798
  762661
  762793
  765594
  768468
  730784
  751372
  754966
  761681
  761847
  780400
  786701
  787070
  794470
  795379
  799477
  810012
  456357
  427117
  512142
  687039
  827904
  533276
  539020
  530594
  530585
  536852
  537626
  553498
  564998
  577691
  577704
  553636
  546096
  554727
  556604
  656660
  660716
  664700
  670938
  677913
  695057
  703625
  703628
  657860
  665332
  669622
  671256
  653290
  668064
  672213
  672894
  676196
  689180
  689571
  690517
  695008
  696380
  696794
  699135
  708084
  713151
  547103
  585289
  588003
  590017
  590383
  594639
  616053
  621777
  626645
  629784
]
2.77 ms
(0.74%)
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
  388559
  405820
  420037
  427117
  456357
  458779
  462507
  512142
  530585
  530594
  533276
  534183
  536852
  537626
  539020
  546096
  547103
  553498
  553636
  554727
  556604
  564998
  577691
  577704
  581275
  585289
  588003
  590017
  590383
  594639
  612250
  616053
  621777
  626235
  626645
  629784
  630624
  634460
  650896
  653290
  656660
  657860
  660716
  664700
  665332
  668064
  669622
  670938
  671256
  672213
  672894
  676196
  677913
  687039
  689180
  689571
  690517
  693789
  695008
  695057
  696380
  696794
  699135
  703625
  703628
  708084
  708294
  713151
  715435
  730784
  733453
  747991
  751372
  752196
  754703
  754966
  759798
  761681
  761847
  762661
  762793
  766151
  766971
  768468
  768578
  778145
  779790
  780400
  781099
  783586
  785970
  786701
  787070
  787083
  790923
  791509
  793332
  794470
  795379
  797023
  797824
  799477
  800745
  800889
  801717
  802892
  807106
  809802
  810012
  811355
  813190
  813365
  813635
  817322
  817464
  824063
  824914
  825392
  827904
]
2.16 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade girlfriend"
]
1.85 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск girlfriend"
]
1.54 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск girlfriend"
]

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.