Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.10 ms
(85.39%)
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
  427488
  443359
  517758
  533193
  546434
  576992
  589191
  589633
  610779
  616464
  618363
  626948
  631024
  641870
  680342
  680346
  718641
  725020
  725082
  725430
  726925
  726978
  726989
  727569
  727578
  728779
  728907
  729157
  730128
  730482
  731088
  733176
  734300
  734604
  734706
  734851
  735900
  736419
  736726
  738322
  738332
  738356
  738803
  739521
  742567
  742592
  743356
  743921
  745227
  748063
  751269
  753057
  753216
  755172
  757038
  757925
  757995
  759088
  759171
  760787
  760888
  761023
  761679
  761983
  762443
  764850
  765692
  766110
  767555
  768110
  768203
  768628
  769068
  769196
  769314
  770079
  770153
  770564
  771187
  771229
  771923
  771941
  773682
  773927
  775168
  775618
  776028
  776040
  776228
  778457
  779241
  779730
  781366
  781758
  782168
  783572
  785900
  786156
  786747
  786816
  787111
  787458
  787769
  788621
  791825
  791827
  792348
  792659
  792668
  793939
  797057
  797472
  799894
  800798
  802386
  802619
  810083
]
11.60 ms
(7.67%)
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
  576992
  589633
  589191
  631024
  775168
  775618
  776228
  778457
  779241
  779730
  781758
  792348
  797057
  799894
  800798
  776028
  781366
  782168
  783572
  787458
  792659
  793939
  802619
  730482
  731088
  734300
  736419
  743921
  751269
  753216
  760787
  760888
  764850
  769068
  769196
  770153
  770564
  771941
  773927
  786816
  788621
  792668
  797472
  810083
  725020
  725082
  734706
  748063
  757995
  759171
  761679
  767555
  768628
  771229
  771923
  725430
  726925
  726978
  729157
  730128
  734851
  736726
  738332
  738803
  745227
  753057
  759088
  761023
  764896
  766110
  768110
  769314
  770079
  771187
  735900
  738322
  739521
  755172
  762443
  726989
  727569
  727578
  728907
  734604
  738356
  742567
  742592
  743356
  757038
  761983
  765692
  765782
  768203
  773682
  626948
  718641
  776040
  785900
  786156
  786747
  787111
  787389
  787769
  791825
  791827
  802386
  427488
  443359
  641870
  616464
  533193
  680346
  610779
  618363
  733176
  757925
  728779
  517758
  546434
  680342
]
3.91 ms
(2.59%)
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
  427488
  443359
  517758
  533193
  546434
  576992
  589191
  589633
  610779
  616464
  618363
  626948
  631024
  641870
  680342
  680346
  718641
  725020
  725082
  725430
  726925
  726978
  726989
  727569
  727578
  728779
  728907
  729157
  730128
  730482
  731088
  733176
  734300
  734604
  734706
  734851
  735900
  736419
  736726
  738322
  738332
  738356
  738803
  739521
  742567
  742592
  743356
  743921
  745227
  748063
  751269
  753057
  753216
  755172
  757038
  757925
  757995
  759088
  759171
  760787
  760888
  761023
  761679
  761983
  762443
  764850
  765692
  766110
  767555
  768110
  768203
  768628
  769068
  769196
  769314
  770079
  770153
  770564
  771187
  771229
  771923
  771941
  773682
  773927
  775168
  775618
  776028
  776040
  776228
  778457
  779241
  779730
  781366
  781758
  782168
  783572
  785900
  786156
  786747
  786816
  787111
  787458
  787769
  788621
  791825
  791827
  792348
  792659
  792668
  793939
  797057
  797472
  799894
  800798
  802386
  802619
  810083
]
1.97 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "home made creampie"
]
1.63 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск creampie"
]
1.37 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск creampie"
]

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.