Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.15 ms
(82.19%)
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
  387251
  387905
  405961
  410254
  417067
  418538
  419550
  420635
  420695
  421250
  421871
  421907
  422044
  422463
  424411
  439819
  441004
  442673
  443660
  443779
  443784
  443823
  443926
  447045
  448521
  449170
  453494
  453841
  454277
  455411
  456455
  456614
  462305
  463074
  464327
  464368
  466355
  467555
  470487
  470657
  470941
  474289
  474633
  474639
  475439
  475846
  476797
  478096
  480059
  482132
  482142
  482506
  484628
  484629
  484656
  484665
  484681
  484727
  484738
  484748
  484750
  495149
  500363
  502147
  503658
  506056
  508180
  509033
  510398
  512355
  513604
  513607
  515358
  516329
  520753
  522556
  524018
  531884
  534968
  537970
  538360
  544528
  544665
  544668
  549799
  550667
  551130
  553190
  558788
  562758
  565351
  573800
  578411
  581433
  583482
  583500
  590230
  590469
  591416
  598859
  603635
  603653
  603675
  609531
  612422
  628654
  639044
  639060
  640136
  648539
  653052
  671863
  671893
  707889
  710265
  724305
  728143
  733239
  750725
  751565
]
22.22 ms
(11.77%)
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
  448521
  422463
  418538
  463074
  495149
  478096
  653052
  648539
  424411
  470657
  470941
  512355
  484738
  484727
  581433
  420695
  453494
  456614
  454277
  516329
  549799
  609531
  603635
  603675
  603653
  612422
  467555
  466355
  484629
  387251
  591416
  475846
  509033
  443823
  447045
  453841
  583482
  590230
  480059
  455411
  502147
  544668
  419550
  565351
  544528
  482506
  421907
  510398
  464368
  421871
  420635
  441004
  707889
  558788
  417067
  520753
  598859
  387905
  443660
  534968
  443779
  462305
  456455
  443784
  484628
  531884
  639044
  421250
  538360
  551130
  583500
  671893
  640136
  474639
  484748
  484750
  513607
  750725
  733239
  578411
  544665
  573800
  590469
  524018
  537970
  482132
  500363
  443926
  405961
  442673
  503658
  550667
  422044
  476797
  470487
  506056
  475439
  515358
  724305
  474633
  484665
  484656
  410254
  639060
  751565
  464327
  508180
  628654
  482142
  484681
  728143
  553190
  439819
  474289
  449170
  671863
  710265
  522556
  562758
  513604
]
4.18 ms
(2.22%)
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
  387251
  387905
  405961
  410254
  417067
  418538
  419550
  420635
  420695
  421250
  421871
  421907
  422044
  422463
  424411
  439819
  441004
  442673
  443660
  443779
  443784
  443823
  443926
  447045
  448521
  449170
  453494
  453841
  454277
  455411
  456455
  456614
  462305
  463074
  464327
  464368
  466355
  467555
  470487
  470657
  470941
  474289
  474633
  474639
  475439
  475846
  476797
  478096
  480059
  482132
  482142
  482506
  484628
  484629
  484656
  484665
  484681
  484727
  484738
  484748
  484750
  495149
  500363
  502147
  503658
  506056
  508180
  509033
  510398
  512355
  513604
  513607
  515358
  516329
  520753
  522556
  524018
  531884
  534968
  537970
  538360
  544528
  544665
  544668
  549799
  550667
  551130
  553190
  558788
  562758
  565351
  573800
  578411
  581433
  583482
  583500
  590230
  590469
  591416
  598859
  603635
  603653
  603675
  609531
  612422
  628654
  639044
  639060
  640136
  648539
  653052
  671863
  671893
  707889
  710265
  724305
  728143
  733239
  750725
  751565
]
2.12 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "swinger wife anal"
]
1.83 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "свингер жен анал"
]
1.66 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "свингер жен анал"
]
1.61 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.