Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.58 ms
(82.44%)
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
  14328
  14389
  28591
  29242
  31028
  31305
  33082
  33602
  34170
  44177
  56810
  57344
  59007
  71071
  72766
  81100
  86313
  97276
  102043
  111630
  117883
  135519
  145053
  146216
  153376
  156487
  156877
  170942
  181438
  186988
  191069
  191336
  191509
  205205
  213662
  214719
  222222
  229555
  239112
  239542
  289441
  308832
  311005
  327338
  361382
  382302
  382357
  382489
  382556
  382611
  382934
  383149
  383437
  383658
  384543
  384545
  384762
  384923
  385104
  385373
  385484
  385851
  386630
  386778
  387176
  387424
  387919
  388195
  389978
  390229
  390318
  390483
  390809
  393267
  393694
  395542
  395554
  395656
  396111
  396292
  396543
  396859
  397307
  399364
  399757
  401395
  401798
  404359
  408493
  412858
  416402
  416820
  421417
  429841
  451538
  454797
  465612
  472606
  477528
  499908
  532439
  539102
  539104
  540501
  546403
  560090
  579089
  581845
  591699
  591708
  603174
  603879
  604525
  710889
  723708
  790824
  812595
  827892
  828845
]
16.41 ms
(10.95%)
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
  34170
  222222
  191069
  451538
  385373
  153376
  395656
  389978
  390809
  416402
  382357
  393694
  383437
  135519
  229555
  156877
  382611
  388195
  390229
  401798
  454797
  539104
  532439
  581845
  591708
  181438
  156487
  28591
  386630
  308832
  384545
  393267
  311005
  33602
  827892
  579089
  604525
  59007
  117883
  97276
  384762
  146216
  31028
  539102
  812595
  56810
  384923
  111630
  385104
  327338
  289441
  382556
  57344
  14389
  81100
  408493
  429841
  828845
  465612
  591699
  603174
  603879
  723708
  771522
  14328
  396543
  412858
  477528
  416820
  385851
  102043
  239542
  71071
  382934
  386778
  72766
  31305
  44177
  396292
  421417
  710889
  546403
  790824
  33082
  390318
  86313
  191509
  205205
  383149
  383658
  401395
  404359
  213662
  214719
  239112
  390483
  395554
  382489
  382302
  396111
  540501
  387176
  399364
  387424
  395542
  499908
  186988
  191336
  145053
  170942
  361382
  29242
  387919
  399757
  472606
  560090
  396859
  384543
  385484
  397307
]
2.60 ms
(1.74%)
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
  14328
  14389
  28591
  29242
  31028
  31305
  33082
  33602
  34170
  44177
  56810
  57344
  59007
  71071
  72766
  81100
  86313
  97276
  102043
  111630
  117883
  135519
  145053
  146216
  153376
  156487
  156877
  170942
  181438
  186988
  191069
  191336
  191509
  205205
  213662
  214719
  222222
  229555
  239112
  239542
  289441
  308832
  311005
  327338
  361382
  382302
  382357
  382489
  382556
  382611
  382934
  383149
  383437
  383658
  384543
  384545
  384762
  384923
  385104
  385373
  385484
  385851
  386630
  386778
  387176
  387424
  387919
  388195
  389978
  390229
  390318
  390483
  390809
  393267
  393694
  395542
  395554
  395656
  396111
  396292
  396543
  396859
  397307
  399364
  399757
  401395
  401798
  404359
  408493
  412858
  416402
  416820
  421417
  429841
  451538
  454797
  465612
  472606
  477528
  499908
  532439
  539102
  539104
  540501
  546403
  560090
  579089
  581845
  591699
  591708
  603174
  603879
  604525
  710889
  723708
  790824
  812595
  827892
  828845
]
2.08 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big muscle"
]
1.86 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие мускулистые"
]
1.70 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.11%)
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.