Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.90 ms
(81.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
  384801
  390379
  395573
  397372
  457081
  464659
  469585
  469586
  473506
  480777
  484785
  489472
  489483
  489489
  495267
  499800
  500331
  501329
  502515
  504417
  505826
  512048
  513307
  513313
  513346
  514071
  518181
  520898
  522789
  525756
  529175
  529194
  529198
  530492
  531229
  531505
  534166
  535048
  536347
  536785
  542205
  543448
  544812
  553359
  558250
  559087
  560668
  562841
  563797
  563803
  564764
  564776
  570398
  575729
  575788
  576352
  577321
  577391
  583952
  589600
  593465
  597197
  597257
  598612
  599724
  602606
  604995
  605399
  607713
  610586
  610600
  614739
  620040
  622402
  628294
  631249
  632148
  633689
  641377
  642359
  644380
  646451
  646782
  650161
  650188
  654201
  671128
  674415
  676162
  677279
  678970
  682562
  683262
  684913
  702622
  719333
  724252
  726658
  731707
  733870
  755208
  755350
  759563
  761574
  771789
  772573
  778061
  781718
  789677
  790034
  792617
  792652
  793757
  798679
  802119
  804773
  804776
  805383
  812909
  814939
]
19.46 ms
(11.38%)
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
  726658
  731707
  755208
  755350
  771789
  632148
  633689
  802119
  390379
  457081
  489483
  502515
  522789
  529194
  464659
  518181
  531229
  536347
  495267
  520898
  536785
  553359
  575788
  577321
  560668
  570398
  577391
  563803
  646782
  682562
  559087
  576352
  597257
  598612
  593465
  599724
  644380
  790034
  781718
  798679
  805383
  724252
  759563
  761574
  812909
  772573
  604995
  610600
  792652
  489472
  513307
  395573
  397372
  814939
  480777
  469586
  499800
  505826
  531505
  534166
  525756
  500331
  564764
  575729
  543448
  563797
  564776
  583952
  650161
  678970
  654201
  683262
  684913
  589600
  620040
  642359
  607713
  614739
  605399
  778061
  789677
  804773
  793757
  641377
  702622
  792617
  804776
  384801
  469585
  473506
  489489
  513346
  513313
  535048
  504417
  530492
  512048
  514071
  529175
  558250
  562841
  544812
  671128
  677279
  676162
  646451
  631249
  628294
  597197
  602606
  610586
  484785
  501329
  529198
  542205
  650188
  674415
  719333
  622402
  733870
]
4.07 ms
(2.38%)
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
  384801
  390379
  395573
  397372
  457081
  464659
  469585
  469586
  473506
  480777
  484785
  489472
  489483
  489489
  495267
  499800
  500331
  501329
  502515
  504417
  505826
  512048
  513307
  513313
  513346
  514071
  518181
  520898
  522789
  525756
  529175
  529194
  529198
  530492
  531229
  531505
  534166
  535048
  536347
  536785
  542205
  543448
  544812
  553359
  558250
  559087
  560668
  562841
  563797
  563803
  564764
  564776
  570398
  575729
  575788
  576352
  577321
  577391
  583952
  589600
  593465
  597197
  597257
  598612
  599724
  602606
  604995
  605399
  607713
  610586
  610600
  614739
  620040
  622402
  628294
  631249
  632148
  633689
  641377
  642359
  644380
  646451
  646782
  650161
  650188
  654201
  671128
  674415
  676162
  677279
  678970
  682562
  683262
  684913
  702622
  719333
  724252
  726658
  731707
  733870
  755208
  755350
  759563
  761574
  771789
  772573
  778061
  781718
  789677
  790034
  792617
  792652
  793757
  798679
  802119
  804773
  804776
  805383
  812909
  814939
]
2.30 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "самим фоксом"
]
1.89 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фокс"
]
1.75 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фокс"
]
1.59 ms
(0.93%)
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.