Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.51 ms
(55.13%)
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
  404273
  404568
  414313
  443163
  459141
  465350
  465360
  465377
  465525
  466075
  470074
  472910
  473504
  474509
  488246
  492111
  506211
  508525
  511193
  512558
  516090
  516103
  517117
  520354
  520448
  522215
  522423
  522525
  529457
  532504
  542148
  542753
  542759
  542794
  543597
  562831
  565273
  571680
  575661
  583482
  583723
  584063
  586554
  587651
  588286
  591416
  598292
  605545
  609958
  612809
  619398
  628426
  643316
  644280
  647328
  733204
  778307
]
38.74 ms
(30.29%)
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:
[
  "amateur mom mmf"
  "amateur mom mmf"
  "amateur mom mmf"
  20
]
10.01 ms
(7.82%)
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
  466075
  542794
  598292
  508525
  506211
  565273
  647328
  644280
  404568
  459141
  542753
  543597
  542759
  532504
  465350
  619398
  473504
  522423
  733204
  522525
  522215
  512558
  520448
  465377
  778307
  511193
  443163
  465360
  404273
  575661
  517117
  591416
  488246
  586554
  414313
  470074
  529457
  474509
  583482
  584063
  472910
  516090
  571680
  465525
  542148
  583723
  587651
  492111
  516103
  520354
  628426
  562831
  609958
  605545
  588286
  643316
  612809
]
2.25 ms
(1.76%)
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
  404273
  404568
  414313
  443163
  459141
  465350
  465360
  465377
  465525
  466075
  470074
  472910
  473504
  474509
  488246
  492111
  506211
  508525
  511193
  512558
  516090
  516103
  517117
  520354
  520448
  522215
  522423
  522525
  529457
  532504
  542148
  542753
  542759
  542794
  543597
  562831
  565273
  571680
  575661
  583482
  583723
  584063
  586554
  587651
  588286
  591416
  598292
  605545
  609958
  612809
  619398
  628426
  643316
  644280
  647328
  733204
  778307
]
1.89 ms
(1.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur mom mmf"
]
1.55 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск mom мжм секс втро"
]
1.25 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск mom мжм секс втро"
]

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.