GET https://search.jues.net/search/embeds/3?q=fat%20mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.15 ms
(84.99%)
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
  111260
  122767
  187786
  388222
  389703
  392937
  392957
  392980
  395584
  397771
  398966
  405485
  406688
  408831
  427165
  427220
  428108
  443410
  443807
  443892
  452216
  452222
  455348
  459148
  461397
  465551
  465663
  465727
  467922
  472583
  473398
  473434
  473475
  476301
  477225
  482755
  496550
  511259
  512474
  512929
  519089
  522990
  523861
  524497
  532413
  535802
  548466
  559415
  560968
  561036
  585364
  588714
  590464
  591869
  599565
  601923
  605905
  610262
  613611
  617578
  625250
  633479
  647692
  665461
  665880
  667295
  667542
  667581
  667834
  669758
  672950
  673328
  693901
  697186
  707069
  710374
  720542
  724183
  725219
  725470
  725476
  730076
  733169
  733265
  734268
  735435
  736207
  736368
  737392
  737466
  738571
  739636
  742293
  744218
  751974
  756253
  757093
  757278
  758687
  761817
  764934
  766623
  770192
  772305
  778521
  781995
  781998
  788364
  794183
  801166
  801788
  803056
  803884
  803895
  810663
  811045
  815583
  824642
  827271
  827711
]
13.81 ms
(8.62%)
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
  693901
  707069
  720542
  667295
  669758
  559415
  633479
  591869
  737392
  803056
  811045
  744218
  757278
  764934
  738571
  733169
  803884
  427165
  465727
  512929
  392957
  461397
  452222
  465663
  736368
  725476
  398966
  665461
  781995
  476301
  560968
  465551
  395584
  467922
  428108
  519089
  561036
  770192
  601923
  473434
  524497
  736207
  730076
  815583
  667581
  710374
  673328
  585364
  590464
  788364
  772305
  778521
  122767
  443807
  392980
  427220
  473398
  455348
  697186
  605905
  599565
  588714
  794183
  724183
  761817
  473475
  443410
  512474
  392937
  388222
  827271
  827711
  824642
  532413
  535802
  548466
  665880
  647692
  667542
  667834
  610262
  613611
  617578
  801788
  803895
  742293
  757093
  801166
  725219
  734268
  739636
  751974
  756253
  737466
  758687
  735435
  725470
  397771
  111260
  405485
  187786
  443892
  459148
  477225
  452216
  482755
  511259
  472583
  672950
  625250
  810663
  766623
  781998
  408831
  522990
  406688
  733265
  389703
  496550
  523861
]
3.08 ms
(1.92%)
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
  111260
  122767
  187786
  388222
  389703
  392937
  392957
  392980
  395584
  397771
  398966
  405485
  406688
  408831
  427165
  427220
  428108
  443410
  443807
  443892
  452216
  452222
  455348
  459148
  461397
  465551
  465663
  465727
  467922
  472583
  473398
  473434
  473475
  476301
  477225
  482755
  496550
  511259
  512474
  512929
  519089
  522990
  523861
  524497
  532413
  535802
  548466
  559415
  560968
  561036
  585364
  588714
  590464
  591869
  599565
  601923
  605905
  610262
  613611
  617578
  625250
  633479
  647692
  665461
  665880
  667295
  667542
  667581
  667834
  669758
  672950
  673328
  693901
  697186
  707069
  710374
  720542
  724183
  725219
  725470
  725476
  730076
  733169
  733265
  734268
  735435
  736207
  736368
  737392
  737466
  738571
  739636
  742293
  744218
  751974
  756253
  757093
  757278
  758687
  761817
  764934
  766623
  770192
  772305
  778521
  781995
  781998
  788364
  794183
  801166
  801788
  803056
  803884
  803895
  810663
  811045
  815583
  824642
  827271
  827711
]
2.14 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fat mother"
]
1.76 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fat мам женщин"
]
1.71 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fat мам женщин"
]

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.