Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
286.21 ms
(90.27%)
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
  391725
  397295
  401757
  410770
  411258
  412177
  416143
  418911
  420849
  420877
  423766
  431948
  434544
  435060
  437829
  441559
  446993
  447070
  447937
  452425
  453945
  454405
  455897
  457809
  463407
  469662
  473754
  475455
  475472
  476900
  478145
  478764
  480037
  483761
  484160
  489703
  493465
  496150
  496428
  502209
  502230
  506477
  511246
  516440
  516564
  520526
  522084
  522286
  522715
  522960
  524487
  526560
  527386
  531326
  532212
  535280
  535934
  538520
  542154
  547429
  551511
  552669
  555463
  556219
  558228
  560273
  561330
  566294
  566537
  570135
  570396
  572339
  576509
  580282
  581033
  581072
  583502
  584858
  585417
  604625
  610504
  616790
  616795
  621220
  636951
  639295
  639924
  652586
  687453
  696126
  698880
  698883
  704161
  710953
  718877
  720096
  721431
  733560
  740879
  740904
  751597
  752840
  760214
  760313
  767976
  769077
  770303
  784054
  787959
  790256
  792137
  796307
  798670
  804117
  804562
  805660
  806614
  808101
  812993
  823454
]
20.20 ms
(6.37%)
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
  710953
  493465
  516440
  489703
  391725
  687453
  457809
  416143
  418911
  431948
  441559
  823454
  453945
  447070
  483761
  475455
  478764
  480037
  496428
  496150
  484160
  555463
  560273
  581033
  576509
  718877
  720096
  547429
  616795
  636951
  639295
  790256
  792137
  804562
  806614
  740879
  740904
  760214
  784054
  787959
  796307
  804117
  805660
  808101
  751597
  760313
  769077
  733560
  752840
  767976
  770303
  604625
  698880
  721431
  812993
  412177
  423766
  411258
  452425
  535934
  516564
  397295
  446993
  455897
  469662
  520526
  538520
  522960
  522715
  524487
  566537
  572339
  542154
  551511
  698883
  652586
  696126
  704161
  552669
  558228
  566294
  580282
  583502
  616790
  639924
  610504
  585417
  798670
  621220
  401757
  435060
  506477
  420849
  434544
  437829
  410770
  420877
  447937
  454405
  478145
  475472
  527386
  502230
  502209
  511246
  526560
  531326
  532212
  535280
  522084
  522286
  463407
  473754
  476900
  561330
  584858
  556219
  570135
  570396
  581072
]
3.86 ms
(1.22%)
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
  391725
  397295
  401757
  410770
  411258
  412177
  416143
  418911
  420849
  420877
  423766
  431948
  434544
  435060
  437829
  441559
  446993
  447070
  447937
  452425
  453945
  454405
  455897
  457809
  463407
  469662
  473754
  475455
  475472
  476900
  478145
  478764
  480037
  483761
  484160
  489703
  493465
  496150
  496428
  502209
  502230
  506477
  511246
  516440
  516564
  520526
  522084
  522286
  522715
  522960
  524487
  526560
  527386
  531326
  532212
  535280
  535934
  538520
  542154
  547429
  551511
  552669
  555463
  556219
  558228
  560273
  561330
  566294
  566537
  570135
  570396
  572339
  576509
  580282
  581033
  581072
  583502
  584858
  585417
  604625
  610504
  616790
  616795
  621220
  636951
  639295
  639924
  652586
  687453
  696126
  698880
  698883
  704161
  710953
  718877
  720096
  721431
  733560
  740879
  740904
  751597
  752840
  760214
  760313
  767976
  769077
  770303
  784054
  787959
  790256
  792137
  796307
  798670
  804117
  804562
  805660
  806614
  808101
  812993
  823454
]
1.92 ms
(0.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск first"
]
1.77 ms
(0.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur first"
]
1.44 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск first"
]

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.