Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.02 ms
(83.18%)
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
  4290
  58313
  70601
  111786
  147369
  250422
  381850
  383436
  384457
  385243
  391216
  419309
  419316
  423483
  424672
  425654
  429815
  430661
  431528
  433198
  433574
  433696
  434933
  441314
  455974
  458784
  463479
  463561
  467590
  467668
  479952
  481567
  483359
  485507
  486480
  488426
  489785
  499694
  500018
  501005
  503741
  504000
  509772
  512390
  513620
  514011
  518795
  524984
  530167
  530176
  537178
  540694
  544064
  549218
  550472
  552149
  552732
  553025
  553616
  557311
  558696
  559365
  568722
  574470
  578847
  585531
  590465
  591232
  600499
  601384
  620023
  626636
  626645
  654222
  654282
  661064
  664564
  674272
  691535
  716235
  716268
  719967
  730654
  736437
  737995
  744791
  746854
  755918
  758064
  763918
  764429
  766064
  767892
  768447
  768452
  768459
  768809
  769178
  769186
  769203
  779694
  786474
  787152
  787994
  791255
  792301
  792968
  792976
  793292
  795765
  796322
  797361
  799713
  800250
  800741
  808082
  811820
  813636
  821793
]
14.67 ms
(9.92%)
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
  500018
  768452
  568722
  766064
  768459
  434933
  795765
  558696
  488426
  793292
  791255
  540694
  385243
  499694
  768809
  524984
  787994
  797361
  250422
  600499
  796322
  467668
  463561
  504000
  147369
  744791
  716268
  746854
  767890
  737995
  552732
  792968
  384457
  383436
  425654
  821793
  800741
  767892
  719967
  530167
  574470
  716235
  58313
  458784
  479952
  501005
  514011
  691535
  590465
  769203
  763918
  764429
  800250
  786474
  381850
  391216
  559365
  509772
  518795
  503741
  485507
  111786
  537178
  730654
  779694
  419316
  419309
  4290
  626645
  481567
  486480
  585531
  792301
  467590
  544064
  553616
  424672
  513620
  429815
  736437
  455974
  483359
  489785
  620023
  811820
  755918
  813636
  530176
  552149
  557311
  654222
  654282
  661064
  664564
  674272
  549218
  591232
  626636
  792976
  758064
  769186
  799713
  808082
  769178
  768447
  431528
  70601
  423483
  430661
  512390
  441314
  550472
  578847
  601384
  433198
  433696
  433574
  463479
  787152
  553025
]
3.15 ms
(2.13%)
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
  4290
  58313
  70601
  111786
  147369
  250422
  381850
  383436
  384457
  385243
  391216
  419309
  419316
  423483
  424672
  425654
  429815
  430661
  431528
  433198
  433574
  433696
  434933
  441314
  455974
  458784
  463479
  463561
  467590
  467668
  479952
  481567
  483359
  485507
  486480
  488426
  489785
  499694
  500018
  501005
  503741
  504000
  509772
  512390
  513620
  514011
  518795
  524984
  530167
  530176
  537178
  540694
  544064
  549218
  550472
  552149
  552732
  553025
  553616
  557311
  558696
  559365
  568722
  574470
  578847
  585531
  590465
  591232
  600499
  601384
  620023
  626636
  626645
  654222
  654282
  661064
  664564
  674272
  691535
  716235
  716268
  719967
  730654
  736437
  737995
  744791
  746854
  755918
  758064
  763918
  764429
  766064
  767892
  768447
  768452
  768459
  768809
  769178
  769186
  769203
  779694
  786474
  787152
  787994
  791255
  792301
  792968
  792976
  793292
  795765
  796322
  797361
  799713
  800250
  800741
  808082
  811820
  813636
  821793
]
1.98 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жена дрочит с подружк%…"
]
1.76 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен дрочк подружк"
]
1.72 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен дрочк подружк"
]
1.59 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.