GET https://search.jues.net/search/embeds/4?q=sex%20and%20submission

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.48 ms
(89.79%)
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
  190870
  311235
  381869
  385899
  413612
  429508
  443115
  443471
  444198
  446137
  446992
  449952
  460974
  477498
  482599
  485334
  490780
  494274
  494734
  503176
  505187
  511638
  513979
  521211
  521218
  522163
  522869
  530670
  531251
  531570
  533274
  533500
  540095
  542167
  543736
  543856
  546219
  546820
  547572
  551888
  552070
  556432
  556507
  559111
  559142
  559192
  561127
  563168
  567389
  569720
  569743
  569764
  569770
  574000
  574263
  576081
  576165
  580592
  585583
  585780
  588814
  590381
  591079
  592984
  594411
  594980
  601470
  605025
  606035
  616400
  618745
  619088
  624228
  624504
  625229
  632293
  632557
  667944
  668012
  706928
  706929
  715826
  716132
  719825
  722677
  722966
  731170
  731276
  734371
  734373
  738631
  739861
  742865
  745305
  750789
  751431
  758494
  760760
  763296
  763369
  769471
  770293
  785607
  789172
  790038
  790078
  793934
  798117
  800236
  801593
  801608
  802105
  802125
  802740
  803928
  812057
  814685
  819564
  819585
  819608
]
11.25 ms
(5.28%)
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
  551888
  790078
  751431
  556507
  556432
  715826
  618745
  758494
  763296
  793934
  802740
  429508
  591079
  503176
  569720
  567389
  624228
  632293
  552070
  576081
  731170
  561127
  706929
  812057
  531251
  814685
  543856
  542167
  569743
  760760
  763369
  443115
  477498
  381869
  446137
  505187
  533500
  546820
  619088
  594980
  616400
  798117
  734371
  745305
  750789
  769471
  460974
  819585
  494274
  531570
  543736
  706928
  625229
  800236
  739861
  485334
  559111
  632557
  569764
  574000
  580592
  731276
  790038
  722677
  803928
  530670
  559142
  802125
  449952
  513979
  590381
  802105
  190870
  569770
  742865
  443471
  444198
  522163
  494734
  563168
  559192
  716132
  719825
  574263
  585780
  801593
  789172
  734373
  738631
  722966
  311235
  413612
  446992
  482599
  490780
  521211
  521218
  511638
  547572
  667944
  606035
  592984
  585583
  594411
  601470
  785607
  801608
  385899
  819564
  576165
  668012
  770293
  605025
  819608
  522869
  546219
  588814
  624504
  540095
  533274
]
2.72 ms
(1.27%)
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
  190870
  311235
  381869
  385899
  413612
  429508
  443115
  443471
  444198
  446137
  446992
  449952
  460974
  477498
  482599
  485334
  490780
  494274
  494734
  503176
  505187
  511638
  513979
  521211
  521218
  522163
  522869
  530670
  531251
  531570
  533274
  533500
  540095
  542167
  543736
  543856
  546219
  546820
  547572
  551888
  552070
  556432
  556507
  559111
  559142
  559192
  561127
  563168
  567389
  569720
  569743
  569764
  569770
  574000
  574263
  576081
  576165
  580592
  585583
  585780
  588814
  590381
  591079
  592984
  594411
  594980
  601470
  605025
  606035
  616400
  618745
  619088
  624228
  624504
  625229
  632293
  632557
  667944
  668012
  706928
  706929
  715826
  716132
  719825
  722677
  722966
  731170
  731276
  734371
  734373
  738631
  739861
  742865
  745305
  750789
  751431
  758494
  760760
  763296
  763369
  769471
  770293
  785607
  789172
  790038
  790078
  793934
  798117
  800236
  801593
  801608
  802105
  802125
  802740
  803928
  812057
  814685
  819564
  819585
  819608
]
2.24 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex and submission"
]
2.15 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс доминирован"
]
1.53 ms
(0.72%)
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.