GET https://search.jues.net/search/embeds/2?q=boyfriend%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.62 ms
(81.22%)
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
  6670
  12326
  325984
  390402
  393562
  395871
  398201
  401140
  404587
  407881
  417408
  421215
  424194
  424996
  428624
  429012
  429877
  436849
  439038
  443061
  443861
  448378
  453135
  453793
  455108
  461716
  463933
  463948
  464725
  465868
  469748
  470782
  472452
  476800
  481040
  481908
  485145
  485311
  489818
  505815
  508777
  516922
  519925
  523364
  527859
  535453
  544127
  544849
  546665
  549081
  553223
  561694
  563864
  565158
  576933
  577130
  577321
  580236
  589472
  598473
  602007
  609130
  609743
  617959
  618939
  619506
  623435
  624220
  631954
  637098
  637654
  644301
  648880
  651851
  654026
  660277
  660750
  663232
  676468
  676972
  677677
  687964
  700617
  717835
  721088
  721369
  721393
  722785
  722882
  723153
  725108
  727923
  734800
  740277
  740793
  744639
  744723
  747755
  751120
  752566
  766302
  766763
  767611
  770298
  770819
  781447
  792619
  793900
  800931
  803460
  808456
  809811
  810401
  813408
  814787
  817608
  819571
  823707
  825585
  827919
]
20.05 ms
(11.92%)
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
  428624
  465868
  485311
  563864
  744723
  436849
  508777
  519925
  577130
  404587
  817608
  472452
  723153
  589472
  770298
  429877
  325984
  455108
  660277
  544127
  722882
  676972
  637654
  808456
  747755
  767611
  700617
  453793
  544849
  489818
  398201
  439038
  463948
  576933
  651851
  619506
  727923
  751120
  721393
  407881
  470782
  448378
  527859
  535453
  443861
  823707
  825585
  654026
  660750
  663232
  722785
  618939
  793900
  800931
  809811
  752566
  624220
  721369
  803460
  12326
  734800
  424996
  481040
  549081
  553223
  602007
  623435
  766763
  463933
  505815
  485145
  577321
  687964
  598473
  770819
  453135
  481908
  464725
  565158
  561694
  546665
  744639
  443061
  6670
  401140
  395871
  417408
  424194
  819571
  814787
  677677
  617959
  609743
  644301
  810401
  813408
  740793
  725108
  766302
  637098
  717835
  721088
  781447
  390402
  461716
  827919
  429012
  580236
  792619
  476800
  516922
  421215
  523364
  648880
  676468
  609130
  631954
  740277
  469748
  393562
]
3.78 ms
(2.25%)
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
  6670
  12326
  325984
  390402
  393562
  395871
  398201
  401140
  404587
  407881
  417408
  421215
  424194
  424996
  428624
  429012
  429877
  436849
  439038
  443061
  443861
  448378
  453135
  453793
  455108
  461716
  463933
  463948
  464725
  465868
  469748
  470782
  472452
  476800
  481040
  481908
  485145
  485311
  489818
  505815
  508777
  516922
  519925
  523364
  527859
  535453
  544127
  544849
  546665
  549081
  553223
  561694
  563864
  565158
  576933
  577130
  577321
  580236
  589472
  598473
  602007
  609130
  609743
  617959
  618939
  619506
  623435
  624220
  631954
  637098
  637654
  644301
  648880
  651851
  654026
  660277
  660750
  663232
  676468
  676972
  677677
  687964
  700617
  717835
  721088
  721369
  721393
  722785
  722882
  723153
  725108
  727923
  734800
  740277
  740793
  744639
  744723
  747755
  751120
  752566
  766302
  766763
  767611
  770298
  770819
  781447
  792619
  793900
  800931
  803460
  808456
  809811
  810401
  813408
  814787
  817608
  819571
  823707
  825585
  827919
]
2.24 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boyfriend anal"
]
1.91 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "boyfriend анал"
]
1.77 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "boyfriend анал"
]

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.