Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.52 ms
(84.97%)
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
  6768
  125762
  329464
  381921
  384518
  385548
  386662
  387085
  391372
  392207
  395306
  395563
  396051
  396467
  399088
  399853
  400841
  400982
  401989
  402020
  411443
  413135
  417739
  417744
  428610
  429439
  430809
  432797
  433089
  436577
  438830
  441442
  443467
  445854
  446361
  446645
  447109
  447140
  448824
  451529
  451749
  451755
  452987
  453468
  453825
  454090
  455937
  456930
  458206
  458921
  461743
  463882
  464696
  466484
  473756
  473773
  473967
  475451
  477883
  482538
  483902
  485306
  487862
  494526
  495824
  497976
  499121
  499774
  501155
  501723
  505454
  505977
  508204
  510687
  512306
  512879
  516019
  518929
  522188
  527927
  529708
  530632
  530697
  533016
  533049
  533660
  533696
  533986
  536253
  537881
  537891
  538272
  538812
  542245
  565277
  600659
  631003
  631009
  633918
  706667
  707093
  719947
  722234
  723914
  727288
  739879
  739882
  747988
  753824
  757639
  761718
  769924
  783386
  802765
  808317
  820806
  823045
  823972
  828589
  828849
]
16.11 ms
(9.74%)
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
  719947
  329464
  499774
  565277
  413135
  458206
  483902
  477883
  448824
  529708
  473756
  722234
  802765
  723914
  769924
  429439
  438830
  456930
  411443
  385548
  384518
  125762
  6768
  396467
  402020
  820806
  823045
  823972
  828849
  828589
  455937
  466484
  505454
  516019
  533986
  501155
  538812
  538272
  542245
  706667
  600659
  631003
  631009
  633918
  783386
  808317
  753824
  727288
  757639
  739879
  739882
  747988
  761718
  707093
  387085
  386662
  395306
  395563
  392207
  381921
  391372
  396051
  399088
  399853
  400841
  400982
  401989
  417739
  428610
  430809
  441442
  432797
  433089
  417744
  436577
  443467
  445854
  446645
  451529
  451749
  451755
  453468
  463882
  475451
  487862
  446361
  447109
  453825
  464696
  473773
  482538
  447140
  452987
  454090
  458921
  461743
  473967
  485306
  497976
  501723
  505977
  518929
  530697
  495824
  499121
  512306
  512879
  530632
  533016
  533660
  537881
  510687
  533049
  533696
  494526
  508204
  522188
  527927
  536253
  537891
]
2.33 ms
(1.41%)
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
  6768
  125762
  329464
  381921
  384518
  385548
  386662
  387085
  391372
  392207
  395306
  395563
  396051
  396467
  399088
  399853
  400841
  400982
  401989
  402020
  411443
  413135
  417739
  417744
  428610
  429439
  430809
  432797
  433089
  436577
  438830
  441442
  443467
  445854
  446361
  446645
  447109
  447140
  448824
  451529
  451749
  451755
  452987
  453468
  453825
  454090
  455937
  456930
  458206
  458921
  461743
  463882
  464696
  466484
  473756
  473773
  473967
  475451
  477883
  482538
  483902
  485306
  487862
  494526
  495824
  497976
  499121
  499774
  501155
  501723
  505454
  505977
  508204
  510687
  512306
  512879
  516019
  518929
  522188
  527927
  529708
  530632
  530697
  533016
  533049
  533660
  533696
  533986
  536253
  537881
  537891
  538272
  538812
  542245
  565277
  600659
  631003
  631009
  633918
  706667
  707093
  719947
  722234
  723914
  727288
  739879
  739882
  747988
  753824
  757639
  761718
  769924
  783386
  802765
  808317
  820806
  823045
  823972
  828589
  828849
]
1.84 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen white"
]
1.66 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen white"
]
1.35 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen white"
]

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.