Query Metrics

7 Database Queries
7 Different statements
167.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
146.60 ms
(87.32%)
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
  382227
  390892
  401584
  430558
  437233
  437842
  437994
  438004
  438017
  438044
  438209
  447734
  458156
  459913
  460425
  462544
  470164
  474263
  478347
  479576
  483312
  494102
  494796
  495446
  498900
  506319
  508238
  512276
  516378
  519556
  521860
  522253
  551077
  558336
  563204
  563626
  567370
  570352
  570506
  574918
  596592
  608519
  614755
  615057
  616772
  616808
  626862
  631193
  631296
  632695
  655683
  656363
  658015
  658035
  658094
  662474
  678572
  679062
  684410
  686271
  689857
  691479
  710116
  718545
  723116
  731036
  734986
  736352
  737049
  738207
  742239
  745513
  746172
  757012
  757813
  757816
  764667
  765729
  765947
  766534
  767401
  767443
  768736
  770505
  777171
  778281
  781181
  781748
  782497
  786225
  786339
  786587
  788029
  788076
  792512
  793910
  793977
  794052
  794901
  795614
  797891
  798914
  803435
  805001
  805334
  809350
  809957
  810326
  811137
  811199
  811965
  813329
  813702
  816637
  816744
  818240
  825604
  825708
  825710
  825807
]
11.86 ms
(7.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
  519556
  460425
  462544
  825708
  813702
  825604
  825807
  521860
  656363
  689857
  655683
  662474
  781748
  794901
  805334
  778281
  803435
  737049
  810326
  745513
  738207
  768736
  746172
  723116
  793977
  809350
  811965
  506319
  401584
  437994
  632695
  631193
  596592
  437233
  459913
  563626
  563204
  430558
  498900
  512276
  816637
  818240
  816744
  825710
  474263
  483312
  522253
  508238
  567370
  658094
  678572
  679062
  684410
  616772
  781181
  786225
  788029
  811137
  811199
  786339
  793910
  797891
  805001
  766534
  786587
  788076
  757816
  757813
  767401
  767443
  757012
  764667
  615057
  792512
  813329
  558336
  616808
  390892
  438044
  494796
  478347
  570506
  570352
  574918
  438209
  458156
  382227
  438004
  437842
  470164
  516378
  495446
  438017
  479576
  551077
  658015
  658035
  686271
  691479
  710116
  626862
  631296
  608519
  614755
  782497
  795614
  798914
  731036
  736352
  770505
  794052
  742239
  734986
  765729
  765947
  718545
  777171
  809957
  447734
  494102
]
2.44 ms
(1.45%)
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
  382227
  390892
  401584
  430558
  437233
  437842
  437994
  438004
  438017
  438044
  438209
  447734
  458156
  459913
  460425
  462544
  470164
  474263
  478347
  479576
  483312
  494102
  494796
  495446
  498900
  506319
  508238
  512276
  516378
  519556
  521860
  522253
  551077
  558336
  563204
  563626
  567370
  570352
  570506
  574918
  596592
  608519
  614755
  615057
  616772
  616808
  626862
  631193
  631296
  632695
  655683
  656363
  658015
  658035
  658094
  662474
  678572
  679062
  684410
  686271
  689857
  691479
  710116
  718545
  723116
  731036
  734986
  736352
  737049
  738207
  742239
  745513
  746172
  757012
  757813
  757816
  764667
  765729
  765947
  766534
  767401
  767443
  768736
  770505
  777171
  778281
  781181
  781748
  782497
  786225
  786339
  786587
  788029
  788076
  792512
  793910
  793977
  794052
  794901
  795614
  797891
  798914
  803435
  805001
  805334
  809350
  809957
  810326
  811137
  811199
  811965
  813329
  813702
  816637
  816744
  818240
  825604
  825708
  825710
  825807
]
1.97 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "love russian"
]
1.91 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "love русск"
]
1.44 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "love русск"
]

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.