GET https://search.jues.net/search/embeds/8?q=sex%20erotic

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.83 ms
(88.33%)
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
  56806
  89205
  281431
  392319
  406852
  432533
  490744
  525798
  529993
  530567
  530569
  534068
  535185
  540563
  544305
  547304
  547310
  547345
  549370
  549391
  552141
  552152
  555493
  557285
  558717
  559419
  560356
  560808
  560876
  563083
  569383
  570776
  571733
  572575
  572578
  575624
  577286
  577751
  578779
  579783
  579918
  584232
  584437
  585635
  587209
  592172
  592938
  593065
  601816
  602637
  602887
  609089
  614063
  614201
  615886
  622336
  623115
  636520
  636836
  638560
  639856
  639913
  640483
  649933
  650108
  664191
  666602
  667244
  669244
  669481
  669689
  670448
  670569
  674264
  676944
  678570
  679352
  680476
  690290
  693408
  696168
  704188
  708001
  708530
  712398
  713030
  716135
  718346
  722452
  722944
  734382
  741134
  741211
  745311
  746589
  761339
  769089
  769358
  777299
  778655
  780403
  785403
  785472
  786789
  793008
  797822
  798299
  800821
  801783
  803032
  803234
  806753
  806997
  808664
  808673
  810523
  812142
  812420
  813631
  814197
]
11.47 ms
(6.38%)
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
  745311
  746589
  490744
  544305
  549391
  578779
  592938
  587209
  432533
  392319
  281431
  56806
  89205
  406852
  814197
  813631
  525798
  529993
  530569
  534068
  530567
  535185
  540563
  547310
  552152
  560876
  572578
  549370
  555493
  563083
  575624
  577751
  579783
  584437
  560356
  560808
  570776
  577286
  670448
  680476
  690290
  696168
  708530
  712398
  713030
  722944
  650108
  667244
  669689
  716135
  718346
  649933
  664191
  666602
  669244
  669481
  670569
  674264
  676944
  678570
  679352
  693408
  704188
  708001
  722452
  547304
  547345
  552141
  557285
  558717
  559419
  569383
  571733
  572575
  579918
  584232
  614063
  615886
  622336
  636520
  640483
  602637
  609089
  614201
  623115
  639856
  602887
  636836
  585635
  592172
  593065
  601816
  638560
  639913
  777299
  778655
  797822
  803032
  806997
  808664
  808673
  780403
  786789
  798299
  800821
  803234
  806753
  810523
  812420
  741134
  741211
  761339
  769089
  769358
  785403
  785472
  793008
  801783
  812142
  734382
]
2.90 ms
(1.61%)
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
  56806
  89205
  281431
  392319
  406852
  432533
  490744
  525798
  529993
  530567
  530569
  534068
  535185
  540563
  544305
  547304
  547310
  547345
  549370
  549391
  552141
  552152
  555493
  557285
  558717
  559419
  560356
  560808
  560876
  563083
  569383
  570776
  571733
  572575
  572578
  575624
  577286
  577751
  578779
  579783
  579918
  584232
  584437
  585635
  587209
  592172
  592938
  593065
  601816
  602637
  602887
  609089
  614063
  614201
  615886
  622336
  623115
  636520
  636836
  638560
  639856
  639913
  640483
  649933
  650108
  664191
  666602
  667244
  669244
  669481
  669689
  670448
  670569
  674264
  676944
  678570
  679352
  680476
  690290
  693408
  696168
  704188
  708001
  708530
  712398
  713030
  716135
  718346
  722452
  722944
  734382
  741134
  741211
  745311
  746589
  761339
  769089
  769358
  777299
  778655
  780403
  785403
  785472
  786789
  793008
  797822
  798299
  800821
  801783
  803032
  803234
  806753
  806997
  808664
  808673
  810523
  812142
  812420
  813631
  814197
]
1.97 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex erotic"
]
1.68 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс эротик"
]
1.38 ms
(0.77%)
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.