Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.44 ms
(55.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая красивая"
]
141.55 ms
(37.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
  7950
  29295
  38135
  38637
  83894
  192551
  239808
  260350
  308684
  382827
  383542
  385125
  386793
  390346
  391206
  392458
  396605
  398710
  401476
  404740
  405854
  406928
  409173
  415419
  415658
  417880
  419346
  419832
  424284
  425033
  428003
  431302
  445067
  445551
  446484
  447879
  449135
  450070
  451573
  451578
  452825
  453668
  454721
  454996
  457748
  459607
  459831
  462742
  468818
  470193
  474101
  474289
  477496
  479762
  483681
  488293
  495588
  497071
  497311
  499125
  499709
  504345
  511910
  514730
  520803
  521306
  521934
  525842
  535648
  545456
  551212
  558948
  562126
  562702
  564417
  573051
  580702
  587864
  589830
  590511
  591530
  594830
  597590
  600314
  605515
  605845
  607091
  609835
  617759
  618889
  642295
  642662
  652596
  653239
  684574
  693184
  693209
  693536
  712882
  713014
  714449
  722670
  736394
  741074
  747147
  750004
  754786
  760480
  766777
  768587
  771320
  775078
  776191
  779711
  781630
  793244
  797235
  805278
  805472
  809463
]
16.01 ms
(4.21%)
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
  779711
  415419
  425033
  642295
  693184
  652596
  741074
  747147
  451573
  474289
  488293
  446484
  590511
  457748
  521306
  562126
  684574
  722670
  600314
  736394
  605515
  450070
  431302
  545456
  617759
  766777
  573051
  396605
  642662
  445067
  504345
  445551
  514730
  562702
  520803
  597590
  468818
  497071
  525842
  392458
  453668
  470193
  809463
  462742
  564417
  580702
  459607
  452825
  495588
  454721
  551212
  419832
  499709
  447879
  449135
  459831
  607091
  417880
  714449
  428003
  511910
  415658
  499125
  451578
  454996
  477496
  404740
  479762
  497311
  605845
  594830
  587864
  618889
  406928
  38637
  383542
  308684
  260350
  385125
  38135
  483681
  713014
  398710
  589830
  793244
  805472
  750004
  29295
  653239
  591530
  405854
  419346
  83894
  535648
  775078
  401476
  391206
  239808
  521934
  693209
  805278
  781630
  776191
  754786
  797235
  386793
  474101
  424284
  609835
  7950
  382827
  760480
  712882
  409173
  693536
  771320
  390346
  192551
  558948
  768587
]
4.15 ms
(1.09%)
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
  7950
  29295
  38135
  38637
  83894
  192551
  239808
  260350
  308684
  382827
  383542
  385125
  386793
  390346
  391206
  392458
  396605
  398710
  401476
  404740
  405854
  406928
  409173
  415419
  415658
  417880
  419346
  419832
  424284
  425033
  428003
  431302
  445067
  445551
  446484
  447879
  449135
  450070
  451573
  451578
  452825
  453668
  454721
  454996
  457748
  459607
  459831
  462742
  468818
  470193
  474101
  474289
  477496
  479762
  483681
  488293
  495588
  497071
  497311
  499125
  499709
  504345
  511910
  514730
  520803
  521306
  521934
  525842
  535648
  545456
  551212
  558948
  562126
  562702
  564417
  573051
  580702
  587864
  589830
  590511
  591530
  594830
  597590
  600314
  605515
  605845
  607091
  609835
  617759
  618889
  642295
  642662
  652596
  653239
  684574
  693184
  693209
  693536
  712882
  713014
  714449
  722670
  736394
  741074
  747147
  750004
  754786
  760480
  766777
  768587
  771320
  775078
  776191
  779711
  781630
  793244
  797235
  805278
  805472
  809463
]
2.44 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde beautiful"
]
2.12 ms
(0.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.03 ms
(0.53%)
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.