GET https://search.jues.net/search/embeds/8?q=%D1%80%D1%8F%D0%B4

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.86 ms
(87.08%)
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
  387326
  387677
  393903
  396772
  398005
  405894
  411635
  417938
  418448
  422303
  428547
  428562
  432421
  433808
  437259
  437911
  438759
  441357
  442076
  447619
  455799
  456954
  461516
  461895
  467311
  472385
  473557
  476095
  479456
  479470
  481315
  482426
  483026
  483391
  484015
  484103
  485909
  485968
  486359
  487464
  488855
  489888
  491096
  491494
  492001
  492636
  493024
  493026
  493029
  493313
  493451
  494205
  494242
  494359
  494796
  495457
  495851
  495951
  496492
  497777
  498117
  499438
  499616
  501421
  503487
  504682
  504946
  505359
  505580
  505987
  506012
  506367
  507132
  508247
  508777
  508880
  509142
  509250
  509406
  509722
  509773
  509831
  510002
  510175
  510496
  510979
  511698
  511701
  512237
  512759
  512760
  512893
  513361
  514883
  515742
  516066
  516110
  516236
  517151
  518817
  519762
  520295
  521109
  521531
  521667
  522416
  522614
  522714
  523952
  524241
  525215
  525618
  525902
  526068
  526258
  526625
  528664
  529423
  535630
  538210
]
18.23 ms
(8.54%)
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
  461516
  461895
  467311
  472385
  473557
  476095
  479456
  479470
  481315
  503487
  508247
  509250
  509773
  512759
  516066
  521531
  522614
  528664
  484015
  484103
  488855
  489888
  493026
  493313
  494205
  494359
  495457
  495951
  499616
  501421
  504682
  505987
  506012
  508777
  508880
  509831
  510002
  510979
  511701
  513361
  517151
  522416
  525902
  535630
  538210
  483026
  483391
  485909
  486359
  491494
  492001
  492636
  493024
  493451
  504946
  506367
  509142
  510175
  510496
  511698
  512760
  512893
  516110
  520295
  521109
  521667
  523952
  524241
  525215
  525618
  526068
  526258
  485968
  487464
  491096
  493029
  494242
  494796
  495851
  496492
  497777
  498117
  499438
  505359
  505580
  507132
  509406
  509722
  512237
  514883
  515742
  516236
  518817
  519762
  522714
  526625
  529423
  393903
  387326
  387677
  396772
  398005
  405894
  417938
  418448
  428547
  428562
  433808
  441357
  422303
  432421
  437259
  437911
  442076
  438759
  411635
  482426
  447619
  455799
  456954
]
2.86 ms
(1.34%)
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
  387326
  387677
  393903
  396772
  398005
  405894
  411635
  417938
  418448
  422303
  428547
  428562
  432421
  433808
  437259
  437911
  438759
  441357
  442076
  447619
  455799
  456954
  461516
  461895
  467311
  472385
  473557
  476095
  479456
  479470
  481315
  482426
  483026
  483391
  484015
  484103
  485909
  485968
  486359
  487464
  488855
  489888
  491096
  491494
  492001
  492636
  493024
  493026
  493029
  493313
  493451
  494205
  494242
  494359
  494796
  495457
  495851
  495951
  496492
  497777
  498117
  499438
  499616
  501421
  503487
  504682
  504946
  505359
  505580
  505987
  506012
  506367
  507132
  508247
  508777
  508880
  509142
  509250
  509406
  509722
  509773
  509831
  510002
  510175
  510496
  510979
  511698
  511701
  512237
  512759
  512760
  512893
  513361
  514883
  515742
  516066
  516110
  516236
  517151
  518817
  519762
  520295
  521109
  521531
  521667
  522416
  522614
  522714
  523952
  524241
  525215
  525618
  525902
  526068
  526258
  526625
  528664
  529423
  535630
  538210
]
1.94 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ряд"
]
1.83 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ряд"
]
1.39 ms
(0.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 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.