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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.07 ms
(81.78%)
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
  387080
  389994
  390720
  391597
  391959
  401374
  420005
  424224
  427112
  427135
  427162
  435536
  435552
  435567
  435591
  435593
  436075
  436885
  437369
  437723
  437733
  437950
  438465
  438607
  439291
  439376
  442584
  443830
  444086
  447975
  448275
  448918
  450446
  450509
  452960
  453481
  454018
  455202
  455568
  462229
  464064
  464543
  466030
  466252
  466488
  466699
  467876
  468314
  469142
  469427
  470024
  471674
  473282
  474181
  474911
  475097
  475347
  475605
  476675
  476889
  479604
  480339
  483844
  484781
  489804
  494207
  495251
  496020
  496506
  498648
  499390
  503665
  505771
  507332
  511168
  513203
  513628
  513681
  514031
  514464
  516495
  517299
  517805
  518371
  520622
  524653
  524929
  540743
  545971
  547774
  547803
  548010
  555003
  558178
  569558
  569564
  576120
  578768
  592656
  597276
  598469
  599377
  600325
  601555
  626859
  669912
  680665
  692288
  695551
  704613
  714524
  742375
  757826
  759474
  792270
  806762
  806789
  824533
  824633
  824733
]
16.43 ms
(11.28%)
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
  511168
  518371
  471674
  576120
  545971
  692288
  714524
  558178
  599377
  597276
  598469
  601555
  792270
  757826
  742375
  806789
  391959
  427135
  438607
  454018
  462229
  424224
  437733
  443830
  448275
  448918
  453481
  467876
  474181
  476675
  427112
  435552
  435591
  452960
  516495
  540743
  483844
  494207
  514464
  517299
  517805
  524929
  484781
  496506
  626859
  824533
  824633
  824733
  695551
  759474
  475347
  578768
  466252
  390720
  437369
  427162
  436885
  437950
  447975
  464064
  475097
  476889
  469427
  473282
  496020
  507332
  469142
  547803
  548010
  547774
  680665
  669912
  704613
  555003
  569558
  569564
  592656
  600325
  391597
  436075
  464543
  468314
  475605
  479604
  387080
  420005
  435536
  435593
  438465
  450509
  455568
  466030
  401374
  435567
  437723
  442584
  466699
  480339
  389994
  439291
  439376
  444086
  450446
  455202
  470024
  466488
  474911
  503665
  513628
  514031
  498648
  505771
  513203
  520622
  524653
  495251
  499390
  513681
  489804
  806762
]
2.91 ms
(2.00%)
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
  387080
  389994
  390720
  391597
  391959
  401374
  420005
  424224
  427112
  427135
  427162
  435536
  435552
  435567
  435591
  435593
  436075
  436885
  437369
  437723
  437733
  437950
  438465
  438607
  439291
  439376
  442584
  443830
  444086
  447975
  448275
  448918
  450446
  450509
  452960
  453481
  454018
  455202
  455568
  462229
  464064
  464543
  466030
  466252
  466488
  466699
  467876
  468314
  469142
  469427
  470024
  471674
  473282
  474181
  474911
  475097
  475347
  475605
  476675
  476889
  479604
  480339
  483844
  484781
  489804
  494207
  495251
  496020
  496506
  498648
  499390
  503665
  505771
  507332
  511168
  513203
  513628
  513681
  514031
  514464
  516495
  517299
  517805
  518371
  520622
  524653
  524929
  540743
  545971
  547774
  547803
  548010
  555003
  558178
  569558
  569564
  576120
  578768
  592656
  597276
  598469
  599377
  600325
  601555
  626859
  669912
  680665
  692288
  695551
  704613
  714524
  742375
  757826
  759474
  792270
  806762
  806789
  824533
  824633
  824733
]
2.06 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian wife solo"
]
1.95 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жен соло"
]
1.56 ms
(1.07%)
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.