GET https://search.jues.net/search/embeds/3?q=swinger%20amateurs

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.93 ms
(51.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
172.47 ms
(42.47%)
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
  78637
  100449
  142598
  210661
  383227
  391897
  398995
  403243
  410911
  426365
  470600
  476437
  479067
  530828
  531860
  532659
  532670
  533054
  533646
  533689
  534907
  535789
  538141
  538883
  539018
  540122
  542513
  543757
  543943
  544746
  544879
  544956
  545014
  546544
  551524
  563387
  576512
  583958
  585583
  586562
  588116
  593075
  603658
  603690
  604698
  606772
  617692
  618260
  622116
  622166
  622179
  622322
  630668
  630712
  631986
  632405
  633049
  635780
  635840
  635859
  635863
  635872
  639075
  640233
  641865
  649627
  649639
  650642
  650815
  650825
  651313
  651318
  651422
  652122
  653154
  653603
  653615
  653628
  653634
  653780
  653807
  653880
  654256
  654293
  671501
  685521
  691616
  692463
  693794
  694128
  696167
  696992
  698109
  698129
  699430
  699488
  702302
  702684
  703211
  705409
  708060
  708919
  714080
  714404
  716172
  717062
  718742
  718964
  721932
  721982
  723971
  725096
  731032
  733076
  733577
  734388
  761504
  762268
  775130
  787686
]
16.50 ms
(4.06%)
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
  635859
  717062
  721932
  721982
  775130
  142598
  210661
  650825
  698109
  476437
  698129
  787686
  692463
  479067
  693794
  699430
  654256
  708919
  635872
  540122
  649639
  652122
  653634
  671501
  694128
  702302
  708060
  714080
  714404
  649627
  651313
  653154
  653628
  699488
  651318
  653603
  653615
  653780
  653880
  654293
  691616
  696167
  630668
  639075
  622179
  640233
  641865
  586562
  603658
  622116
  630712
  633049
  635780
  635840
  635863
  603690
  631986
  617692
  618260
  622166
  632405
  696992
  702684
  705409
  531860
  533689
  535789
  530828
  538141
  533054
  539018
  546544
  685521
  703211
  653807
  650642
  545014
  604698
  606772
  593075
  733076
  398995
  410911
  563387
  470600
  383227
  100449
  391897
  78637
  403243
  426365
  534907
  532659
  538883
  533646
  532670
  542513
  543943
  544879
  551524
  543757
  544746
  544956
  576512
  650815
  718742
  718964
  651422
  716172
  583958
  588116
  622322
  585583
  723971
  734388
  761504
  762268
  725096
  731032
  733577
]
3.11 ms
(0.77%)
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
  78637
  100449
  142598
  210661
  383227
  391897
  398995
  403243
  410911
  426365
  470600
  476437
  479067
  530828
  531860
  532659
  532670
  533054
  533646
  533689
  534907
  535789
  538141
  538883
  539018
  540122
  542513
  543757
  543943
  544746
  544879
  544956
  545014
  546544
  551524
  563387
  576512
  583958
  585583
  586562
  588116
  593075
  603658
  603690
  604698
  606772
  617692
  618260
  622116
  622166
  622179
  622322
  630668
  630712
  631986
  632405
  633049
  635780
  635840
  635859
  635863
  635872
  639075
  640233
  641865
  649627
  649639
  650642
  650815
  650825
  651313
  651318
  651422
  652122
  653154
  653603
  653615
  653628
  653634
  653780
  653807
  653880
  654256
  654293
  671501
  685521
  691616
  692463
  693794
  694128
  696167
  696992
  698109
  698129
  699430
  699488
  702302
  702684
  703211
  705409
  708060
  708919
  714080
  714404
  716172
  717062
  718742
  718964
  721932
  721982
  723971
  725096
  731032
  733076
  733577
  734388
  761504
  762268
  775130
  787686
]
1.89 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "swinger amateurs"
]
1.81 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "свингер любительск"
]
1.35 ms
(0.33%)
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.