Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.66 ms
(80.64%)
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
  7449
  54117
  68292
  81588
  83152
  107348
  109218
  123457
  151455
  165570
  209931
  337088
  348358
  383932
  385337
  386645
  387085
  391468
  392325
  396168
  396307
  397793
  400467
  402605
  405082
  405995
  409173
  415055
  487921
  492552
  492601
  492610
  493015
  494706
  495022
  497515
  499891
  503955
  508818
  509369
  512103
  523262
  523532
  530107
  530543
  530559
  533796
  537608
  537628
  541332
  542947
  548257
  555555
  558296
  558299
  559208
  561997
  573321
  579632
  580646
  581663
  581797
  597831
  601538
  605500
  608808
  615810
  618757
  621691
  622062
  622451
  623132
  624842
  628887
  635781
  641094
  644384
  648906
  657101
  657315
  657371
  657706
  659833
  665502
  665512
  666779
  669749
  673041
  679397
  687149
  688019
  701297
  708469
  710786
  715411
  719138
  720439
  721993
  723361
  724910
  725351
  725902
  732871
  735030
  748742
  754228
  755736
  755856
  758107
  760490
  778453
  780877
  782721
  783780
  786515
  788912
  799603
  801265
  804348
  819550
]
20.66 ms
(13.16%)
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
  396307
  397793
  405082
  499891
  509369
  487921
  492552
  512103
  523262
  492601
  492610
  497515
  503955
  523532
  541332
  493015
  508818
  386645
  385337
  151455
  165570
  530107
  530543
  537628
  558299
  542947
  657315
  665502
  687149
  628887
  622062
  635781
  618757
  622451
  783780
  780877
  782721
  755736
  788912
  804348
  735030
  758107
  732871
  748742
  754228
  725902
  755856
  760490
  641094
  720439
  387085
  415055
  7449
  337088
  548257
  580646
  581663
  561997
  581797
  597831
  605500
  624842
  621691
  601538
  396168
  495022
  68292
  83152
  383932
  209931
  109218
  107348
  123457
  392325
  348358
  81588
  54117
  391468
  400467
  402605
  405995
  409173
  819550
  530559
  533796
  537608
  494706
  573321
  579632
  555555
  558296
  559208
  665512
  669749
  688019
  708469
  719138
  657371
  673041
  701297
  648906
  657101
  657706
  659833
  666779
  679397
  710786
  715411
  721993
  723361
  623132
  644384
  608808
  615810
  778453
  786515
  799603
  801265
  724910
  725351
]
2.96 ms
(1.89%)
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
  7449
  54117
  68292
  81588
  83152
  107348
  109218
  123457
  151455
  165570
  209931
  337088
  348358
  383932
  385337
  386645
  387085
  391468
  392325
  396168
  396307
  397793
  400467
  402605
  405082
  405995
  409173
  415055
  487921
  492552
  492601
  492610
  493015
  494706
  495022
  497515
  499891
  503955
  508818
  509369
  512103
  523262
  523532
  530107
  530543
  530559
  533796
  537608
  537628
  541332
  542947
  548257
  555555
  558296
  558299
  559208
  561997
  573321
  579632
  580646
  581663
  581797
  597831
  601538
  605500
  608808
  615810
  618757
  621691
  622062
  622451
  623132
  624842
  628887
  635781
  641094
  644384
  648906
  657101
  657315
  657371
  657706
  659833
  665502
  665512
  666779
  669749
  673041
  679397
  687149
  688019
  701297
  708469
  710786
  715411
  719138
  720439
  721993
  723361
  724910
  725351
  725902
  732871
  735030
  748742
  754228
  755736
  755856
  758107
  760490
  778453
  780877
  782721
  783780
  786515
  788912
  799603
  801265
  804348
  819550
]
1.90 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин"
]
1.74 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мужчин"
]
1.69 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "man such"
]
1.44 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.