GET https://search.jues.net/search/embeds/10?q=%D0%BD%D0%BE%D0%B3%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
332.29 ms
(93.28%)
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
  4446
  31758
  31822
  97851
  116623
  118227
  146694
  212254
  213598
  218811
  310581
  311532
  381819
  383542
  385337
  386215
  387284
  387373
  388631
  391017
  392558
  395477
  397100
  397202
  399019
  407550
  418020
  418541
  419842
  428064
  448081
  462061
  506669
  508917
  510186
  520310
  524036
  529461
  531331
  537683
  541149
  549414
  550561
  551558
  551712
  554422
  564907
  565071
  570689
  577174
  578104
  593110
  606835
  607375
  612306
  612903
  616446
  617673
  627925
  628761
  633214
  638497
  647594
  649982
  650913
  655125
  656011
  656061
  656081
  656962
  657337
  658713
  661526
  663038
  663924
  685277
  689879
  693351
  695498
  702365
  710362
  721451
  728676
  732492
  732987
  733334
  734308
  740090
  740668
  742231
  744327
  744810
  746532
  746545
  746778
  749635
  750886
  753511
  759377
  760105
  760648
  765409
  768544
  773546
  774030
  776823
  777272
  782110
  782718
  782964
  793389
  797145
  802279
  805841
  808361
  811132
  812494
  812499
  814430
]
14.58 ms
(4.09%)
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
  506669
  510186
  520310
  386215
  385337
  383542
  116623
  118227
  146694
  212254
  213598
  218811
  392558
  395477
  311532
  310581
  381819
  31822
  31758
  4446
  97851
  388631
  387284
  387373
  391017
  397202
  397100
  399019
  407550
  419842
  428064
  418020
  418541
  814430
  448081
  531331
  524036
  529461
  537683
  508917
  462061
  570689
  550561
  551558
  551712
  554422
  541149
  549414
  564907
  565071
  577174
  578104
  649982
  650913
  656061
  661526
  663038
  693351
  702365
  710362
  655125
  656081
  656962
  663924
  685277
  721451
  647594
  656011
  657337
  658713
  689879
  695498
  617673
  628761
  633214
  638497
  612306
  618517
  593110
  607375
  616446
  627925
  606835
  612903
  777272
  782110
  782718
  805841
  811132
  776823
  782964
  793389
  802279
  733334
  740668
  746778
  750886
  768544
  773546
  797145
  808361
  812494
  812499
  734308
  753511
  760105
  728676
  732987
  744327
  746545
  759377
  760648
  732492
  740090
  742231
  744810
  746532
  749635
  765409
  774030
]
3.08 ms
(0.86%)
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
  4446
  31758
  31822
  97851
  116623
  118227
  146694
  212254
  213598
  218811
  310581
  311532
  381819
  383542
  385337
  386215
  387284
  387373
  388631
  391017
  392558
  395477
  397100
  397202
  399019
  407550
  418020
  418541
  419842
  428064
  448081
  462061
  506669
  508917
  510186
  520310
  524036
  529461
  531331
  537683
  541149
  549414
  550561
  551558
  551712
  554422
  564907
  565071
  570689
  577174
  578104
  593110
  606835
  607375
  612306
  612903
  616446
  617673
  627925
  628761
  633214
  638497
  647594
  649982
  650913
  655125
  656011
  656061
  656081
  656962
  657337
  658713
  661526
  663038
  663924
  685277
  689879
  693351
  695498
  702365
  710362
  721451
  728676
  732492
  732987
  733334
  734308
  740090
  740668
  742231
  744327
  744810
  746532
  746545
  746778
  749635
  750886
  753511
  759377
  760105
  760648
  765409
  768544
  773546
  774030
  776823
  777272
  782110
  782718
  782964
  793389
  797145
  802279
  805841
  808361
  811132
  812494
  812499
  814430
]
1.71 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ноге"
]
1.60 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ног"
]
1.57 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.39%)
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.