Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.33 ms
(80.57%)
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
  123029
  390813
  395686
  397413
  408532
  413499
  419132
  420472
  421238
  422671
  425473
  427174
  429943
  443503
  443593
  443644
  445641
  445833
  451772
  454954
  461008
  463519
  469042
  470288
  470531
  472343
  472345
  478491
  480024
  481134
  484870
  484924
  485475
  485481
  491406
  491678
  492519
  492598
  492608
  493284
  494620
  498899
  504595
  510126
  512909
  516433
  518049
  519701
  521454
  523082
  523099
  525102
  526188
  527633
  528074
  528440
  529185
  529222
  530061
  530776
  530779
  536004
  541866
  543480
  549063
  551948
  561023
  564348
  569047
  572544
  573914
  574155
  574162
  574179
  574857
  575600
  580715
  581025
  585154
  586628
  587477
  589761
  594144
  594920
  597142
  597532
  599826
  600035
  600501
  604103
  605941
  614344
  614434
  614693
  621543
  621648
  623849
  632020
  632356
  638326
  638967
  674758
  682460
  684214
  689634
  698972
  698981
  705791
  711642
  743292
  753467
  758024
  775235
  804277
  816183
  817402
  817507
  818682
  822024
  822296
]
18.96 ms
(12.59%)
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
  758024
  472343
  523099
  454954
  481134
  597532
  614434
  445833
  419132
  492598
  422671
  523082
  521454
  498899
  518049
  527633
  529222
  492519
  551948
  682460
  684214
  674758
  621648
  632356
  587477
  605941
  472345
  818682
  743292
  600035
  638967
  408532
  395686
  397413
  425473
  443593
  443644
  413499
  451772
  469042
  491406
  528440
  530779
  528074
  529185
  519701
  530776
  574162
  543480
  561023
  581025
  585154
  597142
  614693
  621543
  614344
  638326
  594144
  594920
  604103
  698981
  421238
  485475
  575600
  705791
  586628
  390813
  429943
  485481
  493284
  480024
  526188
  494620
  492608
  574179
  574155
  569047
  689634
  572544
  573914
  589761
  463519
  525102
  817402
  541866
  816183
  711642
  623849
  599826
  420472
  443503
  491678
  804277
  817507
  470288
  632020
  822024
  530061
  445641
  484924
  484870
  822296
  461008
  753467
  512909
  549063
  564348
  698972
  574857
  504595
  123029
  600501
  775235
  470531
  478491
  516433
  427174
  580715
  510126
  536004
]
2.81 ms
(1.86%)
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
  123029
  390813
  395686
  397413
  408532
  413499
  419132
  420472
  421238
  422671
  425473
  427174
  429943
  443503
  443593
  443644
  445641
  445833
  451772
  454954
  461008
  463519
  469042
  470288
  470531
  472343
  472345
  478491
  480024
  481134
  484870
  484924
  485475
  485481
  491406
  491678
  492519
  492598
  492608
  493284
  494620
  498899
  504595
  510126
  512909
  516433
  518049
  519701
  521454
  523082
  523099
  525102
  526188
  527633
  528074
  528440
  529185
  529222
  530061
  530776
  530779
  536004
  541866
  543480
  549063
  551948
  561023
  564348
  569047
  572544
  573914
  574155
  574162
  574179
  574857
  575600
  580715
  581025
  585154
  586628
  587477
  589761
  594144
  594920
  597142
  597532
  599826
  600035
  600501
  604103
  605941
  614344
  614434
  614693
  621543
  621648
  623849
  632020
  632356
  638326
  638967
  674758
  682460
  684214
  689634
  698972
  698981
  705791
  711642
  743292
  753467
  758024
  775235
  804277
  816183
  817402
  817507
  818682
  822024
  822296
]
2.28 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen-car"
]
1.90 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen вмашин"
]
1.56 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen вмашин"
]

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.