Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.00 ms
(87.19%)
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
  16679
  21500
  73421
  96955
  108054
  146341
  207970
  339474
  339770
  382078
  386057
  388542
  389176
  397980
  405716
  410180
  410954
  413417
  414055
  416297
  417849
  418547
  418729
  418840
  418861
  418866
  418895
  420126
  423563
  423658
  424535
  425440
  425545
  426809
  428335
  430309
  431421
  432753
  437552
  446762
  446813
  447671
  447849
  448650
  448862
  451696
  452372
  452400
  453316
  453957
  454785
  455801
  456832
  457118
  457936
  466397
  466542
  466738
  469181
  469270
  471193
  474551
  475277
  477126
  477575
  479616
  483048
  486234
  486751
  488510
  488551
  489766
  490040
  491126
  491465
  494820
  495221
  496106
  498077
  499964
  500453
  505970
  508957
  511097
  511392
  516407
  519215
  520711
  520872
  522977
  523142
  525752
  527416
  528125
  528406
  528843
  529279
  549317
  551137
  556704
  560242
  560453
  565889
  567375
  572304
  572758
  573196
  580895
  582346
  583852
  584007
  587202
  592959
  614036
  615812
  627810
  716675
  730575
  752517
  789870
]
15.97 ms
(8.00%)
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
  96955
  730575
  420126
  423563
  551137
  528125
  567375
  418861
  431421
  520711
  523142
  382078
  495221
  587202
  457118
  483048
  489766
  486751
  479616
  451696
  519215
  520872
  752517
  448862
  73421
  437552
  417849
  432753
  522977
  418895
  446813
  457936
  455801
  491126
  505970
  474551
  582346
  389176
  418866
  452372
  454785
  486234
  572758
  471193
  475277
  488510
  508957
  511097
  528843
  560242
  716675
  580895
  627810
  466397
  499964
  572304
  573196
  560453
  556704
  425545
  500453
  494820
  108054
  413417
  424535
  490040
  388542
  453316
  496106
  146341
  516407
  592959
  615812
  386057
  339770
  16679
  405716
  418840
  491465
  565889
  789870
  469270
  469181
  477126
  477575
  447671
  453957
  207970
  339474
  397980
  527416
  466542
  584007
  447849
  529279
  614036
  528406
  488551
  416297
  418729
  426809
  428335
  418547
  414055
  583852
  549317
  410180
  425440
  430309
  21500
  498077
  525752
  410954
  446762
  452400
  448650
  456832
  511392
  466738
  423658
]
2.56 ms
(1.28%)
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
  16679
  21500
  73421
  96955
  108054
  146341
  207970
  339474
  339770
  382078
  386057
  388542
  389176
  397980
  405716
  410180
  410954
  413417
  414055
  416297
  417849
  418547
  418729
  418840
  418861
  418866
  418895
  420126
  423563
  423658
  424535
  425440
  425545
  426809
  428335
  430309
  431421
  432753
  437552
  446762
  446813
  447671
  447849
  448650
  448862
  451696
  452372
  452400
  453316
  453957
  454785
  455801
  456832
  457118
  457936
  466397
  466542
  466738
  469181
  469270
  471193
  474551
  475277
  477126
  477575
  479616
  483048
  486234
  486751
  488510
  488551
  489766
  490040
  491126
  491465
  494820
  495221
  496106
  498077
  499964
  500453
  505970
  508957
  511097
  511392
  516407
  519215
  520711
  520872
  522977
  523142
  525752
  527416
  528125
  528406
  528843
  529279
  549317
  551137
  556704
  560242
  560453
  565889
  567375
  572304
  572758
  573196
  580895
  582346
  583852
  584007
  587202
  592959
  614036
  615812
  627810
  716675
  730575
  752517
  789870
]
2.10 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "члены мужчин подборка…"
]
1.90 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член мужчин подборк"
]
1.61 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.71%)
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.