GET https://search.jues.net/search/embeds/4?q=public%20agen%20big

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.20 ms
(85.23%)
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
  232085
  397780
  400226
  401935
  412907
  425935
  448180
  455801
  461123
  465543
  469503
  476971
  506548
  521447
  522561
  523044
  524648
  527339
  530397
  530651
  530664
  533700
  533711
  533712
  535371
  535407
  536082
  539751
  539752
  539962
  540705
  543559
  545798
  561511
  563408
  564860
  565382
  575615
  581028
  588596
  589799
  595086
  608151
  611687
  618189
  618600
  621230
  622022
  625750
  627191
  627896
  628772
  629774
  632086
  633664
  638502
  644850
  647200
  648572
  651648
  666014
  683570
  684055
  689868
  690410
  695670
  695671
  696044
  696053
  696058
  696698
  696701
  707973
  709452
  709517
  711320
  713951
  716582
  720470
  721755
  722993
  726049
  734377
  734386
  736498
  736514
  746481
  750345
  752765
  757557
  768598
  770164
  771406
  777327
  780210
  781930
  783535
  785526
  789112
  791105
  791497
  791643
  794489
  798964
  799010
  799017
  799822
  802816
  802927
  809767
  810757
  813802
  821525
  824277
  828039
  828158
  828171
  828425
]
14.95 ms
(8.96%)
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
  822935
  530664
  789112
  768598
  799010
  539752
  539751
  533712
  536082
  530651
  533700
  535371
  535407
  648572
  647200
  799822
  780210
  757557
  581028
  589799
  628772
  770164
  711320
  781930
  783535
  828425
  828039
  561511
  689868
  734377
  632086
  813802
  469503
  709517
  563408
  802816
  726049
  527339
  543559
  565382
  611687
  618189
  785526
  455801
  465543
  709452
  651648
  627896
  771406
  425935
  690410
  564860
  476971
  810757
  794489
  397780
  448180
  696044
  799017
  750345
  695671
  644850
  530397
  540705
  533711
  523044
  798964
  791497
  736514
  621230
  696701
  777327
  401935
  824277
  828158
  506548
  545798
  734386
  809767
  752765
  461123
  400226
  232085
  746481
  683570
  721755
  521447
  821525
  608151
  713951
  802927
  588596
  828171
  828054
  622022
  638502
  666014
  595086
  412907
  524648
  522561
  539962
  575615
  684055
  696053
  696058
  696698
  722993
  695670
  707973
  716582
  720470
  633664
  625750
  618600
  627191
  629774
  791105
  791643
  736498
]
2.69 ms
(1.61%)
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
  232085
  397780
  400226
  401935
  412907
  425935
  448180
  455801
  461123
  465543
  469503
  476971
  506548
  521447
  522561
  523044
  524648
  527339
  530397
  530651
  530664
  533700
  533711
  533712
  535371
  535407
  536082
  539751
  539752
  539962
  540705
  543559
  545798
  561511
  563408
  564860
  565382
  575615
  581028
  588596
  589799
  595086
  608151
  611687
  618189
  618600
  621230
  622022
  625750
  627191
  627896
  628772
  629774
  632086
  633664
  638502
  644850
  647200
  648572
  651648
  666014
  683570
  684055
  689868
  690410
  695670
  695671
  696044
  696053
  696058
  696698
  696701
  707973
  709452
  709517
  711320
  713951
  716582
  720470
  721755
  722993
  726049
  734377
  734386
  736498
  736514
  746481
  750345
  752765
  757557
  768598
  770164
  771406
  777327
  780210
  781930
  783535
  785526
  789112
  791105
  791497
  791643
  794489
  798964
  799010
  799017
  799822
  802816
  802927
  809767
  810757
  813802
  821525
  824277
  828039
  828158
  828171
  828425
]
2.21 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public agen big"
]
1.73 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на agen улиц большие"
]
1.41 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на agen улиц большие"
]

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.