GET https://search.jues.net/search/embeds/4?q=homemade%20little

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.72 ms
(85.30%)
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
  397915
  402771
  421623
  436257
  444192
  447028
  448786
  458356
  464855
  472877
  480088
  486646
  488299
  495645
  527274
  530254
  531370
  531650
  532800
  534091
  547405
  547870
  549075
  555734
  556549
  564458
  568852
  572921
  574193
  576498
  577561
  583297
  589979
  592261
  598182
  605067
  610928
  615985
  616592
  617080
  617849
  623825
  628591
  634315
  634995
  640149
  648671
  654293
  656944
  657565
  674202
  675489
  677104
  678238
  687310
  689551
  689771
  693899
  696139
  698797
  700649
  700711
  709393
  713829
  719473
  723003
  726182
  726249
  729002
  733090
  737224
  738835
  744889
  750407
  754027
  761873
  762986
  763152
  763827
  767417
  768018
  768465
  770368
  770369
  771986
  773687
  773939
  775434
  776227
  776930
  779747
  780027
  780485
  780630
  782885
  783087
  784920
  784962
  787937
  787965
  788170
  788221
  788385
  788405
  792483
  796332
  796842
  802572
  802946
  804835
  804929
  806819
  807264
  808981
  810785
  813356
  813925
  819780
  819901
  827888
]
12.79 ms
(8.04%)
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
  634995
  750407
  617849
  698797
  448786
  480088
  577561
  656944
  547870
  615985
  813925
  447028
  458356
  531370
  472877
  576498
  674202
  713829
  547405
  598182
  776930
  782885
  784962
  796332
  754027
  768018
  768465
  773687
  802572
  729002
  738835
  771986
  726182
  763827
  744889
  761873
  770369
  723003
  779747
  780485
  784920
  788405
  804929
  806819
  572921
  719473
  780630
  788385
  796842
  810785
  780027
  783087
  792483
  813356
  773939
  787937
  787965
  807264
  763152
  767417
  770368
  775434
  788170
  788221
  802946
  804835
  808981
  402771
  421623
  397915
  444192
  827888
  486646
  531650
  495645
  530254
  574193
  677104
  687310
  689551
  693899
  700649
  657565
  675489
  678238
  648671
  654293
  696139
  700711
  709393
  556549
  564458
  589979
  592261
  610928
  640149
  616592
  617080
  623825
  733090
  737224
  634315
  488299
  549075
  628591
  726249
  776227
  762986
  436257
  819901
  819780
  464855
  527274
  532800
  534091
  568852
  583297
  555734
  689771
  605067
]
2.99 ms
(1.88%)
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
  397915
  402771
  421623
  436257
  444192
  447028
  448786
  458356
  464855
  472877
  480088
  486646
  488299
  495645
  527274
  530254
  531370
  531650
  532800
  534091
  547405
  547870
  549075
  555734
  556549
  564458
  568852
  572921
  574193
  576498
  577561
  583297
  589979
  592261
  598182
  605067
  610928
  615985
  616592
  617080
  617849
  623825
  628591
  634315
  634995
  640149
  648671
  654293
  656944
  657565
  674202
  675489
  677104
  678238
  687310
  689551
  689771
  693899
  696139
  698797
  700649
  700711
  709393
  713829
  719473
  723003
  726182
  726249
  729002
  733090
  737224
  738835
  744889
  750407
  754027
  761873
  762986
  763152
  763827
  767417
  768018
  768465
  770368
  770369
  771986
  773687
  773939
  775434
  776227
  776930
  779747
  780027
  780485
  780630
  782885
  783087
  784920
  784962
  787937
  787965
  788170
  788221
  788385
  788405
  792483
  796332
  796842
  802572
  802946
  804835
  804929
  806819
  807264
  808981
  810785
  813356
  813925
  819780
  819901
  827888
]
2.09 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade little"
]
1.99 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск little"
]
1.89 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск little"
]

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.