GET https://search.jues.net/search/embeds/7?q=latina%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.28 ms
(87.63%)
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
  221799
  247954
  390133
  390575
  390839
  395655
  403959
  471014
  472535
  475644
  505338
  515531
  526169
  529595
  530126
  532219
  536713
  540774
  545504
  545506
  553413
  553849
  559746
  572773
  604966
  610062
  623236
  629040
  629825
  630125
  630131
  636444
  638741
  644840
  647177
  647219
  648739
  650272
  662905
  708013
  709093
  710439
  712081
  713957
  724160
  726634
  726816
  736074
  738042
  738077
  738110
  738675
  739483
  740858
  747446
  749678
  749863
  750505
  750684
  751358
  751595
  751669
  751791
  752235
  752240
  752251
  752295
  752383
  752452
  752470
  755563
  756287
  757003
  758294
  759102
  759510
  765627
  769130
  770022
  770452
  770518
  774739
  778387
  785326
  786084
  786872
  787916
  792273
  793212
  796380
  796399
  796694
  798441
  799039
  799151
  799186
  801578
  806495
  806700
  806705
  807134
  807264
  809109
  809608
  810802
  811324
  811597
  811848
  811895
  812198
  812241
  812324
  812433
  813464
  814706
  816873
  818536
  822734
  825340
  825449
]
13.85 ms
(7.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
  623236
  636444
  638741
  793212
  796380
  807134
  810802
  811324
  811895
  812241
  812433
  787916
  792273
  799039
  801578
  806700
  809109
  812324
  738077
  739483
  740858
  749863
  752235
  752240
  755563
  769130
  770022
  770452
  786872
  796399
  799151
  807264
  809608
  813464
  738110
  751595
  751669
  752470
  724160
  738042
  738675
  752251
  752452
  756287
  758294
  770518
  751358
  751791
  752295
  752383
  726634
  736074
  747446
  749678
  750505
  750684
  757003
  759102
  759510
  765627
  604966
  610062
  629040
  629825
  630125
  630131
  709093
  710439
  712081
  774739
  778387
  785326
  786084
  796694
  798441
  799186
  806495
  806705
  811597
  811848
  812198
  247954
  471014
  726816
  221799
  395655
  390575
  390133
  390839
  403959
  814706
  644840
  816873
  822734
  818536
  825340
  825449
  472535
  529595
  505338
  530126
  532219
  536713
  540774
  526169
  515531
  475644
  559746
  545504
  545506
  553413
  553849
  572773
  647177
  647219
  662905
  708013
  713957
  648739
  650272
]
2.66 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
  221799
  247954
  390133
  390575
  390839
  395655
  403959
  471014
  472535
  475644
  505338
  515531
  526169
  529595
  530126
  532219
  536713
  540774
  545504
  545506
  553413
  553849
  559746
  572773
  604966
  610062
  623236
  629040
  629825
  630125
  630131
  636444
  638741
  644840
  647177
  647219
  648739
  650272
  662905
  708013
  709093
  710439
  712081
  713957
  724160
  726634
  726816
  736074
  738042
  738077
  738110
  738675
  739483
  740858
  747446
  749678
  749863
  750505
  750684
  751358
  751595
  751669
  751791
  752235
  752240
  752251
  752295
  752383
  752452
  752470
  755563
  756287
  757003
  758294
  759102
  759510
  765627
  769130
  770022
  770452
  770518
  774739
  778387
  785326
  786084
  786872
  787916
  792273
  793212
  796380
  796399
  796694
  798441
  799039
  799151
  799186
  801578
  806495
  806700
  806705
  807134
  807264
  809109
  809608
  810802
  811324
  811597
  811848
  811895
  812198
  812241
  812324
  812433
  813464
  814706
  816873
  818536
  822734
  825340
  825449
]
1.99 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская соло"
]
1.78 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina solo"
]
1.51 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.74%)
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.