GET https://search.jues.net/search/embeds/3?q=big%20muslim

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
338.85 ms
(91.76%)
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
  401704
  435731
  445498
  452303
  457378
  457390
  457391
  457392
  458560
  460629
  463830
  472275
  473206
  473218
  477579
  478985
  478987
  478988
  478990
  478992
  484269
  486531
  488566
  488573
  494720
  494732
  494736
  494745
  507207
  512790
  512800
  512807
  521552
  521563
  521564
  521580
  521582
  521583
  522396
  525088
  529528
  542602
  542802
  542999
  543048
  543143
  543150
  543164
  543179
  543181
  543186
  543191
  543193
  543204
  543253
  543255
  543435
  543461
  543506
  543514
  543776
  543777
  543779
  543781
  549144
  552044
  552050
  556867
  556935
  556941
  556945
  556950
  556951
  556961
  556970
  562773
  565220
  565923
  565925
  565929
  568050
  569953
  569968
  575009
  577058
  577074
  581089
  585110
  585569
  586490
  586497
  586498
  586499
  586508
  586513
  586516
  586518
  586520
  586528
  586534
  590728
  591859
  592898
  599289
  600404
  603716
  605176
  617116
  619816
  621246
  621543
  626348
  632119
  637437
  643380
  655482
  660750
  660834
  660843
  663288
]
19.09 ms
(5.17%)
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
  478988
  494732
  529528
  521583
  522396
  543150
  569953
  543514
  549144
  552044
  626348
  643380
  473206
  478992
  488573
  542602
  556867
  660750
  569968
  586490
  586498
  605176
  621246
  637437
  590728
  600404
  445498
  472275
  543506
  660843
  457378
  488566
  463830
  586508
  401704
  457391
  457390
  478987
  484269
  507207
  542999
  591859
  478990
  521563
  457392
  458560
  512800
  543143
  543179
  543253
  543776
  543164
  577074
  599289
  478985
  494720
  494736
  486531
  460629
  521564
  543435
  585110
  521580
  581089
  542802
  543204
  552050
  575009
  543781
  556961
  565220
  577058
  585569
  586513
  586516
  512807
  565929
  556935
  592898
  543255
  556945
  556950
  632119
  494745
  655482
  586520
  603716
  543181
  543461
  452303
  512790
  477579
  543779
  543191
  562773
  568050
  619816
  586499
  473218
  521582
  556970
  586534
  586518
  525088
  556951
  521552
  663288
  556941
  617116
  565923
  543048
  621543
  565925
  435731
  543186
  543193
  543777
  586528
  660834
  586497
]
3.22 ms
(0.87%)
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
  401704
  435731
  445498
  452303
  457378
  457390
  457391
  457392
  458560
  460629
  463830
  472275
  473206
  473218
  477579
  478985
  478987
  478988
  478990
  478992
  484269
  486531
  488566
  488573
  494720
  494732
  494736
  494745
  507207
  512790
  512800
  512807
  521552
  521563
  521564
  521580
  521582
  521583
  522396
  525088
  529528
  542602
  542802
  542999
  543048
  543143
  543150
  543164
  543179
  543181
  543186
  543191
  543193
  543204
  543253
  543255
  543435
  543461
  543506
  543514
  543776
  543777
  543779
  543781
  549144
  552044
  552050
  556867
  556935
  556941
  556945
  556950
  556951
  556961
  556970
  562773
  565220
  565923
  565925
  565929
  568050
  569953
  569968
  575009
  577058
  577074
  581089
  585110
  585569
  586490
  586497
  586498
  586499
  586508
  586513
  586516
  586518
  586520
  586528
  586534
  590728
  591859
  592898
  599289
  600404
  603716
  605176
  617116
  619816
  621246
  621543
  626348
  632119
  637437
  643380
  655482
  660750
  660834
  660843
  663288
]
2.32 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big muslim"
]
2.05 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие muslim"
]
1.91 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие muslim"
]

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.