Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.03 ms
(84.48%)
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
  14508
  33098
  108018
  383439
  387115
  388690
  395474
  396562
  396781
  398154
  399058
  399323
  399414
  407654
  408508
  410056
  410057
  416784
  417880
  417888
  419876
  420363
  425395
  428395
  429037
  429198
  430742
  431772
  434724
  436037
  446694
  447314
  448628
  449018
  451571
  453202
  455116
  460137
  464165
  471897
  474725
  475797
  482812
  497550
  499668
  499743
  502284
  504546
  509054
  510674
  510820
  512122
  524755
  525819
  525938
  527761
  529349
  532926
  534817
  536740
  538043
  547078
  547364
  548733
  550198
  556911
  556962
  557243
  562350
  582346
  584576
  591032
  591612
  592385
  604435
  604526
  610283
  612211
  622403
  625803
  626605
  627601
  638988
  654460
  654600
  655636
  657057
  660956
  662047
  665936
  672506
  675394
  686776
  691254
  699734
  705702
  707738
  708520
  722489
  725606
  735938
  737847
  740616
  741434
  742439
  743066
  744679
  747481
  750911
  792056
  803190
  805164
  805281
  805607
  807982
  814527
  814574
  815956
  818413
  821487
]
20.43 ms
(10.52%)
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
  655636
  660956
  547364
  805164
  429198
  591612
  14508
  399323
  408508
  420363
  431772
  407654
  814527
  814574
  815956
  818413
  821487
  449018
  471897
  460137
  510820
  529349
  538043
  512122
  527761
  509054
  534817
  536740
  547078
  654460
  665936
  707738
  672506
  662047
  686776
  699734
  705702
  708520
  722489
  584576
  622403
  626605
  610283
  612211
  627601
  638988
  805281
  792056
  805607
  725606
  743066
  750911
  737847
  747481
  740616
  744679
  735938
  741434
  742439
  604435
  803190
  807982
  387115
  396781
  108018
  410056
  416784
  455116
  430742
  499743
  525938
  532926
  654600
  592385
  502284
  475797
  524755
  582346
  425395
  557243
  383439
  395474
  33098
  399058
  434724
  410057
  417880
  446694
  453202
  464165
  482812
  510674
  474725
  388690
  396562
  436037
  398154
  399414
  447314
  417888
  504546
  497550
  499668
  625803
  419876
  562350
  556962
  657057
  675394
  691254
  591032
  604526
  428395
  429037
  448628
  451571
  525819
  548733
  550198
  556911
]
2.40 ms
(1.23%)
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
  14508
  33098
  108018
  383439
  387115
  388690
  395474
  396562
  396781
  398154
  399058
  399323
  399414
  407654
  408508
  410056
  410057
  416784
  417880
  417888
  419876
  420363
  425395
  428395
  429037
  429198
  430742
  431772
  434724
  436037
  446694
  447314
  448628
  449018
  451571
  453202
  455116
  460137
  464165
  471897
  474725
  475797
  482812
  497550
  499668
  499743
  502284
  504546
  509054
  510674
  510820
  512122
  524755
  525819
  525938
  527761
  529349
  532926
  534817
  536740
  538043
  547078
  547364
  548733
  550198
  556911
  556962
  557243
  562350
  582346
  584576
  591032
  591612
  592385
  604435
  604526
  610283
  612211
  622403
  625803
  626605
  627601
  638988
  654460
  654600
  655636
  657057
  660956
  662047
  665936
  672506
  675394
  686776
  691254
  699734
  705702
  707738
  708520
  722489
  725606
  735938
  737847
  740616
  741434
  742439
  743066
  744679
  747481
  750911
  792056
  803190
  805164
  805281
  805607
  807982
  814527
  814574
  815956
  818413
  821487
]
2.24 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small tits interracial"
]
1.80 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая сиськ межрасов"
]
1.68 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.81%)
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.