GET https://search.jues.net/search/embeds/10?q=sexy%20brunette

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.87 ms
(55.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy brunette"
]
140.64 ms
(37.53%)
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
  287315
  381838
  390320
  402093
  402664
  403736
  403891
  410452
  411685
  415552
  417435
  418559
  419979
  420131
  420142
  421795
  428616
  428710
  429288
  429747
  431604
  434006
  435948
  441454
  445387
  447551
  451050
  451624
  453719
  454756
  455632
  455922
  457092
  457202
  461036
  461037
  464548
  465154
  466142
  466405
  470145
  478663
  479469
  480788
  484762
  485461
  490272
  492841
  494418
  494720
  495023
  496682
  497034
  500197
  501801
  507452
  509060
  515004
  518061
  519520
  522835
  526197
  554079
  569498
  572556
  576545
  581520
  587058
  589349
  591003
  594293
  595088
  598261
  599105
  602314
  603702
  604904
  605758
  608038
  615031
  625169
  626119
  630777
  630871
  643488
  646022
  654174
  660359
  668398
  669071
  670366
  670372
  674941
  695868
  705669
  710638
  716459
  719141
  731371
  732323
  742281
  748257
  756230
  757365
  758133
  759870
  759948
  761598
  765298
  780475
  780595
  796129
  797437
  799190
  801974
  803784
  810408
  810983
  814790
]
17.22 ms
(4.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
  669071
  695868
  705669
  719141
  670366
  670372
  674941
  646022
  654174
  660359
  710638
  554079
  569498
  572556
  576545
  581520
  591003
  598261
  602314
  589349
  599105
  604621
  625169
  643488
  594293
  595088
  603702
  604904
  605758
  626119
  630777
  587058
  608038
  630871
  780475
  780595
  803784
  759948
  761598
  765298
  796129
  810408
  810983
  731371
  758133
  759870
  742281
  756230
  732323
  748257
  757365
  615031
  716459
  797437
  799190
  801974
  420131
  435948
  454756
  464548
  287315
  421795
  431604
  466142
  480788
  381838
  410452
  457202
  466405
  470145
  390320
  402664
  403736
  420142
  429288
  451050
  478663
  479469
  447551
  451624
  457092
  465154
  500197
  501801
  507452
  522835
  492841
  515004
  485461
  494720
  496682
  509060
  490272
  494418
  495023
  497034
  518061
  526197
  668398
  455922
  402093
  403891
  428616
  429747
  441454
  415552
  428710
  417435
  411685
  419979
  434006
  418559
  445387
  814790
  453719
  461037
  455632
  461036
  484762
  519520
]
3.66 ms
(0.98%)
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
  287315
  381838
  390320
  402093
  402664
  403736
  403891
  410452
  411685
  415552
  417435
  418559
  419979
  420131
  420142
  421795
  428616
  428710
  429288
  429747
  431604
  434006
  435948
  441454
  445387
  447551
  451050
  451624
  453719
  454756
  455632
  455922
  457092
  457202
  461036
  461037
  464548
  465154
  466142
  466405
  470145
  478663
  479469
  480788
  484762
  485461
  490272
  492841
  494418
  494720
  495023
  496682
  497034
  500197
  501801
  507452
  509060
  515004
  518061
  519520
  522835
  526197
  554079
  569498
  572556
  576545
  581520
  587058
  589349
  591003
  594293
  595088
  598261
  599105
  602314
  603702
  604904
  605758
  608038
  615031
  625169
  626119
  630777
  630871
  643488
  646022
  654174
  660359
  668398
  669071
  670366
  670372
  674941
  695868
  705669
  710638
  716459
  719141
  731371
  732323
  742281
  748257
  756230
  757365
  758133
  759870
  759948
  761598
  765298
  780475
  780595
  796129
  797437
  799190
  801974
  803784
  810408
  810983
  814790
]
1.83 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy черноволосая"
]
1.83 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy черноволосая"
]
1.68 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.