Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.00 ms
(88.20%)
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
  235834
  382456
  391302
  391949
  392729
  397329
  411715
  417461
  424023
  428475
  443178
  443370
  449125
  453624
  462506
  462690
  463771
  464283
  464303
  466187
  467767
  473252
  474842
  477409
  477958
  480957
  491200
  504764
  506445
  507772
  509077
  511889
  512044
  515201
  515203
  523680
  526390
  527116
  530578
  534126
  541250
  542942
  543694
  551157
  552534
  562114
  568440
  580276
  583210
  584666
  586789
  591418
  595654
  598696
  605841
  606258
  609712
  615622
  617603
  622509
  624508
  628811
  645965
  648729
  672744
  673260
  675424
  684096
  686082
  692337
  693341
  694154
  701508
  702320
  707881
  710001
  726556
  732775
  733295
  736866
  740489
  743009
  744711
  747954
  750205
  750782
  753548
  753677
  757278
  758723
  761592
  761862
  762559
  766687
  770444
  775284
  775630
  786715
  787950
  788948
  789837
  789870
  790101
  794974
  800275
  800305
  800377
  801305
  803144
  803244
  803261
  807663
  811866
  813660
  816764
  817482
  821870
  825260
  825694
  827328
]
13.91 ms
(6.42%)
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
  541250
  391949
  480957
  462690
  534126
  598696
  512044
  392729
  701508
  684096
  686082
  586789
  811866
  428475
  761592
  543694
  788948
  726556
  750205
  515203
  491200
  515201
  443370
  817482
  821870
  825694
  827328
  816764
  463771
  474842
  464283
  467767
  507772
  509077
  523680
  542942
  562114
  568440
  583210
  584666
  552534
  693341
  707881
  675424
  710001
  617603
  606258
  609712
  624508
  595654
  775630
  789870
  794974
  786715
  790101
  801305
  803144
  803261
  770444
  787950
  800305
  800377
  736866
  740489
  750782
  732775
  743009
  753548
  761862
  762559
  753677
  744711
  747954
  702320
  775284
  800275
  803244
  807663
  424023
  466187
  477409
  477958
  462506
  235834
  473252
  443178
  453624
  758723
  417461
  530578
  526390
  506445
  825260
  551157
  628811
  382456
  673260
  391302
  813660
  645965
  789837
  648729
  766687
  504764
  511889
  580276
  672744
  692337
  605841
  615622
  622509
  591418
  733295
  757278
  449125
  464303
  411715
  397329
  527116
  694154
]
4.02 ms
(1.85%)
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
  235834
  382456
  391302
  391949
  392729
  397329
  411715
  417461
  424023
  428475
  443178
  443370
  449125
  453624
  462506
  462690
  463771
  464283
  464303
  466187
  467767
  473252
  474842
  477409
  477958
  480957
  491200
  504764
  506445
  507772
  509077
  511889
  512044
  515201
  515203
  523680
  526390
  527116
  530578
  534126
  541250
  542942
  543694
  551157
  552534
  562114
  568440
  580276
  583210
  584666
  586789
  591418
  595654
  598696
  605841
  606258
  609712
  615622
  617603
  622509
  624508
  628811
  645965
  648729
  672744
  673260
  675424
  684096
  686082
  692337
  693341
  694154
  701508
  702320
  707881
  710001
  726556
  732775
  733295
  736866
  740489
  743009
  744711
  747954
  750205
  750782
  753548
  753677
  757278
  758723
  761592
  761862
  762559
  766687
  770444
  775284
  775630
  786715
  787950
  788948
  789837
  789870
  790101
  794974
  800275
  800305
  800377
  801305
  803144
  803244
  803261
  807663
  811866
  813660
  816764
  817482
  821870
  825260
  825694
  827328
]
2.16 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young old homemade"
]
2.09 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young old домашн любительск"
]
1.80 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young old домашн любительск"
]
1.57 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.