Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.38 ms
(87.51%)
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
  382588
  383234
  395325
  395707
  395788
  406080
  409201
  415451
  441988
  458161
  461212
  462364
  462455
  467216
  488965
  489269
  490589
  493436
  494919
  495322
  496201
  499047
  508208
  508770
  510995
  520192
  530509
  538004
  581729
  583467
  585362
  586471
  588480
  589255
  596870
  596946
  599437
  608091
  614882
  618040
  623650
  625110
  637183
  643007
  646101
  662391
  664120
  668467
  677564
  690851
  693343
  693884
  697274
  705196
  709201
  709763
  713445
  713783
  720247
  720449
  721280
  721883
  722018
  722019
  724861
  729731
  732344
  739529
  740702
  742043
  742439
  742809
  744958
  745862
  746269
  752868
  755470
  756567
  760703
  761373
  766417
  768351
  769614
  772080
  776597
  778018
  778471
  782813
  785636
  785879
  785910
  785922
  787408
  787713
  788762
  789279
  789293
  789888
  790000
  790390
  796932
  797765
  798972
  799342
  801227
  802710
  802737
  802750
  804968
  807456
  807823
  808283
  809910
  811511
  813831
  814853
  815324
  816661
  820625
  826028
]
14.28 ms
(7.25%)
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
  808283
  441988
  722018
  614882
  637183
  776597
  785910
  790000
  796932
  766417
  746269
  752868
  756567
  732344
  742439
  785922
  395788
  826028
  583467
  720449
  664120
  625110
  623650
  785636
  797765
  802710
  788762
  807823
  722019
  798972
  804968
  807456
  489269
  813831
  462455
  697274
  789279
  493436
  720247
  586471
  782813
  415451
  690851
  785879
  789293
  739529
  745862
  787408
  755470
  768351
  761373
  721883
  395325
  495322
  520192
  693343
  709201
  608091
  588480
  799342
  778018
  724861
  769614
  772080
  467216
  508770
  815324
  496201
  581729
  668467
  693884
  705196
  709763
  596870
  801227
  742809
  760703
  461212
  538004
  499047
  713783
  395707
  814853
  816661
  530509
  510995
  596946
  585362
  618040
  787713
  789888
  802737
  809910
  740702
  729731
  721280
  458161
  490589
  494919
  713445
  662391
  643007
  790390
  383234
  820625
  488965
  508208
  677564
  589255
  599437
  778471
  744958
  462364
  382588
  406080
  646101
  811511
  802750
  742043
  409201
]
3.72 ms
(1.89%)
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
  382588
  383234
  395325
  395707
  395788
  406080
  409201
  415451
  441988
  458161
  461212
  462364
  462455
  467216
  488965
  489269
  490589
  493436
  494919
  495322
  496201
  499047
  508208
  508770
  510995
  520192
  530509
  538004
  581729
  583467
  585362
  586471
  588480
  589255
  596870
  596946
  599437
  608091
  614882
  618040
  623650
  625110
  637183
  643007
  646101
  662391
  664120
  668467
  677564
  690851
  693343
  693884
  697274
  705196
  709201
  709763
  713445
  713783
  720247
  720449
  721280
  721883
  722018
  722019
  724861
  729731
  732344
  739529
  740702
  742043
  742439
  742809
  744958
  745862
  746269
  752868
  755470
  756567
  760703
  761373
  766417
  768351
  769614
  772080
  776597
  778018
  778471
  782813
  785636
  785879
  785910
  785922
  787408
  787713
  788762
  789279
  789293
  789888
  790000
  790390
  796932
  797765
  798972
  799342
  801227
  802710
  802737
  802750
  804968
  807456
  807823
  808283
  809910
  811511
  813831
  814853
  815324
  816661
  820625
  826028
]
1.80 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "house секс"
]
1.72 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "house sex"
]
1.58 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "house секс"
]
1.51 ms
(0.77%)
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.