Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
86.91 ms
(63.22%)
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
  395144
  415112
  416303
  417396
  417787
  420358
  425518
  434601
  446112
  447500
  452606
  455941
  469576
  470302
  482350
  484724
  485633
  492097
  492098
  497921
  497923
  507680
  514115
  517833
  522056
  523222
  524951
  524992
  525702
  529078
  541366
  541588
  541888
  544455
  556025
  576645
  576711
  577362
  584514
  590469
  590667
  596226
  598475
  605345
  613220
  614017
  621201
  621691
  625696
  634487
  659025
  716394
  727812
  730762
  786552
  788264
]
28.35 ms
(20.62%)
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:
[
  "stockings porn"
  "stockings porn"
  "stockings porn"
  20
]
12.70 ms
(9.24%)
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
  596226
  605345
  614017
  634487
  788264
  786552
  716394
  446112
  416303
  425518
  452606
  447500
  455941
  517833
  485633
  497923
  522056
  525702
  730762
  613220
  590469
  621201
  395144
  469576
  492098
  541366
  576645
  659025
  576711
  415112
  470302
  420358
  514115
  524992
  541588
  529078
  584514
  577362
  417787
  492097
  524951
  544455
  727812
  625696
  482350
  484724
  434601
  523222
  507680
  541888
  598475
  621691
  497921
  556025
  590667
  417396
]
2.49 ms
(1.81%)
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
  395144
  415112
  416303
  417396
  417787
  420358
  425518
  434601
  446112
  447500
  452606
  455941
  469576
  470302
  482350
  484724
  485633
  492097
  492098
  497921
  497923
  507680
  514115
  517833
  522056
  523222
  524951
  524992
  525702
  529078
  541366
  541588
  541888
  544455
  556025
  576645
  576711
  577362
  584514
  590469
  590667
  596226
  598475
  605345
  613220
  614017
  621201
  621691
  625696
  634487
  659025
  716394
  727812
  730762
  786552
  788264
]
2.26 ms
(1.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stockings porn"
]
1.74 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "чулк нижн бел porn"
]
1.53 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "чулк нижн бел porn"
]

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.