GET https://search.jues.net/search/embeds/9?q=compilation%20small

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.73 ms
(84.93%)
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
  387937
  415818
  423424
  423568
  424873
  425786
  429906
  431962
  443389
  445327
  445526
  446257
  446815
  447640
  448414
  451696
  452612
  452617
  464651
  465198
  466492
  469200
  471380
  472544
  473737
  475280
  479119
  481602
  483536
  485527
  488235
  490120
  491248
  491480
  492926
  495212
  497545
  503105
  503118
  504081
  506811
  508303
  511067
  513217
  515380
  516607
  517855
  520215
  521287
  528304
  528945
  528947
  528966
  529348
  532338
  534335
  535486
  535657
  540241
  545319
  548046
  549101
  549320
  550476
  551991
  552006
  554119
  559822
  559886
  560667
  561089
  563885
  565499
  566047
  566289
  568387
  568503
  569128
  569204
  569778
  569821
  570812
  571228
  574718
  585717
  586597
  586598
  586603
  587979
  590952
  597946
  601438
  603732
  605581
  606618
  607743
  613515
  619126
  627725
  671085
  680859
  694553
  697912
  700282
  721958
  728362
  743021
  750334
  773683
  774009
  778785
  785109
  801227
  802827
  805011
  805164
  814347
  814650
  821836
]
17.17 ms
(9.36%)
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
  728362
  750334
  805011
  528945
  497545
  488235
  491480
  387937
  423568
  814347
  447640
  491248
  446257
  451696
  485527
  517855
  529348
  535486
  503105
  511067
  516607
  464651
  472544
  585717
  586598
  452612
  469200
  481602
  448414
  473737
  492926
  520215
  521287
  508303
  828061
  571228
  559886
  551991
  550476
  778785
  559822
  568503
  569128
  568387
  554119
  560667
  565499
  569778
  680859
  548046
  552006
  561089
  563885
  566047
  607743
  619126
  603732
  570812
  587979
  466492
  613515
  627725
  425786
  471380
  814650
  821836
  446815
  504081
  528947
  528966
  535657
  540241
  528304
  534335
  549320
  566289
  671085
  700282
  694553
  697912
  721958
  545319
  549101
  569821
  601438
  606618
  590952
  605581
  805164
  801227
  743021
  773683
  785109
  802827
  479119
  515380
  532338
  506811
  586603
  774009
  445526
  495212
  513217
  490120
  569204
  597946
  423424
  443389
  429906
  431962
  424873
  445327
  483536
  503118
  475280
  574718
  586597
  465198
  452617
  415818
]
2.77 ms
(1.51%)
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
  387937
  415818
  423424
  423568
  424873
  425786
  429906
  431962
  443389
  445327
  445526
  446257
  446815
  447640
  448414
  451696
  452612
  452617
  464651
  465198
  466492
  469200
  471380
  472544
  473737
  475280
  479119
  481602
  483536
  485527
  488235
  490120
  491248
  491480
  492926
  495212
  497545
  503105
  503118
  504081
  506811
  508303
  511067
  513217
  515380
  516607
  517855
  520215
  521287
  528304
  528945
  528947
  528966
  529348
  532338
  534335
  535486
  535657
  540241
  545319
  548046
  549101
  549320
  550476
  551991
  552006
  554119
  559822
  559886
  560667
  561089
  563885
  565499
  566047
  566289
  568387
  568503
  569128
  569204
  569778
  569821
  570812
  571228
  574718
  585717
  586597
  586598
  586603
  587979
  590952
  597946
  601438
  603732
  605581
  606618
  607743
  613515
  619126
  627725
  671085
  680859
  694553
  697912
  700282
  721958
  728362
  743021
  750334
  773683
  774009
  778785
  785109
  801227
  802827
  805011
  805164
  814347
  814650
  821836
]
2.38 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation small"
]
1.87 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк маленькая"
]
1.73 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "подборк маленькая"
]
1.71 ms
(0.93%)
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.