GET https://search.jues.net/search/embeds/3?q=mom%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.15 ms
(84.84%)
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
  365295
  395724
  402122
  402882
  431691
  444474
  446311
  447352
  471623
  471707
  473309
  482249
  485066
  490801
  491934
  502300
  513765
  518504
  522168
  526649
  536706
  542344
  543446
  545292
  556825
  558814
  559037
  560510
  565140
  571195
  572841
  574277
  579769
  582213
  585290
  586351
  589951
  596816
  596907
  597604
  600671
  601020
  601034
  623879
  640097
  644953
  660422
  682144
  716215
  721692
  725199
  727391
  728238
  733357
  738736
  753019
  784244
  787341
  797143
  797500
  801337
  802700
  802748
  804196
  805439
  806088
  809368
  810926
  811214
  812797
  812821
  813269
  813529
  813672
  813782
  814249
  814344
  814414
  814895
  815068
  815223
  815254
  815420
  815496
  815698
  815777
  815910
  816020
  816853
  816880
  817859
  817942
  817945
  818213
  818865
  819175
  820052
  820060
  820072
  820717
  820744
  821032
  821059
  821210
  821268
  821283
  821377
  821450
  821689
  821726
  822421
  822424
  823037
  823243
  823252
  823377
  823522
  824953
  825091
  828648
]
15.76 ms
(9.08%)
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
  545292
  558814
  572841
  660422
  601034
  596816
  600671
  623879
  805439
  809368
  810926
  812797
  812821
  784244
  402122
  447352
  518504
  365295
  814344
  815420
  817942
  818865
  823037
  823243
  644953
  814414
  817945
  813782
  815223
  816020
  819175
  821283
  822421
  825091
  815910
  821032
  821689
  490801
  543446
  716215
  586351
  585290
  597604
  601020
  797500
  802748
  804196
  806088
  811214
  802700
  725199
  753019
  787341
  797143
  813529
  728238
  727391
  733357
  738736
  801337
  813269
  485066
  395724
  820072
  822424
  482249
  473309
  560510
  559037
  565140
  589951
  596907
  402882
  471623
  471707
  526649
  491934
  502300
  513765
  446311
  431691
  522168
  444474
  813672
  821059
  814249
  815698
  818213
  821210
  821268
  821377
  815254
  815496
  816880
  817859
  820052
  821726
  823252
  823522
  824953
  814895
  815068
  815777
  816853
  820060
  820717
  820744
  821450
  823377
  828648
  536706
  574277
  542344
  579769
  682144
  721692
  556825
  571195
  582213
  640097
]
3.30 ms
(1.90%)
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
  365295
  395724
  402122
  402882
  431691
  444474
  446311
  447352
  471623
  471707
  473309
  482249
  485066
  490801
  491934
  502300
  513765
  518504
  522168
  526649
  536706
  542344
  543446
  545292
  556825
  558814
  559037
  560510
  565140
  571195
  572841
  574277
  579769
  582213
  585290
  586351
  589951
  596816
  596907
  597604
  600671
  601020
  601034
  623879
  640097
  644953
  660422
  682144
  716215
  721692
  725199
  727391
  728238
  733357
  738736
  753019
  784244
  787341
  797143
  797500
  801337
  802700
  802748
  804196
  805439
  806088
  809368
  810926
  811214
  812797
  812821
  813269
  813529
  813672
  813782
  814249
  814344
  814414
  814895
  815068
  815223
  815254
  815420
  815496
  815698
  815777
  815910
  816020
  816853
  816880
  817859
  817942
  817945
  818213
  818865
  819175
  820052
  820060
  820072
  820717
  820744
  821032
  821059
  821210
  821268
  821283
  821377
  821450
  821689
  821726
  822421
  822424
  823037
  823243
  823252
  823377
  823522
  824953
  825091
  828648
]
1.96 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom латинская"
]
1.81 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom латинская"
]
1.79 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom latina"
]
1.69 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.