Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
62.67 ms
(56.83%)
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
  419627
  421164
  431448
  432077
  445443
  451866
  457152
  503419
  514120
  520737
  520739
  522382
  524508
  526203
  527975
  530030
  530696
  535505
  536789
  539203
  543659
  544840
  545341
  545409
  545418
  565501
  566667
  582631
  599835
  602655
  625533
  627725
  627807
  628333
  628383
  630550
  631202
  632978
  633451
  634153
  637021
  640793
  641975
  645276
  647837
  647936
  666894
  677783
  685714
  695123
  696582
  707391
  810109
]
20.60 ms
(18.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:
[
  "rough deepthroat teen"
  "rough deepthroat teen"
  "rough deepthroat teen"
  20
]
17.71 ms
(16.06%)
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
  535505
  520739
  685714
  637021
  627807
  457152
  536789
  543659
  432077
  634153
  566667
  810109
  503419
  645276
  530030
  640793
  641975
  545341
  647936
  696582
  431448
  527975
  631202
  633451
  419627
  627725
  565501
  524508
  530696
  544840
  677783
  632978
  630550
  647837
  421164
  695123
  599835
  445443
  539203
  545409
  707391
  666894
  628383
  451866
  625533
  602655
  582631
  514120
  628333
  545418
  520737
  522382
  526203
]
2.81 ms
(2.54%)
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
  419627
  421164
  431448
  432077
  445443
  451866
  457152
  503419
  514120
  520737
  520739
  522382
  524508
  526203
  527975
  530030
  530696
  535505
  536789
  539203
  543659
  544840
  545341
  545409
  545418
  565501
  566667
  582631
  599835
  602655
  625533
  627725
  627807
  628333
  628383
  630550
  631202
  632978
  633451
  634153
  637021
  640793
  641975
  645276
  647837
  647936
  666894
  677783
  685714
  695123
  696582
  707391
  810109
]
1.98 ms
(1.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "rough deepthroat teen"
]
1.96 ms
(1.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "rough глубокийминет минет оральн секс teen"
]
1.21 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "rough глубокийминет минет оральн секс teen"
]

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.