Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.40 ms
(83.30%)
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
  33562
  396617
  412603
  419632
  428537
  432717
  436868
  437174
  443151
  449676
  452365
  453447
  453793
  455012
  455963
  456732
  456734
  456977
  457311
  457523
  458192
  458680
  459036
  459256
  462655
  463151
  463404
  464370
  465691
  466548
  468349
  468375
  468984
  470579
  470916
  472008
  472075
  473296
  473854
  474996
  477774
  478830
  479379
  479401
  480855
  482193
  482857
  482915
  483277
  484753
  484995
  485255
  487019
  487710
  488433
  490012
  491584
  493657
  494584
  494818
  495046
  495908
  496559
  496687
  497077
  497493
  499100
  501907
  502106
  503011
  503500
  503530
  503547
  504333
  505436
  505850
  507833
  509052
  510428
  511211
  513405
  513445
  514487
  515586
  515635
  515674
  516241
  516663
  517057
  517448
  517584
  517607
  518499
  518926
  520398
  520790
  521770
  524147
  524835
  525775
  526416
  527297
  530166
  531426
  533690
  534837
  537262
  543384
  544517
  584036
  594556
  594583
  604468
  606366
  651251
  728440
  732868
  734322
  759464
  807725
]
17.03 ms
(10.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
  443151
  527297
  456977
  474996
  452365
  453793
  495046
  511211
  496559
  534837
  495908
  594556
  759464
  728440
  479401
  464370
  479379
  499100
  501907
  503530
  514487
  515635
  482915
  515674
  490012
  494584
  33562
  396617
  428537
  412603
  432717
  437174
  458192
  458680
  459256
  470579
  455012
  465691
  488433
  457311
  459036
  466548
  468349
  478830
  484753
  485255
  487019
  491584
  505436
  517584
  520790
  537262
  533690
  507833
  526416
  496687
  513405
  517607
  521770
  524835
  531426
  463404
  468375
  482193
  544517
  543384
  651251
  584036
  594583
  606366
  807725
  734322
  732868
  604468
  419632
  449676
  453447
  456732
  462655
  473296
  480855
  457523
  468984
  470916
  477774
  436868
  456734
  472008
  472075
  487710
  503500
  518926
  482857
  483277
  494818
  497077
  497493
  503547
  525775
  530166
  493657
  503011
  505850
  509052
  515586
  520398
  473854
  516663
  518499
  502106
  463151
  455963
  504333
  516241
  517448
  484995
  510428
  513445
  517057
  524147
]
2.94 ms
(1.82%)
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
  33562
  396617
  412603
  419632
  428537
  432717
  436868
  437174
  443151
  449676
  452365
  453447
  453793
  455012
  455963
  456732
  456734
  456977
  457311
  457523
  458192
  458680
  459036
  459256
  462655
  463151
  463404
  464370
  465691
  466548
  468349
  468375
  468984
  470579
  470916
  472008
  472075
  473296
  473854
  474996
  477774
  478830
  479379
  479401
  480855
  482193
  482857
  482915
  483277
  484753
  484995
  485255
  487019
  487710
  488433
  490012
  491584
  493657
  494584
  494818
  495046
  495908
  496559
  496687
  497077
  497493
  499100
  501907
  502106
  503011
  503500
  503530
  503547
  504333
  505436
  505850
  507833
  509052
  510428
  511211
  513405
  513445
  514487
  515586
  515635
  515674
  516241
  516663
  517057
  517448
  517584
  517607
  518499
  518926
  520398
  520790
  521770
  524147
  524835
  525775
  526416
  527297
  530166
  531426
  533690
  534837
  537262
  543384
  544517
  584036
  594556
  594583
  604468
  606366
  651251
  728440
  732868
  734322
  759464
  807725
]
2.03 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большой для жены"
]
1.87 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большой большие жен"
]
1.42 ms
(0.88%)
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.