GET https://search.jues.net/search/embeds/3?q=compilation%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.40 ms
(84.87%)
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
  31218
  396799
  398399
  412910
  418068
  433721
  446003
  448300
  453417
  453757
  456891
  458121
  468515
  471650
  472514
  472853
  475277
  477069
  482223
  489766
  490162
  490475
  491673
  491842
  497473
  498593
  512961
  521755
  526838
  531004
  532718
  532722
  545783
  548164
  550166
  557071
  557466
  580438
  583471
  593738
  608398
  616535
  623643
  626016
  626795
  629593
  635020
  636562
  648777
  667169
  678162
  678173
  678182
  678201
  679471
  682277
  701611
  701628
  707719
  710805
  710942
  710956
  711568
  711570
  716657
  717202
  718314
  724152
  724160
  724167
  725004
  725630
  726705
  727774
  729966
  730069
  730088
  733364
  738088
  744091
  744370
  748816
  749392
  752221
  752247
  752252
  752255
  752315
  752403
  752405
  752448
  752895
  756212
  756431
  758315
  761505
  761546
  776390
  778834
  779083
  784275
  793454
  793744
  797228
  798357
  799438
  801510
  802700
  803352
  806251
  807923
  810115
  811880
  813112
  818576
  819171
  819725
  825073
  825075
  825275
]
11.90 ms
(8.39%)
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
  813112
  724167
  752315
  752895
  398399
  716657
  793454
  730088
  724152
  761546
  818576
  548164
  667169
  711570
  701611
  799438
  725004
  730069
  724160
  717202
  778834
  797228
  531004
  701628
  635020
  608398
  811880
  793744
  806251
  718314
  779083
  490162
  682277
  629593
  744091
  727774
  758315
  761505
  472514
  489766
  825075
  472853
  752405
  678173
  756431
  491673
  396799
  550166
  798357
  31218
  810115
  498593
  490475
  583471
  557071
  679471
  710956
  648777
  678182
  710805
  636562
  725630
  726705
  748816
  412910
  471650
  776390
  752252
  710942
  512961
  448300
  491842
  807923
  453757
  825073
  825275
  446003
  477069
  453417
  475277
  711568
  678201
  593738
  626795
  784275
  733364
  819171
  557466
  707719
  801510
  752221
  752255
  729966
  752247
  752403
  526838
  744370
  418068
  623643
  626016
  456891
  819725
  678162
  458121
  532718
  532722
  616535
  803352
  802700
  749392
  738088
  752448
  433721
  521755
  545783
  756212
  482223
  497473
  468515
  580438
]
3.01 ms
(2.12%)
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
  31218
  396799
  398399
  412910
  418068
  433721
  446003
  448300
  453417
  453757
  456891
  458121
  468515
  471650
  472514
  472853
  475277
  477069
  482223
  489766
  490162
  490475
  491673
  491842
  497473
  498593
  512961
  521755
  526838
  531004
  532718
  532722
  545783
  548164
  550166
  557071
  557466
  580438
  583471
  593738
  608398
  616535
  623643
  626016
  626795
  629593
  635020
  636562
  648777
  667169
  678162
  678173
  678182
  678201
  679471
  682277
  701611
  701628
  707719
  710805
  710942
  710956
  711568
  711570
  716657
  717202
  718314
  724152
  724160
  724167
  725004
  725630
  726705
  727774
  729966
  730069
  730088
  733364
  738088
  744091
  744370
  748816
  749392
  752221
  752247
  752252
  752255
  752315
  752403
  752405
  752448
  752895
  756212
  756431
  758315
  761505
  761546
  776390
  778834
  779083
  784275
  793454
  793744
  797228
  798357
  799438
  801510
  802700
  803352
  806251
  807923
  810115
  811880
  813112
  818576
  819171
  819725
  825073
  825075
  825275
]
1.87 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation latina"
]
1.75 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк латинская"
]
1.55 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "подборк латинская"
]
1.39 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.