Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.40 ms
(52.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "husband friend жен"
]
168.05 ms
(41.84%)
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
  385285
  392109
  419462
  427441
  437618
  441197
  447732
  454398
  459305
  474831
  479378
  479394
  484352
  485611
  490287
  496543
  509052
  511172
  517607
  518952
  528920
  536959
  543381
  545014
  551095
  556685
  556993
  559572
  568594
  572224
  574978
  575687
  577155
  577213
  579332
  579403
  579557
  579813
  579853
  583467
  588142
  588781
  590898
  592708
  603169
  603265
  604243
  605454
  610510
  623221
  625713
  628718
  635789
  640105
  644102
  648672
  649093
  650867
  653896
  654224
  666457
  667057
  668072
  672281
  675345
  687362
  688567
  689061
  695839
  697223
  700902
  702275
  704314
  707144
  710274
  712959
  715410
  720163
  721156
  728686
  730928
  731195
  732604
  732819
  733241
  733451
  736169
  737465
  739956
  741076
  744368
  745510
  753255
  756755
  757866
  761670
  766702
  767874
  771069
  778701
  785142
  787102
  791174
  793877
  795332
  795779
  795827
  795843
  796497
  797878
  802488
  803248
  803590
  805339
  807544
  809991
  824420
]
16.80 ms
(4.18%)
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
  688567
  667057
  644102
  695839
  697223
  795779
  809991
  791174
  447732
  485611
  545014
  556685
  592708
  796497
  797878
  795843
  757866
  739943
  730928
  715410
  712959
  579853
  628718
  700902
  728686
  672281
  689061
  707144
  648672
  753255
  484352
  518952
  702275
  736169
  764584
  771069
  795332
  635789
  803590
  787102
  479378
  579813
  583467
  720163
  732819
  756755
  704314
  795827
  739956
  603265
  668072
  650867
  710274
  805339
  733241
  807544
  623221
  761670
  721156
  392109
  824420
  536959
  511172
  543381
  675345
  610510
  785142
  732604
  741076
  577213
  737465
  427441
  459305
  528920
  579332
  556993
  588142
  604243
  605454
  802488
  441197
  766702
  385285
  579557
  654224
  744368
  517607
  579403
  574978
  649093
  572224
  577155
  603169
  803248
  731195
  437618
  509052
  778701
  767874
  745510
  419462
  496543
  474831
  568594
  575687
  675594
  687362
  666457
  588781
  625713
  479394
  454398
  490287
  559572
  551095
  653896
  590898
  640105
  793877
  733451
]
2.38 ms
(0.59%)
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
  385285
  392109
  419462
  427441
  437618
  441197
  447732
  454398
  459305
  474831
  479378
  479394
  484352
  485611
  490287
  496543
  509052
  511172
  517607
  518952
  528920
  536959
  543381
  545014
  551095
  556685
  556993
  559572
  568594
  572224
  574978
  575687
  577155
  577213
  579332
  579403
  579557
  579813
  579853
  583467
  588142
  588781
  590898
  592708
  603169
  603265
  604243
  605454
  610510
  623221
  625713
  628718
  635789
  640105
  644102
  648672
  649093
  650867
  653896
  654224
  666457
  667057
  668072
  672281
  675345
  687362
  688567
  689061
  695839
  697223
  700902
  702275
  704314
  707144
  710274
  712959
  715410
  720163
  721156
  728686
  730928
  731195
  732604
  732819
  733241
  733451
  736169
  737465
  739956
  741076
  744368
  745510
  753255
  756755
  757866
  761670
  766702
  767874
  771069
  778701
  785142
  787102
  791174
  793877
  795332
  795779
  795827
  795843
  796497
  797878
  802488
  803248
  803590
  805339
  807544
  809991
  824420
]
1.83 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "husband friend wife"
]
1.57 ms
(0.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "husband friend жен"
]

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.