GET https://search.jues.net/search/embeds/8?q=blonde%20beautiful

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
225.93 ms
(90.25%)
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
  6919
  12904
  38261
  66264
  68464
  135702
  178561
  181420
  266061
  285875
  307342
  375949
  384176
  387536
  391764
  392421
  397977
  398318
  400957
  401309
  402137
  402682
  404276
  405320
  406695
  408223
  411451
  413165
  413677
  419028
  419410
  419428
  425244
  429030
  429217
  429286
  429941
  430132
  433781
  445007
  460036
  465641
  471115
  474021
  474580
  475100
  476458
  480240
  483228
  484051
  489909
  490306
  495358
  499936
  511048
  516251
  518091
  518152
  521942
  547911
  552752
  561658
  562516
  566526
  568429
  568563
  579001
  584825
  585858
  588262
  591594
  600228
  601598
  619490
  627161
  630922
  639253
  643969
  678620
  709825
  724659
  732472
  740506
  742870
  744015
  744130
  744566
  745063
  747288
  748986
  753004
  754195
  754568
  755595
  756339
  757077
  758622
  760961
  764354
  765482
  768478
  773514
  774627
  774745
  775774
  781434
  781540
  782095
  783637
  785559
  786336
  786664
  789454
  790116
  791218
  800648
  801475
  803195
  804192
  813446
]
14.06 ms
(5.61%)
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
  643969
  585858
  600228
  601598
  630922
  774627
  774745
  786664
  781540
  782095
  790116
  742870
  744015
  748986
  754195
  754568
  755595
  758622
  773514
  781434
  786336
  800648
  732472
  740506
  768478
  724659
  753004
  744130
  744566
  747288
  764354
  756339
  757077
  760961
  619490
  709825
  783637
  789454
  803195
  813446
  12904
  285875
  307342
  391764
  66264
  68464
  135702
  397977
  400957
  413677
  475100
  419428
  471115
  484051
  392421
  387536
  402137
  405320
  408223
  445007
  413165
  425244
  516251
  460036
  561658
  568429
  566526
  579001
  584825
  588262
  745063
  627161
  266061
  6919
  401309
  419028
  429030
  433781
  181420
  375949
  398318
  402682
  474021
  476458
  480240
  429217
  430132
  429941
  518091
  521942
  483228
  495358
  511048
  490306
  639253
  404276
  465641
  406695
  178561
  38261
  429286
  411451
  419410
  489909
  474580
  499936
  518152
  562516
  552752
  547911
  568563
  678620
  591594
  775774
  801475
  765482
  785559
  791218
  804192
  384176
]
2.92 ms
(1.16%)
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
  6919
  12904
  38261
  66264
  68464
  135702
  178561
  181420
  266061
  285875
  307342
  375949
  384176
  387536
  391764
  392421
  397977
  398318
  400957
  401309
  402137
  402682
  404276
  405320
  406695
  408223
  411451
  413165
  413677
  419028
  419410
  419428
  425244
  429030
  429217
  429286
  429941
  430132
  433781
  445007
  460036
  465641
  471115
  474021
  474580
  475100
  476458
  480240
  483228
  484051
  489909
  490306
  495358
  499936
  511048
  516251
  518091
  518152
  521942
  547911
  552752
  561658
  562516
  566526
  568429
  568563
  579001
  584825
  585858
  588262
  591594
  600228
  601598
  619490
  627161
  630922
  639253
  643969
  678620
  709825
  724659
  732472
  740506
  742870
  744015
  744130
  744566
  745063
  747288
  748986
  753004
  754195
  754568
  755595
  756339
  757077
  758622
  760961
  764354
  765482
  768478
  773514
  774627
  774745
  775774
  781434
  781540
  782095
  783637
  785559
  786336
  786664
  789454
  790116
  791218
  800648
  801475
  803195
  804192
  813446
]
2.04 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая красивая"
]
1.87 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde beautiful"
]
1.85 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.67%)
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.