Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
230.71 ms
(91.04%)
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
  2332
  156487
  181315
  384095
  387324
  401531
  401627
  401652
  401794
  402689
  413223
  442318
  459730
  464442
  471629
  505843
  509881
  510074
  516985
  529718
  530470
  538831
  538940
  542344
  543184
  547265
  549271
  551710
  553841
  556654
  562884
  562911
  570788
  570851
  574183
  583847
  596488
  600311
  606846
  614529
  616117
  616209
  618285
  628297
  636883
  639310
  639841
  641810
  644656
  645917
  649859
  671654
  681002
  681022
  682534
  688100
  689606
  691561
  691830
  693127
  694485
  695919
  708095
  712564
  714586
  715662
  717060
  719994
  720939
  721141
  723731
  726319
  727436
  729649
  735404
  740113
  740842
  741077
  743019
  745696
  750074
  751508
  751610
  752539
  753251
  755463
  755474
  756310
  756394
  757525
  758634
  759776
  760668
  761555
  768552
  769894
  770885
  770925
  771002
  771620
  775605
  779616
  787914
  789735
  789984
  791248
  795163
  795513
  795973
  800885
  801474
  802678
  804478
  805264
  806054
  808079
  815902
  817929
  824491
  828872
]
11.36 ms
(4.48%)
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
  538940
  547265
  551710
  649859
  693127
  714586
  717060
  719994
  553841
  570851
  616117
  628297
  636883
  795513
  802678
  806054
  791248
  753251
  760668
  770925
  771002
  800885
  805264
  727436
  750074
  751610
  769894
  726319
  740842
  745696
  755463
  759776
  740113
  756310
  756394
  771620
  618285
  779616
  808079
  401531
  402689
  562884
  639310
  543184
  689606
  795163
  509881
  741077
  770885
  828872
  743019
  556654
  715662
  712564
  645917
  596488
  815902
  583847
  570788
  775605
  752539
  789735
  795973
  606846
  817929
  691561
  708095
  616209
  600311
  614529
  761555
  464442
  505843
  442318
  401794
  824491
  529718
  691830
  681022
  688100
  681002
  682534
  694485
  720939
  644656
  787914
  801474
  804478
  768552
  723731
  758634
  735404
  2332
  401652
  471629
  401627
  459730
  530470
  538831
  516985
  542344
  549271
  574183
  695919
  671654
  562911
  641810
  639841
  789984
  729649
  757525
  751508
  755474
  721141
  181315
  387324
  413223
  156487
  384095
  510074
]
3.42 ms
(1.35%)
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
  2332
  156487
  181315
  384095
  387324
  401531
  401627
  401652
  401794
  402689
  413223
  442318
  459730
  464442
  471629
  505843
  509881
  510074
  516985
  529718
  530470
  538831
  538940
  542344
  543184
  547265
  549271
  551710
  553841
  556654
  562884
  562911
  570788
  570851
  574183
  583847
  596488
  600311
  606846
  614529
  616117
  616209
  618285
  628297
  636883
  639310
  639841
  641810
  644656
  645917
  649859
  671654
  681002
  681022
  682534
  688100
  689606
  691561
  691830
  693127
  694485
  695919
  708095
  712564
  714586
  715662
  717060
  719994
  720939
  721141
  723731
  726319
  727436
  729649
  735404
  740113
  740842
  741077
  743019
  745696
  750074
  751508
  751610
  752539
  753251
  755463
  755474
  756310
  756394
  757525
  758634
  759776
  760668
  761555
  768552
  769894
  770885
  770925
  771002
  771620
  775605
  779616
  787914
  789735
  789984
  791248
  795163
  795513
  795973
  800885
  801474
  802678
  804478
  805264
  806054
  808079
  815902
  817929
  824491
  828872
]
2.66 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс mom beauty"
]
1.88 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex mom beauty"
]
1.53 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс mom beauty"
]

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.