GET https://search.jues.net/search/embeds/4?q=fisting%20double

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.28 ms
(84.97%)
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
  382960
  387218
  410272
  414357
  426511
  441074
  441081
  441095
  444645
  451609
  461924
  467608
  475647
  475649
  478512
  481904
  483730
  486776
  502796
  505138
  508891
  510812
  514220
  522187
  530503
  530625
  530630
  530791
  531272
  532658
  533375
  533717
  533942
  534532
  534536
  534544
  535001
  535620
  536249
  536413
  536783
  537675
  540504
  541849
  545453
  546829
  547856
  548458
  550264
  554530
  571192
  574458
  583936
  586402
  599861
  599875
  599958
  600312
  601535
  601585
  606275
  613032
  617428
  619703
  620794
  625783
  630869
  632046
  632588
  632636
  632654
  632657
  633748
  634773
  636309
  639027
  639706
  639718
  639762
  639802
  640740
  642018
  647885
  647914
  649546
  650187
  651674
  656568
  666550
  666871
  666872
  666876
  666880
  666894
  666904
  669073
  674943
  676097
  678141
  678514
  678529
  679016
  679029
  691984
  696216
  705119
  708441
  715750
  724109
  728215
  729691
  739558
  742363
  782836
  788922
  790234
  806580
  809122
  810914
  819218
]
16.05 ms
(9.59%)
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
  532658
  533942
  535620
  666872
  696216
  666550
  647885
  647914
  606275
  632654
  639762
  639802
  639706
  639027
  634773
  819218
  534532
  535001
  546829
  548458
  571192
  691984
  715750
  669073
  705119
  613032
  782836
  788922
  724109
  810914
  742363
  728215
  387218
  441095
  478512
  483730
  510812
  514220
  475647
  650187
  574458
  599958
  586402
  441081
  441074
  451609
  502796
  414357
  444645
  410272
  531272
  530625
  530630
  530791
  536249
  537675
  541849
  678141
  678514
  679029
  676097
  678529
  708441
  599861
  790234
  806580
  617428
  620794
  467608
  649546
  481904
  530503
  533375
  540504
  583936
  656568
  666904
  679016
  666871
  666876
  642018
  600312
  632657
  599875
  632588
  632636
  619703
  632046
  639718
  601535
  633748
  636309
  382960
  534536
  534544
  533717
  545453
  547856
  550264
  809122
  729691
  739558
  486776
  505138
  536413
  508891
  522187
  475649
  554530
  601585
  625783
  640740
  461924
  426511
  536783
  651674
  666880
  666894
  674943
  630869
]
2.09 ms
(1.25%)
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
  382960
  387218
  410272
  414357
  426511
  441074
  441081
  441095
  444645
  451609
  461924
  467608
  475647
  475649
  478512
  481904
  483730
  486776
  502796
  505138
  508891
  510812
  514220
  522187
  530503
  530625
  530630
  530791
  531272
  532658
  533375
  533717
  533942
  534532
  534536
  534544
  535001
  535620
  536249
  536413
  536783
  537675
  540504
  541849
  545453
  546829
  547856
  548458
  550264
  554530
  571192
  574458
  583936
  586402
  599861
  599875
  599958
  600312
  601535
  601585
  606275
  613032
  617428
  619703
  620794
  625783
  630869
  632046
  632588
  632636
  632654
  632657
  633748
  634773
  636309
  639027
  639706
  639718
  639762
  639802
  640740
  642018
  647885
  647914
  649546
  650187
  651674
  656568
  666550
  666871
  666872
  666876
  666880
  666894
  666904
  669073
  674943
  676097
  678141
  678514
  678529
  679016
  679029
  691984
  696216
  705119
  708441
  715750
  724109
  728215
  729691
  739558
  742363
  782836
  788922
  790234
  806580
  809122
  810914
  819218
]
2.05 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting double"
]
1.84 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг double"
]
1.61 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фистинг double"
]
1.53 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.