Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.20 ms
(82.24%)
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
  75936
  389062
  397605
  407562
  420293
  422243
  423966
  427359
  428054
  437305
  441838
  445112
  450315
  450563
  450816
  453021
  453496
  453512
  453620
  454973
  455730
  455757
  458320
  459098
  459372
  459899
  460406
  460757
  460923
  463173
  464015
  464545
  466941
  467835
  467914
  470504
  476495
  477715
  479038
  483367
  485330
  485980
  488993
  489285
  491157
  494592
  499051
  502600
  503773
  508163
  509639
  511083
  513975
  514301
  517451
  518828
  525545
  526642
  526967
  528707
  548036
  556436
  559036
  559038
  562962
  584048
  589642
  599550
  618294
  620438
  622240
  631322
  654634
  700611
  702616
  724592
  726537
  726556
  726698
  731004
  733155
  733481
  734352
  736285
  744150
  744156
  744216
  744831
  750284
  755600
  756318
  759763
  763152
  766236
  768896
  793713
  793810
  794506
  796273
  800152
  801796
  804398
  804414
  804579
  810715
  823598
  824641
  824642
  824953
  825065
  825973
  826060
  826335
  826448
  826489
  826594
  826695
  827308
  827483
  827711
]
18.19 ms
(11.76%)
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
  726698
  459899
  459098
  731004
  494592
  599550
  724592
  826695
  826448
  463173
  702616
  460406
  407562
  476495
  467835
  589642
  420293
  518828
  428054
  548036
  810715
  511083
  825065
  744831
  75936
  389062
  513975
  654634
  499051
  503773
  744156
  750284
  823598
  454973
  460923
  445112
  827483
  397605
  455757
  464545
  562962
  793713
  559038
  459372
  631322
  733155
  756318
  450816
  427359
  824641
  826060
  826335
  744216
  491157
  559036
  824642
  755600
  441838
  464015
  458320
  517451
  526967
  422243
  526642
  827308
  827711
  824953
  825973
  508163
  479038
  467914
  485980
  826489
  733481
  453021
  804414
  453496
  509639
  556436
  453512
  437305
  759763
  763152
  804579
  801796
  450563
  618294
  584048
  800152
  477715
  744150
  489285
  768896
  793810
  466941
  528707
  460757
  450315
  485330
  423966
  622240
  766236
  736285
  470504
  488993
  525545
  804398
  794506
  734352
  726556
  453620
  620438
  483367
  826594
  502600
  514301
  700611
  726537
  455730
  796273
]
2.24 ms
(1.45%)
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
  75936
  389062
  397605
  407562
  420293
  422243
  423966
  427359
  428054
  437305
  441838
  445112
  450315
  450563
  450816
  453021
  453496
  453512
  453620
  454973
  455730
  455757
  458320
  459098
  459372
  459899
  460406
  460757
  460923
  463173
  464015
  464545
  466941
  467835
  467914
  470504
  476495
  477715
  479038
  483367
  485330
  485980
  488993
  489285
  491157
  494592
  499051
  502600
  503773
  508163
  509639
  511083
  513975
  514301
  517451
  518828
  525545
  526642
  526967
  528707
  548036
  556436
  559036
  559038
  562962
  584048
  589642
  599550
  618294
  620438
  622240
  631322
  654634
  700611
  702616
  724592
  726537
  726556
  726698
  731004
  733155
  733481
  734352
  736285
  744150
  744156
  744216
  744831
  750284
  755600
  756318
  759763
  763152
  766236
  768896
  793713
  793810
  794506
  796273
  800152
  801796
  804398
  804414
  804579
  810715
  823598
  824641
  824642
  824953
  825065
  825973
  826060
  826335
  826448
  826489
  826594
  826695
  827308
  827483
  827711
]
2.08 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"полные домашнее куниÐ%…"
]
2.00 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "полная домашн любительск куннилингус оральн секс"
]
1.40 ms
(0.90%)
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.