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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
268.03 ms
(90.56%)
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
  445802
  446864
  456079
  479786
  485802
  514312
  518244
  520792
  524211
  524667
  525182
  527769
  528635
  533181
  539441
  546296
  548848
  557688
  580600
  595645
  599574
  602595
  616364
  616576
  623452
  627218
  648654
  650369
  662872
  673974
  698359
  738807
  748360
  757296
  757585
  764836
  765033
  765219
  765582
  766888
  767138
  768826
  769479
  769909
  771234
  771288
  771313
  773330
  778326
  779969
  780733
  784762
  785020
  785984
  788099
  789592
  790315
  790801
  794348
  796010
  796426
  796674
  796676
  797477
  797484
  797486
  801030
  802387
  803224
  807433
  809826
  809851
  810865
  811484
  811517
  812877
  813266
  813472
  813695
  813832
  813839
  813860
  814249
  815068
  818095
  819145
  819159
  819177
  819668
  820430
  820435
  820540
  820935
  820990
  821023
  821059
  821101
  821123
  821204
  821210
  821229
  821268
  821450
  821515
  821567
  821626
  821644
  821726
  821991
  822230
  822921
  823088
  823139
  823285
  823320
  823413
  823530
  825075
  825348
]
18.66 ms
(6.30%)
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
  446864
  524667
  514312
  520792
  524211
  539441
  485802
  518244
  790801
  445802
  479786
  456079
  528635
  548848
  813832
  821059
  821229
  823139
  823285
  823320
  813860
  814249
  818095
  819145
  820430
  820540
  820990
  821210
  821268
  821644
  821991
  823413
  825348
  813695
  813839
  819177
  819668
  821101
  821123
  821726
  822230
  822921
  823088
  815068
  819159
  820435
  820935
  821023
  821204
  821450
  821515
  821567
  821626
  823530
  825075
  525182
  527769
  533181
  557688
  546296
  580600
  648654
  662872
  650369
  673974
  698359
  616364
  623452
  627218
  595645
  599574
  602595
  616576
  779969
  780733
  785984
  789592
  797484
  797486
  801030
  802387
  803224
  809851
  811517
  812877
  778326
  785020
  790315
  796674
  796676
  809826
  810865
  813472
  757296
  764836
  765582
  767138
  768826
  773292
  784762
  788099
  794348
  796010
  796426
  797477
  807433
  811484
  813266
  757585
  769479
  771288
  771313
  765033
  765219
  769909
  771234
  773330
  738807
  766888
  748360
]
2.73 ms
(0.92%)
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
  445802
  446864
  456079
  479786
  485802
  514312
  518244
  520792
  524211
  524667
  525182
  527769
  528635
  533181
  539441
  546296
  548848
  557688
  580600
  595645
  599574
  602595
  616364
  616576
  623452
  627218
  648654
  650369
  662872
  673974
  698359
  738807
  748360
  757296
  757585
  764836
  765033
  765219
  765582
  766888
  767138
  768826
  769479
  769909
  771234
  771288
  771313
  773330
  778326
  779969
  780733
  784762
  785020
  785984
  788099
  789592
  790315
  790801
  794348
  796010
  796426
  796674
  796676
  797477
  797484
  797486
  801030
  802387
  803224
  807433
  809826
  809851
  810865
  811484
  811517
  812877
  813266
  813472
  813695
  813832
  813839
  813860
  814249
  815068
  818095
  819145
  819159
  819177
  819668
  820430
  820435
  820540
  820935
  820990
  821023
  821059
  821101
  821123
  821204
  821210
  821229
  821268
  821450
  821515
  821567
  821626
  821644
  821726
  821991
  822230
  822921
  823088
  823139
  823285
  823320
  823413
  823530
  825075
  825348
]
1.79 ms
(0.61%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов латинская"
]
1.74 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov latina"
]
1.53 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.51%)
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.