GET https://search.jues.net/search/embeds/8?q=milf%20domination

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.72 ms
(83.02%)
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
  381878
  382266
  390231
  394685
  398284
  398955
  415594
  418974
  421571
  423505
  424477
  424478
  428685
  434609
  448042
  449105
  449109
  454273
  457804
  459520
  459878
  460722
  460975
  463758
  465731
  465930
  467617
  470513
  471685
  473255
  475590
  477037
  477154
  477376
  477968
  479285
  480976
  481920
  487860
  491909
  494000
  499417
  508679
  511019
  513978
  521701
  525192
  527061
  530450
  533258
  533264
  534018
  537927
  538957
  541586
  542095
  542373
  542397
  542411
  544501
  545471
  545484
  546219
  547428
  548568
  549268
  549413
  550010
  550224
  550333
  551026
  555889
  556511
  559139
  559726
  561074
  561740
  563183
  564373
  565484
  568117
  568477
  569579
  569722
  569756
  570151
  570797
  574222
  576655
  576662
  594338
  596868
  599591
  600274
  600356
  600732
  601052
  601714
  602054
  604596
  610209
  614407
  615322
  615392
  619358
  619469
  624753
  627726
  639982
  648259
  699325
  711275
  716835
  717859
  719807
  720308
  731814
  739866
  799362
  809811
]
16.20 ms
(10.61%)
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
  499417
  508679
  511019
  513978
  521701
  525192
  527061
  530450
  533258
  533264
  534018
  537927
  538957
  459878
  477154
  487860
  491909
  494000
  542411
  549268
  559139
  541586
  542095
  542373
  547428
  548568
  550333
  559726
  565484
  568477
  569722
  574222
  576662
  542397
  544501
  546219
  550010
  556511
  561740
  564373
  568117
  569756
  570151
  576655
  648259
  699325
  716835
  717859
  719807
  545471
  545484
  549413
  550224
  551026
  555889
  561074
  563183
  569579
  570797
  600274
  600356
  601714
  639982
  594338
  599591
  600732
  624753
  627726
  596868
  610209
  615392
  619469
  601052
  614407
  619358
  809811
  731814
  739866
  602054
  604596
  615322
  711275
  720308
  799362
  381878
  382266
  398284
  460722
  473255
  398955
  421571
  428685
  434609
  449105
  465731
  470513
  475590
  477376
  479285
  480976
  481920
  418974
  423505
  424477
  459520
  477968
  390231
  394685
  415594
  448042
  449109
  454273
  457804
  471685
  477037
  424478
  460975
  463758
  465930
  467617
]
2.42 ms
(1.59%)
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
  381878
  382266
  390231
  394685
  398284
  398955
  415594
  418974
  421571
  423505
  424477
  424478
  428685
  434609
  448042
  449105
  449109
  454273
  457804
  459520
  459878
  460722
  460975
  463758
  465731
  465930
  467617
  470513
  471685
  473255
  475590
  477037
  477154
  477376
  477968
  479285
  480976
  481920
  487860
  491909
  494000
  499417
  508679
  511019
  513978
  521701
  525192
  527061
  530450
  533258
  533264
  534018
  537927
  538957
  541586
  542095
  542373
  542397
  542411
  544501
  545471
  545484
  546219
  547428
  548568
  549268
  549413
  550010
  550224
  550333
  551026
  555889
  556511
  559139
  559726
  561074
  561740
  563183
  564373
  565484
  568117
  568477
  569579
  569722
  569756
  570151
  570797
  574222
  576655
  576662
  594338
  596868
  599591
  600274
  600356
  600732
  601052
  601714
  602054
  604596
  610209
  614407
  615322
  615392
  619358
  619469
  624753
  627726
  639982
  648259
  699325
  711275
  716835
  717859
  719807
  720308
  731814
  739866
  799362
  809811
]
2.01 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf domination"
]
2.01 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf domination"
]
1.63 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf domination"
]

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.