GET https://search.jues.net/search/embeds/9?q=red%20head%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.04 ms
(84.16%)
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
  381867
  389923
  390614
  397079
  399857
  415230
  416969
  420136
  424385
  447426
  450038
  453353
  467113
  478842
  482088
  487206
  488235
  499353
  509904
  521089
  521832
  524196
  527568
  528424
  528945
  529803
  541454
  541480
  544858
  553541
  554131
  566791
  584837
  586006
  588898
  596643
  598439
  598798
  616994
  617536
  618449
  618808
  623200
  623204
  624244
  635250
  640792
  644674
  646851
  651716
  651934
  651944
  655151
  661933
  672492
  673032
  674001
  674216
  675342
  675370
  682496
  691450
  691472
  694612
  695319
  697079
  700666
  703945
  703970
  704025
  708043
  720762
  722850
  727844
  728378
  730595
  739012
  740787
  741556
  743197
  746070
  747384
  748715
  753446
  762203
  763798
  764879
  766867
  767181
  767227
  768346
  768852
  769735
  769742
  769760
  769805
  770582
  770849
  770984
  771834
  772667
  772730
  776284
  776317
  779226
  789672
  790437
  793896
  797843
  799045
  800321
  804915
  807097
  807669
  812351
  814440
  818025
  824090
  827858
  827942
]
15.37 ms
(9.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
  521832
  509904
  499353
  521089
  524196
  544858
  623200
  596643
  618449
  623204
  644674
  399857
  415230
  527568
  487206
  381867
  389923
  390614
  420136
  824090
  827858
  467113
  478842
  528424
  584837
  655151
  700666
  661933
  672492
  691472
  704025
  708043
  651716
  674001
  674216
  695319
  722850
  635250
  640792
  618808
  624244
  586006
  617536
  776284
  779226
  793896
  800321
  807097
  776317
  790437
  812351
  727844
  740787
  743197
  753446
  770582
  772730
  797843
  804915
  807669
  730595
  746070
  762203
  764879
  768346
  769742
  770849
  728378
  741556
  770984
  748715
  766867
  767181
  769735
  769760
  771834
  772667
  739012
  747384
  763798
  767227
  768852
  769805
  697079
  703945
  720762
  789672
  799045
  397079
  528945
  488235
  447426
  646851
  598439
  482088
  424385
  616994
  416969
  818025
  814440
  827942
  453353
  450038
  529803
  541454
  541480
  566791
  703970
  651934
  673032
  675342
  675370
  691450
  651944
  682496
  694612
  553541
  554131
  588898
  598798
]
2.96 ms
(1.86%)
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
  381867
  389923
  390614
  397079
  399857
  415230
  416969
  420136
  424385
  447426
  450038
  453353
  467113
  478842
  482088
  487206
  488235
  499353
  509904
  521089
  521832
  524196
  527568
  528424
  528945
  529803
  541454
  541480
  544858
  553541
  554131
  566791
  584837
  586006
  588898
  596643
  598439
  598798
  616994
  617536
  618449
  618808
  623200
  623204
  624244
  635250
  640792
  644674
  646851
  651716
  651934
  651944
  655151
  661933
  672492
  673032
  674001
  674216
  675342
  675370
  682496
  691450
  691472
  694612
  695319
  697079
  700666
  703945
  703970
  704025
  708043
  720762
  722850
  727844
  728378
  730595
  739012
  740787
  741556
  743197
  746070
  747384
  748715
  753446
  762203
  763798
  764879
  766867
  767181
  767227
  768346
  768852
  769735
  769742
  769760
  769805
  770582
  770849
  770984
  771834
  772667
  772730
  776284
  776317
  779226
  789672
  790437
  793896
  797843
  799045
  800321
  804915
  807097
  807669
  812351
  814440
  818025
  824090
  827858
  827942
]
2.18 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "red head teen"
]
1.84 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рыжая teen"
]
1.38 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рыжая teen"
]

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.