Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.77 ms
(50.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
94.82 ms
(23.47%)
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:
[
  "русские в чулках соблазняют"
  "русские в чулках соблазняют"
  "русские в чулках соблазняют"
  20
]
84.19 ms
(20.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
  389840
  391163
  392028
  396188
  397907
  397923
  401007
  411794
  418226
  424435
  439663
  439718
  440999
  445834
  447934
  451486
  465380
  465802
  466331
  467621
  468183
  470272
  474793
  476275
  482505
  482525
  489940
  490935
  490946
  491932
  491972
  501749
  511523
  517977
  527292
  552229
  552360
  563198
  591241
  591292
  598391
  599552
  601016
  608553
  619511
  619528
  658468
  677050
  722846
  724809
  741859
  744912
  744922
  760875
  769863
  770603
  782632
]
10.99 ms
(2.72%)
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
  782632
  391163
  760875
  392028
  724809
  658468
  741859
  677050
  396188
  418226
  445834
  744922
  397907
  389840
  447934
  552229
  411794
  397923
  517977
  470272
  769863
  476275
  490946
  591241
  770603
  401007
  465802
  619511
  591292
  424435
  440999
  619528
  552360
  468183
  451486
  563198
  439718
  474793
  501749
  598391
  482505
  601016
  744912
  722846
  489940
  511523
  465380
  491972
  491932
  467621
  490935
  527292
  439663
  466331
  482525
  599552
  608553
]
3.68 ms
(0.91%)
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
  389840
  391163
  392028
  396188
  397907
  397923
  401007
  411794
  418226
  424435
  439663
  439718
  440999
  445834
  447934
  451486
  465380
  465802
  466331
  467621
  468183
  470272
  474793
  476275
  482505
  482525
  489940
  490935
  490946
  491932
  491972
  501749
  511523
  517977
  527292
  552229
  552360
  563198
  591241
  591292
  598391
  599552
  601016
  608553
  619511
  619528
  658468
  677050
  722846
  724809
  741859
  744912
  744922
  760875
  769863
  770603
  782632
]
2.25 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русские в чулках соблазняют"
]
1.75 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск чулк нижн бел соблазня"
]
1.64 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск чулк нижн бел соблазня"
]

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.