Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.05 ms
(83.25%)
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
  385899
  394212
  395344
  397901
  412136
  422108
  424491
  424847
  427001
  428098
  432631
  434135
  437614
  438699
  440802
  447749
  448352
  449412
  450096
  450830
  451725
  452118
  453018
  458406
  458464
  462031
  462815
  463010
  464207
  467026
  470989
  473244
  474307
  475599
  478393
  478806
  480476
  482950
  485453
  488920
  489181
  497666
  500083
  502318
  504358
  507042
  507204
  507440
  508154
  508272
  508378
  511211
  512860
  514273
  514396
  519800
  520081
  523843
  524970
  527505
  527574
  527859
  527896
  528272
  529025
  529253
  529353
  529451
  530307
  532334
  533126
  535331
  538263
  543310
  548558
  549166
  550040
  555526
  558635
  558839
  560021
  564275
  564518
  564565
  564999
  565333
  566071
  568773
  568819
  569698
  570241
  572276
  572396
  572784
  574532
  575865
  576299
  580735
  584088
  586157
  595514
  598747
  599358
  603381
  604654
  604783
  608518
  618040
  619327
  622280
  627420
  645893
  646939
  663965
  667253
  667497
  667880
  680992
  684298
  687316
]
15.31 ms
(10.79%)
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
  572396
  574532
  580735
  598747
  474307
  395344
  529025
  385899
  432631
  424847
  482950
  500083
  570241
  687316
  618040
  428098
  451725
  452118
  453018
  470989
  448352
  449412
  458464
  462815
  473244
  511211
  524970
  532334
  529253
  497666
  502318
  538263
  504358
  507440
  527505
  530307
  488920
  543310
  572276
  576299
  548558
  549166
  566071
  558839
  564275
  667880
  680992
  684298
  645893
  667253
  667497
  558635
  560021
  595514
  586157
  604783
  438699
  462031
  475599
  422108
  458406
  478393
  467026
  478806
  508378
  514396
  527859
  527896
  528272
  489181
  514273
  520081
  507042
  485453
  529451
  434135
  450830
  507204
  584088
  565333
  575865
  646939
  550040
  604654
  622280
  608518
  412136
  427001
  463010
  529353
  535331
  512860
  564518
  564999
  440802
  424491
  523843
  437614
  464207
  480476
  450096
  508154
  508272
  519800
  527574
  533126
  555526
  572784
  564565
  568819
  568773
  569698
  663965
  619327
  603381
  599358
  627420
  447749
  394212
  397901
]
2.08 ms
(1.47%)
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
  385899
  394212
  395344
  397901
  412136
  422108
  424491
  424847
  427001
  428098
  432631
  434135
  437614
  438699
  440802
  447749
  448352
  449412
  450096
  450830
  451725
  452118
  453018
  458406
  458464
  462031
  462815
  463010
  464207
  467026
  470989
  473244
  474307
  475599
  478393
  478806
  480476
  482950
  485453
  488920
  489181
  497666
  500083
  502318
  504358
  507042
  507204
  507440
  508154
  508272
  508378
  511211
  512860
  514273
  514396
  519800
  520081
  523843
  524970
  527505
  527574
  527859
  527896
  528272
  529025
  529253
  529353
  529451
  530307
  532334
  533126
  535331
  538263
  543310
  548558
  549166
  550040
  555526
  558635
  558839
  560021
  564275
  564518
  564565
  564999
  565333
  566071
  568773
  568819
  569698
  570241
  572276
  572396
  572784
  574532
  575865
  576299
  580735
  584088
  586157
  595514
  598747
  599358
  603381
  604654
  604783
  608518
  618040
  619327
  622280
  627420
  645893
  646939
  663965
  667253
  667497
  667880
  680992
  684298
  687316
]
1.92 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жопа в юбке"
]
1.52 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп в юбк"
]
1.47 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп в юбк"
]
1.46 ms
(1.03%)
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.