GET https://search.jues.net/search/embeds/3?q=sleeping%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
198.04 ms
(89.66%)
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
  397490
  416407
  416878
  417846
  418389
  425749
  426934
  427573
  429321
  431709
  435180
  444009
  444387
  446918
  449743
  455788
  467742
  473145
  476001
  483882
  485826
  486257
  489096
  490757
  494323
  506423
  508298
  509377
  512148
  516101
  525557
  527764
  529121
  529629
  541333
  542908
  543149
  544090
  555628
  556991
  575189
  578008
  581793
  585168
  590095
  599606
  601955
  604313
  609819
  610938
  613732
  615580
  616858
  618700
  625340
  626375
  631871
  672902
  673187
  674068
  678222
  683978
  695002
  697129
  698285
  699267
  716796
  720656
  726790
  728051
  746708
  756724
  756868
  761959
  762090
  762970
  766002
  768155
  768818
  771742
  775731
  775771
  777956
  778326
  778927
  779256
  779909
  783794
  784762
  784920
  785211
  786901
  788080
  788142
  788374
  790470
  791818
  792308
  792446
  794712
  795661
  801503
  805101
  805361
  805685
  805777
  807728
  809433
  810559
  811549
  812436
  812720
  814271
  818081
  818094
  821764
  823949
  825674
  825689
]
13.48 ms
(6.10%)
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
  616858
  775771
  777956
  778927
  783794
  795661
  805101
  812720
  778326
  794712
  810559
  784762
  788374
  726790
  761959
  762090
  728051
  746708
  768818
  768155
  771742
  697129
  779909
  791818
  801503
  418389
  425749
  397490
  427573
  444009
  467742
  446918
  449743
  473145
  506423
  489096
  542908
  578008
  544090
  555628
  575189
  581793
  556991
  416407
  426934
  435180
  416878
  444387
  483882
  529121
  508298
  509377
  417846
  818081
  818094
  823949
  825674
  821764
  485826
  525557
  527764
  516101
  543149
  673187
  674068
  683978
  699267
  672902
  678222
  695002
  716796
  585168
  615580
  590095
  599606
  626375
  618700
  625340
  786901
  788142
  792446
  805361
  811549
  756868
  766002
  766558
  756724
  762970
  601955
  609819
  720656
  775731
  779256
  784920
  785211
  788080
  790470
  792308
  805685
  812436
  486257
  529629
  698285
  490757
  512148
  541333
  610938
  613732
  604313
  631871
  805777
  807728
  809433
  476001
  431709
  455788
  494323
  429321
  814271
  825689
]
2.65 ms
(1.20%)
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
  397490
  416407
  416878
  417846
  418389
  425749
  426934
  427573
  429321
  431709
  435180
  444009
  444387
  446918
  449743
  455788
  467742
  473145
  476001
  483882
  485826
  486257
  489096
  490757
  494323
  506423
  508298
  509377
  512148
  516101
  525557
  527764
  529121
  529629
  541333
  542908
  543149
  544090
  555628
  556991
  575189
  578008
  581793
  585168
  590095
  599606
  601955
  604313
  609819
  610938
  613732
  615580
  616858
  618700
  625340
  626375
  631871
  672902
  673187
  674068
  678222
  683978
  695002
  697129
  698285
  699267
  716796
  720656
  726790
  728051
  746708
  756724
  756868
  761959
  762090
  762970
  766002
  768155
  768818
  771742
  775731
  775771
  777956
  778326
  778927
  779256
  779909
  783794
  784762
  784920
  785211
  786901
  788080
  788142
  788374
  790470
  791818
  792308
  792446
  794712
  795661
  801503
  805101
  805361
  805685
  805777
  807728
  809433
  810559
  811549
  812436
  812720
  814271
  818081
  818094
  821764
  823949
  825674
  825689
]
1.94 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sleeping pov"
]
1.77 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спящ пов"
]
1.52 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 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.