Query Metrics

8 Database Queries
8 Different statements
104.74 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
61.00 ms
(58.24%)
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
  210281
  391603
  423849
  435015
  438032
  444698
  450646
  455834
  457563
  457735
  457786
  458269
  461005
  471662
  484010
  487047
  492289
  494938
  497180
  497236
  505591
  512936
  519676
  527435
  527533
  534828
  546592
  554025
  556869
  557042
  572754
  577679
  595029
  610023
  615420
  637176
  652779
  659956
  704034
  705726
  724781
  732629
  754873
  756263
  769585
  779733
  783528
  794924
  814299
  828212
]
23.49 ms
(22.43%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "real amateur outdoor"
  "real amateur outdoor"
  "real amateur outdoor"
  20
]
9.53 ms
(9.09%)
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
  794924
  779733
  732629
  828212
  554025
  754873
  610023
  783528
  572754
  705726
  756263
  814299
  659956
  534828
  704034
  724781
  556869
  637176
  210281
  438032
  769585
  471662
  652779
  546592
  455834
  615420
  487047
  458269
  423849
  435015
  527533
  577679
  391603
  457563
  497180
  527435
  450646
  461005
  505591
  494938
  595029
  492289
  497236
  519676
  457735
  512936
  444698
  484010
  457786
  557042
]
2.59 ms
(2.48%)
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
  210281
  391603
  423849
  435015
  438032
  444698
  450646
  455834
  457563
  457735
  457786
  458269
  461005
  471662
  484010
  487047
  492289
  494938
  497180
  497236
  505591
  512936
  519676
  527435
  527533
  534828
  546592
  554025
  556869
  557042
  572754
  577679
  595029
  610023
  615420
  637176
  652779
  659956
  704034
  705726
  724781
  732629
  754873
  756263
  769585
  779733
  783528
  794924
  814299
  828212
]
2.25 ms
(2.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real amateur outdoor"
]
2.17 ms
(2.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real любительск outdoor"
]
2.02 ms
(1.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real любительск outdoor"
]

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.