GET https://search.jues.net/search/embeds/3?q=girl%20kissing

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.97 ms
(78.57%)
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
  401076
  401088
  401583
  441181
  454346
  510391
  510637
  510640
  512309
  514785
  515015
  516380
  516736
  527579
  528340
  538231
  538400
  538401
  538432
  542953
  552193
  552229
  552633
  560653
  562280
  562317
  562319
  562328
  565024
  568355
  569847
  569875
  570004
  570035
  570207
  570259
  570276
  570338
  570498
  570526
  570533
  570635
  570813
  571539
  571593
  571643
  571881
  571887
  571895
  571913
  571918
  572103
  572124
  572137
  572171
  572364
  572396
  572423
  572429
  572442
  573095
  573413
  573685
  573850
  573949
  574813
  575508
  575796
  580772
  582484
  607203
  630289
  644010
  652901
  652949
  654332
  654465
  670177
  672485
  676914
  676979
  677343
  677402
  678563
  679079
  679113
  679130
  679369
  679698
  697562
  699456
  714527
  718491
  719046
  721329
  724436
  724726
  730852
  736628
  739460
  742931
  743052
  743161
  743197
  744346
  744973
  748322
  753340
  753383
  753841
  755178
  758241
  759543
  769741
  769805
  770420
  770436
  786334
  801001
  816485
]
28.87 ms
(15.65%)
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
  560653
  562280
  562319
  571913
  573095
  652949
  677402
  672485
  679130
  676914
  571895
  644010
  748322
  724726
  724436
  441181
  510637
  538432
  676979
  679079
  718491
  678563
  670177
  719046
  801001
  753340
  512309
  514785
  699456
  743161
  739460
  538400
  677343
  572124
  580772
  743197
  759543
  770436
  401088
  570526
  542953
  569847
  570207
  570338
  571643
  573413
  552229
  570276
  571881
  654332
  570498
  571887
  574813
  607203
  630289
  755178
  770420
  743052
  744973
  769805
  401583
  510640
  516380
  515015
  569875
  572442
  575796
  570004
  570635
  572171
  572423
  573850
  552193
  570813
  571539
  571593
  572364
  572396
  652901
  654465
  721329
  679113
  679698
  552633
  562317
  562328
  568355
  570035
  570533
  571918
  572103
  572137
  573685
  575508
  742931
  753841
  786334
  744346
  730852
  769741
  758241
  454346
  538401
  516736
  582484
  753383
  714527
  510391
  527579
  538231
  816485
  697562
  401076
  565024
  570259
  573949
  679369
  572429
  736628
  528340
]
3.13 ms
(1.70%)
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
  401076
  401088
  401583
  441181
  454346
  510391
  510637
  510640
  512309
  514785
  515015
  516380
  516736
  527579
  528340
  538231
  538400
  538401
  538432
  542953
  552193
  552229
  552633
  560653
  562280
  562317
  562319
  562328
  565024
  568355
  569847
  569875
  570004
  570035
  570207
  570259
  570276
  570338
  570498
  570526
  570533
  570635
  570813
  571539
  571593
  571643
  571881
  571887
  571895
  571913
  571918
  572103
  572124
  572137
  572171
  572364
  572396
  572423
  572429
  572442
  573095
  573413
  573685
  573850
  573949
  574813
  575508
  575796
  580772
  582484
  607203
  630289
  644010
  652901
  652949
  654332
  654465
  670177
  672485
  676914
  676979
  677343
  677402
  678563
  679079
  679113
  679130
  679369
  679698
  697562
  699456
  714527
  718491
  719046
  721329
  724436
  724726
  730852
  736628
  739460
  742931
  743052
  743161
  743197
  744346
  744973
  748322
  753340
  753383
  753841
  755178
  758241
  759543
  769741
  769805
  770420
  770436
  786334
  801001
  816485
]
2.56 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк kissing"
]
1.72 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl kissing"
]
1.70 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк kissing"
]
1.56 ms
(0.84%)
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.