GET https://search.jues.net/search/embeds/4?q=%D1%82%D0%B2%D0%BE%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.54 ms
(83.81%)
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
  385434
  469828
  539104
  545257
  546671
  547111
  548921
  549129
  551685
  552957
  554597
  578045
  584370
  587693
  588833
  591542
  591546
  592069
  593380
  605800
  608664
  609829
  610015
  611027
  616889
  618729
  618737
  628224
  628651
  629858
  630647
  631390
  631765
  632934
  636130
  641645
  651243
  653241
  653902
  657790
  660345
  668374
  687126
  692115
  693830
  694540
  694541
  696125
  700570
  702682
  703711
  703730
  707404
  708697
  708851
  708856
  709926
  711355
  714603
  714694
  714791
  714988
  715642
  716429
  716637
  717013
  718353
  718494
  718841
  719153
  720179
  723517
  729590
  731187
  742914
  744782
  747363
  756392
  763661
  763959
  766110
  769460
  772076
  772411
  774847
  776117
  776665
  776741
  776834
  776966
  778331
  780534
  781075
  781218
  782165
  785343
  786142
  788470
  788862
  789919
  790767
  791170
  794357
  795414
  797066
  799194
  799215
  799618
  799899
  800640
  809760
  811204
  811603
  812015
  812631
  812892
  814509
  814697
  815085
  815134
]
13.12 ms
(8.30%)
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
  766110
  729590
  742914
  744782
  763661
  769460
  772076
  772411
  731187
  747363
  756392
  763959
  608664
  609829
  641645
  702682
  703711
  715642
  716429
  718841
  720179
  776665
  776834
  776966
  785343
  786142
  788862
  790767
  797066
  799194
  809760
  811204
  811603
  812892
  385434
  815085
  723517
  814509
  814697
  815134
  469828
  539104
  547111
  548921
  549129
  551685
  552957
  584370
  651243
  653241
  657790
  692115
  693830
  703730
  708856
  714603
  714791
  718353
  718494
  719153
  653902
  668374
  694541
  707404
  708851
  711355
  716637
  717013
  660345
  687126
  694540
  696125
  700570
  708697
  709926
  714694
  714988
  545257
  546671
  554597
  578045
  592069
  605800
  631765
  587693
  591546
  628224
  630647
  636130
  588833
  610015
  611027
  616889
  628651
  632934
  591542
  593380
  618729
  618737
  629858
  631390
  776741
  778331
  780534
  788470
  791170
  794357
  799215
  799618
  799899
  800640
  812015
  812631
  774847
  776117
  781075
  781218
  782165
  789919
  795414
]
4.04 ms
(2.55%)
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
  385434
  469828
  539104
  545257
  546671
  547111
  548921
  549129
  551685
  552957
  554597
  578045
  584370
  587693
  588833
  591542
  591546
  592069
  593380
  605800
  608664
  609829
  610015
  611027
  616889
  618729
  618737
  628224
  628651
  629858
  630647
  631390
  631765
  632934
  636130
  641645
  651243
  653241
  653902
  657790
  660345
  668374
  687126
  692115
  693830
  694540
  694541
  696125
  700570
  702682
  703711
  703730
  707404
  708697
  708851
  708856
  709926
  711355
  714603
  714694
  714791
  714988
  715642
  716429
  716637
  717013
  718353
  718494
  718841
  719153
  720179
  723517
  729590
  731187
  742914
  744782
  747363
  756392
  763661
  763959
  766110
  769460
  772076
  772411
  774847
  776117
  776665
  776741
  776834
  776966
  778331
  780534
  781075
  781218
  782165
  785343
  786142
  788470
  788862
  789919
  790767
  791170
  794357
  795414
  797066
  799194
  799215
  799618
  799899
  800640
  809760
  811204
  811603
  812015
  812631
  812892
  814509
  814697
  815085
  815134
]
2.49 ms
(1.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "твои"
]
2.28 ms
(1.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тво"
]
2.05 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "тво"
]
1.63 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.