Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.72 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.76 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русское с тату"
]
3 13.31 ms
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
  420515
  626969
  790401
  390678
  391764
  408429
  398997
  387352
  828673
  828557
  533761
  704059
  654842
  789287
  790420
  769318
  732160
  724238
  739939
  766481
  754634
  765961
  481023
  478749
  566303
  654555
  682417
  559275
  386959
  447597
  401003
  475177
  438004
  443028
  448250
  448577
  481226
  463312
  481156
  540724
  499047
  504214
  523710
  453507
  433037
  736818
  813470
  509241
  533662
  720649
  723210
  653371
  558073
  598591
  596584
  782520
  787189
  809938
  811150
  743105
  739265
  384050
  395442
  476024
  233934
  426843
  426893
  666006
  623021
  631920
  825540
  562986
  656957
  722999
  640469
  803155
  804908
  762050
  755617
  763544
  778381
  467891
  438911
  585114
  585116
  495160
  557349
  562306
  564994
  563209
  580015
  582641
  549732
  564999
  579490
  581928
  546705
  567059
  572469
  597057
  611331
  590615
  618854
  619352
  599110
  619358
  620011
  618813
  453924
  459019
  480947
  433489
  433536
  459959
  465667
  475996
  480113
  426746
  432176
  437983
]
4 2.94 ms
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
  233934
  384050
  386959
  387352
  390678
  391764
  395442
  398997
  401003
  408429
  420515
  426746
  426843
  426893
  432176
  433037
  433489
  433536
  437983
  438004
  438911
  443028
  447597
  448250
  448577
  453507
  453924
  459019
  459959
  463312
  465667
  467891
  475177
  475996
  476024
  478749
  480113
  480947
  481023
  481156
  481226
  495160
  499047
  504214
  509241
  523710
  533662
  533761
  540724
  546705
  549732
  557349
  558073
  559275
  562306
  562986
  563209
  564994
  564999
  566303
  567059
  572469
  579490
  580015
  581928
  582641
  585114
  585116
  590615
  596584
  597057
  598591
  599110
  611331
  618813
  618854
  619352
  619358
  620011
  623021
  626969
  631920
  640469
  653371
  654555
  654842
  656957
  666006
  682417
  704059
  720649
  722999
  723210
  724238
  732160
  736818
  739265
  739939
  743105
  754634
  755617
  762050
  763544
  765961
  766481
  769318
  778381
  782520
  787189
  789287
  790401
  790420
  803155
  804908
  809938
  811150
  813470
  825540
  828557
  828673
]
5 305.67 ms
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
  233934
  384050
  386959
  387352
  390678
  391764
  395442
  398997
  401003
  408429
  420515
  426746
  426843
  426893
  432176
  433037
  433489
  433536
  437983
  438004
  438911
  443028
  447597
  448250
  448577
  453507
  453924
  459019
  459959
  463312
  465667
  467891
  475177
  475996
  476024
  478749
  480113
  480947
  481023
  481156
  481226
  495160
  499047
  504214
  509241
  523710
  533662
  533761
  540724
  546705
  549732
  557349
  558073
  559275
  562306
  562986
  563209
  564994
  564999
  566303
  567059
  572469
  579490
  580015
  581928
  582641
  585114
  585116
  590615
  596584
  597057
  598591
  599110
  611331
  618813
  618854
  619352
  619358
  620011
  623021
  626969
  631920
  640469
  653371
  654555
  654842
  656957
  666006
  682417
  704059
  720649
  722999
  723210
  724238
  732160
  736818
  739265
  739939
  743105
  754634
  755617
  762050
  763544
  765961
  766481
  769318
  778381
  782520
  787189
  789287
  790401
  790420
  803155
  804908
  809938
  811150
  813470
  825540
  828557
  828673
]
6 2.01 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск татуированные"
]
7 1.50 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск татуированные"
]
8 70.20 ms
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
]

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.