Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.68 ms
(83.70%)
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
  384900
  395218
  402866
  402978
  417318
  420696
  420737
  420879
  421660
  424534
  424753
  438042
  438291
  443066
  444053
  445747
  445756
  446868
  455522
  455657
  456359
  460718
  463708
  465905
  472094
  474538
  476304
  479970
  481494
  483982
  484002
  487239
  487999
  488996
  490198
  490524
  491377
  491387
  495484
  498111
  498115
  502639
  502832
  504833
  510079
  510609
  510771
  511543
  513695
  518587
  518975
  520272
  523299
  523593
  525971
  527601
  532351
  533004
  534575
  535960
  537692
  539116
  540369
  542832
  543420
  546419
  550592
  551178
  553768
  554805
  555076
  561435
  563690
  565372
  565398
  573291
  575398
  577953
  579717
  579775
  580642
  580993
  581030
  584950
  587506
  593793
  598757
  599386
  606566
  611435
  620240
  620645
  625323
  635577
  638117
  640871
  641480
  643315
  647262
  648497
  654273
  660995
  662905
  682573
  705801
  712549
  720445
  724790
  734387
  744596
  756183
  761040
  775224
  780506
  783161
  783736
  796531
  803214
  805229
  810108
]
17.93 ms
(10.16%)
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
  662905
  648497
  720445
  611435
  498111
  620240
  523299
  561435
  660995
  724790
  638117
  504833
  491377
  783736
  488996
  550592
  575398
  647262
  598757
  803214
  744596
  577953
  456359
  579717
  384900
  810108
  523593
  395218
  481494
  460718
  446868
  542832
  565398
  580993
  573291
  479970
  490524
  483982
  654273
  643315
  417318
  796531
  402866
  553768
  599386
  780506
  705801
  775224
  424534
  682573
  555076
  563690
  620645
  402978
  584950
  510079
  424753
  537692
  540369
  579775
  641480
  756183
  761040
  734387
  476304
  445747
  805229
  534575
  587506
  420696
  443066
  502832
  484002
  625323
  438042
  420737
  455522
  593793
  421660
  444053
  487999
  532351
  487239
  539116
  495484
  783161
  472094
  510771
  498115
  527601
  420879
  520272
  465905
  455657
  518587
  525971
  533004
  474538
  581030
  712549
  606566
  445756
  463708
  491387
  513695
  554805
  518975
  551178
  438291
  510609
  546419
  543420
  565372
  490198
  640871
  535960
  511543
  580642
  635577
  502639
]
3.42 ms
(1.94%)
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
  384900
  395218
  402866
  402978
  417318
  420696
  420737
  420879
  421660
  424534
  424753
  438042
  438291
  443066
  444053
  445747
  445756
  446868
  455522
  455657
  456359
  460718
  463708
  465905
  472094
  474538
  476304
  479970
  481494
  483982
  484002
  487239
  487999
  488996
  490198
  490524
  491377
  491387
  495484
  498111
  498115
  502639
  502832
  504833
  510079
  510609
  510771
  511543
  513695
  518587
  518975
  520272
  523299
  523593
  525971
  527601
  532351
  533004
  534575
  535960
  537692
  539116
  540369
  542832
  543420
  546419
  550592
  551178
  553768
  554805
  555076
  561435
  563690
  565372
  565398
  573291
  575398
  577953
  579717
  579775
  580642
  580993
  581030
  584950
  587506
  593793
  598757
  599386
  606566
  611435
  620240
  620645
  625323
  635577
  638117
  640871
  641480
  643315
  647262
  648497
  654273
  660995
  662905
  682573
  705801
  712549
  720445
  724790
  734387
  744596
  756183
  761040
  775224
  780506
  783161
  783736
  796531
  803214
  805229
  810108
]
2.05 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sucking public"
]
1.87 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sucking на улиц"
]
1.63 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sucking на улиц"
]

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.