Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.94 ms
(85.34%)
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
  30533
  73070
  172220
  326039
  381882
  384038
  391653
  394204
  397619
  397898
  398553
  411398
  411406
  419529
  426000
  429777
  430923
  434611
  448042
  449851
  451475
  451507
  452045
  452052
  452401
  455282
  455747
  457442
  458012
  468328
  475797
  477959
  478446
  480381
  480832
  482223
  487178
  491399
  491902
  493150
  501671
  502278
  507884
  509206
  509556
  512999
  513693
  513837
  522484
  525625
  531928
  531983
  535485
  535532
  537596
  539164
  542411
  542522
  543080
  543255
  543778
  544463
  547303
  548887
  549404
  549964
  550100
  550369
  551023
  553728
  556842
  578158
  579101
  584810
  590417
  591286
  591992
  606788
  619482
  622064
  624300
  646833
  647306
  648910
  661568
  664390
  664793
  673365
  684336
  684934
  689012
  692084
  693700
  693727
  697272
  697719
  716309
  725350
  726465
  726836
  730735
  737169
  738019
  744632
  773454
  795271
  801356
  801868
  802741
  804073
  807633
  817003
  817910
  818271
  820002
  820679
  824183
  824522
  826788
  827471
]
16.29 ms
(8.58%)
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
  773454
  738019
  384038
  172220
  429777
  487178
  579101
  795271
  804073
  30533
  73070
  397619
  507884
  419529
  326039
  820679
  475797
  477959
  493150
  478446
  452045
  458012
  480381
  535532
  509556
  513693
  542411
  553728
  556842
  578158
  584810
  543080
  547303
  542522
  543778
  646833
  661568
  684934
  673365
  689012
  549964
  624300
  590417
  591992
  622064
  591286
  619482
  801356
  730735
  726465
  744632
  726836
  802741
  381882
  391653
  394204
  451475
  411398
  426000
  452401
  411406
  430923
  448042
  455747
  468328
  509206
  512999
  525625
  452052
  502278
  543255
  480832
  482223
  451507
  455282
  491902
  550100
  491399
  513837
  522484
  457442
  449851
  807633
  737169
  397898
  817910
  539164
  535485
  664793
  606788
  801868
  725350
  434611
  544463
  398553
  537596
  826788
  827471
  818271
  820002
  824183
  824522
  817003
  531983
  501671
  531928
  548887
  550369
  549404
  551023
  684336
  693727
  697719
  716309
  647306
  664390
  692084
  697272
  648910
  693700
]
4.08 ms
(2.15%)
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
  30533
  73070
  172220
  326039
  381882
  384038
  391653
  394204
  397619
  397898
  398553
  411398
  411406
  419529
  426000
  429777
  430923
  434611
  448042
  449851
  451475
  451507
  452045
  452052
  452401
  455282
  455747
  457442
  458012
  468328
  475797
  477959
  478446
  480381
  480832
  482223
  487178
  491399
  491902
  493150
  501671
  502278
  507884
  509206
  509556
  512999
  513693
  513837
  522484
  525625
  531928
  531983
  535485
  535532
  537596
  539164
  542411
  542522
  543080
  543255
  543778
  544463
  547303
  548887
  549404
  549964
  550100
  550369
  551023
  553728
  556842
  578158
  579101
  584810
  590417
  591286
  591992
  606788
  619482
  622064
  624300
  646833
  647306
  648910
  661568
  664390
  664793
  673365
  684336
  684934
  689012
  692084
  693700
  693727
  697272
  697719
  716309
  725350
  726465
  726836
  730735
  737169
  738019
  744632
  773454
  795271
  801356
  801868
  802741
  804073
  807633
  817003
  817910
  818271
  820002
  820679
  824183
  824522
  826788
  827471
]
2.12 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "поцелуи мама"
]
1.97 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "поцел мам женщин"
]
1.88 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.79%)
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.