Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.97 ms
(82.83%)
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
  8824
  254390
  403562
  411750
  414788
  415843
  415879
  426557
  428128
  435522
  448443
  450390
  455326
  456612
  465329
  477555
  484951
  487470
  494122
  495038
  497408
  504007
  505348
  506458
  508730
  509576
  510098
  511951
  513625
  515308
  516482
  517807
  518756
  519436
  519878
  524790
  526193
  527258
  543268
  544609
  545130
  546881
  546902
  547707
  547756
  554210
  554908
  555417
  558325
  558889
  559182
  560458
  563041
  563108
  574085
  580359
  581978
  584045
  584377
  585311
  589444
  594170
  595992
  598095
  606945
  614424
  615277
  616554
  620059
  640367
  640492
  645518
  649743
  651853
  660120
  668959
  669261
  669851
  669895
  671553
  673056
  688307
  696614
  709323
  712116
  731557
  733388
  738292
  741036
  741266
  746042
  746615
  750771
  752197
  754001
  756493
  757415
  761281
  772032
  773101
  776464
  788751
  789449
  793524
  794097
  794168
  794508
  794754
  796712
  803307
  804835
  807008
  807334
  808078
  815100
  815108
  817538
  818568
  824563
  826506
]
16.07 ms
(10.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
  757415
  772032
  741036
  756493
  606945
  254390
  494122
  415843
  518756
  517807
  426557
  554210
  455326
  516482
  660120
  673056
  584045
  595992
  807334
  746615
  414788
  506458
  513625
  450390
  484951
  546902
  554908
  559182
  558325
  560458
  546881
  620059
  435522
  510098
  527258
  508730
  524790
  509576
  8824
  826506
  818568
  817538
  824563
  558889
  545130
  543268
  547707
  696614
  651853
  669851
  688307
  645518
  649743
  668959
  669261
  669895
  712116
  589444
  615277
  640367
  585311
  598095
  616554
  594170
  793524
  794508
  803307
  807008
  738292
  752197
  761281
  788751
  789449
  794168
  794754
  808078
  731557
  741266
  750771
  733388
  746042
  773101
  754001
  614424
  640492
  709323
  776464
  794097
  796712
  804835
  815108
  456612
  477555
  411750
  403562
  415879
  465329
  497408
  519436
  547756
  580359
  563041
  563108
  581978
  584377
  428128
  448443
  487470
  511951
  519878
  495038
  815100
  505348
  504007
  515308
  526193
  544609
  555417
  574085
  671553
]
3.38 ms
(2.16%)
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
  8824
  254390
  403562
  411750
  414788
  415843
  415879
  426557
  428128
  435522
  448443
  450390
  455326
  456612
  465329
  477555
  484951
  487470
  494122
  495038
  497408
  504007
  505348
  506458
  508730
  509576
  510098
  511951
  513625
  515308
  516482
  517807
  518756
  519436
  519878
  524790
  526193
  527258
  543268
  544609
  545130
  546881
  546902
  547707
  547756
  554210
  554908
  555417
  558325
  558889
  559182
  560458
  563041
  563108
  574085
  580359
  581978
  584045
  584377
  585311
  589444
  594170
  595992
  598095
  606945
  614424
  615277
  616554
  620059
  640367
  640492
  645518
  649743
  651853
  660120
  668959
  669261
  669851
  669895
  671553
  673056
  688307
  696614
  709323
  712116
  731557
  733388
  738292
  741036
  741266
  746042
  746615
  750771
  752197
  754001
  756493
  757415
  761281
  772032
  773101
  776464
  788751
  789449
  793524
  794097
  794168
  794508
  794754
  796712
  803307
  804835
  807008
  807334
  808078
  815100
  815108
  817538
  818568
  824563
  826506
]
2.26 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "your mother"
]
1.91 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "your мам женщин"
]
1.56 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "your мам женщин"
]

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.