GET https://search.jues.net/search/embeds/5?q=homemade%20riding%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.95 ms
(84.98%)
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
  4131
  412814
  416611
  416613
  445851
  467970
  534100
  535637
  539235
  539860
  542573
  542968
  554340
  567727
  575625
  575665
  577969
  578807
  579179
  580873
  581262
  584346
  584615
  587340
  589977
  593809
  594497
  595463
  595469
  598141
  599425
  600119
  606930
  607793
  610161
  618514
  620864
  620944
  625483
  630135
  633179
  633289
  633345
  634033
  641792
  643647
  645761
  646136
  648099
  648379
  648410
  649711
  651040
  651510
  651731
  654918
  655243
  655811
  656148
  656241
  656283
  656286
  656484
  658215
  660068
  660804
  661044
  671252
  674866
  683496
  693492
  695008
  704703
  707045
  707928
  710348
  716044
  716561
  719725
  722403
  724971
  734326
  738556
  739008
  740578
  750278
  753649
  758068
  760526
  760844
  762577
  764198
  764261
  765582
  765677
  765760
  765926
  766794
  768103
  771353
  775554
  778420
  778973
  779317
  782532
  785591
  791122
  791383
  791525
  791937
  792089
  797101
  799890
  803613
  804550
  804695
  807051
  813747
  813813
  814580
]
14.68 ms
(9.24%)
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
  740578
  753649
  765677
  765926
  739008
  762577
  768103
  716044
  716561
  719725
  778973
  792089
  445851
  575665
  579179
  630135
  813747
  778420
  554340
  594497
  4131
  412814
  416611
  416613
  467970
  598141
  618514
  785591
  671252
  535637
  813813
  814580
  542573
  580873
  722403
  589977
  804550
  804695
  775554
  791122
  791383
  797101
  799890
  807051
  765582
  791525
  791937
  766794
  771353
  724971
  738556
  760526
  760844
  764198
  765760
  750278
  758068
  764261
  782532
  803613
  534100
  539860
  539235
  542968
  567727
  575625
  581262
  584615
  584346
  645761
  648099
  649711
  651040
  651510
  651731
  654918
  656148
  658215
  660068
  660804
  683496
  648379
  648410
  656241
  656283
  656484
  693492
  704703
  707045
  646136
  655243
  655811
  656286
  661044
  674866
  695008
  707928
  710348
  577969
  578807
  595463
  625483
  633179
  634033
  641792
  587340
  593809
  595469
  607793
  620944
  633345
  599425
  600119
  620864
  633289
  643647
  606930
  610161
  779317
  734326
]
2.71 ms
(1.71%)
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
  4131
  412814
  416611
  416613
  445851
  467970
  534100
  535637
  539235
  539860
  542573
  542968
  554340
  567727
  575625
  575665
  577969
  578807
  579179
  580873
  581262
  584346
  584615
  587340
  589977
  593809
  594497
  595463
  595469
  598141
  599425
  600119
  606930
  607793
  610161
  618514
  620864
  620944
  625483
  630135
  633179
  633289
  633345
  634033
  641792
  643647
  645761
  646136
  648099
  648379
  648410
  649711
  651040
  651510
  651731
  654918
  655243
  655811
  656148
  656241
  656283
  656286
  656484
  658215
  660068
  660804
  661044
  671252
  674866
  683496
  693492
  695008
  704703
  707045
  707928
  710348
  716044
  716561
  719725
  722403
  724971
  734326
  738556
  739008
  740578
  750278
  753649
  758068
  760526
  760844
  762577
  764198
  764261
  765582
  765677
  765760
  765926
  766794
  768103
  771353
  775554
  778420
  778973
  779317
  782532
  785591
  791122
  791383
  791525
  791937
  792089
  797101
  799890
  803613
  804550
  804695
  807051
  813747
  813813
  814580
]
1.68 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade riding teen"
]
1.67 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск riding teen"
]
1.50 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск riding 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.