Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.82 ms
(58.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "молодые 18 19 старый лет"
]
122.35 ms
(33.71%)
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
  7088
  34884
  60096
  392206
  393046
  396811
  400438
  402036
  418484
  429292
  429949
  465823
  470733
  474767
  500453
  524016
  527864
  535972
  541350
  544873
  545547
  546992
  550447
  552232
  554236
  556285
  569365
  573842
  574289
  574808
  575636
  577905
  577989
  578709
  585822
  590328
  593919
  594286
  595538
  614665
  618144
  622303
  629497
  629727
  630478
  643879
  644686
  645728
  652424
  656779
  657158
  668189
  670762
  676499
  676524
  676532
  676929
  677026
  677750
  693506
  709459
  715247
  720104
  721225
  721756
  723010
  728759
  729705
  730432
  730676
  732401
  735092
  735743
  737763
  740281
  741320
  742075
  744314
  744320
  744882
  746932
  748649
  755130
  755553
  755853
  756488
  760288
  761861
  762015
  764406
  766517
  773029
  773277
  774811
  777474
  778266
  778510
  778518
  779926
  780808
  782440
  785171
  785242
  787941
  789003
  789845
  791325
  791748
  794079
  795611
  796230
  797473
  797573
  802522
  804197
  804853
  807924
  812478
]
19.27 ms
(5.31%)
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
  550447
  60096
  527864
  535972
  544873
  554236
  575636
  577905
  552232
  556285
  541350
  569365
  676929
  723010
  645728
  657158
  670762
  676524
  693506
  709459
  720104
  652424
  676499
  676532
  677026
  677750
  721225
  545547
  574289
  577989
  585822
  590328
  593919
  630478
  594286
  622303
  629727
  595538
  614665
  618144
  774811
  777474
  778510
  778518
  779926
  785171
  791325
  794079
  797573
  782440
  787941
  802522
  807924
  729705
  730676
  742075
  744882
  766517
  791748
  797473
  732401
  735743
  740281
  755853
  761861
  762015
  773277
  735092
  737763
  748649
  755553
  760288
  764406
  773029
  728759
  730432
  741320
  746932
  755130
  756488
  643879
  706529
  721756
  780808
  785242
  789003
  795611
  804197
  804853
  812478
  7088
  392206
  761775
  629497
  744320
  400438
  418484
  474767
  578709
  465823
  470733
  524016
  574808
  644686
  656779
  429292
  500453
  668189
  744314
  396811
  429949
  715247
  573842
  789845
  778266
  796230
  393046
  546992
  402036
  34884
]
3.02 ms
(0.83%)
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
  7088
  34884
  60096
  392206
  393046
  396811
  400438
  402036
  418484
  429292
  429949
  465823
  470733
  474767
  500453
  524016
  527864
  535972
  541350
  544873
  545547
  546992
  550447
  552232
  554236
  556285
  569365
  573842
  574289
  574808
  575636
  577905
  577989
  578709
  585822
  590328
  593919
  594286
  595538
  614665
  618144
  622303
  629497
  629727
  630478
  643879
  644686
  645728
  652424
  656779
  657158
  668189
  670762
  676499
  676524
  676532
  676929
  677026
  677750
  693506
  709459
  715247
  720104
  721225
  721756
  723010
  728759
  729705
  730432
  730676
  732401
  735092
  735743
  737763
  740281
  741320
  742075
  744314
  744320
  744882
  746932
  748649
  755130
  755553
  755853
  756488
  760288
  761861
  762015
  764406
  766517
  773029
  773277
  774811
  777474
  778266
  778510
  778518
  779926
  780808
  782440
  785171
  785242
  787941
  789003
  789845
  791325
  791748
  794079
  795611
  796230
  797473
  797573
  802522
  804197
  804853
  807924
  812478
]
1.91 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодые 18летними с дедами"
]
1.74 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодые 18 19 старый лет"
]

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.