GET https://search.jues.net/search/embeds/3?q=bbc%20mmf%20interracial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.12 ms
(86.65%)
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
  96256
  373803
  387562
  389987
  393613
  395411
  395489
  396565
  396599
  396708
  396742
  397531
  397946
  399689
  400934
  402343
  404622
  405176
  407429
  408462
  408528
  411284
  412713
  420252
  425316
  431405
  448215
  449011
  450204
  451579
  463864
  471896
  478610
  491272
  501480
  513126
  521805
  521942
  522883
  523300
  530450
  530492
  531393
  531982
  532783
  533372
  534804
  535679
  536242
  536898
  537591
  537840
  539926
  544833
  545785
  545791
  547082
  556958
  558437
  559327
  576428
  577454
  589754
  599862
  600346
  600429
  603180
  604191
  604508
  604553
  604571
  605617
  606962
  606977
  607013
  607080
  611716
  616336
  616629
  630915
  630916
  637437
  638997
  641756
  646733
  647357
  648854
  650506
  651270
  651630
  651650
  653830
  653876
  654294
  666575
  666584
  674430
  675806
  681313
  695929
  697369
  698095
  700281
  710668
  711900
  714556
  718388
  719004
  719427
  719862
  720394
  732341
  737550
  780637
  802346
  808406
  815784
  818439
  825042
  828369
]
12.86 ms
(7.23%)
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
  425316
  545785
  653876
  544833
  630916
  478610
  491272
  681313
  719427
  389987
  408528
  666584
  719862
  607080
  732341
  412713
  674430
  604571
  637437
  606962
  780637
  396599
  96256
  405176
  395411
  397531
  535679
  539926
  471896
  576428
  646733
  651270
  653830
  654294
  606977
  611716
  607013
  737550
  411284
  451579
  534804
  450204
  393613
  402343
  431405
  407429
  825042
  536242
  559327
  714556
  651630
  675806
  695929
  700281
  711900
  719004
  616629
  603180
  802346
  808406
  604553
  399689
  521942
  815784
  530450
  531982
  537840
  718388
  647357
  650506
  651650
  589754
  638997
  387562
  522883
  697369
  698095
  604191
  556958
  547082
  604508
  600429
  666575
  536898
  600346
  396565
  395489
  532783
  630915
  400934
  720394
  641756
  523300
  616336
  373803
  420252
  396708
  828369
  397946
  408462
  537591
  531393
  710668
  577454
  818439
  449011
  530492
  513126
  545791
  648854
  605617
  501480
  599862
  533372
  558437
  463864
  521805
  396742
  404622
  448215
]
3.12 ms
(1.75%)
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
  96256
  373803
  387562
  389987
  393613
  395411
  395489
  396565
  396599
  396708
  396742
  397531
  397946
  399689
  400934
  402343
  404622
  405176
  407429
  408462
  408528
  411284
  412713
  420252
  425316
  431405
  448215
  449011
  450204
  451579
  463864
  471896
  478610
  491272
  501480
  513126
  521805
  521942
  522883
  523300
  530450
  530492
  531393
  531982
  532783
  533372
  534804
  535679
  536242
  536898
  537591
  537840
  539926
  544833
  545785
  545791
  547082
  556958
  558437
  559327
  576428
  577454
  589754
  599862
  600346
  600429
  603180
  604191
  604508
  604553
  604571
  605617
  606962
  606977
  607013
  607080
  611716
  616336
  616629
  630915
  630916
  637437
  638997
  641756
  646733
  647357
  648854
  650506
  651270
  651630
  651650
  653830
  653876
  654294
  666575
  666584
  674430
  675806
  681313
  695929
  697369
  698095
  700281
  710668
  711900
  714556
  718388
  719004
  719427
  719862
  720394
  732341
  737550
  780637
  802346
  808406
  815784
  818439
  825042
  828369
]
2.08 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc mmf interracial"
]
2.00 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbc мжм секс втро межрасов"
]
1.86 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.03%)
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.