Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.43 ms
(82.99%)
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
  385278
  393442
  409484
  415961
  419197
  426361
  439033
  439463
  440361
  440469
  440481
  440826
  441049
  443572
  444283
  444842
  445211
  446445
  446863
  446948
  449210
  450434
  452760
  454526
  456232
  461651
  461673
  465814
  470392
  471635
  472159
  478665
  479590
  480960
  482725
  483123
  485803
  486312
  486596
  486619
  487191
  488152
  488827
  490819
  493490
  493897
  494493
  499143
  499765
  503003
  508107
  508542
  508895
  510214
  510565
  512972
  513547
  514236
  514272
  517182
  517780
  518798
  520487
  521600
  522440
  526356
  527072
  527355
  527660
  531632
  533937
  534553
  535091
  537966
  552745
  554256
  558568
  558645
  560508
  560663
  564132
  565033
  566086
  567272
  570718
  571812
  575852
  579624
  585142
  585173
  586641
  588818
  590813
  594503
  595687
  597920
  598078
  599713
  600607
  600804
  604238
  604328
  610958
  612414
  626569
  628910
  641764
  641910
  648716
  659215
  671396
  672906
  674507
  679821
  720184
  740920
  747655
  747687
  755331
  792423
]
20.56 ms
(11.34%)
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
  514272
  488152
  493897
  595687
  612414
  385278
  594503
  598078
  628910
  604238
  600607
  626569
  499143
  571812
  672906
  599713
  426361
  439463
  440826
  585142
  482725
  470392
  486619
  494493
  531632
  533937
  534553
  517182
  521600
  483123
  488827
  560508
  565033
  552745
  554256
  558568
  720184
  648716
  558645
  564132
  567272
  585173
  604328
  740920
  747687
  465814
  446863
  452760
  415961
  445211
  485803
  486312
  747655
  755331
  517780
  444283
  440481
  493490
  450434
  508542
  510565
  522440
  526356
  472159
  575852
  674507
  560663
  586641
  600804
  792423
  446445
  480960
  446948
  440361
  444842
  478665
  479590
  439033
  486596
  487191
  490819
  512972
  514236
  520487
  659215
  597920
  588818
  641910
  641764
  393442
  409484
  570718
  671396
  508107
  535091
  499765
  441049
  449210
  461673
  537966
  527072
  566086
  579624
  679821
  590813
  610958
  471635
  510214
  513547
  518798
  503003
  527660
  527355
  419197
  440469
  443572
  456232
  454526
  508895
  461651
]
3.39 ms
(1.87%)
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
  385278
  393442
  409484
  415961
  419197
  426361
  439033
  439463
  440361
  440469
  440481
  440826
  441049
  443572
  444283
  444842
  445211
  446445
  446863
  446948
  449210
  450434
  452760
  454526
  456232
  461651
  461673
  465814
  470392
  471635
  472159
  478665
  479590
  480960
  482725
  483123
  485803
  486312
  486596
  486619
  487191
  488152
  488827
  490819
  493490
  493897
  494493
  499143
  499765
  503003
  508107
  508542
  508895
  510214
  510565
  512972
  513547
  514236
  514272
  517182
  517780
  518798
  520487
  521600
  522440
  526356
  527072
  527355
  527660
  531632
  533937
  534553
  535091
  537966
  552745
  554256
  558568
  558645
  560508
  560663
  564132
  565033
  566086
  567272
  570718
  571812
  575852
  579624
  585142
  585173
  586641
  588818
  590813
  594503
  595687
  597920
  598078
  599713
  600607
  600804
  604238
  604328
  610958
  612414
  626569
  628910
  641764
  641910
  648716
  659215
  671396
  672906
  674507
  679821
  720184
  740920
  747655
  747687
  755331
  792423
]
2.01 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade petite"
]
1.90 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск petite"
]
1.44 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск petite"
]

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.