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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.14 ms
(86.05%)
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
  31218
  58408
  59007
  233330
  272566
  305824
  358410
  382182
  383541
  385712
  388850
  390580
  391485
  392082
  392391
  393886
  397155
  397866
  398239
  410079
  413356
  418621
  424284
  428033
  439455
  442429
  443938
  447200
  451225
  480083
  482853
  488684
  494893
  500877
  501541
  502934
  502999
  505569
  507112
  507439
  509264
  510197
  516374
  519473
  526683
  536944
  538099
  539652
  542117
  542298
  553620
  558226
  559015
  562544
  563588
  577512
  594552
  602979
  605632
  609512
  615377
  650649
  651392
  660770
  667150
  680295
  681780
  687310
  702310
  704418
  707161
  707419
  709340
  711139
  711749
  717274
  724908
  725022
  731173
  732211
  734637
  737318
  739230
  740763
  742220
  742561
  742742
  747507
  752487
  753762
  756370
  756424
  756685
  757878
  762049
  762830
  764387
  766114
  766265
  766272
  768300
  769496
  770977
  772474
  777939
  778410
  783136
  787425
  792022
  795195
  795966
  796097
  797712
  801800
  804988
  809914
  814993
  817578
  825171
  828804
]
12.22 ms
(7.45%)
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
  795966
  740763
  757878
  762049
  762830
  766265
  742561
  764387
  769496
  772474
  732211
  737318
  739230
  742220
  742742
  756685
  734637
  747507
  756370
  756424
  770977
  709340
  711749
  777939
  778410
  796097
  801800
  809914
  58408
  385712
  447200
  31218
  505569
  482853
  562544
  717274
  391485
  388850
  825171
  563588
  804988
  752487
  766272
  795195
  358410
  428033
  536944
  731173
  509264
  519473
  681780
  615377
  725022
  783136
  753762
  605632
  609512
  594552
  59007
  392391
  488684
  451225
  494893
  390580
  397866
  398239
  651392
  766114
  707161
  233330
  305824
  272566
  817578
  828804
  539652
  542298
  707419
  704418
  602979
  797712
  724908
  792022
  768300
  711139
  787425
  383541
  393886
  392082
  382182
  397155
  410079
  413356
  442429
  418621
  439455
  424284
  443938
  814993
  500877
  516374
  526683
  538099
  510197
  507112
  507439
  501541
  502934
  502999
  480083
  559015
  542117
  577512
  553620
  558226
  650649
  660770
  667150
  680295
  687310
  702310
]
3.14 ms
(1.91%)
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
  31218
  58408
  59007
  233330
  272566
  305824
  358410
  382182
  383541
  385712
  388850
  390580
  391485
  392082
  392391
  393886
  397155
  397866
  398239
  410079
  413356
  418621
  424284
  428033
  439455
  442429
  443938
  447200
  451225
  480083
  482853
  488684
  494893
  500877
  501541
  502934
  502999
  505569
  507112
  507439
  509264
  510197
  516374
  519473
  526683
  536944
  538099
  539652
  542117
  542298
  553620
  558226
  559015
  562544
  563588
  577512
  594552
  602979
  605632
  609512
  615377
  650649
  651392
  660770
  667150
  680295
  681780
  687310
  702310
  704418
  707161
  707419
  709340
  711139
  711749
  717274
  724908
  725022
  731173
  732211
  734637
  737318
  739230
  740763
  742220
  742561
  742742
  747507
  752487
  753762
  756370
  756424
  756685
  757878
  762049
  762830
  764387
  766114
  766265
  766272
  768300
  769496
  770977
  772474
  777939
  778410
  783136
  787425
  792022
  795195
  795966
  796097
  797712
  801800
  804988
  809914
  814993
  817578
  825171
  828804
]
2.20 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жен раком"
]
1.98 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен рак"
]
1.79 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.95%)
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.