Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
423.76 ms
(53.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "veronicaleal сквирт оргазм"
]
340.46 ms
(42.82%)
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
  406792
  413649
  413826
  425820
  429255
  446330
  447914
  451246
  451257
  451261
  458538
  461853
  463867
  469023
  469465
  478492
  521581
  531166
  531263
  533877
  533944
  536783
  537904
  550298
  580188
  614029
  617410
  618326
  620794
  632691
  642044
  645238
  646923
  647330
  647355
  647879
  649214
  649215
  656502
  666534
  666538
  666539
  666540
  666541
  666545
  666548
  666550
  666553
  676022
  676641
  678143
  679799
  679810
  693504
  699639
  702677
  707391
  788780
  811497
]
13.36 ms
(1.68%)
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:
[
  "veronica leal squirt"
  "veronica leal squirt"
  "veronica leal squirt"
  20
]
10.20 ms
(1.28%)
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
  699639
  647330
  580188
  531166
  537904
  656502
  478492
  533944
  707391
  533877
  666541
  666534
  666538
  463867
  666548
  666553
  649214
  406792
  531263
  666539
  666540
  666545
  649215
  666550
  614029
  679799
  632691
  811497
  620794
  550298
  678143
  676022
  693504
  461853
  536783
  642044
  645238
  647879
  458538
  679810
  617410
  451246
  702677
  647355
  676641
  618326
  646923
  469465
  425820
  446330
  788780
  451261
  447914
  451257
  429255
  469023
  413649
  521581
  413826
]
2.25 ms
(0.28%)
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
  406792
  413649
  413826
  425820
  429255
  446330
  447914
  451246
  451257
  451261
  458538
  461853
  463867
  469023
  469465
  478492
  521581
  531166
  531263
  533877
  533944
  536783
  537904
  550298
  580188
  614029
  617410
  618326
  620794
  632691
  642044
  645238
  646923
  647330
  647355
  647879
  649214
  649215
  656502
  666534
  666538
  666539
  666540
  666541
  666545
  666548
  666550
  666553
  676022
  676641
  678143
  679799
  679810
  693504
  699639
  702677
  707391
  788780
  811497
]
1.78 ms
(0.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "veronica leal squirt"
]
1.66 ms
(0.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "veronicaleal сквирт оргазм"
]

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.