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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.35 ms
(85.59%)
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
  392107
  423926
  424017
  429706
  436116
  454504
  454516
  455194
  459109
  467891
  488273
  533700
  533712
  535371
  535378
  535381
  535407
  535409
  535601
  536082
  537065
  541018
  541726
  543751
  543951
  544013
  544018
  552870
  564955
  568771
  569636
  574926
  581549
  589525
  590522
  598240
  602331
  615570
  617068
  618946
  619907
  624527
  629941
  633696
  647132
  669867
  669902
  671204
  672789
  675884
  679964
  681525
  684722
  690755
  691704
  697658
  697994
  709168
  709970
  711084
  712361
  713325
  713973
  719475
  719484
  719512
  722285
  722433
  723024
  727582
  733798
  735907
  736819
  736831
  741130
  742295
  745514
  747419
  747423
  751604
  756492
  757473
  759068
  759377
  766475
  767908
  768911
  769335
  769343
  778622
  780889
  782149
  782658
  783175
  785870
  786598
  790292
  791439
  791919
  792272
  792375
  792738
  793039
  793092
  794031
  800690
  802279
  803230
  816163
  819935
  820034
  824230
  824850
  824875
  825515
  825610
  825677
  825797
  825800
  827543
]
13.78 ms
(8.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
  712361
  803230
  564955
  467891
  429706
  455194
  488273
  454504
  459109
  454516
  436116
  423926
  671204
  392107
  424017
  825515
  825677
  827543
  819935
  820034
  824230
  824875
  816163
  824850
  825610
  825797
  825800
  533712
  535409
  536082
  533700
  535371
  535601
  535407
  535378
  535381
  537065
  541018
  543951
  544018
  552870
  568771
  569636
  544013
  541726
  543751
  675884
  713973
  719475
  719484
  719512
  722285
  669902
  672789
  681525
  684722
  691704
  697658
  647132
  669867
  679964
  690755
  709168
  709970
  574926
  581549
  590522
  602331
  589525
  615570
  624527
  633696
  617068
  619907
  629941
  598240
  618946
  786598
  790292
  792375
  780889
  783175
  791439
  792738
  800690
  802279
  727582
  733798
  736831
  742295
  747423
  751604
  791919
  793039
  793092
  794031
  735907
  736819
  756492
  759068
  766475
  769335
  769343
  745514
  759377
  767908
  768911
  741130
  747419
  757473
  697994
  711084
  713325
  722433
  723024
  778622
  782149
  782658
  785870
  792272
]
2.43 ms
(1.53%)
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
  392107
  423926
  424017
  429706
  436116
  454504
  454516
  455194
  459109
  467891
  488273
  533700
  533712
  535371
  535378
  535381
  535407
  535409
  535601
  536082
  537065
  541018
  541726
  543751
  543951
  544013
  544018
  552870
  564955
  568771
  569636
  574926
  581549
  589525
  590522
  598240
  602331
  615570
  617068
  618946
  619907
  624527
  629941
  633696
  647132
  669867
  669902
  671204
  672789
  675884
  679964
  681525
  684722
  690755
  691704
  697658
  697994
  709168
  709970
  711084
  712361
  713325
  713973
  719475
  719484
  719512
  722285
  722433
  723024
  727582
  733798
  735907
  736819
  736831
  741130
  742295
  745514
  747419
  747423
  751604
  756492
  757473
  759068
  759377
  766475
  767908
  768911
  769335
  769343
  778622
  780889
  782149
  782658
  783175
  785870
  786598
  790292
  791439
  791919
  792272
  792375
  792738
  793039
  793092
  794031
  800690
  802279
  803230
  816163
  819935
  820034
  824230
  824850
  824875
  825515
  825610
  825677
  825797
  825800
  827543
]
1.81 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian wife solo"
]
1.78 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жен соло"
]
1.59 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск жен соло"
]
1.57 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.