Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.01 ms
(83.82%)
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
  9732
  396794
  461755
  490638
  495117
  496347
  499514
  500413
  502799
  503747
  505311
  512408
  516553
  517170
  518455
  519807
  520241
  520573
  524352
  524828
  524889
  524909
  525080
  525733
  525787
  526758
  526848
  527286
  527867
  528566
  530193
  532200
  532409
  533229
  534000
  535713
  536015
  538767
  538963
  540396
  540436
  540753
  543227
  543732
  544407
  544552
  547433
  549504
  550929
  551662
  553881
  555559
  556180
  556790
  557020
  557582
  560275
  562758
  563551
  571003
  571131
  576446
  577179
  578023
  578780
  579518
  579550
  583741
  585193
  588416
  589657
  591785
  593561
  593923
  595047
  597637
  598662
  600518
  605667
  606165
  607996
  608542
  609294
  610485
  612168
  613907
  613994
  616429
  616503
  616508
  618942
  622562
  626002
  634660
  634956
  635342
  639164
  643098
  643832
  643835
  649263
  652132
  653051
  660346
  661060
  663389
  666721
  669895
  682409
  683595
  687155
  723656
  728597
  736454
  736705
  738321
  738445
  739085
  757589
  813033
]
20.25 ms
(10.88%)
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
  503747
  533229
  571003
  652132
  653051
  591785
  495117
  538767
  551662
  622562
  600518
  616429
  597637
  527867
  534000
  616503
  532200
  461755
  661060
  555559
  643098
  518455
  643835
  723656
  543732
  544407
  579550
  738321
  757589
  524828
  538963
  520573
  526848
  536015
  540753
  609294
  736705
  738445
  736454
  562758
  9732
  544552
  687155
  649263
  579518
  616508
  543227
  547433
  553881
  813033
  682409
  556790
  639164
  728597
  549504
  606165
  500413
  557582
  525080
  528566
  635342
  643832
  585193
  608542
  613907
  524909
  634660
  396794
  524889
  519807
  526758
  512408
  663389
  589657
  605667
  613994
  739085
  490638
  525787
  527286
  516553
  540436
  517170
  550929
  556180
  607996
  560275
  576446
  577179
  660346
  666721
  610485
  593923
  535713
  683595
  669895
  598662
  612168
  505311
  557020
  634956
  499514
  524352
  540396
  502799
  530193
  532409
  563551
  578780
  593561
  496347
  618942
  525733
  520241
  578023
  583741
  588416
  595047
  626002
  571131
]
2.68 ms
(1.44%)
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
  9732
  396794
  461755
  490638
  495117
  496347
  499514
  500413
  502799
  503747
  505311
  512408
  516553
  517170
  518455
  519807
  520241
  520573
  524352
  524828
  524889
  524909
  525080
  525733
  525787
  526758
  526848
  527286
  527867
  528566
  530193
  532200
  532409
  533229
  534000
  535713
  536015
  538767
  538963
  540396
  540436
  540753
  543227
  543732
  544407
  544552
  547433
  549504
  550929
  551662
  553881
  555559
  556180
  556790
  557020
  557582
  560275
  562758
  563551
  571003
  571131
  576446
  577179
  578023
  578780
  579518
  579550
  583741
  585193
  588416
  589657
  591785
  593561
  593923
  595047
  597637
  598662
  600518
  605667
  606165
  607996
  608542
  609294
  610485
  612168
  613907
  613994
  616429
  616503
  616508
  618942
  622562
  626002
  634660
  634956
  635342
  639164
  643098
  643832
  643835
  649263
  652132
  653051
  660346
  661060
  663389
  666721
  669895
  682409
  683595
  687155
  723656
  728597
  736454
  736705
  738321
  738445
  739085
  757589
  813033
]
2.12 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пизда с большими яйца%…"
]
1.79 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин большие яйц"
]
1.47 ms
(0.79%)
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.