GET https://search.jues.net/search/embeds/5?q=mom%20russian%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.47 ms
(52.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom русск домашн любительск"
]
172.92 ms
(42.06%)
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
  400998
  411340
  420486
  424118
  424240
  438009
  439713
  439798
  444171
  452336
  453184
  454211
  454868
  459024
  460582
  462559
  463232
  466274
  467673
  474213
  474783
  477950
  479042
  486190
  486820
  487548
  490413
  492758
  502729
  506222
  508744
  509485
  512843
  518267
  519406
  521129
  525310
  542741
  542926
  546981
  547741
  547743
  549719
  556471
  557500
  560866
  562192
  562743
  565898
  577598
  579189
  579209
  580363
  581135
  582479
  584765
  590441
  598541
  599535
  602806
  603767
  612977
  667774
  669893
  677862
  695707
  702312
  709540
  713384
  716738
  736130
  745462
  746267
  750699
  751536
  751567
  751803
  752134
  753507
  755132
  758171
  758804
  760875
  760881
  765837
  765859
  766385
  768553
  771375
  772763
  777217
  777739
  777759
  777861
  778383
  778748
  778749
  779431
  779902
  780088
  782503
  784237
  789188
  789276
  792522
  793955
  795521
  796214
  800097
  800934
  803562
  804836
  805145
  805358
  811919
  813921
  814028
  818054
  820107
  825590
]
15.01 ms
(3.65%)
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
  508744
  519406
  462559
  479042
  467673
  424240
  463232
  400998
  825590
  820107
  814028
  525310
  547743
  716738
  667774
  562743
  778383
  789188
  805145
  777217
  777759
  778749
  780088
  792522
  803562
  804836
  811919
  736130
  755132
  766385
  795521
  796214
  760881
  765837
  771375
  746267
  752134
  758804
  760875
  745462
  751803
  768553
  751536
  753507
  758171
  602806
  777739
  777861
  778748
  779902
  800934
  459024
  772763
  474783
  492758
  411340
  584765
  556471
  751567
  750699
  420486
  424118
  474213
  454211
  509485
  518267
  521129
  486190
  487548
  490413
  502729
  506222
  438009
  460582
  486820
  542926
  581135
  542741
  579209
  582479
  546981
  669893
  579189
  452336
  454868
  477950
  466274
  444171
  439798
  439713
  512843
  565898
  547741
  789276
  765859
  560866
  577598
  562192
  713384
  677862
  695707
  702312
  590441
  598541
  612977
  599535
  603767
  709540
  784237
  793955
  580363
  453184
  818054
  813921
  549719
  557500
  779431
  782503
  800097
  805358
]
3.01 ms
(0.73%)
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
  400998
  411340
  420486
  424118
  424240
  438009
  439713
  439798
  444171
  452336
  453184
  454211
  454868
  459024
  460582
  462559
  463232
  466274
  467673
  474213
  474783
  477950
  479042
  486190
  486820
  487548
  490413
  492758
  502729
  506222
  508744
  509485
  512843
  518267
  519406
  521129
  525310
  542741
  542926
  546981
  547741
  547743
  549719
  556471
  557500
  560866
  562192
  562743
  565898
  577598
  579189
  579209
  580363
  581135
  582479
  584765
  590441
  598541
  599535
  602806
  603767
  612977
  667774
  669893
  677862
  695707
  702312
  709540
  713384
  716738
  736130
  745462
  746267
  750699
  751536
  751567
  751803
  752134
  753507
  755132
  758171
  758804
  760875
  760881
  765837
  765859
  766385
  768553
  771375
  772763
  777217
  777739
  777759
  777861
  778383
  778748
  778749
  779431
  779902
  780088
  782503
  784237
  789188
  789276
  792522
  793955
  795521
  796214
  800097
  800934
  803562
  804836
  805145
  805358
  811919
  813921
  814028
  818054
  820107
  825590
]
1.97 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom russian homemade"
]
1.49 ms
(0.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom русск домашн любительск"
]

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.