Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.86 ms
(85.91%)
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
  400362
  402980
  403291
  405802
  410235
  433751
  441336
  445671
  446218
  448886
  449279
  454472
  454491
  458647
  465223
  473827
  481755
  487216
  494553
  498604
  498872
  499719
  500743
  502752
  514972
  525561
  526590
  527461
  530298
  539961
  547741
  555631
  569476
  571753
  580218
  582678
  584576
  584609
  585842
  588072
  589931
  589945
  589953
  589958
  589986
  590100
  591157
  598315
  598382
  602080
  602626
  621092
  623755
  624145
  629117
  632140
  634309
  635572
  636066
  643541
  645528
  662499
  673868
  675310
  675355
  680753
  682741
  690961
  693679
  705136
  708194
  708643
  709037
  709065
  709179
  709182
  712744
  718803
  729660
  741545
  744697
  745469
  762451
  765413
  766572
  776266
  776289
  782756
  783896
  786856
  788388
  790171
  791637
  794279
  795248
  795697
  796086
  797906
  799382
  800496
  801626
  806865
  807364
  808514
  809011
  809264
  809370
  809638
  811442
  811820
  812296
  812587
  813116
  813467
  817978
  824647
  827701
  827825
]
11.30 ms
(7.78%)
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
  673868
  634309
  708643
  824647
  827701
  445671
  454491
  458647
  526590
  539961
  487216
  708194
  712744
  693679
  589953
  598382
  621092
  776289
  781127
  799382
  800496
  813116
  782756
  791637
  795248
  795697
  796086
  797906
  801626
  808514
  812296
  723709
  786856
  790171
  809011
  809264
  809370
  811442
  811820
  812587
  729660
  766572
  765413
  762451
  629117
  718803
  783896
  788388
  806865
  807364
  809638
  433751
  446218
  448886
  473827
  514972
  827825
  481755
  498872
  499719
  530298
  571753
  584609
  580218
  662499
  675355
  680753
  690961
  709065
  675310
  705136
  709037
  709179
  682741
  588072
  589945
  589958
  589986
  623755
  643541
  602626
  624145
  632140
  589931
  591157
  636066
  794279
  745469
  602080
  635572
  502752
  498604
  403291
  547741
  741545
  402980
  449279
  527461
  494553
  500743
  582678
  645528
  709182
  555631
  584576
  585842
  598315
  590100
  776266
  813467
  525561
  744697
  569476
  400362
  405802
  441336
  410235
  817978
  454472
  465223
]
2.46 ms
(1.69%)
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
  400362
  402980
  403291
  405802
  410235
  433751
  441336
  445671
  446218
  448886
  449279
  454472
  454491
  458647
  465223
  473827
  481755
  487216
  494553
  498604
  498872
  499719
  500743
  502752
  514972
  525561
  526590
  527461
  530298
  539961
  547741
  555631
  569476
  571753
  580218
  582678
  584576
  584609
  585842
  588072
  589931
  589945
  589953
  589958
  589986
  590100
  591157
  598315
  598382
  602080
  602626
  621092
  623755
  624145
  629117
  632140
  634309
  635572
  636066
  643541
  645528
  662499
  673868
  675310
  675355
  680753
  682741
  690961
  693679
  705136
  708194
  708643
  709037
  709065
  709179
  709182
  712744
  718803
  729660
  741545
  744697
  745469
  762451
  765413
  766572
  776266
  776289
  782756
  783896
  786856
  788388
  790171
  791637
  794279
  795248
  795697
  796086
  797906
  799382
  800496
  801626
  806865
  807364
  808514
  809011
  809264
  809370
  809638
  811442
  811820
  812296
  812587
  813116
  813467
  817978
  824647
  827701
  827825
]
2.13 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade perfect"
]
1.63 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск perfect"
]
1.54 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск perfect"
]

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.