GET https://search.jues.net/search/embeds/10?q=homemade%20real

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.08 ms
(86.68%)
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
  56632
  392401
  419938
  437560
  441808
  441892
  458541
  475560
  485929
  487896
  490158
  493994
  507816
  531937
  535865
  550914
  551534
  553443
  557728
  558570
  559657
  561431
  561571
  564533
  566817
  585334
  588483
  603761
  610517
  613981
  614880
  620716
  620938
  622855
  622870
  628828
  630098
  642996
  643334
  648033
  654256
  654261
  657735
  658555
  671193
  673880
  675491
  680584
  681371
  681490
  681797
  685263
  686753
  687466
  703235
  704673
  705111
  707569
  707915
  709937
  712582
  712952
  714855
  716270
  718868
  719325
  726818
  730641
  731361
  732984
  733330
  737126
  741796
  744493
  748263
  748304
  751507
  764518
  765063
  767193
  773621
  775606
  776042
  777862
  780883
  782387
  782654
  783963
  786756
  789437
  789597
  791235
  791895
  792479
  794877
  795089
  795895
  796399
  796916
  801094
  801145
  801182
  801572
  801580
  802166
  803026
  803651
  804902
  805239
  805533
  806849
  808048
  808585
  810856
  813016
  814283
  817688
  818753
  818833
]
11.01 ms
(7.39%)
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
  730641
  748263
  765063
  726818
  737126
  762399
  767193
  731361
  773621
  703235
  714855
  776042
  780883
  802166
  806849
  810856
  441808
  475560
  675491
  559657
  557728
  535865
  620716
  707569
  553443
  564533
  566817
  681490
  709937
  704673
  705111
  654256
  654261
  657735
  673880
  558570
  685263
  716270
  603761
  628828
  681797
  719325
  707915
  561431
  671193
  680584
  681371
  687466
  686753
  622855
  622870
  610517
  613981
  643334
  614880
  801182
  733330
  789437
  751507
  630098
  531937
  648033
  658555
  712952
  585334
  744493
  801094
  801145
  808585
  813016
  764518
  392401
  419938
  818833
  814283
  818753
  817688
  485929
  458541
  487896
  561571
  550914
  712582
  718868
  588483
  620938
  642996
  777862
  783963
  792479
  796916
  801572
  801580
  782654
  786756
  794877
  795089
  805239
  805533
  791895
  795895
  796399
  803026
  804902
  732984
  741796
  748304
  775606
  782387
  789597
  791235
  803651
  808048
  56632
  437560
  441892
  507816
  490158
  493994
  551534
]
2.17 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
  56632
  392401
  419938
  437560
  441808
  441892
  458541
  475560
  485929
  487896
  490158
  493994
  507816
  531937
  535865
  550914
  551534
  553443
  557728
  558570
  559657
  561431
  561571
  564533
  566817
  585334
  588483
  603761
  610517
  613981
  614880
  620716
  620938
  622855
  622870
  628828
  630098
  642996
  643334
  648033
  654256
  654261
  657735
  658555
  671193
  673880
  675491
  680584
  681371
  681490
  681797
  685263
  686753
  687466
  703235
  704673
  705111
  707569
  707915
  709937
  712582
  712952
  714855
  716270
  718868
  719325
  726818
  730641
  731361
  732984
  733330
  737126
  741796
  744493
  748263
  748304
  751507
  764518
  765063
  767193
  773621
  775606
  776042
  777862
  780883
  782387
  782654
  783963
  786756
  789437
  789597
  791235
  791895
  792479
  794877
  795089
  795895
  796399
  796916
  801094
  801145
  801182
  801572
  801580
  802166
  803026
  803651
  804902
  805239
  805533
  806849
  808048
  808585
  810856
  813016
  814283
  817688
  818753
  818833
]
1.81 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск real"
]
1.73 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade real"
]
1.60 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск real"
]

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.