GET https://search.jues.net/search/embeds/7?q=%D0%B1%D0%B5%D0%B7%20%D1%8E%D0%B1%D0%BA%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.17 ms
(84.99%)
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
  42917
  149429
  233570
  305556
  325253
  334474
  382419
  382540
  382573
  383735
  384594
  386974
  387245
  387368
  387854
  389560
  390461
  392611
  393306
  398195
  398853
  398974
  401785
  402239
  403872
  405904
  412857
  413109
  416925
  426767
  428093
  429341
  432483
  432657
  442060
  443327
  446478
  453406
  454301
  457011
  458736
  459172
  460164
  461252
  465190
  465977
  466462
  467784
  475048
  484234
  485348
  490812
  491360
  492418
  492770
  512200
  513167
  522571
  528305
  528675
  529906
  529916
  529924
  532070
  535710
  536720
  539932
  547058
  547870
  549374
  550117
  550149
  551534
  551926
  551953
  553163
  553334
  554492
  554788
  556855
  557263
  557454
  557524
  560265
  562849
  563942
  569726
  572734
  573233
  574143
  576729
  581555
  588344
  594903
  600213
  609040
  613647
  617074
  621026
  622354
  622607
  625618
  634400
  642113
  647147
  647217
  657145
  657884
  658349
  659682
  660934
  665094
  690858
  707310
  712063
  782081
  782152
  817876
  825559
  825611
]
17.06 ms
(9.16%)
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
  528305
  512200
  492418
  551953
  572734
  690858
  647217
  562849
  613647
  621026
  782081
  475048
  233570
  382573
  390461
  443327
  454301
  485348
  393306
  392611
  325253
  334474
  382419
  42917
  387854
  398195
  398853
  403872
  405904
  432657
  426767
  416925
  817876
  825559
  825611
  490812
  457011
  459172
  460164
  484234
  491360
  446478
  453406
  513167
  522571
  529924
  528675
  529916
  532070
  535710
  550149
  553334
  554492
  560265
  574143
  576729
  557263
  547058
  554788
  557524
  569726
  573233
  581555
  659682
  665094
  712063
  657145
  660934
  547870
  553163
  556855
  563942
  594903
  622354
  642113
  634400
  625618
  588344
  782152
  617074
  707310
  382540
  386974
  401785
  412857
  413109
  432483
  383735
  387245
  398974
  467784
  305556
  458736
  387368
  402239
  492770
  389560
  429341
  442060
  428093
  465190
  529906
  536720
  539932
  551534
  551926
  549374
  647147
  657884
  658349
  550117
  557454
  600213
  609040
  622607
  384594
  149429
  461252
  465977
  466462
]
3.24 ms
(1.74%)
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
  42917
  149429
  233570
  305556
  325253
  334474
  382419
  382540
  382573
  383735
  384594
  386974
  387245
  387368
  387854
  389560
  390461
  392611
  393306
  398195
  398853
  398974
  401785
  402239
  403872
  405904
  412857
  413109
  416925
  426767
  428093
  429341
  432483
  432657
  442060
  443327
  446478
  453406
  454301
  457011
  458736
  459172
  460164
  461252
  465190
  465977
  466462
  467784
  475048
  484234
  485348
  490812
  491360
  492418
  492770
  512200
  513167
  522571
  528305
  528675
  529906
  529916
  529924
  532070
  535710
  536720
  539932
  547058
  547870
  549374
  550117
  550149
  551534
  551926
  551953
  553163
  553334
  554492
  554788
  556855
  557263
  557454
  557524
  560265
  562849
  563942
  569726
  572734
  573233
  574143
  576729
  581555
  588344
  594903
  600213
  609040
  613647
  617074
  621026
  622354
  622607
  625618
  634400
  642113
  647147
  647217
  657145
  657884
  658349
  659682
  660934
  665094
  690858
  707310
  712063
  782081
  782152
  817876
  825559
  825611
]
2.04 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "без юбк"
]
1.99 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "без юбки"
]
1.94 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.90%)
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.