Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.65 ms
(82.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
  14599
  329912
  384913
  385855
  386093
  391144
  396781
  404384
  405812
  415735
  415737
  417783
  421051
  423777
  425627
  426413
  428009
  433618
  433823
  443237
  444695
  445581
  446343
  447301
  457492
  463828
  463838
  465109
  466324
  467049
  469619
  478054
  480419
  493763
  496311
  496456
  499177
  518187
  518405
  529275
  530304
  531602
  535883
  540461
  554834
  556788
  560799
  565335
  571975
  574391
  575172
  579106
  582393
  582741
  584425
  585365
  587214
  588791
  595194
  599006
  600907
  604464
  604466
  605129
  606475
  606780
  621675
  622582
  634711
  635202
  640798
  641075
  643018
  645322
  645618
  652548
  663749
  669062
  671721
  673731
  675531
  675638
  680030
  680161
  695929
  704179
  713727
  714556
  714612
  718264
  720889
  720924
  722527
  722552
  724536
  732767
  733307
  741752
  744650
  751571
  757232
  757458
  758557
  767598
  774524
  777133
  784740
  787402
  788562
  788908
  792587
  794560
  804597
  807541
  807725
  808293
  808998
  820658
  822286
  822961
]
16.63 ms
(10.33%)
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
  14599
  822286
  530304
  554834
  673731
  680030
  720889
  635202
  585365
  604464
  599006
  622582
  641075
  804597
  774524
  794560
  787402
  792587
  724536
  732767
  757458
  784740
  405812
  396781
  571975
  426413
  531602
  588791
  733307
  433618
  444695
  480419
  529275
  808998
  469619
  704179
  606475
  722552
  777133
  463828
  788562
  404384
  645618
  713727
  718264
  722527
  595194
  605129
  606780
  744650
  808293
  757232
  758557
  788908
  417783
  415735
  714612
  663749
  741752
  421051
  457492
  582393
  443237
  652548
  807541
  751571
  767598
  447301
  518187
  478054
  645322
  621675
  428009
  423777
  535883
  499177
  385855
  433823
  820658
  493763
  467049
  540461
  675531
  604466
  640798
  807725
  425627
  391144
  466324
  518405
  445581
  415737
  465109
  463838
  579106
  582741
  386093
  384913
  329912
  822961
  446343
  496311
  496456
  556788
  560799
  565335
  584425
  574391
  669062
  714556
  720924
  671721
  675638
  680161
  695929
  575172
  634711
  643018
  587214
  600907
]
3.75 ms
(2.33%)
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
  14599
  329912
  384913
  385855
  386093
  391144
  396781
  404384
  405812
  415735
  415737
  417783
  421051
  423777
  425627
  426413
  428009
  433618
  433823
  443237
  444695
  445581
  446343
  447301
  457492
  463828
  463838
  465109
  466324
  467049
  469619
  478054
  480419
  493763
  496311
  496456
  499177
  518187
  518405
  529275
  530304
  531602
  535883
  540461
  554834
  556788
  560799
  565335
  571975
  574391
  575172
  579106
  582393
  582741
  584425
  585365
  587214
  588791
  595194
  599006
  600907
  604464
  604466
  605129
  606475
  606780
  621675
  622582
  634711
  635202
  640798
  641075
  643018
  645322
  645618
  652548
  663749
  669062
  671721
  673731
  675531
  675638
  680030
  680161
  695929
  704179
  713727
  714556
  714612
  718264
  720889
  720924
  722527
  722552
  724536
  732767
  733307
  741752
  744650
  751571
  757232
  757458
  758557
  767598
  774524
  777133
  784740
  787402
  788562
  788908
  792587
  794560
  804597
  807541
  807725
  808293
  808998
  820658
  822286
  822961
]
2.80 ms
(1.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black girl ass"
]
1.90 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black девушк жоп"
]
1.64 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black девушк жоп"
]
1.62 ms
(1.01%)
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.