GET https://search.jues.net/search/embeds/4?q=group%20mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.14 ms
(87.39%)
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
  130289
  187636
  191599
  218768
  310758
  326134
  381777
  383111
  385889
  389875
  393778
  394646
  396595
  397302
  400960
  401843
  409652
  410430
  421253
  422331
  438656
  443387
  447901
  453695
  467628
  469415
  470585
  470647
  471366
  471974
  474551
  474673
  476112
  482804
  483655
  484560
  504964
  506301
  510261
  513901
  514710
  517582
  521418
  522868
  531960
  533384
  542816
  543356
  544604
  548756
  549225
  557978
  559372
  560087
  562372
  565541
  566575
  567396
  572038
  599999
  600401
  601106
  603174
  603190
  604331
  606417
  606826
  613375
  636322
  640858
  645235
  649543
  659079
  660427
  669391
  711891
  715662
  720264
  720308
  721990
  722511
  722551
  726322
  731844
  733033
  734117
  745245
  748210
  748342
  767185
  775140
  775787
  775940
  775943
  775981
  784308
  787715
  795574
  799362
  801934
  801950
  803353
  803360
  803469
  806268
  807386
  811486
  815452
  816568
  816904
  817351
  817489
  818367
  820678
  820778
  820962
  823942
  824130
  827201
  827480
]
14.42 ms
(7.63%)
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
  467628
  513901
  572038
  600401
  807386
  471366
  557978
  542816
  543356
  566575
  548756
  562372
  636322
  383111
  823942
  817489
  601106
  803353
  733033
  604331
  748210
  483655
  522868
  606417
  603174
  731844
  748342
  191599
  447901
  385889
  393778
  381777
  504964
  400960
  474673
  401843
  453695
  471974
  715662
  720264
  484560
  510261
  394646
  310758
  389875
  396595
  422331
  817351
  820678
  824130
  827201
  816568
  818367
  820778
  482804
  469415
  506301
  533384
  474551
  567396
  559372
  669391
  721990
  645235
  660427
  711891
  649543
  599999
  613375
  640858
  775787
  801950
  775140
  775981
  801934
  745245
  784308
  806268
  811486
  720308
  799362
  397302
  438656
  514710
  517582
  549225
  187636
  827480
  815452
  816904
  820962
  531960
  544604
  560087
  722551
  659079
  606826
  603190
  803469
  775943
  803360
  734117
  787715
  767185
  726322
  722511
  775940
  795574
  130289
  326134
  409652
  410430
  476112
  470647
  218768
  443387
  470585
  421253
  521418
  565541
]
2.53 ms
(1.34%)
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
  130289
  187636
  191599
  218768
  310758
  326134
  381777
  383111
  385889
  389875
  393778
  394646
  396595
  397302
  400960
  401843
  409652
  410430
  421253
  422331
  438656
  443387
  447901
  453695
  467628
  469415
  470585
  470647
  471366
  471974
  474551
  474673
  476112
  482804
  483655
  484560
  504964
  506301
  510261
  513901
  514710
  517582
  521418
  522868
  531960
  533384
  542816
  543356
  544604
  548756
  549225
  557978
  559372
  560087
  562372
  565541
  566575
  567396
  572038
  599999
  600401
  601106
  603174
  603190
  604331
  606417
  606826
  613375
  636322
  640858
  645235
  649543
  659079
  660427
  669391
  711891
  715662
  720264
  720308
  721990
  722511
  722551
  726322
  731844
  733033
  734117
  745245
  748210
  748342
  767185
  775140
  775787
  775940
  775943
  775981
  784308
  787715
  795574
  799362
  801934
  801950
  803353
  803360
  803469
  806268
  807386
  811486
  815452
  816568
  816904
  817351
  817489
  818367
  820678
  820778
  820962
  823942
  824130
  827201
  827480
]
2.08 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "group mother"
]
1.78 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "group мам женщин"
]
1.57 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "group мам женщин"
]

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.