GET https://search.jues.net/search/embeds/7?q=%D0%BD%D0%B0%20%D1%80%D1%83%D0%BA%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.93 ms
(83.47%)
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
  369753
  402154
  418078
  438023
  440659
  454514
  457530
  458160
  476496
  479361
  480028
  481352
  481764
  482306
  483146
  486197
  486939
  489001
  491570
  491793
  494658
  496308
  498914
  499045
  508576
  509633
  515215
  515774
  517521
  517766
  522545
  525771
  526259
  526550
  527044
  527339
  533403
  533480
  533960
  534673
  536469
  540724
  545232
  545500
  545768
  547653
  548239
  548312
  552602
  552675
  555011
  555636
  555965
  558106
  558448
  559186
  559674
  559689
  559785
  561260
  562289
  562844
  563715
  564019
  566639
  566726
  569108
  570195
  570843
  571010
  573274
  574648
  575392
  575440
  575846
  576289
  578572
  581946
  583285
  583336
  584660
  588750
  589485
  590660
  591243
  591938
  592372
  594824
  595674
  600653
  600941
  602030
  602671
  605425
  606095
  607632
  608320
  608705
  613797
  614396
  617073
  618656
  619159
  619663
  621040
  624116
  626217
  626607
  634223
  634736
  635480
  639686
  642269
  643669
  655275
  656321
  672343
  682417
  684402
  689436
]
16.14 ms
(9.84%)
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
  555965
  566726
  547653
  559186
  559689
  569108
  583285
  584660
  555636
  563715
  570195
  575846
  578572
  672343
  656321
  682417
  545500
  552675
  562289
  566639
  571010
  575440
  576289
  583336
  595674
  605425
  591243
  600941
  602030
  618656
  626217
  642269
  590660
  592372
  639686
  617073
  480028
  369753
  479361
  454514
  440659
  438023
  540724
  491570
  508576
  496308
  527339
  558448
  559785
  491793
  499045
  509633
  515774
  525771
  534673
  486197
  545768
  548239
  555011
  634736
  517521
  482306
  481352
  515215
  526550
  526259
  533480
  517766
  483146
  655275
  689436
  591938
  634223
  600653
  607632
  619663
  608320
  621040
  481764
  418078
  476496
  522545
  548312
  574648
  545232
  581946
  561260
  684402
  558106
  573274
  613797
  594824
  619159
  614396
  527044
  498914
  402154
  489001
  486939
  533403
  533960
  536469
  494658
  564019
  570843
  559674
  552602
  562844
  575392
  606095
  635480
  602671
  626607
  588750
  643669
  589485
  624116
  608705
  457530
  458160
]
3.45 ms
(2.10%)
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
  369753
  402154
  418078
  438023
  440659
  454514
  457530
  458160
  476496
  479361
  480028
  481352
  481764
  482306
  483146
  486197
  486939
  489001
  491570
  491793
  494658
  496308
  498914
  499045
  508576
  509633
  515215
  515774
  517521
  517766
  522545
  525771
  526259
  526550
  527044
  527339
  533403
  533480
  533960
  534673
  536469
  540724
  545232
  545500
  545768
  547653
  548239
  548312
  552602
  552675
  555011
  555636
  555965
  558106
  558448
  559186
  559674
  559689
  559785
  561260
  562289
  562844
  563715
  564019
  566639
  566726
  569108
  570195
  570843
  571010
  573274
  574648
  575392
  575440
  575846
  576289
  578572
  581946
  583285
  583336
  584660
  588750
  589485
  590660
  591243
  591938
  592372
  594824
  595674
  600653
  600941
  602030
  602671
  605425
  606095
  607632
  608320
  608705
  613797
  614396
  617073
  618656
  619159
  619663
  621040
  624116
  626217
  626607
  634223
  634736
  635480
  639686
  642269
  643669
  655275
  656321
  672343
  682417
  684402
  689436
]
2.11 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на руке"
]
1.83 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на рук"
]
1.76 ms
(1.07%)
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.