Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.71 ms
(86.60%)
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
  445431
  446335
  446343
  448824
  457329
  459818
  461728
  461739
  461741
  468469
  468704
  469001
  472725
  472883
  480280
  486766
  494619
  496993
  497732
  508193
  510058
  515009
  518452
  523573
  533306
  533384
  534114
  534322
  534590
  535718
  535724
  536242
  540301
  541965
  542345
  542829
  543866
  545475
  545796
  550094
  554179
  559160
  561661
  563758
  564392
  573568
  575038
  576926
  580614
  581609
  585552
  585952
  587118
  588315
  588590
  591032
  591513
  591608
  591623
  594209
  595150
  596059
  596941
  598645
  604329
  604466
  618845
  630582
  633755
  634029
  636285
  636553
  636956
  637418
  637437
  645258
  645669
  645990
  647357
  647641
  649187
  649857
  650506
  651630
  655833
  657057
  661960
  666583
  671328
  672622
  672677
  673353
  674043
  674430
  674936
  675806
  677705
  679881
  683183
  689315
  689616
  694938
  695347
  695387
  695929
  698095
  698407
  700281
  711899
  711900
  712021
  712773
  714556
  715371
  719934
  720042
  720306
  720755
  722488
  722527
]
15.54 ms
(8.22%)
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
  468469
  486766
  446335
  446343
  457329
  459818
  461728
  461739
  461741
  472725
  445431
  448824
  472883
  496993
  497732
  533384
  534322
  535718
  508193
  510058
  518452
  535724
  515009
  533306
  534114
  534590
  540301
  494619
  523573
  536242
  468704
  469001
  480280
  542829
  545796
  550094
  564392
  554179
  561661
  576926
  541965
  542345
  543866
  559160
  563758
  573568
  575038
  645990
  649857
  657057
  671328
  673353
  694938
  695387
  711899
  712021
  714556
  719934
  720042
  720755
  645258
  645669
  647357
  649187
  650506
  651630
  661960
  672622
  674430
  674936
  675806
  677705
  679881
  683183
  689616
  695347
  695929
  698407
  700281
  647641
  655833
  666583
  672677
  674043
  689315
  698095
  711900
  712773
  715371
  720306
  722488
  722527
  545475
  580614
  581609
  588590
  591608
  598645
  604466
  618845
  636285
  636553
  585552
  591032
  591513
  595150
  604329
  634029
  636956
  637418
  637437
  596059
  596941
  630582
  633755
  585952
  587118
  588315
  591623
  594209
]
2.77 ms
(1.47%)
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
  445431
  446335
  446343
  448824
  457329
  459818
  461728
  461739
  461741
  468469
  468704
  469001
  472725
  472883
  480280
  486766
  494619
  496993
  497732
  508193
  510058
  515009
  518452
  523573
  533306
  533384
  534114
  534322
  534590
  535718
  535724
  536242
  540301
  541965
  542345
  542829
  543866
  545475
  545796
  550094
  554179
  559160
  561661
  563758
  564392
  573568
  575038
  576926
  580614
  581609
  585552
  585952
  587118
  588315
  588590
  591032
  591513
  591608
  591623
  594209
  595150
  596059
  596941
  598645
  604329
  604466
  618845
  630582
  633755
  634029
  636285
  636553
  636956
  637418
  637437
  645258
  645669
  645990
  647357
  647641
  649187
  649857
  650506
  651630
  655833
  657057
  661960
  666583
  671328
  672622
  672677
  673353
  674043
  674430
  674936
  675806
  677705
  679881
  683183
  689315
  689616
  694938
  695347
  695387
  695929
  698095
  698407
  700281
  711899
  711900
  712021
  712773
  714556
  715371
  719934
  720042
  720306
  720755
  722488
  722527
]
2.18 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen interracial"
]
1.80 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen межрасов"
]
1.42 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen межрасов"
]

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.