Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
239.70 ms
(87.19%)
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
  9021
  392903
  401049
  407464
  431963
  442168
  442864
  443600
  446906
  449855
  452418
  453631
  453848
  457590
  459107
  459597
  459667
  461346
  461417
  462548
  462566
  466255
  470161
  473969
  474029
  484919
  487448
  491027
  492609
  492627
  497240
  497416
  500691
  501623
  504042
  508484
  518106
  520468
  520692
  521977
  522662
  524408
  526383
  526426
  526434
  527943
  528867
  533021
  534769
  545725
  548866
  549783
  555680
  559080
  559771
  563549
  570505
  575189
  575607
  578565
  578610
  587579
  587791
  588762
  590854
  590877
  590879
  590881
  590885
  590906
  591789
  592421
  593344
  596556
  597753
  603175
  606794
  607058
  608921
  609412
  610002
  611190
  613815
  614020
  615774
  619247
  619379
  620377
  625363
  628194
  633045
  634297
  635838
  644399
  649642
  653900
  654597
  675898
  676289
  676804
  696172
  707557
  707597
  724425
  728145
  740212
  764490
  771971
  776768
  786230
  792910
  793431
  797519
  797849
  799601
  806765
  812777
  814062
  814265
  825299
]
24.01 ms
(8.73%)
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
  799601
  459107
  520468
  590906
  814062
  675898
  707557
  9021
  593344
  609412
  392903
  633045
  625363
  555680
  619379
  812777
  526434
  570505
  449855
  615774
  470161
  533021
  649642
  696172
  588762
  611190
  526426
  654597
  492609
  528867
  613815
  459667
  527943
  590854
  491027
  487448
  610002
  676804
  596556
  461346
  442864
  497240
  501623
  524408
  628194
  592421
  452418
  534769
  559771
  606794
  676289
  590881
  806765
  407464
  590877
  453631
  500691
  518106
  724425
  644399
  446906
  474029
  797849
  619247
  453848
  591789
  793431
  740212
  764490
  401049
  462548
  814265
  545725
  575607
  492627
  508484
  504042
  578565
  442168
  443600
  461417
  575189
  563549
  707597
  548866
  607058
  634297
  590879
  614020
  776768
  792910
  771971
  459597
  466255
  825299
  520692
  484919
  620377
  590885
  473969
  497416
  522662
  526383
  578610
  549783
  653900
  559080
  608921
  587791
  603175
  635838
  587579
  597753
  728145
  786230
  797519
  462566
  431963
  457590
  521977
]
3.72 ms
(1.35%)
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
  9021
  392903
  401049
  407464
  431963
  442168
  442864
  443600
  446906
  449855
  452418
  453631
  453848
  457590
  459107
  459597
  459667
  461346
  461417
  462548
  462566
  466255
  470161
  473969
  474029
  484919
  487448
  491027
  492609
  492627
  497240
  497416
  500691
  501623
  504042
  508484
  518106
  520468
  520692
  521977
  522662
  524408
  526383
  526426
  526434
  527943
  528867
  533021
  534769
  545725
  548866
  549783
  555680
  559080
  559771
  563549
  570505
  575189
  575607
  578565
  578610
  587579
  587791
  588762
  590854
  590877
  590879
  590881
  590885
  590906
  591789
  592421
  593344
  596556
  597753
  603175
  606794
  607058
  608921
  609412
  610002
  611190
  613815
  614020
  615774
  619247
  619379
  620377
  625363
  628194
  633045
  634297
  635838
  644399
  649642
  653900
  654597
  675898
  676289
  676804
  696172
  707557
  707597
  724425
  728145
  740212
  764490
  771971
  776768
  786230
  792910
  793431
  797519
  797849
  799601
  806765
  812777
  814062
  814265
  825299
]
2.05 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жмж секс втро домашн любительск"
]
1.95 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жмж дом"
]
1.54 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.