GET https://search.jues.net/search/embeds/3?q=%D1%80%D0%B0%D0%BA%D0%BE%D0%BC%20%D1%81%D0%BE%D1%81%D0%BA%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
192.27 ms
(87.01%)
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
  6968
  68869
  92038
  106162
  142853
  233135
  335472
  385688
  390386
  393127
  393572
  395933
  397308
  398447
  400019
  400617
  404383
  411967
  414094
  417430
  417851
  421547
  435407
  436250
  439747
  441708
  445880
  450256
  451590
  451715
  452442
  459213
  461659
  463501
  464711
  465497
  466431
  472295
  472601
  475201
  479449
  480359
  481323
  498943
  500425
  504656
  506468
  507858
  509588
  511349
  513793
  516730
  519754
  520543
  520729
  520761
  521352
  525865
  526560
  528893
  529191
  529230
  530130
  534226
  534736
  535785
  537100
  538991
  539061
  541294
  544223
  544503
  545139
  546887
  549128
  549201
  549249
  549619
  549663
  549787
  550681
  551028
  554124
  560435
  560490
  564504
  564601
  567404
  568166
  569401
  569503
  571809
  573301
  574675
  574742
  575707
  578432
  578436
  579192
  582297
  582498
  582792
  583954
  584507
  587619
  593506
  598569
  604673
  615006
  619593
  622911
  623811
  631719
  635007
  645235
  660075
  668780
  668782
  672677
  769303
]
19.16 ms
(8.67%)
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
  525865
  534226
  538991
  511349
  528893
  526560
  534736
  535785
  537100
  529230
  466431
  479449
  480359
  549201
  574675
  544223
  544503
  573301
  575707
  578432
  568166
  574742
  645235
  668780
  672677
  567404
  578436
  598569
  587619
  619593
  622911
  615006
  631719
  635007
  604673
  623811
  769303
  395933
  400617
  475201
  106162
  142853
  397308
  441708
  459213
  68869
  92038
  439747
  450256
  461659
  233135
  393127
  400019
  464711
  520543
  520729
  571809
  385688
  393572
  335472
  6968
  390386
  398447
  404383
  417851
  417430
  421547
  414094
  411967
  435407
  436250
  451715
  465497
  445880
  472601
  451590
  452442
  472295
  481323
  521352
  504656
  500425
  513793
  519754
  520761
  498943
  506468
  507858
  509588
  516730
  529191
  530130
  539061
  463501
  549249
  549663
  560435
  545139
  549128
  549619
  551028
  564601
  569503
  582792
  583954
  541294
  550681
  560490
  564504
  569401
  660075
  668782
  546887
  549787
  554124
  579192
  582297
  582498
  584507
  593506
]
3.26 ms
(1.48%)
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
  6968
  68869
  92038
  106162
  142853
  233135
  335472
  385688
  390386
  393127
  393572
  395933
  397308
  398447
  400019
  400617
  404383
  411967
  414094
  417430
  417851
  421547
  435407
  436250
  439747
  441708
  445880
  450256
  451590
  451715
  452442
  459213
  461659
  463501
  464711
  465497
  466431
  472295
  472601
  475201
  479449
  480359
  481323
  498943
  500425
  504656
  506468
  507858
  509588
  511349
  513793
  516730
  519754
  520543
  520729
  520761
  521352
  525865
  526560
  528893
  529191
  529230
  530130
  534226
  534736
  535785
  537100
  538991
  539061
  541294
  544223
  544503
  545139
  546887
  549128
  549201
  549249
  549619
  549663
  549787
  550681
  551028
  554124
  560435
  560490
  564504
  564601
  567404
  568166
  569401
  569503
  571809
  573301
  574675
  574742
  575707
  578432
  578436
  579192
  582297
  582498
  582792
  583954
  584507
  587619
  593506
  598569
  604673
  615006
  619593
  622911
  623811
  631719
  635007
  645235
  660075
  668780
  668782
  672677
  769303
]
1.82 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "раком соску"
]
1.55 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак соск"
]
1.37 ms
(0.62%)
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.