GET https://search.jues.net/search/embeds/9?q=beautiful%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
203.01 ms
(82.88%)
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
  382670
  382955
  384310
  384745
  385832
  391328
  393534
  396033
  396110
  396425
  399412
  399909
  401454
  401801
  403240
  403653
  403703
  410841
  412119
  416446
  417099
  417824
  419258
  419277
  420078
  420426
  422397
  423101
  424097
  427797
  430110
  430369
  432794
  442705
  444378
  444706
  447108
  450398
  454380
  455615
  457710
  457917
  460038
  460309
  460625
  460653
  461527
  461984
  462169
  462596
  462779
  463180
  465862
  466214
  466623
  468530
  469669
  470153
  470978
  472326
  472379
  472930
  473231
  474001
  475148
  476589
  476915
  478404
  478494
  478747
  480111
  484216
  485535
  489622
  493895
  495982
  497140
  498875
  499157
  502830
  504595
  509120
  510979
  511720
  512311
  515795
  519609
  521760
  522409
  522801
  524252
  526156
  534011
  552073
  552237
  553093
  559504
  560656
  562489
  569860
  570514
  570611
  571923
  573037
  573637
  574905
  589971
  590728
  596347
  596629
  598311
  598495
  598710
  601373
  669258
  699459
  741545
  781291
  782659
  787857
]
29.06 ms
(11.86%)
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
  570514
  552237
  562489
  570611
  571923
  601373
  596629
  781291
  741545
  468530
  472326
  473231
  412119
  416446
  417099
  424097
  469669
  474001
  382670
  399909
  410841
  455615
  460038
  461984
  470978
  444378
  472379
  489622
  497140
  510979
  485535
  522801
  384310
  399412
  444706
  427797
  417824
  475148
  470153
  460625
  515795
  460309
  422397
  476589
  457917
  502830
  519609
  465862
  384745
  432794
  466623
  430110
  495982
  521760
  526156
  393534
  391328
  396033
  396110
  420426
  442705
  478404
  478494
  454380
  480111
  534011
  511720
  460653
  493895
  569860
  669258
  553093
  559504
  573037
  589971
  590728
  598311
  598495
  787857
  782659
  382955
  396425
  401801
  462169
  401454
  423101
  462596
  463180
  403653
  403703
  403240
  419258
  419277
  447108
  457710
  462779
  466214
  476915
  461527
  472930
  524252
  504595
  512311
  522409
  484216
  498875
  499157
  509120
  478747
  385832
  420078
  430369
  450398
  573637
  574905
  552073
  699459
  560656
  596347
  598710
]
4.18 ms
(1.71%)
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
  382670
  382955
  384310
  384745
  385832
  391328
  393534
  396033
  396110
  396425
  399412
  399909
  401454
  401801
  403240
  403653
  403703
  410841
  412119
  416446
  417099
  417824
  419258
  419277
  420078
  420426
  422397
  423101
  424097
  427797
  430110
  430369
  432794
  442705
  444378
  444706
  447108
  450398
  454380
  455615
  457710
  457917
  460038
  460309
  460625
  460653
  461527
  461984
  462169
  462596
  462779
  463180
  465862
  466214
  466623
  468530
  469669
  470153
  470978
  472326
  472379
  472930
  473231
  474001
  475148
  476589
  476915
  478404
  478494
  478747
  480111
  484216
  485535
  489622
  493895
  495982
  497140
  498875
  499157
  502830
  504595
  509120
  510979
  511720
  512311
  515795
  519609
  521760
  522409
  522801
  524252
  526156
  534011
  552073
  552237
  553093
  559504
  560656
  562489
  569860
  570514
  570611
  571923
  573037
  573637
  574905
  589971
  590728
  596347
  596629
  598311
  598495
  598710
  601373
  669258
  699459
  741545
  781291
  782659
  787857
]
2.28 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful girls"
]
2.24 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.17 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая девушк"
]
2.01 ms
(0.82%)
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.