GET https://search.jues.net/search/embeds/4?q=%D0%BF%D0%B8%D0%B7%D0%B4%D0%B0%20%D0%B5%D0%B1%D1%83%D1%82

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.93 ms
(85.18%)
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
  76853
  114536
  401103
  444586
  464449
  477200
  483871
  485835
  490050
  490638
  492968
  494672
  496213
  498890
  499301
  500021
  501072
  501209
  502028
  503775
  505633
  508268
  509361
  511821
  513378
  520327
  521386
  524116
  525151
  527735
  528146
  533459
  535343
  535626
  535742
  536912
  539349
  541096
  543467
  545623
  546266
  549380
  550911
  551737
  551815
  554185
  555632
  557306
  557908
  558268
  559098
  560988
  561300
  561488
  562106
  562289
  562821
  564680
  566334
  567570
  568739
  568782
  569965
  578163
  581158
  583298
  583716
  585873
  589015
  589331
  591534
  591561
  591696
  592308
  593966
  596967
  597872
  598362
  600828
  602389
  602438
  603061
  604050
  606717
  609275
  612483
  612847
  613732
  614637
  615851
  618220
  618995
  619414
  622294
  625547
  630825
  633095
  633424
  634917
  642130
  642813
  645706
  647911
  657312
  660022
  663432
  663854
  664676
  668768
  673152
  673575
  680854
  684937
  686710
  687437
  726463
  785245
  787257
  796794
]
13.21 ms
(8.66%)
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
  686710
  597872
  554185
  511821
  560988
  603061
  612483
  645706
  527735
  503775
  543467
  524116
  521386
  663854
  633095
  562106
  490638
  501072
  598362
  642813
  613732
  614637
  600828
  630825
  528146
  625547
  591534
  401103
  500021
  533459
  551815
  549380
  492968
  541096
  664676
  585873
  485835
  619414
  633424
  606717
  551737
  508268
  796794
  499301
  604050
  618220
  539349
  668768
  596967
  785245
  787257
  509361
  562289
  568739
  567570
  546266
  555632
  562821
  657312
  673575
  589331
  592308
  535742
  602438
  477200
  647911
  76853
  520327
  609275
  583716
  564680
  561300
  591561
  557306
  726463
  593966
  602389
  642130
  535626
  498890
  513378
  525151
  505633
  663432
  684937
  494672
  615851
  444586
  526388
  545623
  581158
  680854
  464449
  536912
  496213
  622294
  114536
  612847
  673152
  569965
  591696
  483871
  558268
  660022
  583298
  687437
  490050
  557908
  561488
  589015
  535343
  578163
  559098
  566334
  618995
  501209
  550911
  568782
  634917
  502028
]
3.06 ms
(2.01%)
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
  76853
  114536
  401103
  444586
  464449
  477200
  483871
  485835
  490050
  490638
  492968
  494672
  496213
  498890
  499301
  500021
  501072
  501209
  502028
  503775
  505633
  508268
  509361
  511821
  513378
  520327
  521386
  524116
  525151
  527735
  528146
  533459
  535343
  535626
  535742
  536912
  539349
  541096
  543467
  545623
  546266
  549380
  550911
  551737
  551815
  554185
  555632
  557306
  557908
  558268
  559098
  560988
  561300
  561488
  562106
  562289
  562821
  564680
  566334
  567570
  568739
  568782
  569965
  578163
  581158
  583298
  583716
  585873
  589015
  589331
  591534
  591561
  591696
  592308
  593966
  596967
  597872
  598362
  600828
  602389
  602438
  603061
  604050
  606717
  609275
  612483
  612847
  613732
  614637
  615851
  618220
  618995
  619414
  622294
  625547
  630825
  633095
  633424
  634917
  642130
  642813
  645706
  647911
  657312
  660022
  663432
  663854
  664676
  668768
  673152
  673575
  680854
  684937
  686710
  687437
  726463
  785245
  787257
  796794
]
1.78 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пизда ебут"
]
1.55 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин секс"
]
1.33 ms
(0.87%)
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.