Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.98 ms
(87.18%)
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
  87363
  106483
  145285
  146414
  147148
  383544
  385428
  385599
  386345
  388226
  394448
  402949
  427029
  453871
  457040
  490144
  492411
  515270
  547340
  547532
  550944
  552756
  559853
  560150
  560910
  560913
  569105
  570850
  588942
  589178
  591232
  592069
  593317
  593342
  593398
  593493
  593521
  605392
  606809
  607733
  616379
  616920
  619908
  620975
  622646
  628291
  628309
  632340
  637740
  649484
  663271
  664670
  664964
  668654
  668679
  669587
  670354
  670450
  671977
  672826
  674116
  675514
  680640
  683932
  685633
  685680
  688064
  690771
  691197
  694148
  695682
  701691
  711000
  715068
  716483
  720341
  723637
  728290
  728376
  730073
  748317
  752533
  752535
  755942
  755949
  755950
  755956
  759861
  761536
  764628
  791151
  792724
  795528
  798864
  803768
  806098
  807700
  807702
  807704
  807705
  807724
  808174
  808175
  808567
  809185
  809704
  811149
  814060
  814064
  815546
  815590
  815629
  815668
  815998
  816583
  817035
  818360
  820957
  827313
  828833
]
13.71 ms
(7.24%)
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
  664670
  670354
  670450
  674116
  680640
  547340
  569105
  593521
  616379
  628291
  591232
  593317
  593342
  593398
  619908
  606809
  807724
  809185
  811149
  798864
  748317
  752535
  755942
  755950
  791151
  807702
  807704
  807705
  808175
  728290
  728376
  752533
  755956
  730073
  755949
  759861
  761536
  764628
  607733
  622646
  711000
  806098
  808174
  809704
  427029
  87363
  394448
  146414
  385428
  385599
  386345
  383544
  106483
  145285
  147148
  388226
  402949
  815629
  818360
  723637
  814064
  815546
  815668
  815590
  816583
  817035
  820957
  814060
  815998
  828833
  827313
  453871
  457040
  490144
  492411
  515270
  550944
  552756
  560150
  560910
  547532
  559853
  560913
  570850
  663271
  664964
  669587
  675514
  691197
  649484
  672826
  685680
  690771
  695682
  716483
  668654
  668679
  671977
  683932
  685633
  688064
  694148
  701691
  715068
  720341
  589178
  592069
  632340
  588942
  616920
  620975
  637740
  593493
  605392
  628309
  803768
  807700
  808567
  792724
  795528
]
2.81 ms
(1.49%)
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
  87363
  106483
  145285
  146414
  147148
  383544
  385428
  385599
  386345
  388226
  394448
  402949
  427029
  453871
  457040
  490144
  492411
  515270
  547340
  547532
  550944
  552756
  559853
  560150
  560910
  560913
  569105
  570850
  588942
  589178
  591232
  592069
  593317
  593342
  593398
  593493
  593521
  605392
  606809
  607733
  616379
  616920
  619908
  620975
  622646
  628291
  628309
  632340
  637740
  649484
  663271
  664670
  664964
  668654
  668679
  669587
  670354
  670450
  671977
  672826
  674116
  675514
  680640
  683932
  685633
  685680
  688064
  690771
  691197
  694148
  695682
  701691
  711000
  715068
  716483
  720341
  723637
  728290
  728376
  730073
  748317
  752533
  752535
  755942
  755949
  755950
  755956
  759861
  761536
  764628
  791151
  792724
  795528
  798864
  803768
  806098
  807700
  807702
  807704
  807705
  807724
  808174
  808175
  808567
  809185
  809704
  811149
  814060
  814064
  815546
  815590
  815629
  815668
  815998
  816583
  817035
  818360
  820957
  827313
  828833
]
2.01 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с медсёстрами"
]
1.98 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "медицин"
]
1.76 ms
(0.93%)
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.