Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.60 ms
(86.46%)
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
  385734
  407809
  417046
  417319
  417827
  419240
  420504
  423106
  424924
  425496
  427766
  430535
  434763
  439475
  440650
  440937
  440946
  444991
  445310
  445605
  450982
  452367
  454502
  457002
  457014
  458645
  460854
  463248
  466702
  467684
  467762
  467948
  468106
  468815
  471754
  472062
  477065
  482602
  487553
  488313
  489812
  491302
  495901
  496013
  498254
  501706
  502190
  502552
  504148
  504679
  504863
  505423
  506264
  508512
  508521
  508524
  511825
  511840
  515610
  515619
  517374
  517448
  518110
  524080
  525843
  526629
  526637
  527101
  527139
  527732
  534023
  545725
  545729
  557043
  559617
  559722
  561303
  568541
  572211
  577468
  579940
  580982
  584159
  585838
  588374
  592613
  593279
  593876
  594031
  594992
  595676
  598980
  599617
  599883
  602104
  602199
  604319
  604732
  610120
  610587
  612614
  612933
  614428
  616091
  624886
  631478
  643489
  650863
  653726
  721129
  721133
  755652
  763522
  774799
  785594
  786525
  803524
  805224
  809271
]
15.28 ms
(8.55%)
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
  425496
  534023
  585838
  385734
  482602
  588374
  599883
  610587
  592613
  595676
  598980
  599617
  612614
  594031
  602104
  584159
  616091
  594992
  631478
  612933
  472062
  427766
  504148
  457014
  467948
  495901
  488313
  417827
  423106
  424924
  505423
  439475
  440650
  407809
  417046
  417319
  440937
  434763
  450982
  457002
  491302
  525843
  502552
  477065
  557043
  572211
  545725
  545729
  568541
  650863
  721129
  577468
  579940
  593876
  604319
  610120
  624886
  786525
  803524
  755652
  763522
  614428
  809271
  419240
  468815
  444991
  460854
  467762
  517448
  504679
  526629
  496013
  487553
  502190
  524080
  527732
  420504
  430535
  440946
  452367
  466702
  458645
  508524
  511840
  498254
  501706
  527139
  508512
  559722
  580982
  559617
  561303
  653726
  721133
  557804
  602199
  593279
  643489
  604732
  774799
  785594
  805224
  463248
  468106
  454502
  471754
  445310
  467684
  445605
  515610
  515619
  489812
  504863
  518110
  506264
  508521
  517374
  511825
  526637
  527101
]
2.45 ms
(1.37%)
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
  385734
  407809
  417046
  417319
  417827
  419240
  420504
  423106
  424924
  425496
  427766
  430535
  434763
  439475
  440650
  440937
  440946
  444991
  445310
  445605
  450982
  452367
  454502
  457002
  457014
  458645
  460854
  463248
  466702
  467684
  467762
  467948
  468106
  468815
  471754
  472062
  477065
  482602
  487553
  488313
  489812
  491302
  495901
  496013
  498254
  501706
  502190
  502552
  504148
  504679
  504863
  505423
  506264
  508512
  508521
  508524
  511825
  511840
  515610
  515619
  517374
  517448
  518110
  524080
  525843
  526629
  526637
  527101
  527139
  527732
  534023
  545725
  545729
  557043
  559617
  559722
  561303
  568541
  572211
  577468
  579940
  580982
  584159
  585838
  588374
  592613
  593279
  593876
  594031
  594992
  595676
  598980
  599617
  599883
  602104
  602199
  604319
  604732
  610120
  610587
  612614
  612933
  614428
  616091
  624886
  631478
  643489
  650863
  653726
  721129
  721133
  755652
  763522
  774799
  785594
  786525
  803524
  805224
  809271
]
1.79 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur facial"
]
1.62 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск facial"
]
1.57 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск facial"
]

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.