Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.20 ms
(59.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
117.90 ms
(33.90%)
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
  6656
  370829
  387711
  388350
  393391
  402896
  404185
  415287
  424125
  428580
  428583
  432810
  433372
  439727
  440906
  471407
  471458
  488619
  503407
  510064
  512506
  515441
  516226
  522857
  527908
  534991
  543983
  545342
  547476
  565164
  571266
  591666
  595309
  597165
  598306
  598556
  600004
  600179
  604138
  606618
  611893
  617825
  620310
  624895
  632358
  639736
  642075
  664226
  666736
  669016
  669370
  671701
  673983
  678744
  686009
  696308
  697354
  698969
  702463
  702621
  705404
  712617
  715145
  716055
  716897
  718152
  720410
  720713
  723461
  723735
  726277
  734487
  739998
  750554
  751515
  751627
  758191
  758355
  759369
  760814
  761570
  761600
  761696
  766523
  766860
  766896
  770337
  770499
  770900
  770908
  770938
  775477
  778889
  781332
  782657
  785051
  786763
  788284
  788856
  790575
  790974
  795731
  797520
  800495
  801542
  801609
  802845
  803461
  803524
  805434
  807402
  809122
  810824
  810899
  813255
  814359
  814656
  814851
  822168
  823510
]
13.48 ms
(3.88%)
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
  801609
  402896
  471458
  512506
  534991
  510064
  666736
  705404
  624895
  785051
  761600
  790575
  439727
  424125
  393391
  440906
  516226
  702621
  712617
  611893
  598556
  726277
  428583
  488619
  571266
  678744
  696308
  595309
  600004
  591666
  810899
  803524
  803461
  810824
  766896
  770337
  715145
  788284
  370829
  471407
  433372
  503407
  775477
  527908
  415287
  432810
  814359
  822168
  814656
  823510
  515441
  522857
  545342
  547476
  565164
  543983
  671701
  697354
  723461
  664226
  669016
  669370
  686009
  698969
  673983
  716055
  720410
  600179
  606618
  598306
  597165
  604138
  642075
  781332
  782657
  790974
  778889
  800495
  805434
  809122
  723735
  750554
  761696
  766523
  770499
  770908
  786763
  788856
  795731
  813255
  759369
  760814
  766860
  734487
  751627
  770900
  770938
  758355
  761570
  739998
  751515
  758191
  617825
  620310
  632358
  639736
  702463
  716897
  718152
  720713
  797520
  801542
  802845
  807402
  387711
  6656
  388350
  404185
  428580
  814851
]
2.68 ms
(0.77%)
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
  6656
  370829
  387711
  388350
  393391
  402896
  404185
  415287
  424125
  428580
  428583
  432810
  433372
  439727
  440906
  471407
  471458
  488619
  503407
  510064
  512506
  515441
  516226
  522857
  527908
  534991
  543983
  545342
  547476
  565164
  571266
  591666
  595309
  597165
  598306
  598556
  600004
  600179
  604138
  606618
  611893
  617825
  620310
  624895
  632358
  639736
  642075
  664226
  666736
  669016
  669370
  671701
  673983
  678744
  686009
  696308
  697354
  698969
  702463
  702621
  705404
  712617
  715145
  716055
  716897
  718152
  720410
  720713
  723461
  723735
  726277
  734487
  739998
  750554
  751515
  751627
  758191
  758355
  759369
  760814
  761570
  761600
  761696
  766523
  766860
  766896
  770337
  770499
  770900
  770908
  770938
  775477
  778889
  781332
  782657
  785051
  786763
  788284
  788856
  790575
  790974
  795731
  797520
  800495
  801542
  801609
  802845
  803461
  803524
  805434
  807402
  809122
  810824
  810899
  813255
  814359
  814656
  814851
  822168
  823510
]
2.21 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf-mom-anal"
]
1.83 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf mom анал"
]
1.46 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf mom анал"
]

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.