GET https://search.jues.net/search/embeds/4?q=domina%20facesitting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.31 ms
(87.47%)
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
  12887
  381878
  386709
  390082
  390231
  390610
  391546
  416926
  416928
  417065
  419840
  419847
  420475
  421249
  424477
  424492
  425491
  426424
  426623
  427141
  434838
  436440
  442143
  442280
  445394
  446090
  447230
  448040
  448043
  448052
  448064
  448069
  448077
  449265
  449317
  449331
  453746
  454220
  454273
  454292
  456367
  456387
  456407
  456689
  459471
  460970
  464232
  464544
  464546
  465476
  465731
  466163
  468616
  469263
  470128
  470513
  471441
  472285
  474467
  477683
  479138
  479255
  482547
  482566
  484495
  485051
  487382
  487479
  487907
  488951
  490684
  490729
  494185
  496884
  497904
  498195
  499417
  499474
  500860
  508963
  509498
  510172
  510555
  511155
  513341
  514210
  519762
  521226
  525197
  529322
  530345
  532898
  533195
  533256
  533258
  533260
  534261
  538957
  540073
  540187
  540195
  540370
  542397
  542412
  544501
  548568
  556847
  556852
  565252
  569423
  576519
  610228
  614627
  614942
  624227
  641778
  646880
  784275
  817115
  820147
]
19.58 ms
(8.38%)
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
  445394
  482566
  482547
  448043
  465476
  449265
  454220
  454292
  464546
  468616
  470128
  488951
  448040
  464544
  471441
  474467
  477683
  533256
  533260
  540370
  494185
  540187
  540195
  498195
  499417
  510172
  533258
  538957
  542412
  548568
  542397
  544501
  646880
  556847
  614627
  641778
  381878
  391546
  442143
  465731
  470513
  424477
  426424
  390231
  434838
  454273
  479255
  511155
  514210
  484495
  487382
  519762
  472285
  425491
  496884
  500860
  497904
  460970
  576519
  416926
  456367
  448069
  499474
  479138
  436440
  459471
  446090
  448077
  449317
  490684
  513341
  508963
  510555
  532898
  614942
  386709
  12887
  390082
  390610
  419840
  421249
  419847
  416928
  427141
  442280
  817115
  820147
  456387
  456407
  448064
  449331
  456689
  485051
  509498
  521226
  534261
  530345
  529322
  540073
  533195
  487479
  565252
  569423
  556852
  610228
  784275
  624227
  453746
  469263
  447230
  448052
  420475
  424492
  426623
  464232
  466163
  490729
  525197
  487907
  417065
]
2.93 ms
(1.26%)
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
  12887
  381878
  386709
  390082
  390231
  390610
  391546
  416926
  416928
  417065
  419840
  419847
  420475
  421249
  424477
  424492
  425491
  426424
  426623
  427141
  434838
  436440
  442143
  442280
  445394
  446090
  447230
  448040
  448043
  448052
  448064
  448069
  448077
  449265
  449317
  449331
  453746
  454220
  454273
  454292
  456367
  456387
  456407
  456689
  459471
  460970
  464232
  464544
  464546
  465476
  465731
  466163
  468616
  469263
  470128
  470513
  471441
  472285
  474467
  477683
  479138
  479255
  482547
  482566
  484495
  485051
  487382
  487479
  487907
  488951
  490684
  490729
  494185
  496884
  497904
  498195
  499417
  499474
  500860
  508963
  509498
  510172
  510555
  511155
  513341
  514210
  519762
  521226
  525197
  529322
  530345
  532898
  533195
  533256
  533258
  533260
  534261
  538957
  540073
  540187
  540195
  540370
  542397
  542412
  544501
  548568
  556847
  556852
  565252
  569423
  576519
  610228
  614627
  614942
  624227
  641778
  646880
  784275
  817115
  820147
]
1.95 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "domina facesitting"
]
1.67 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "доминирован фейсситтинг"
]
1.31 ms
(0.56%)
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.