GET https://search.jues.net/search/embeds/9?q=casting%20old%20man

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.01 ms
(82.34%)
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
  418650
  418727
  422594
  422639
  422652
  422863
  423400
  447258
  465051
  466161
  472467
  474642
  474681
  491354
  492067
  494622
  496032
  502889
  503151
  503802
  508485
  508487
  508769
  510757
  515644
  516450
  517073
  518472
  520740
  521444
  529084
  530269
  530757
  530833
  533463
  533471
  538023
  544381
  545610
  550774
  556014
  556017
  562373
  562491
  565191
  565254
  568537
  573926
  576398
  576399
  579359
  580860
  581301
  585335
  585716
  590731
  596323
  597139
  597227
  597253
  597263
  597266
  598057
  598590
  598828
  599856
  599887
  600290
  601635
  601856
  604102
  606508
  609147
  612222
  614867
  615440
  619592
  622401
  624179
  624505
  626541
  627804
  627809
  627813
  628175
  628365
  628366
  628368
  628376
  628377
  628388
  628392
  628409
  628420
  630540
  631965
  632689
  633782
  633788
  633798
  637023
  637078
  642691
  646838
  659409
  670758
  679810
  680116
  680118
  680126
  680167
  680255
  702927
  704256
  714497
  717744
  720056
  721846
  732878
  733909
]
16.89 ms
(11.13%)
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
  680126
  702927
  704256
  714497
  576398
  624505
  585335
  590731
  597227
  597266
  598057
  622401
  624179
  628365
  628376
  633798
  637023
  596323
  597139
  597253
  597263
  598590
  599887
  600290
  601635
  627804
  628368
  628377
  628388
  628392
  628409
  637078
  598828
  612222
  628420
  733909
  732878
  604102
  627813
  633782
  423400
  447258
  466161
  418727
  422639
  465051
  472467
  422594
  474642
  422863
  474681
  503802
  491354
  492067
  496032
  503151
  516450
  520740
  508485
  508769
  518472
  529084
  533463
  502889
  515644
  521444
  601856
  626541
  585716
  510757
  418650
  422652
  530269
  530757
  530833
  533471
  538023
  494622
  508487
  517073
  580860
  581301
  544381
  545610
  562373
  565191
  565254
  576399
  579359
  562491
  568537
  573926
  679810
  717744
  659409
  670758
  680255
  720056
  646838
  680116
  680118
  680167
  721846
  550774
  556014
  556017
  599856
  606508
  619592
  627809
  630540
  631965
  609147
  614867
  628175
  632689
  633788
  642691
  615440
  628366
]
2.65 ms
(1.74%)
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
  418650
  418727
  422594
  422639
  422652
  422863
  423400
  447258
  465051
  466161
  472467
  474642
  474681
  491354
  492067
  494622
  496032
  502889
  503151
  503802
  508485
  508487
  508769
  510757
  515644
  516450
  517073
  518472
  520740
  521444
  529084
  530269
  530757
  530833
  533463
  533471
  538023
  544381
  545610
  550774
  556014
  556017
  562373
  562491
  565191
  565254
  568537
  573926
  576398
  576399
  579359
  580860
  581301
  585335
  585716
  590731
  596323
  597139
  597227
  597253
  597263
  597266
  598057
  598590
  598828
  599856
  599887
  600290
  601635
  601856
  604102
  606508
  609147
  612222
  614867
  615440
  619592
  622401
  624179
  624505
  626541
  627804
  627809
  627813
  628175
  628365
  628366
  628368
  628376
  628377
  628388
  628392
  628409
  628420
  630540
  631965
  632689
  633782
  633788
  633798
  637023
  637078
  642691
  646838
  659409
  670758
  679810
  680116
  680118
  680126
  680167
  680255
  702927
  704256
  714497
  717744
  720056
  721846
  732878
  733909
]
2.02 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting old man"
]
1.99 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг old мужчин"
]
1.71 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кастинг old мужчин"
]

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.