GET https://search.jues.net/search/embeds/3?q=small%20bbc

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.56 ms
(77.58%)
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
  378035
  384541
  386271
  386756
  391086
  391541
  395423
  396588
  398049
  399250
  399367
  399705
  405182
  409010
  410780
  417903
  417904
  419765
  419868
  420231
  425320
  436250
  449592
  449679
  451265
  460799
  463864
  464146
  464147
  465168
  465575
  468063
  468714
  468873
  474240
  477074
  481148
  481151
  481663
  481668
  482793
  485161
  485249
  496380
  497743
  500431
  507219
  508910
  513126
  519819
  524501
  530488
  532807
  533370
  533476
  534216
  536741
  538416
  540305
  543884
  545615
  555847
  555873
  562391
  565161
  565506
  565507
  566035
  572641
  573926
  575355
  587598
  589060
  597863
  598944
  599862
  599863
  599955
  600206
  600363
  600415
  604025
  604391
  604581
  612804
  619505
  622452
  622996
  631972
  639008
  643338
  653823
  654833
  655113
  656088
  656785
  657430
  658077
  658094
  659161
  659502
  659567
  659638
  659759
  660531
  672712
  674927
  674945
  681189
  698048
  718931
  719857
  720301
  725622
  732638
  741288
  788570
  800331
  804756
  828115
]
26.43 ms
(16.07%)
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
  468873
  481151
  485249
  533476
  562391
  545615
  565161
  573926
  674927
  587598
  631972
  600206
  425320
  386271
  395423
  378035
  398049
  399705
  417904
  436250
  449679
  540305
  464147
  565507
  575355
  674945
  604025
  604391
  604581
  804756
  725622
  622452
  409010
  399250
  477074
  481668
  391086
  399367
  420231
  465575
  496380
  507219
  828115
  732638
  657430
  659161
  659638
  659502
  659759
  654833
  656785
  698048
  532807
  589060
  513126
  533370
  599863
  599955
  599862
  655113
  463864
  524501
  543884
  566035
  672712
  600415
  600363
  718931
  386756
  658077
  658094
  660531
  653823
  659567
  622996
  619505
  384541
  643338
  536741
  656088
  565506
  396588
  410780
  419765
  482793
  465168
  481148
  485161
  451265
  468063
  449592
  481663
  534216
  538416
  519819
  530488
  460799
  474240
  572641
  681189
  720301
  719857
  555847
  555873
  598944
  597863
  639008
  741288
  800331
  612804
  788570
  417903
  405182
  391541
  468714
  419868
  464146
  500431
  497743
  508910
]
2.54 ms
(1.54%)
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
  378035
  384541
  386271
  386756
  391086
  391541
  395423
  396588
  398049
  399250
  399367
  399705
  405182
  409010
  410780
  417903
  417904
  419765
  419868
  420231
  425320
  436250
  449592
  449679
  451265
  460799
  463864
  464146
  464147
  465168
  465575
  468063
  468714
  468873
  474240
  477074
  481148
  481151
  481663
  481668
  482793
  485161
  485249
  496380
  497743
  500431
  507219
  508910
  513126
  519819
  524501
  530488
  532807
  533370
  533476
  534216
  536741
  538416
  540305
  543884
  545615
  555847
  555873
  562391
  565161
  565506
  565507
  566035
  572641
  573926
  575355
  587598
  589060
  597863
  598944
  599862
  599863
  599955
  600206
  600363
  600415
  604025
  604391
  604581
  612804
  619505
  622452
  622996
  631972
  639008
  643338
  653823
  654833
  655113
  656088
  656785
  657430
  658077
  658094
  659161
  659502
  659567
  659638
  659759
  660531
  672712
  674927
  674945
  681189
  698048
  718931
  719857
  720301
  725622
  732638
  741288
  788570
  800331
  804756
  828115
]
2.24 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small bbc"
]
2.04 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая bbc"
]
1.75 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая bbc"
]

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.