GET https://search.jues.net/search/embeds/4?q=mature%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.74 ms
(86.34%)
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
  11385
  143085
  327378
  384901
  404275
  404308
  404324
  406636
  408138
  413991
  414729
  415570
  415988
  433276
  448678
  451982
  452104
  452271
  452318
  454419
  454533
  454538
  461048
  468339
  470427
  478413
  481943
  482776
  489141
  491934
  495652
  498057
  507041
  526649
  526838
  528064
  532845
  534258
  535045
  536640
  543446
  555180
  557192
  565648
  565730
  565732
  565749
  578734
  584395
  586351
  638557
  646152
  650969
  662913
  696426
  710380
  710566
  716215
  716285
  726478
  726486
  726489
  726505
  726514
  726517
  726532
  726546
  726565
  726566
  726592
  726595
  726601
  726690
  726846
  726847
  726849
  726879
  727032
  728296
  729247
  732236
  732855
  737195
  740958
  741190
  742810
  742871
  746221
  747171
  750770
  761011
  766635
  767095
  767273
  767599
  770192
  782395
  787341
  788300
  794169
  796072
  796185
  797109
  800594
  807533
  807623
  808175
  810669
  811040
  811332
  811983
  812829
  814532
  815745
  815865
  815910
  817373
  820901
  822421
]
16.02 ms
(8.39%)
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
  454533
  470427
  489141
  452104
  468339
  448678
  452271
  454538
  478413
  782395
  413991
  415988
  526649
  491934
  528064
  143085
  814532
  817373
  820901
  822421
  815910
  532845
  543446
  565648
  650969
  716285
  662913
  710380
  716215
  586351
  811332
  812829
  796185
  737195
  757075
  761011
  767273
  767599
  787341
  794169
  797109
  808175
  746221
  766635
  732855
  747171
  729247
  750770
  767095
  800594
  807623
  811983
  327378
  433276
  452318
  482776
  461048
  454419
  481943
  535045
  536640
  646152
  807533
  811040
  404275
  414729
  408138
  404308
  526838
  495652
  498057
  384901
  11385
  404324
  406636
  415570
  815745
  815865
  451982
  507041
  534258
  565732
  578734
  584395
  555180
  565749
  696426
  557192
  565730
  638557
  788300
  810669
  726489
  726517
  726532
  742810
  742871
  796072
  726505
  726566
  726847
  740958
  726478
  726565
  726592
  726595
  726601
  726690
  726879
  726514
  726846
  732236
  770192
  726486
  726546
  726849
  727032
  728296
  741190
  710566
]
3.58 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
  11385
  143085
  327378
  384901
  404275
  404308
  404324
  406636
  408138
  413991
  414729
  415570
  415988
  433276
  448678
  451982
  452104
  452271
  452318
  454419
  454533
  454538
  461048
  468339
  470427
  478413
  481943
  482776
  489141
  491934
  495652
  498057
  507041
  526649
  526838
  528064
  532845
  534258
  535045
  536640
  543446
  555180
  557192
  565648
  565730
  565732
  565749
  578734
  584395
  586351
  638557
  646152
  650969
  662913
  696426
  710380
  710566
  716215
  716285
  726478
  726486
  726489
  726505
  726514
  726517
  726532
  726546
  726565
  726566
  726592
  726595
  726601
  726690
  726846
  726847
  726849
  726879
  727032
  728296
  729247
  732236
  732855
  737195
  740958
  741190
  742810
  742871
  746221
  747171
  750770
  761011
  766635
  767095
  767273
  767599
  770192
  782395
  787341
  788300
  794169
  796072
  796185
  797109
  800594
  807533
  807623
  808175
  810669
  811040
  811332
  811983
  812829
  814532
  815745
  815865
  815910
  817373
  820901
  822421
]
1.82 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature латинская"
]
1.62 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature латинская"
]
1.47 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature latina"
]

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.