Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.27 ms
(52.64%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
157.16 ms
(40.10%)
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
  467951
  472483
  472611
  475328
  481441
  483559
  484951
  486171
  493568
  494437
  494688
  496616
  499241
  499860
  499881
  500240
  501510
  503444
  506076
  507041
  509108
  509610
  510376
  511616
  512800
  512937
  514761
  514995
  515881
  516637
  516701
  516730
  517006
  517481
  517580
  517634
  517712
  517717
  518624
  518919
  518990
  519850
  520211
  521084
  521249
  521470
  522198
  522933
  523556
  523563
  525855
  527223
  527433
  529275
  529331
  532516
  533218
  533634
  534524
  536408
  536426
  536455
  536884
  536887
  538681
  539489
  539559
  540227
  540541
  541321
  542223
  543552
  544976
  544977
  545631
  545926
  549105
  550685
  551132
  551779
  555592
  558903
  559200
  559996
  561447
  562957
  563082
  564390
  564399
  564517
  564858
  565887
  568381
  568427
  568525
  569149
  570722
  571086
  571126
  571144
  571265
  571441
  572235
  572707
  574265
  575665
  576933
  576944
  577912
  578207
  578493
  579471
  579821
  579856
  581722
  582404
  582792
  583710
  584101
  584879
]
19.18 ms
(4.89%)
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
  536408
  536884
  503444
  507041
  509108
  509610
  514761
  516637
  517717
  518990
  519850
  522198
  522933
  527433
  533218
  533634
  536455
  536887
  494437
  494688
  496616
  499241
  499860
  500240
  501510
  506076
  510376
  511616
  512800
  515881
  516701
  518919
  520211
  525855
  529275
  532516
  534524
  536426
  538681
  539489
  539559
  540227
  540541
  499881
  512937
  514995
  516730
  517006
  517481
  517580
  517634
  517712
  518624
  521084
  521249
  521470
  523556
  523563
  527223
  529331
  467951
  472483
  472611
  475328
  481441
  483559
  484951
  486171
  493568
  541321
  544977
  551779
  558903
  559200
  561447
  562957
  564390
  564399
  564517
  568427
  570722
  571265
  575665
  578493
  579856
  581722
  584879
  543552
  544976
  550685
  559996
  563082
  568525
  571126
  576944
  577912
  578207
  579821
  582404
  582792
  583710
  584101
  542223
  545631
  545926
  549105
  551132
  555592
  564858
  565887
  568381
  569149
  571086
  571144
  571441
  572235
  572707
  574265
  576933
  579471
]
3.48 ms
(0.89%)
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
  467951
  472483
  472611
  475328
  481441
  483559
  484951
  486171
  493568
  494437
  494688
  496616
  499241
  499860
  499881
  500240
  501510
  503444
  506076
  507041
  509108
  509610
  510376
  511616
  512800
  512937
  514761
  514995
  515881
  516637
  516701
  516730
  517006
  517481
  517580
  517634
  517712
  517717
  518624
  518919
  518990
  519850
  520211
  521084
  521249
  521470
  522198
  522933
  523556
  523563
  525855
  527223
  527433
  529275
  529331
  532516
  533218
  533634
  534524
  536408
  536426
  536455
  536884
  536887
  538681
  539489
  539559
  540227
  540541
  541321
  542223
  543552
  544976
  544977
  545631
  545926
  549105
  550685
  551132
  551779
  555592
  558903
  559200
  559996
  561447
  562957
  563082
  564390
  564399
  564517
  564858
  565887
  568381
  568427
  568525
  569149
  570722
  571086
  571126
  571144
  571265
  571441
  572235
  572707
  574265
  575665
  576933
  576944
  577912
  578207
  578493
  579471
  579821
  579856
  581722
  582404
  582792
  583710
  584101
  584879
]
2.31 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большая смазка"
]
2.00 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие смазк"
]
1.49 ms
(0.38%)
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.