GET https://search.jues.net/search/embeds/2?q=big%20and%20small

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.10 ms
(92.52%)
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
  441004
  455937
  477561
  533304
  538456
  546674
  603727
  609891
  610527
  612289
  616290
  626883
  635099
  635781
  638549
  638569
  645841
  647334
  651925
  652554
  654572
  655047
  655885
  656444
  657316
  658556
  660472
  660558
  663690
  665956
  672403
  673131
  675024
  675048
  675464
  676520
  678984
  679089
  681701
  684228
  686786
  689749
  691927
  692443
  697441
  699552
  701821
  702146
  702943
  704773
  705313
  709277
  712051
  712189
  715028
  715863
  716694
  716711
  720810
  721670
  722114
  723180
  726333
  730202
  730587
  732336
  734160
  734205
  734432
  734955
  735083
  736573
  736708
  736951
  737370
  741249
  742207
  743818
  746356
  750032
  752146
  752714
  753893
  754197
  755444
  756048
  756220
  757122
  763644
  772889
  789312
  794016
  799285
  806205
  806279
  807969
  809541
  810642
  810657
  811073
  813060
  813456
  814651
  815438
  819202
  819215
  819826
  820561
  820860
  821002
  821167
  821972
  821994
  822150
  822956
  823055
  823507
  824170
  827510
  827831
]
8.15 ms
(3.52%)
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
  676520
  684228
  689749
  702146
  704773
  712051
  657316
  660472
  663690
  665956
  678984
  686786
  697441
  705313
  712189
  716711
  645841
  651925
  656444
  675024
  675464
  715028
  722114
  635099
  807969
  806205
  811073
  730587
  734955
  753893
  757122
  789312
  806279
  726333
  734160
  736708
  756220
  735083
  741249
  742207
  743818
  755444
  732336
  754197
  730202
  736951
  763644
  616290
  720810
  813456
  673131
  658556
  813060
  603727
  824170
  477561
  821972
  822956
  823507
  821994
  455937
  538456
  702943
  723180
  752146
  756048
  772889
  810642
  734432
  799285
  736573
  441004
  814651
  815438
  820561
  821167
  823055
  819215
  820860
  819202
  819826
  821002
  822150
  827831
  827510
  533304
  546674
  655047
  675048
  679089
  701821
  654572
  660558
  672403
  681701
  709277
  716694
  647334
  652554
  655885
  691927
  692443
  699552
  715863
  721670
  609891
  626883
  610527
  635781
  638549
  612289
  638569
  794016
  809541
  810657
  734205
  737370
  746356
  750032
  752714
]
2.78 ms
(1.20%)
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
  441004
  455937
  477561
  533304
  538456
  546674
  603727
  609891
  610527
  612289
  616290
  626883
  635099
  635781
  638549
  638569
  645841
  647334
  651925
  652554
  654572
  655047
  655885
  656444
  657316
  658556
  660472
  660558
  663690
  665956
  672403
  673131
  675024
  675048
  675464
  676520
  678984
  679089
  681701
  684228
  686786
  689749
  691927
  692443
  697441
  699552
  701821
  702146
  702943
  704773
  705313
  709277
  712051
  712189
  715028
  715863
  716694
  716711
  720810
  721670
  722114
  723180
  726333
  730202
  730587
  732336
  734160
  734205
  734432
  734955
  735083
  736573
  736708
  736951
  737370
  741249
  742207
  743818
  746356
  750032
  752146
  752714
  753893
  754197
  755444
  756048
  756220
  757122
  763644
  772889
  789312
  794016
  799285
  806205
  806279
  807969
  809541
  810642
  810657
  811073
  813060
  813456
  814651
  815438
  819202
  819215
  819826
  820561
  820860
  821002
  821167
  821972
  821994
  822150
  822956
  823055
  823507
  824170
  827510
  827831
]
1.94 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big and small"
]
1.55 ms
(0.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие маленькая"
]
1.49 ms
(0.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.60%)
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.