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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.70 ms
(85.03%)
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
  109176
  129246
  197451
  210576
  393711
  401814
  420013
  452218
  463644
  492164
  504101
  506444
  514702
  514718
  527665
  528880
  532286
  535359
  535616
  546814
  550498
  553610
  554209
  554705
  556869
  560164
  564941
  566737
  568142
  569024
  575663
  589083
  589347
  589374
  591211
  592159
  599763
  616839
  626351
  626411
  631136
  632679
  633916
  634362
  634376
  634712
  635357
  643031
  644974
  649837
  649905
  652283
  655542
  659956
  661342
  661377
  661576
  672422
  676760
  677916
  693126
  694425
  695667
  695968
  695980
  695997
  696050
  696052
  696055
  696617
  696628
  696673
  696685
  696699
  698709
  698802
  700177
  701623
  701644
  707562
  708001
  709932
  712660
  716339
  728188
  729564
  732128
  732919
  733021
  734030
  739337
  739339
  740747
  746098
  747634
  751240
  751769
  757603
  759106
  762061
  768591
  783656
  785454
  798667
  798938
  802803
  804272
  804389
  805072
  808710
  810644
  811987
  819148
  819240
  819438
  820920
  828032
  828036
  828138
]
13.02 ms
(8.35%)
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
  759106
  716339
  210576
  819148
  696050
  649837
  696617
  659956
  661576
  676760
  701623
  701644
  798667
  751769
  554705
  564941
  698802
  635357
  591211
  589347
  740747
  700177
  695997
  747634
  634712
  514718
  760242
  708001
  643031
  566737
  393711
  109176
  732128
  492164
  550498
  514702
  535616
  504101
  575663
  696052
  616839
  631136
  804389
  811987
  634362
  589083
  746098
  828032
  633916
  634376
  734030
  729564
  553610
  568142
  810644
  626351
  420013
  644974
  695980
  589374
  728188
  535359
  733021
  768591
  785454
  693126
  532286
  819240
  820920
  798938
  783656
  527665
  569024
  649905
  463644
  506444
  560164
  696685
  698709
  626411
  802803
  828138
  401814
  528880
  655542
  661377
  694425
  696055
  712660
  672422
  695667
  709932
  652283
  661342
  696628
  696673
  696699
  707562
  546814
  554209
  632679
  592159
  739337
  805072
  808710
  751240
  757603
  762061
  732919
  804272
  556869
  695968
  828036
  677916
  599763
  739339
  197451
  452218
  129246
  819438
]
4.10 ms
(2.63%)
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
  109176
  129246
  197451
  210576
  393711
  401814
  420013
  452218
  463644
  492164
  504101
  506444
  514702
  514718
  527665
  528880
  532286
  535359
  535616
  546814
  550498
  553610
  554209
  554705
  556869
  560164
  564941
  566737
  568142
  569024
  575663
  589083
  589347
  589374
  591211
  592159
  599763
  616839
  626351
  626411
  631136
  632679
  633916
  634362
  634376
  634712
  635357
  643031
  644974
  649837
  649905
  652283
  655542
  659956
  661342
  661377
  661576
  672422
  676760
  677916
  693126
  694425
  695667
  695968
  695980
  695997
  696050
  696052
  696055
  696617
  696628
  696673
  696685
  696699
  698709
  698802
  700177
  701623
  701644
  707562
  708001
  709932
  712660
  716339
  728188
  729564
  732128
  732919
  733021
  734030
  739337
  739339
  740747
  746098
  747634
  751240
  751769
  757603
  759106
  762061
  768591
  783656
  785454
  798667
  798938
  802803
  804272
  804389
  805072
  808710
  810644
  811987
  819148
  819240
  819438
  820920
  828032
  828036
  828138
]
1.83 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public agen big"
]
1.59 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на agen улиц большие"
]
1.41 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.89%)
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.