GET https://search.jues.net/search/embeds/6?q=sport%20in%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.14 ms
(54.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "спортивная секс"
]
153.80 ms
(39.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
  393775
  424624
  427699
  428283
  443162
  444839
  446497
  455562
  455811
  457512
  458921
  459748
  463693
  464687
  464836
  465558
  469100
  469597
  471314
  471392
  473738
  473740
  473778
  475475
  487855
  495292
  497336
  498061
  498523
  500740
  501103
  503632
  507368
  509952
  510146
  510170
  510798
  511936
  514090
  514621
  514867
  515275
  515452
  515535
  515556
  516460
  516465
  518176
  521285
  521549
  522231
  524253
  524479
  524939
  528776
  529553
  529969
  530685
  531497
  531777
  532781
  533897
  534106
  534307
  534825
  535540
  538498
  541482
  546723
  547762
  548108
  550676
  550884
  551676
  553964
  559195
  560352
  560401
  560917
  564385
  568381
  568481
  568535
  569111
  576943
  579271
  584320
  584558
  585020
  585281
  587039
  592605
  595176
  601077
  604115
  604640
  604790
  604909
  605857
  620575
  624845
  626593
  632148
  637750
  641095
  641362
  644541
  655453
  683023
  724979
  751582
  757078
  775414
  788119
  790034
  806455
  810703
  815108
  817059
  818456
]
17.26 ms
(4.41%)
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
  518176
  443162
  500740
  620575
  535540
  528776
  503632
  510170
  550676
  551676
  683023
  605857
  624845
  637750
  775414
  463693
  424624
  510146
  498523
  569111
  475475
  529553
  522231
  533897
  538498
  501103
  515535
  530685
  532781
  529969
  541482
  546723
  576943
  568381
  568481
  560917
  584558
  641362
  641095
  788119
  724979
  751582
  632148
  806455
  455811
  515556
  516460
  524939
  497336
  595176
  457512
  469100
  471314
  473740
  511936
  514090
  458921
  428283
  427699
  585020
  446497
  465558
  464836
  509952
  521285
  515275
  464687
  469597
  547762
  568535
  548108
  560352
  579271
  584320
  655453
  553964
  560401
  587039
  604909
  592605
  626593
  604115
  757078
  604640
  444839
  473778
  455562
  507368
  515452
  516465
  487855
  498061
  495292
  510798
  514621
  514867
  473738
  550884
  604790
  524479
  534106
  459748
  471392
  601077
  815108
  818456
  534307
  531777
  790034
  393775
  521549
  564385
  524253
  817059
  644541
  810703
  534825
  531497
  559195
  585281
]
3.19 ms
(0.82%)
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
  393775
  424624
  427699
  428283
  443162
  444839
  446497
  455562
  455811
  457512
  458921
  459748
  463693
  464687
  464836
  465558
  469100
  469597
  471314
  471392
  473738
  473740
  473778
  475475
  487855
  495292
  497336
  498061
  498523
  500740
  501103
  503632
  507368
  509952
  510146
  510170
  510798
  511936
  514090
  514621
  514867
  515275
  515452
  515535
  515556
  516460
  516465
  518176
  521285
  521549
  522231
  524253
  524479
  524939
  528776
  529553
  529969
  530685
  531497
  531777
  532781
  533897
  534106
  534307
  534825
  535540
  538498
  541482
  546723
  547762
  548108
  550676
  550884
  551676
  553964
  559195
  560352
  560401
  560917
  564385
  568381
  568481
  568535
  569111
  576943
  579271
  584320
  584558
  585020
  585281
  587039
  592605
  595176
  601077
  604115
  604640
  604790
  604909
  605857
  620575
  624845
  626593
  632148
  637750
  641095
  641362
  644541
  655453
  683023
  724979
  751582
  757078
  775414
  788119
  790034
  806455
  810703
  815108
  817059
  818456
]
1.88 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sport in sex"
]
1.87 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.