Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.99 ms
(86.39%)
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
  7086
  382613
  396384
  423460
  423499
  430695
  431019
  439647
  443139
  445620
  452052
  452100
  452121
  452156
  452157
  452163
  458504
  459684
  463352
  474182
  477891
  478824
  480302
  480814
  489249
  492660
  498702
  504655
  512526
  512937
  514254
  514877
  519260
  522472
  529885
  530737
  532160
  532170
  532174
  532262
  532266
  534240
  534243
  534259
  534271
  534283
  534285
  534291
  534317
  535117
  535136
  535826
  536332
  541631
  541891
  551028
  552301
  553571
  556543
  556916
  563033
  563082
  565996
  566093
  570730
  570860
  579749
  591631
  591861
  592486
  601923
  602531
  621680
  622923
  630479
  638031
  639278
  640676
  643043
  643420
  649108
  660622
  666869
  672836
  691725
  697489
  699304
  700611
  700765
  712201
  726725
  728436
  728440
  734660
  736343
  742754
  762748
  765913
  765924
  766864
  767633
  767784
  767987
  768578
  771205
  781459
  787120
  787313
  793395
  796562
  800716
  800944
  801124
  802161
  802218
  811915
  818160
  819028
  823356
  824963
]
12.44 ms
(7.46%)
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
  824963
  534283
  699304
  712201
  660622
  672836
  639278
  638031
  801124
  767784
  734660
  765913
  697489
  700611
  396384
  522472
  534317
  514877
  649108
  666869
  643043
  643420
  781459
  787120
  787313
  728436
  728440
  601923
  640676
  459684
  430695
  498702
  423499
  452052
  556916
  565996
  382613
  474182
  423460
  823356
  535117
  519260
  529885
  534271
  532160
  552301
  630479
  793395
  800716
  771205
  742754
  811915
  458504
  477891
  563033
  452157
  534285
  443139
  819028
  535136
  534291
  579749
  691725
  553571
  556543
  602531
  800944
  802218
  726725
  767633
  767987
  736343
  765924
  768578
  762748
  700765
  796562
  7086
  818160
  452163
  512526
  530737
  535826
  514254
  532174
  512937
  536332
  463352
  541891
  551028
  563082
  570860
  566093
  591631
  591861
  592486
  621680
  802161
  766864
  439647
  478824
  445620
  489249
  452156
  431019
  492660
  452121
  532266
  532170
  504655
  532262
  534259
  534240
  534243
  570730
  622923
  480302
  480814
  452100
  541631
]
4.10 ms
(2.46%)
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
  7086
  382613
  396384
  423460
  423499
  430695
  431019
  439647
  443139
  445620
  452052
  452100
  452121
  452156
  452157
  452163
  458504
  459684
  463352
  474182
  477891
  478824
  480302
  480814
  489249
  492660
  498702
  504655
  512526
  512937
  514254
  514877
  519260
  522472
  529885
  530737
  532160
  532170
  532174
  532262
  532266
  534240
  534243
  534259
  534271
  534283
  534285
  534291
  534317
  535117
  535136
  535826
  536332
  541631
  541891
  551028
  552301
  553571
  556543
  556916
  563033
  563082
  565996
  566093
  570730
  570860
  579749
  591631
  591861
  592486
  601923
  602531
  621680
  622923
  630479
  638031
  639278
  640676
  643043
  643420
  649108
  660622
  666869
  672836
  691725
  697489
  699304
  700611
  700765
  712201
  726725
  728436
  728440
  734660
  736343
  742754
  762748
  765913
  765924
  766864
  767633
  767784
  767987
  768578
  771205
  781459
  787120
  787313
  793395
  796562
  800716
  800944
  801124
  802161
  802218
  811915
  818160
  819028
  823356
  824963
]
1.84 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother full"
]
1.46 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин full"
]
1.24 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин full"
]

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.