Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.88 ms
(80.35%)
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
  188269
  413033
  414375
  419475
  420336
  420604
  421691
  436770
  441466
  442186
  442556
  444316
  445243
  449883
  450472
  451469
  452838
  454262
  454392
  456766
  456980
  460067
  460115
  460120
  460784
  461613
  462531
  465079
  468267
  472063
  473395
  473457
  475119
  475544
  477797
  481654
  482061
  482790
  486399
  486422
  486672
  490704
  491450
  495259
  497026
  498038
  498054
  504001
  505202
  507217
  507561
  508221
  508778
  512205
  512505
  513061
  513084
  513536
  513538
  514279
  515226
  515786
  515836
  517094
  517961
  519061
  519547
  519785
  519948
  519949
  522000
  524341
  524607
  525369
  526087
  527089
  529477
  538281
  544865
  549643
  552978
  555118
  555968
  555970
  563146
  573175
  573486
  576616
  580391
  583677
  584168
  586494
  586503
  593238
  593275
  593299
  593348
  593359
  593363
  593368
  593413
  593485
  593529
  593532
  593536
  599414
  601634
  604923
  607618
  615925
  625171
  641130
  644567
  647964
  648817
  653407
  675537
  688332
  717860
  814749
]
18.25 ms
(12.44%)
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
  450472
  451469
  456980
  460784
  465079
  460120
  475544
  482061
  468267
  505202
  513538
  517961
  522000
  486422
  504001
  508778
  527089
  507217
  517094
  524607
  490704
  491450
  507561
  514279
  515786
  515836
  519785
  441466
  436770
  814749
  475119
  449883
  460115
  452838
  454392
  472063
  477797
  512205
  513084
  513536
  519948
  508221
  544865
  552978
  563146
  717860
  647964
  653407
  555970
  576616
  580391
  593299
  593485
  593532
  593536
  604923
  644567
  593368
  593359
  599414
  615925
  601634
  607618
  625171
  641130
  442186
  445243
  454262
  481654
  188269
  420336
  456766
  461613
  414375
  420604
  421691
  473395
  519949
  525369
  486672
  519547
  497026
  495259
  529477
  444316
  473457
  482790
  519061
  524341
  549643
  584168
  573175
  555968
  688332
  555118
  593238
  593348
  593363
  593529
  593275
  593413
  586494
  586503
  413033
  419475
  442556
  462531
  460067
  512505
  513061
  526087
  486399
  515226
  498038
  538281
  498054
  573486
  583677
  675537
  648817
]
3.40 ms
(2.32%)
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
  188269
  413033
  414375
  419475
  420336
  420604
  421691
  436770
  441466
  442186
  442556
  444316
  445243
  449883
  450472
  451469
  452838
  454262
  454392
  456766
  456980
  460067
  460115
  460120
  460784
  461613
  462531
  465079
  468267
  472063
  473395
  473457
  475119
  475544
  477797
  481654
  482061
  482790
  486399
  486422
  486672
  490704
  491450
  495259
  497026
  498038
  498054
  504001
  505202
  507217
  507561
  508221
  508778
  512205
  512505
  513061
  513084
  513536
  513538
  514279
  515226
  515786
  515836
  517094
  517961
  519061
  519547
  519785
  519948
  519949
  522000
  524341
  524607
  525369
  526087
  527089
  529477
  538281
  544865
  549643
  552978
  555118
  555968
  555970
  563146
  573175
  573486
  576616
  580391
  583677
  584168
  586494
  586503
  593238
  593275
  593299
  593348
  593359
  593363
  593368
  593413
  593485
  593529
  593532
  593536
  599414
  601634
  604923
  607618
  615925
  625171
  641130
  644567
  647964
  648817
  653407
  675537
  688332
  717860
  814749
]
2.12 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "nurse 2009"
]
1.77 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "врачих"
]
1.55 ms
(1.06%)
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.