GET https://search.jues.net/search/embeds/7?q=man%20and%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.27 ms
(86.31%)
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
  3653
  4387
  24087
  48166
  48476
  73672
  152765
  156861
  233330
  270415
  316153
  339108
  382061
  382738
  382915
  383726
  384121
  385892
  387013
  387533
  388514
  388726
  388885
  390678
  390858
  391649
  391671
  391707
  391891
  392075
  393042
  396013
  397738
  398239
  398314
  398655
  401893
  403163
  404318
  410227
  416377
  417940
  419248
  421797
  421879
  423436
  427010
  428166
  428769
  435746
  437839
  443649
  449434
  449547
  449603
  451726
  453063
  454444
  458433
  460289
  464111
  470926
  474421
  475927
  478568
  483406
  484721
  486817
  493547
  494720
  499891
  500912
  502062
  504139
  504165
  506328
  506811
  519993
  522782
  528770
  539410
  542789
  542872
  544120
  546433
  546774
  550329
  552672
  557169
  559507
  561884
  562109
  562886
  567539
  570056
  570065
  570068
  584375
  584438
  590628
  599400
  607204
  609196
  614717
  618272
  661570
  663755
  663930
  665435
  670486
  682419
  724681
  737884
  764880
  778867
  784627
  786488
  804274
  824223
  827101
]
17.86 ms
(8.79%)
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
  737884
  393042
  614717
  443649
  506328
  504139
  475927
  421797
  484721
  384121
  391707
  270415
  388514
  584375
  48476
  382915
  392075
  388885
  570068
  670486
  764880
  388726
  419248
  428166
  428769
  449547
  458433
  478568
  449434
  506811
  522782
  528770
  539410
  542789
  544120
  559507
  561884
  567539
  584438
  542872
  661570
  599400
  618272
  607204
  470926
  427010
  435746
  449603
  486817
  493547
  550329
  156861
  339108
  397738
  403163
  663755
  663930
  590628
  519993
  423436
  385892
  398314
  804274
  401893
  396013
  562109
  570065
  570056
  417940
  416377
  499891
  152765
  387013
  391649
  48166
  3653
  398239
  410227
  827101
  786488
  233330
  24087
  557169
  609196
  383726
  784627
  724681
  390678
  778867
  390858
  382738
  73672
  316153
  382061
  824223
  546433
  391671
  500912
  562886
  460289
  483406
  421879
  404318
  546774
  451726
  502062
  552672
  682419
  474421
  494720
  387533
  4387
  391891
  504165
  665435
  398655
  437839
  453063
  454444
  464111
]
3.12 ms
(1.54%)
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
  3653
  4387
  24087
  48166
  48476
  73672
  152765
  156861
  233330
  270415
  316153
  339108
  382061
  382738
  382915
  383726
  384121
  385892
  387013
  387533
  388514
  388726
  388885
  390678
  390858
  391649
  391671
  391707
  391891
  392075
  393042
  396013
  397738
  398239
  398314
  398655
  401893
  403163
  404318
  410227
  416377
  417940
  419248
  421797
  421879
  423436
  427010
  428166
  428769
  435746
  437839
  443649
  449434
  449547
  449603
  451726
  453063
  454444
  458433
  460289
  464111
  470926
  474421
  475927
  478568
  483406
  484721
  486817
  493547
  494720
  499891
  500912
  502062
  504139
  504165
  506328
  506811
  519993
  522782
  528770
  539410
  542789
  542872
  544120
  546433
  546774
  550329
  552672
  557169
  559507
  561884
  562109
  562886
  567539
  570056
  570065
  570068
  584375
  584438
  590628
  599400
  607204
  609196
  614717
  618272
  661570
  663755
  663930
  665435
  670486
  682419
  724681
  737884
  764880
  778867
  784627
  786488
  804274
  824223
  827101
]
1.87 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин жен"
]
1.67 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "man and wife"
]
1.56 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мужчин жен"
]

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.