GET https://search.jues.net/search/embeds/6?q=mature-mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.63 ms
(84.37%)
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
  14700
  123862
  188560
  188610
  233321
  233532
  361978
  365910
  382434
  382802
  383117
  387377
  388322
  388470
  388700
  388719
  388723
  390566
  390582
  391077
  391251
  391576
  391614
  391668
  392208
  395891
  396619
  397304
  397870
  397873
  397879
  397905
  397921
  397937
  398956
  400513
  403314
  409310
  411385
  424430
  426531
  433353
  439627
  439658
  439709
  442987
  443768
  445056
  451488
  460672
  461296
  465540
  466021
  466088
  466793
  466877
  466958
  467940
  468357
  469375
  470180
  470275
  471111
  472690
  472703
  479126
  483655
  493103
  493177
  506067
  508746
  516483
  536213
  538006
  538011
  539487
  549221
  549851
  552286
  555290
  555769
  555779
  563090
  563209
  563436
  588077
  591977
  610473
  695380
  705640
  710510
  718552
  720007
  726585
  727732
  730360
  731084
  731482
  734373
  737164
  739994
  743780
  748213
  757277
  759752
  761597
  765302
  768195
  776320
  784305
  793770
  795540
  796148
  802463
  803498
  803522
  804006
  817347
  825420
  825585
]
22.46 ms
(11.11%)
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
  233532
  397937
  391077
  233321
  397304
  471111
  468357
  795540
  825420
  731084
  398956
  365910
  433353
  388470
  361978
  391251
  445056
  479126
  802463
  388719
  382434
  439658
  391668
  439627
  426531
  466958
  424430
  466877
  470275
  508746
  588077
  390582
  451488
  549221
  552286
  563090
  591977
  443768
  397905
  538006
  483655
  516483
  538011
  493177
  188560
  825585
  472703
  506067
  469375
  470180
  563209
  710510
  720007
  776320
  803498
  803522
  793770
  804006
  727732
  739994
  748213
  737164
  757277
  718552
  188610
  395891
  439709
  493103
  14700
  397879
  388723
  442987
  390566
  400513
  397873
  409310
  563436
  391576
  387377
  391614
  382802
  403314
  466088
  123862
  460672
  472690
  466793
  536213
  539487
  549851
  734373
  796148
  761597
  726585
  765302
  705640
  388322
  397921
  465540
  397870
  461296
  467940
  388700
  466021
  743780
  411385
  396619
  817347
  555769
  555779
  695380
  555290
  610473
  731482
  768195
  730360
  759752
  784305
  383117
  392208
]
2.64 ms
(1.30%)
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
  14700
  123862
  188560
  188610
  233321
  233532
  361978
  365910
  382434
  382802
  383117
  387377
  388322
  388470
  388700
  388719
  388723
  390566
  390582
  391077
  391251
  391576
  391614
  391668
  392208
  395891
  396619
  397304
  397870
  397873
  397879
  397905
  397921
  397937
  398956
  400513
  403314
  409310
  411385
  424430
  426531
  433353
  439627
  439658
  439709
  442987
  443768
  445056
  451488
  460672
  461296
  465540
  466021
  466088
  466793
  466877
  466958
  467940
  468357
  469375
  470180
  470275
  471111
  472690
  472703
  479126
  483655
  493103
  493177
  506067
  508746
  516483
  536213
  538006
  538011
  539487
  549221
  549851
  552286
  555290
  555769
  555779
  563090
  563209
  563436
  588077
  591977
  610473
  695380
  705640
  710510
  718552
  720007
  726585
  727732
  730360
  731084
  731482
  734373
  737164
  739994
  743780
  748213
  757277
  759752
  761597
  765302
  768195
  776320
  784305
  793770
  795540
  796148
  802463
  803498
  803522
  804006
  817347
  825420
  825585
]
1.83 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature-mother"
]
1.66 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature мам женщин"
]
1.48 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature мам женщин"
]

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.