Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.48 ms
(59.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "измена замужних жен"
]
122.57 ms
(34.88%)
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
  84130
  92167
  97738
  207540
  270415
  355533
  361843
  383561
  383593
  384121
  385941
  388514
  388850
  391707
  392184
  396802
  417235
  424293
  483961
  521724
  533781
  535867
  537093
  546655
  547252
  551555
  557410
  566398
  575043
  577296
  578772
  584054
  584866
  593108
  599676
  618245
  620430
  621628
  630467
  652563
  653818
  666075
  668826
  677894
  682758
  685213
  686531
  689829
  690002
  691622
  695079
  700092
  701275
  704998
  705493
  707721
  716452
  720002
  720012
  721868
  725280
  725344
  725421
  725427
  729179
  730147
  731271
  732202
  732710
  733644
  736855
  744169
  744342
  744811
  745567
  745860
  746633
  747187
  747247
  749475
  750700
  751954
  759909
  764845
  773721
  778133
  780660
  780735
  783133
  784209
  784243
  790253
  794286
  795197
  795657
  796520
  799919
  800172
  801133
  801823
  804561
  808304
  811534
  814066
  816808
  817559
  817654
  818063
  819007
  819830
  819925
  823966
  824127
  824222
  824240
  824383
  825049
]
12.50 ms
(3.56%)
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
  578772
  716452
  620430
  97738
  599676
  383593
  207540
  424293
  814066
  483961
  533781
  537093
  521724
  535867
  584054
  575043
  584866
  557410
  566398
  577296
  652563
  668826
  682758
  686531
  690002
  705493
  720012
  653818
  685213
  695079
  701275
  704998
  720002
  666075
  677894
  689829
  691622
  546655
  547252
  551555
  618245
  621628
  593108
  778133
  780735
  796520
  800172
  801133
  801823
  804561
  808304
  811534
  795197
  725427
  732202
  744169
  747187
  749475
  773721
  783133
  784209
  790253
  794286
  725280
  725421
  732710
  744811
  750700
  764845
  729179
  733644
  745567
  745860
  747247
  730401
  746633
  751954
  725344
  730147
  731271
  736855
  744342
  759909
  630467
  700092
  707721
  721868
  780660
  784243
  795657
  799919
  385941
  383561
  384121
  391707
  392184
  355533
  361843
  270415
  84130
  92167
  388850
  388514
  396802
  417235
  816808
  817559
  817654
  818063
  819007
  819830
  819925
  823966
  824127
  824222
  824240
  824383
  824625
  824821
  825049
]
3.81 ms
(1.08%)
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
  84130
  92167
  97738
  207540
  270415
  355533
  361843
  383561
  383593
  384121
  385941
  388514
  388850
  391707
  392184
  396802
  417235
  424293
  483961
  521724
  533781
  535867
  537093
  546655
  547252
  551555
  557410
  566398
  575043
  577296
  578772
  584054
  584866
  593108
  599676
  618245
  620430
  621628
  630467
  652563
  653818
  666075
  668826
  677894
  682758
  685213
  686531
  689829
  690002
  691622
  695079
  700092
  701275
  704998
  705493
  707721
  716452
  720002
  720012
  721868
  725280
  725344
  725421
  725427
  729179
  730147
  731271
  732202
  732710
  733644
  736855
  744169
  744342
  744811
  745567
  745860
  746633
  747187
  747247
  749475
  750700
  751954
  759909
  764845
  773721
  778133
  780660
  780735
  783133
  784209
  784243
  790253
  794286
  795197
  795657
  796520
  799919
  800172
  801133
  801823
  804561
  808304
  811534
  814066
  816808
  817559
  817654
  818063
  819007
  819830
  819925
  823966
  824127
  824222
  824240
  824383
  825049
]
1.89 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен жен жен"
]
1.71 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.42%)
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.