GET https://search.jues.net/search/embeds/3?q=russian%20old%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.39 ms
(82.85%)
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
  106162
  382058
  396554
  404127
  412572
  417428
  432306
  439844
  446894
  447524
  454298
  466920
  469911
  470154
  472179
  478255
  482080
  486130
  492601
  501866
  504303
  506189
  512973
  513290
  516615
  522587
  523985
  526775
  527490
  534028
  543659
  547731
  552662
  564416
  565044
  565198
  569443
  572197
  574580
  574897
  575788
  576051
  576412
  589472
  591393
  595451
  595458
  595853
  595869
  597063
  597072
  597227
  597940
  597999
  598057
  598067
  598471
  598686
  598723
  600894
  603003
  603970
  604350
  610504
  624829
  644670
  659409
  662436
  668141
  677015
  679380
  679385
  696212
  701501
  702624
  714498
  714948
  716043
  718705
  718708
  721369
  721400
  723932
  725141
  731161
  735524
  736911
  739318
  749911
  749919
  751900
  752685
  753482
  754017
  754205
  755854
  761290
  761474
  762984
  763435
  769746
  769786
  775797
  775941
  778955
  786196
  788443
  797247
  800377
  800517
  800568
  803244
  804862
  804995
  810533
  816755
  817317
  817482
  821829
]
17.17 ms
(10.75%)
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
  472179
  565198
  576051
  574897
  598723
  595853
  597227
  598057
  598067
  439844
  516615
  817482
  816755
  817317
  821829
  564416
  569443
  547731
  565044
  572197
  662436
  677015
  668141
  679380
  701501
  718708
  721400
  679385
  714498
  714948
  718705
  552662
  589472
  597940
  603003
  595869
  600894
  644670
  595451
  597072
  604350
  610504
  624829
  591393
  775941
  786196
  788443
  800568
  804995
  810533
  800517
  804862
  725141
  755854
  762984
  763435
  769786
  797247
  800377
  752685
  723932
  753482
  754205
  769746
  735524
  749911
  749919
  751900
  754017
  731161
  736911
  739318
  761290
  761474
  702624
  721369
  778955
  803244
  466920
  106162
  404127
  412572
  417428
  522587
  527490
  396554
  543659
  575788
  574580
  597063
  597999
  603970
  432306
  470154
  478255
  447524
  513290
  506189
  492601
  504303
  484232
  501866
  775797
  382058
  469911
  454298
  595458
  598471
  534028
  576412
  659409
  696212
  598686
  716043
  482080
  486130
  512973
  523985
  526775
  446894
]
2.77 ms
(1.73%)
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
  106162
  382058
  396554
  404127
  412572
  417428
  432306
  439844
  446894
  447524
  454298
  466920
  469911
  470154
  472179
  478255
  482080
  486130
  492601
  501866
  504303
  506189
  512973
  513290
  516615
  522587
  523985
  526775
  527490
  534028
  543659
  547731
  552662
  564416
  565044
  565198
  569443
  572197
  574580
  574897
  575788
  576051
  576412
  589472
  591393
  595451
  595458
  595853
  595869
  597063
  597072
  597227
  597940
  597999
  598057
  598067
  598471
  598686
  598723
  600894
  603003
  603970
  604350
  610504
  624829
  644670
  659409
  662436
  668141
  677015
  679380
  679385
  696212
  701501
  702624
  714498
  714948
  716043
  718705
  718708
  721369
  721400
  723932
  725141
  731161
  735524
  736911
  739318
  749911
  749919
  751900
  752685
  753482
  754017
  754205
  755854
  761290
  761474
  762984
  763435
  769746
  769786
  775797
  775941
  778955
  786196
  788443
  797247
  800377
  800517
  800568
  803244
  804862
  804995
  810533
  816755
  817317
  817482
  821829
]
1.98 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian old teen"
]
1.88 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск old teen"
]
1.87 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск old 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.