GET https://search.jues.net/search/embeds/5?q=bbc%20amateur%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.41 ms
(83.69%)
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
  397193
  419765
  423349
  423350
  425316
  435471
  435515
  450224
  458971
  468126
  508179
  508494
  531286
  531811
  531889
  532186
  534056
  535908
  536856
  536898
  537007
  538063
  540513
  540627
  541917
  544942
  547076
  550656
  558784
  563280
  564270
  568228
  571751
  574460
  576530
  579033
  582042
  585191
  585352
  586207
  586398
  590172
  590233
  591718
  596690
  600960
  604191
  604487
  604612
  604992
  605696
  606785
  615335
  615423
  616571
  623278
  626382
  627634
  628827
  629423
  630873
  631003
  631009
  631063
  632291
  632386
  633430
  633563
  633918
  633926
  633962
  633979
  639645
  641881
  643844
  644757
  645605
  646173
  646174
  647077
  648326
  651485
  653793
  653797
  653813
  653821
  653824
  653832
  655920
  658162
  658192
  665939
  672699
  680020
  686763
  691717
  691729
  692084
  697581
  697615
  699425
  710935
  711255
  715251
  729240
  731302
  732565
  734795
  738390
  739014
  739637
  744434
  745887
  750648
  775424
  796997
  818048
  818143
  823766
  827826
]
13.64 ms
(9.10%)
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
  604191
  458971
  818143
  732565
  425316
  531811
  531889
  535908
  550656
  651485
  715251
  692084
  658162
  576530
  628827
  633979
  604612
  633926
  585191
  615423
  631063
  745887
  643844
  568228
  691717
  606785
  653797
  653832
  591718
  615335
  435471
  435515
  508179
  586207
  586398
  796997
  585352
  419765
  508494
  632386
  823766
  632291
  532186
  547076
  590172
  734795
  744434
  731302
  739637
  750648
  629423
  633563
  423349
  538063
  648326
  653813
  590233
  605696
  697581
  574460
  540513
  537007
  536898
  665939
  397193
  818048
  739014
  571751
  827826
  534056
  536856
  544942
  541917
  564270
  579033
  582042
  646173
  647077
  658192
  680020
  711255
  645605
  653793
  653824
  686763
  646174
  653821
  655920
  672699
  699425
  558784
  563280
  600960
  627634
  596690
  631003
  604992
  631009
  633430
  633918
  639645
  738390
  729240
  604487
  623278
  626382
  644757
  697615
  641881
  630873
  540627
  531286
  423350
  775424
  691729
  633962
  468126
  616571
  710935
  450224
]
2.98 ms
(1.99%)
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
  397193
  419765
  423349
  423350
  425316
  435471
  435515
  450224
  458971
  468126
  508179
  508494
  531286
  531811
  531889
  532186
  534056
  535908
  536856
  536898
  537007
  538063
  540513
  540627
  541917
  544942
  547076
  550656
  558784
  563280
  564270
  568228
  571751
  574460
  576530
  579033
  582042
  585191
  585352
  586207
  586398
  590172
  590233
  591718
  596690
  600960
  604191
  604487
  604612
  604992
  605696
  606785
  615335
  615423
  616571
  623278
  626382
  627634
  628827
  629423
  630873
  631003
  631009
  631063
  632291
  632386
  633430
  633563
  633918
  633926
  633962
  633979
  639645
  641881
  643844
  644757
  645605
  646173
  646174
  647077
  648326
  651485
  653793
  653797
  653813
  653821
  653824
  653832
  655920
  658162
  658192
  665939
  672699
  680020
  686763
  691717
  691729
  692084
  697581
  697615
  699425
  710935
  711255
  715251
  729240
  731302
  732565
  734795
  738390
  739014
  739637
  744434
  745887
  750648
  775424
  796997
  818048
  818143
  823766
  827826
]
2.41 ms
(1.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc amateur wife"
]
1.88 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbc любительск жен"
]
1.76 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbc любительск жен"
]

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.