GET https://search.jues.net/search/embeds/8?q=dick%20and%20dildo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.06 ms
(86.88%)
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
  241603
  287436
  384757
  414339
  416824
  425143
  439532
  444684
  446529
  450518
  463855
  465334
  473428
  474874
  476417
  478775
  479768
  479845
  485468
  489305
  499856
  511372
  514254
  518183
  518419
  519234
  521677
  521850
  522043
  522142
  530791
  530796
  530941
  532345
  536310
  537250
  541832
  541851
  542583
  547235
  550203
  552701
  556476
  561909
  572784
  582526
  590263
  590507
  590696
  590908
  592500
  596226
  601691
  607560
  610083
  613637
  618256
  621125
  622066
  629630
  632794
  633163
  633521
  633768
  636303
  639762
  642038
  645230
  647322
  648583
  650175
  651161
  666470
  671083
  674077
  675019
  676097
  677801
  677986
  678063
  678128
  678144
  678161
  678533
  679728
  695893
  696154
  699718
  704526
  708443
  716900
  716965
  717924
  721106
  721992
  723930
  728072
  745126
  745384
  748257
  749070
  752664
  752676
  755437
  761432
  770213
  770253
  787466
  788567
  799268
  802114
  806271
  811125
  813063
  814270
  816547
  816669
  818387
  819565
  821409
]
20.67 ms
(8.59%)
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
  550203
  542583
  650175
  678144
  678161
  679728
  677801
  677986
  678533
  704526
  647322
  675019
  639762
  636303
  610083
  633521
  633768
  642038
  708443
  463855
  478775
  474874
  476417
  590908
  287436
  816669
  489305
  473428
  519234
  601691
  416824
  541832
  674077
  633163
  537250
  541851
  648583
  552701
  590507
  596226
  632794
  590263
  629630
  439532
  511372
  446529
  530796
  521850
  532345
  530791
  530941
  536310
  678063
  676097
  678128
  716900
  425143
  479768
  522043
  522142
  745384
  622066
  787466
  621125
  241603
  444684
  814270
  818387
  819565
  821409
  816547
  485468
  450518
  499856
  514254
  547235
  572784
  556476
  582526
  561909
  666470
  695893
  645230
  671083
  696154
  721106
  721992
  651161
  699718
  717924
  592500
  590696
  613637
  806271
  752676
  788567
  799268
  811125
  770213
  723930
  745126
  749070
  755437
  728072
  748257
  761432
  770253
  752664
  607560
  618256
  716965
  802114
  813063
  465334
  479845
  518419
  521677
  518183
  384757
  414339
]
4.11 ms
(1.71%)
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
  241603
  287436
  384757
  414339
  416824
  425143
  439532
  444684
  446529
  450518
  463855
  465334
  473428
  474874
  476417
  478775
  479768
  479845
  485468
  489305
  499856
  511372
  514254
  518183
  518419
  519234
  521677
  521850
  522043
  522142
  530791
  530796
  530941
  532345
  536310
  537250
  541832
  541851
  542583
  547235
  550203
  552701
  556476
  561909
  572784
  582526
  590263
  590507
  590696
  590908
  592500
  596226
  601691
  607560
  610083
  613637
  618256
  621125
  622066
  629630
  632794
  633163
  633521
  633768
  636303
  639762
  642038
  645230
  647322
  648583
  650175
  651161
  666470
  671083
  674077
  675019
  676097
  677801
  677986
  678063
  678128
  678144
  678161
  678533
  679728
  695893
  696154
  699718
  704526
  708443
  716900
  716965
  717924
  721106
  721992
  723930
  728072
  745126
  745384
  748257
  749070
  752664
  752676
  755437
  761432
  770213
  770253
  787466
  788567
  799268
  802114
  806271
  811125
  813063
  814270
  816547
  816669
  818387
  819565
  821409
]
2.17 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick and dildo"
]
1.71 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член дилд"
]
1.23 ms
(0.51%)
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.