Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.41 ms
(85.47%)
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
  411884
  414306
  414604
  415950
  421352
  440958
  446706
  448812
  448829
  452234
  454102
  465605
  467592
  470037
  471429
  471792
  473908
  474681
  475443
  480373
  480385
  480387
  480392
  480393
  485216
  486409
  486446
  495895
  499788
  501474
  506787
  506801
  516499
  518493
  526054
  530015
  530268
  530739
  530766
  530788
  530837
  531134
  531183
  531232
  531248
  531438
  532166
  532653
  532780
  532790
  532959
  532989
  533043
  533364
  533382
  533645
  533870
  533942
  534986
  534999
  535005
  536178
  536281
  536283
  536287
  536290
  536344
  536620
  536628
  537676
  537899
  545399
  545537
  550200
  561995
  582563
  589543
  594406
  596075
  596192
  598656
  599852
  599875
  599932
  599941
  599957
  600200
  600215
  600280
  600334
  600354
  601535
  601575
  621656
  633765
  634131
  634202
  636292
  636299
  637048
  639793
  640530
  640767
  640771
  640800
  646175
  646451
  646904
  647939
  647954
  648838
  649186
  650179
  651660
  675479
  692471
  705817
  720720
  724037
  770133
]
17.53 ms
(9.40%)
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
  534986
  536281
  536287
  530766
  532959
  532989
  533870
  535005
  536344
  537676
  537899
  531183
  533043
  530268
  536283
  545399
  651660
  594406
  634202
  475443
  421352
  440958
  414306
  770133
  480373
  474681
  518493
  545537
  470037
  675479
  692471
  724037
  480392
  471429
  448829
  465605
  414604
  415950
  531438
  582563
  640530
  411884
  596075
  506801
  480385
  516499
  536178
  531134
  531248
  536620
  532166
  532780
  534999
  550200
  705817
  600280
  601575
  637048
  633765
  473908
  601535
  506787
  531232
  532790
  536290
  533364
  530015
  530739
  530837
  530788
  532653
  467592
  561995
  646175
  647954
  720720
  646451
  646904
  648838
  649186
  650179
  596192
  599932
  634131
  589543
  599957
  639793
  599852
  600215
  600354
  640771
  640800
  598656
  599941
  600334
  636292
  640767
  480393
  480387
  471792
  446706
  454102
  495895
  501474
  533382
  647939
  621656
  599875
  636299
  533645
  448812
  486446
  485216
  452234
  486409
  499788
  526054
  533942
  536628
  600200
]
2.47 ms
(1.33%)
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
  411884
  414306
  414604
  415950
  421352
  440958
  446706
  448812
  448829
  452234
  454102
  465605
  467592
  470037
  471429
  471792
  473908
  474681
  475443
  480373
  480385
  480387
  480392
  480393
  485216
  486409
  486446
  495895
  499788
  501474
  506787
  506801
  516499
  518493
  526054
  530015
  530268
  530739
  530766
  530788
  530837
  531134
  531183
  531232
  531248
  531438
  532166
  532653
  532780
  532790
  532959
  532989
  533043
  533364
  533382
  533645
  533870
  533942
  534986
  534999
  535005
  536178
  536281
  536283
  536287
  536290
  536344
  536620
  536628
  537676
  537899
  545399
  545537
  550200
  561995
  582563
  589543
  594406
  596075
  596192
  598656
  599852
  599875
  599932
  599941
  599957
  600200
  600215
  600280
  600334
  600354
  601535
  601575
  621656
  633765
  634131
  634202
  636292
  636299
  637048
  639793
  640530
  640767
  640771
  640800
  646175
  646451
  646904
  647939
  647954
  648838
  649186
  650179
  651660
  675479
  692471
  705817
  720720
  724037
  770133
]
2.14 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анальный кастинг мамк…"
]
1.74 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал кастинг мам женщин"
]
1.70 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.81%)
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.