GET https://search.jues.net/search/embeds/3?q=german%20mature%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.62 ms
(59.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "german mature milf"
]
116.89 ms
(32.35%)
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
  191330
  386798
  387905
  401064
  401216
  401933
  412132
  415567
  416886
  419503
  419617
  423379
  425976
  428514
  428520
  428522
  428531
  428533
  443163
  446085
  447930
  453635
  453648
  453650
  455977
  456002
  456915
  457984
  459457
  461141
  464237
  464965
  466927
  466943
  467580
  469352
  471177
  471786
  472618
  472955
  473203
  476227
  477593
  478463
  480759
  480772
  482555
  482686
  483103
  483802
  484086
  485098
  485475
  485481
  491449
  491565
  494261
  494264
  495878
  497703
  502812
  503569
  504085
  504116
  505215
  505910
  506060
  506467
  506805
  509103
  509993
  515825
  518387
  521159
  522191
  523122
  525191
  525485
  526104
  527676
  529162
  538816
  538817
  541336
  541759
  541872
  551922
  559121
  559123
  561005
  564481
  567410
  568989
  569176
  569198
  573914
  581025
  583387
  584063
  589192
  589747
  591253
  593868
  594406
  599609
  599659
  602668
  603002
  603571
  603610
  606608
  606624
  621787
  624084
  674473
  802723
  805874
  809644
]
20.24 ms
(5.60%)
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
  509993
  518387
  505215
  480759
  559123
  603610
  464237
  466943
  503569
  541872
  583387
  559121
  602668
  453650
  464965
  456915
  386798
  191330
  401216
  415567
  425976
  419617
  453648
  457984
  459457
  471786
  472618
  453635
  523122
  515825
  497703
  506060
  538816
  502812
  505910
  561005
  674473
  599609
  603571
  606608
  621787
  802723
  809644
  525191
  495878
  387905
  455977
  466927
  473203
  401933
  401064
  428520
  522191
  428514
  423379
  483103
  491449
  469352
  477593
  478463
  484086
  504116
  506805
  538817
  525485
  476227
  551922
  567410
  569198
  568989
  581025
  589192
  594406
  589747
  591253
  456002
  472955
  446085
  491565
  485475
  494261
  482555
  599659
  428533
  485098
  494264
  606624
  805874
  506467
  443163
  412132
  485481
  509103
  541336
  564481
  573914
  428522
  471177
  419503
  483802
  416886
  467580
  480772
  527676
  569176
  428531
  447930
  482686
  584063
  541759
  593868
  461141
  603002
  504085
  624084
  526104
  529162
  521159
]
4.08 ms
(1.13%)
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
  191330
  386798
  387905
  401064
  401216
  401933
  412132
  415567
  416886
  419503
  419617
  423379
  425976
  428514
  428520
  428522
  428531
  428533
  443163
  446085
  447930
  453635
  453648
  453650
  455977
  456002
  456915
  457984
  459457
  461141
  464237
  464965
  466927
  466943
  467580
  469352
  471177
  471786
  472618
  472955
  473203
  476227
  477593
  478463
  480759
  480772
  482555
  482686
  483103
  483802
  484086
  485098
  485475
  485481
  491449
  491565
  494261
  494264
  495878
  497703
  502812
  503569
  504085
  504116
  505215
  505910
  506060
  506467
  506805
  509103
  509993
  515825
  518387
  521159
  522191
  523122
  525191
  525485
  526104
  527676
  529162
  538816
  538817
  541336
  541759
  541872
  551922
  559121
  559123
  561005
  564481
  567410
  568989
  569176
  569198
  573914
  581025
  583387
  584063
  589192
  589747
  591253
  593868
  594406
  599609
  599659
  602668
  603002
  603571
  603610
  606608
  606624
  621787
  624084
  674473
  802723
  805874
  809644
]
2.03 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "german mature milf"
]
1.75 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "german mature milf"
]
1.74 ms
(0.48%)
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.