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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.44 ms
(85.13%)
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
  434412
  437152
  438056
  438069
  438077
  438082
  439746
  440571
  443669
  443849
  443898
  444840
  446218
  446336
  446813
  452410
  454038
  455715
  463996
  464965
  465405
  466448
  466884
  468355
  469146
  469884
  470007
  470918
  472393
  472676
  474265
  478339
  482466
  483861
  484246
  484683
  484981
  486623
  487260
  487273
  490437
  491126
  494577
  495296
  496733
  499879
  499995
  500030
  500067
  502212
  503104
  503111
  506161
  508396
  509746
  510776
  514066
  515726
  516486
  516488
  516490
  516493
  516500
  517374
  522445
  522626
  522645
  525139
  527197
  527697
  528203
  528350
  541994
  545848
  546059
  546675
  556704
  559239
  560453
  565011
  565886
  565889
  571433
  571472
  574408
  584885
  597123
  616822
  616947
  619953
  619982
  621457
  625035
  628515
  629580
  629663
  672835
  724807
  725661
  733661
  738363
  739646
  739981
  743846
  745136
  761517
  764194
  778724
  791067
  791866
  794273
  799750
  805259
  810359
  819695
  819791
  821804
  824647
  825711
  826306
]
15.03 ms
(8.74%)
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
  455715
  565886
  791866
  739646
  764194
  444840
  500030
  506161
  516493
  495296
  514066
  522645
  672835
  799750
  739981
  825711
  556704
  470007
  824647
  819695
  778724
  446218
  559239
  496733
  434412
  443849
  438056
  463996
  443669
  466448
  525139
  509746
  597123
  437152
  545848
  565011
  616822
  619982
  629663
  625035
  805259
  745136
  761517
  629580
  794273
  810359
  452410
  454038
  499995
  487273
  503104
  484981
  733661
  508396
  438077
  439746
  516490
  560453
  440571
  528203
  478339
  826306
  819791
  499879
  619953
  616947
  469884
  438069
  474265
  527697
  527197
  821804
  724807
  738363
  565889
  438082
  443898
  515726
  571433
  470918
  487260
  791067
  546675
  469146
  472393
  522445
  541994
  621457
  628515
  500067
  503111
  516488
  517374
  502212
  446336
  465405
  468355
  484683
  510776
  466884
  472676
  528350
  483861
  464965
  486623
  522626
  516486
  584885
  484246
  494577
  490437
  725661
  743846
  571472
  482466
  446813
  491126
  516500
  574408
  546059
]
2.98 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
  434412
  437152
  438056
  438069
  438077
  438082
  439746
  440571
  443669
  443849
  443898
  444840
  446218
  446336
  446813
  452410
  454038
  455715
  463996
  464965
  465405
  466448
  466884
  468355
  469146
  469884
  470007
  470918
  472393
  472676
  474265
  478339
  482466
  483861
  484246
  484683
  484981
  486623
  487260
  487273
  490437
  491126
  494577
  495296
  496733
  499879
  499995
  500030
  500067
  502212
  503104
  503111
  506161
  508396
  509746
  510776
  514066
  515726
  516486
  516488
  516490
  516493
  516500
  517374
  522445
  522626
  522645
  525139
  527197
  527697
  528203
  528350
  541994
  545848
  546059
  546675
  556704
  559239
  560453
  565011
  565886
  565889
  571433
  571472
  574408
  584885
  597123
  616822
  616947
  619953
  619982
  621457
  625035
  628515
  629580
  629663
  672835
  724807
  725661
  733661
  738363
  739646
  739981
  743846
  745136
  761517
  764194
  778724
  791067
  791866
  794273
  799750
  805259
  810359
  819695
  819791
  821804
  824647
  825711
  826306
]
2.05 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жен подборк"
]
1.89 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian wife compilation"
]
1.65 ms
(0.96%)
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.