GET https://search.jues.net/search/embeds/7?q=group%20anal%20casting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.24 ms
(83.22%)
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
  430436
  437470
  443480
  522142
  530010
  530028
  530376
  530489
  530491
  530533
  530633
  530709
  530789
  531109
  531116
  531173
  531230
  531257
  532172
  532741
  532852
  532960
  533519
  533926
  533949
  534627
  534995
  535006
  535048
  536249
  536562
  536579
  536586
  536588
  536610
  536618
  536621
  536650
  537200
  537206
  537763
  537771
  537908
  540404
  540405
  540434
  540518
  540577
  541197
  541846
  544803
  544812
  545383
  545441
  545608
  550194
  565243
  565249
  582217
  582323
  587013
  588301
  590411
  599915
  600185
  600312
  600321
  600355
  601150
  617428
  624175
  627807
  628366
  628390
  630522
  630526
  631178
  632614
  632645
  632979
  633756
  636304
  637434
  639717
  639748
  640797
  642002
  642658
  642751
  644962
  645238
  646242
  646450
  646771
  646786
  647320
  647340
  647663
  647879
  648816
  648841
  650330
  666874
  666904
  670758
  674952
  676014
  676090
  677781
  678127
  678493
  679016
  680185
  680203
  683261
  687257
  696579
  703831
  703833
  733840
]
19.34 ms
(10.78%)
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
  535006
  536249
  536588
  540577
  530028
  530376
  534995
  540405
  540518
  545441
  582323
  541846
  541197
  545608
  550194
  646242
  666904
  674952
  676090
  677781
  678493
  679016
  680185
  687257
  696579
  646450
  646771
  648816
  648841
  670758
  676014
  678127
  680203
  683261
  703831
  646786
  647340
  650330
  582217
  599915
  600185
  630522
  642002
  642658
  587013
  588301
  590411
  600312
  600321
  633756
  600355
  601150
  628366
  628390
  632614
  632979
  636304
  642751
  624175
  630526
  632645
  637434
  639748
  640797
  733840
  617428
  627807
  631178
  639717
  703833
  430436
  437470
  522142
  443480
  644962
  530010
  530491
  530533
  531230
  531257
  533519
  533926
  534627
  535048
  536562
  536610
  536618
  537763
  537771
  537908
  540434
  530489
  530633
  532741
  532960
  533949
  536579
  536586
  536621
  530709
  531109
  531116
  531173
  532172
  532852
  536650
  530789
  537200
  537206
  540404
  545383
  565243
  565249
  544803
  544812
  645238
  647320
  647663
  647879
  666874
]
3.41 ms
(1.90%)
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
  430436
  437470
  443480
  522142
  530010
  530028
  530376
  530489
  530491
  530533
  530633
  530709
  530789
  531109
  531116
  531173
  531230
  531257
  532172
  532741
  532852
  532960
  533519
  533926
  533949
  534627
  534995
  535006
  535048
  536249
  536562
  536579
  536586
  536588
  536610
  536618
  536621
  536650
  537200
  537206
  537763
  537771
  537908
  540404
  540405
  540434
  540518
  540577
  541197
  541846
  544803
  544812
  545383
  545441
  545608
  550194
  565243
  565249
  582217
  582323
  587013
  588301
  590411
  599915
  600185
  600312
  600321
  600355
  601150
  617428
  624175
  627807
  628366
  628390
  630522
  630526
  631178
  632614
  632645
  632979
  633756
  636304
  637434
  639717
  639748
  640797
  642002
  642658
  642751
  644962
  645238
  646242
  646450
  646771
  646786
  647320
  647340
  647663
  647879
  648816
  648841
  650330
  666874
  666904
  670758
  674952
  676014
  676090
  677781
  678127
  678493
  679016
  680185
  680203
  683261
  687257
  696579
  703831
  703833
  733840
]
2.13 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "group anal casting"
]
1.86 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "group анал кастинг"
]
1.71 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.92%)
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.