Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.38 ms
(78.17%)
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
  401799
  405804
  415419
  417449
  421207
  426417
  444795
  449784
  452639
  459388
  464368
  468139
  472248
  473779
  475280
  475301
  475414
  479011
  483607
  486871
  488764
  491858
  500477
  506133
  507680
  509685
  512094
  512941
  513572
  513575
  514311
  514940
  515071
  515086
  515953
  517752
  518219
  520540
  521798
  522973
  523045
  523667
  524530
  525738
  529109
  529374
  535432
  538963
  541749
  543844
  545245
  545440
  547245
  549093
  551819
  552273
  553031
  555291
  558191
  559439
  559454
  560425
  560665
  561061
  561346
  561452
  562003
  564646
  565550
  565653
  566708
  569047
  569223
  569302
  573212
  579582
  581530
  581873
  583021
  586573
  588068
  588525
  590906
  591428
  593361
  593363
  593759
  594370
  595070
  595132
  595905
  598233
  598524
  599078
  599940
  600913
  601448
  601529
  601624
  604364
  606482
  611535
  611558
  611567
  615525
  620009
  622241
  623420
  623744
  624095
  624742
  626944
  629428
  634230
  663458
  678095
  678097
]
24.27 ms
(14.78%)
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
  515086
  509685
  514940
  515953
  517752
  529374
  468139
  475280
  545440
  560665
  569302
  579582
  549093
  559439
  559454
  569047
  547245
  581530
  590906
  593363
  595070
  615525
  593759
  623420
  401799
  475301
  472248
  417449
  518219
  520540
  421207
  473779
  475414
  506133
  515071
  529109
  524530
  545245
  560425
  566708
  569223
  561061
  555291
  562003
  581873
  551819
  552273
  598233
  623744
  595132
  588525
  594370
  591428
  624742
  426417
  452639
  479011
  521798
  523667
  525738
  599078
  449784
  522973
  513575
  535432
  512941
  583021
  541749
  561346
  663458
  561452
  601448
  611567
  629428
  586573
  601624
  606482
  595905
  601529
  514311
  444795
  464368
  500477
  513572
  588068
  611535
  459388
  486871
  507680
  538963
  543844
  565550
  565653
  553031
  564646
  678095
  678097
  611558
  620009
  593361
  598524
  600913
  622241
  624095
  604364
  405804
  512094
  491858
  523045
  483607
  488764
  573212
  634230
  415419
  558191
  626944
  599940
]
3.33 ms
(2.03%)
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
  401799
  405804
  415419
  417449
  421207
  426417
  444795
  449784
  452639
  459388
  464368
  468139
  472248
  473779
  475280
  475301
  475414
  479011
  483607
  486871
  488764
  491858
  500477
  506133
  507680
  509685
  512094
  512941
  513572
  513575
  514311
  514940
  515071
  515086
  515953
  517752
  518219
  520540
  521798
  522973
  523045
  523667
  524530
  525738
  529109
  529374
  535432
  538963
  541749
  543844
  545245
  545440
  547245
  549093
  551819
  552273
  553031
  555291
  558191
  559439
  559454
  560425
  560665
  561061
  561346
  561452
  562003
  564646
  565550
  565653
  566708
  569047
  569223
  569302
  573212
  579582
  581530
  581873
  583021
  586573
  588068
  588525
  590906
  591428
  593361
  593363
  593759
  594370
  595070
  595132
  595905
  598233
  598524
  599078
  599940
  600913
  601448
  601529
  601624
  604364
  606482
  611535
  611558
  611567
  615525
  620009
  622241
  623420
  623744
  624095
  624742
  626944
  629428
  634230
  663458
  678095
  678097
]
2.69 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "игрушка для клитора"
]
1.92 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "игрушк клитор"
]
1.86 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.08%)
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.