Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.33 ms
(87.51%)
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
  79677
  389630
  397777
  398648
  400696
  404257
  410663
  413898
  415835
  419240
  419515
  424024
  426705
  427003
  428684
  429960
  431608
  435020
  443129
  443715
  443950
  449981
  453610
  454136
  455641
  456741
  457580
  462167
  465803
  466124
  466137
  473785
  473995
  474062
  474242
  477135
  483850
  483969
  486118
  491071
  496822
  496882
  497201
  501507
  509240
  510348
  516295
  543708
  543714
  543717
  543734
  544186
  572949
  579704
  585895
  601907
  610835
  627746
  664529
  689170
  730819
  733661
  749882
  757803
  757981
  764076
  764668
  766159
  766354
  766361
  767553
  768491
  771445
  771822
  773826
  777471
  778543
  778766
  778773
  779266
  782184
  783609
  783796
  784700
  786090
  786093
  787471
  787840
  788032
  788388
  791498
  791841
  792677
  794081
  795617
  796598
  801736
  803246
  807286
  809645
  810189
  810880
  817205
  817740
  819208
  819793
  819946
  821039
  821796
  823647
  823648
  824057
  824547
  825180
  825525
  825641
  825927
  827105
  827107
  828665
]
17.84 ms
(8.16%)
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
  773826
  766361
  400696
  415835
  825641
  819946
  404257
  601907
  543714
  543734
  786093
  809645
  733661
  768491
  782184
  466137
  509240
  783609
  419515
  389630
  465803
  435020
  455641
  496882
  496822
  516295
  397777
  510348
  413898
  456741
  664529
  777471
  786090
  778766
  779266
  801736
  749882
  771822
  791498
  792677
  803246
  825927
  827105
  825180
  819793
  821796
  823648
  795617
  757981
  426705
  824547
  824057
  486118
  827107
  828665
  473785
  410663
  462167
  443950
  627746
  473995
  454136
  585895
  794081
  778773
  810880
  771445
  784700
  544186
  543717
  689170
  610835
  778543
  730819
  766354
  443129
  424024
  457580
  823647
  572949
  398648
  483850
  497201
  767553
  79677
  427003
  449981
  796598
  757803
  819208
  543708
  579704
  419240
  477135
  788032
  764076
  764668
  788388
  443715
  453610
  474242
  431608
  429960
  466124
  810189
  817740
  821039
  787471
  428684
  474062
  501507
  766159
  791841
  491071
  483969
  817205
  825525
  787840
  783796
  807286
]
2.37 ms
(1.08%)
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
  79677
  389630
  397777
  398648
  400696
  404257
  410663
  413898
  415835
  419240
  419515
  424024
  426705
  427003
  428684
  429960
  431608
  435020
  443129
  443715
  443950
  449981
  453610
  454136
  455641
  456741
  457580
  462167
  465803
  466124
  466137
  473785
  473995
  474062
  474242
  477135
  483850
  483969
  486118
  491071
  496822
  496882
  497201
  501507
  509240
  510348
  516295
  543708
  543714
  543717
  543734
  544186
  572949
  579704
  585895
  601907
  610835
  627746
  664529
  689170
  730819
  733661
  749882
  757803
  757981
  764076
  764668
  766159
  766354
  766361
  767553
  768491
  771445
  771822
  773826
  777471
  778543
  778766
  778773
  779266
  782184
  783609
  783796
  784700
  786090
  786093
  787471
  787840
  788032
  788388
  791498
  791841
  792677
  794081
  795617
  796598
  801736
  803246
  807286
  809645
  810189
  810880
  817205
  817740
  819208
  819793
  819946
  821039
  821796
  823647
  823648
  824057
  824547
  825180
  825525
  825641
  825927
  827105
  827107
  828665
]
1.90 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пов секс с русскими"
]
1.81 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов секс русск"
]
1.49 ms
(0.68%)
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.