GET https://search.jues.net/search/embeds/4?q=brunette%20maid

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.48 ms
(86.81%)
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
  97689
  97769
  172322
  183506
  358849
  383829
  384282
  384977
  385341
  385709
  386658
  390643
  393355
  398982
  399456
  400521
  403404
  403416
  403467
  403476
  420143
  421053
  435549
  436479
  446756
  447556
  456636
  461697
  472830
  472879
  472897
  472924
  472935
  472959
  473499
  476578
  478621
  481157
  481662
  496162
  503322
  509911
  513446
  514252
  517607
  519534
  524469
  526046
  527484
  528027
  535700
  536726
  540207
  540550
  545718
  550712
  552030
  556843
  561134
  563069
  564583
  564719
  564736
  564740
  564741
  567354
  568133
  578131
  583144
  584128
  591063
  591383
  591492
  591522
  596793
  596796
  596901
  597777
  597786
  600406
  615513
  619469
  630941
  636658
  641156
  643007
  663875
  664504
  677048
  677963
  680898
  691989
  699646
  700966
  713820
  715891
  729764
  736596
  741046
  748437
  751664
  766861
  775396
  775598
  779686
  780254
  781481
  788025
  789260
  789477
  791003
  803135
  810056
  810766
  814743
  818173
  818278
  818302
  824214
]
14.13 ms
(8.05%)
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
  810056
  814743
  476578
  536726
  514252
  472935
  545718
  552030
  564719
  564741
  561134
  596793
  172322
  591063
  781481
  810766
  97769
  818302
  824187
  540550
  456636
  472924
  583144
  600406
  641156
  591383
  751664
  615513
  461697
  447556
  556843
  550712
  729764
  524469
  596901
  481157
  472879
  527484
  824214
  478621
  383829
  97689
  400521
  421053
  818173
  481662
  568133
  775396
  775598
  779686
  780254
  791003
  788025
  766861
  748437
  630941
  358849
  513446
  503322
  677963
  564740
  386658
  384282
  399456
  403416
  403476
  403467
  420143
  818278
  472830
  446756
  472897
  509911
  535700
  564583
  563069
  584128
  680898
  700966
  564736
  597777
  619469
  643007
  596796
  597786
  636658
  741046
  390643
  393355
  403404
  183506
  436479
  472959
  526046
  519534
  528027
  473499
  496162
  677048
  715891
  789477
  540207
  789260
  567354
  398982
  713820
  578131
  591492
  591522
  803135
  736596
  699646
  384977
  385709
  435549
  385341
  517607
  691989
  663875
  664504
]
2.50 ms
(1.42%)
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
  97689
  97769
  172322
  183506
  358849
  383829
  384282
  384977
  385341
  385709
  386658
  390643
  393355
  398982
  399456
  400521
  403404
  403416
  403467
  403476
  420143
  421053
  435549
  436479
  446756
  447556
  456636
  461697
  472830
  472879
  472897
  472924
  472935
  472959
  473499
  476578
  478621
  481157
  481662
  496162
  503322
  509911
  513446
  514252
  517607
  519534
  524469
  526046
  527484
  528027
  535700
  536726
  540207
  540550
  545718
  550712
  552030
  556843
  561134
  563069
  564583
  564719
  564736
  564740
  564741
  567354
  568133
  578131
  583144
  584128
  591063
  591383
  591492
  591522
  596793
  596796
  596901
  597777
  597786
  600406
  615513
  619469
  630941
  636658
  641156
  643007
  663875
  664504
  677048
  677963
  680898
  691989
  699646
  700966
  713820
  715891
  729764
  736596
  741046
  748437
  751664
  766861
  775396
  775598
  779686
  780254
  781481
  788025
  789260
  789477
  791003
  803135
  810056
  810766
  814743
  818173
  818278
  818302
  824214
]
1.84 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette maid"
]
1.62 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая горничн"
]
1.45 ms
(0.83%)
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.