GET https://search.jues.net/search/embeds/8?q=doggy%20interracial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.74 ms
(82.50%)
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
  37730
  105333
  152883
  153376
  177651
  282666
  309223
  316911
  326297
  341753
  382513
  382650
  383036
  383564
  384022
  385373
  385677
  387221
  389352
  389473
  390910
  391086
  391322
  396597
  397644
  399156
  403160
  415094
  420622
  420769
  428922
  443457
  445433
  452279
  453747
  461044
  463953
  467120
  468470
  472877
  475706
  496399
  497725
  505466
  508271
  508428
  511688
  514139
  528305
  530547
  530666
  531298
  532347
  533523
  533619
  534677
  534860
  534864
  535849
  537609
  537941
  538030
  539661
  540383
  547101
  550186
  553812
  555857
  568019
  569160
  578549
  579696
  581237
  581960
  582026
  585913
  587723
  592217
  592292
  602059
  604295
  605617
  605625
  606294
  606502
  617214
  629201
  630259
  631479
  633897
  637869
  639394
  649079
  653811
  656544
  658826
  660531
  669397
  669563
  671408
  676608
  683877
  694908
  694914
  700678
  716004
  716017
  720061
  720351
  796232
  803477
  813848
  814967
  815363
  822410
  824096
  826135
  826230
  827827
]
16.34 ms
(10.31%)
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
  629201
  630259
  700678
  796232
  803477
  37730
  396597
  399156
  384022
  309223
  383564
  326297
  316911
  341753
  389473
  443457
  475706
  497725
  508428
  387221
  428922
  445433
  382513
  385677
  391086
  468470
  604295
  605617
  568019
  452279
  555857
  606294
  617214
  420769
  383036
  385373
  105333
  153376
  152883
  177651
  282666
  382650
  389352
  390910
  391322
  397644
  403160
  420622
  415094
  813848
  815363
  822410
  824096
  826230
  814967
  826135
  827827
  463953
  467120
  461044
  453747
  505466
  511688
  514139
  531298
  533523
  533619
  535849
  528305
  530666
  532347
  534864
  538030
  530547
  534677
  534860
  540383
  496399
  508271
  537609
  537941
  539661
  472877
  581237
  550186
  553812
  569160
  579696
  581960
  582026
  649079
  656544
  660531
  669563
  694914
  720061
  663879
  676608
  694908
  653811
  658826
  669397
  671408
  683877
  716004
  716017
  720351
  547101
  578549
  592217
  606502
  631479
  633897
  637869
  639394
  585913
  587723
  592292
  602059
  605625
]
3.16 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
  37730
  105333
  152883
  153376
  177651
  282666
  309223
  316911
  326297
  341753
  382513
  382650
  383036
  383564
  384022
  385373
  385677
  387221
  389352
  389473
  390910
  391086
  391322
  396597
  397644
  399156
  403160
  415094
  420622
  420769
  428922
  443457
  445433
  452279
  453747
  461044
  463953
  467120
  468470
  472877
  475706
  496399
  497725
  505466
  508271
  508428
  511688
  514139
  528305
  530547
  530666
  531298
  532347
  533523
  533619
  534677
  534860
  534864
  535849
  537609
  537941
  538030
  539661
  540383
  547101
  550186
  553812
  555857
  568019
  569160
  578549
  579696
  581237
  581960
  582026
  585913
  587723
  592217
  592292
  602059
  604295
  605617
  605625
  606294
  606502
  617214
  629201
  630259
  631479
  633897
  637869
  639394
  649079
  653811
  656544
  658826
  660531
  669397
  669563
  671408
  676608
  683877
  694908
  694914
  700678
  716004
  716017
  720061
  720351
  796232
  803477
  813848
  814967
  815363
  822410
  824096
  826135
  826230
  827827
]
2.30 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак межрасов"
]
2.11 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy interracial"
]
2.01 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.15%)
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.