GET https://search.jues.net/search/embeds/6?q=kissing%20boy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.21 ms
(83.23%)
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
  105477
  151564
  153869
  192951
  213057
  285846
  382450
  384752
  384810
  387186
  392489
  395632
  396969
  400460
  407761
  410855
  411628
  411947
  414688
  416311
  418488
  420154
  420275
  424429
  429531
  430342
  431213
  442131
  443393
  443756
  446821
  447496
  451455
  451611
  453145
  454279
  455363
  458650
  463221
  465340
  465634
  466807
  467285
  467342
  469493
  471472
  474382
  475039
  475899
  478922
  487060
  491767
  505718
  506235
  519238
  522814
  523624
  529292
  538379
  544504
  545710
  545711
  548651
  549253
  552309
  552695
  558828
  560392
  560485
  560562
  562975
  562993
  563214
  567315
  570418
  570505
  570626
  571572
  572142
  572798
  573688
  573777
  573789
  574490
  574825
  574851
  574920
  575080
  575100
  575138
  575147
  575156
  575503
  575769
  575770
  576072
  576098
  576293
  576405
  576410
  578386
  584436
  588838
  591288
  595432
  596763
  606824
  629847
  699161
  726962
  742248
  748239
  758299
  760925
  788881
  789711
  801173
  801405
  802487
  802806
]
16.52 ms
(10.56%)
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
  802487
  726962
  742248
  760925
  699161
  801405
  802806
  151564
  387186
  392489
  414688
  454279
  285846
  396969
  451455
  105477
  458650
  431213
  455363
  475899
  478922
  505718
  519238
  538379
  506235
  522814
  523624
  384752
  213057
  153869
  192951
  411628
  420275
  429531
  407761
  420154
  442131
  443393
  430342
  410855
  446821
  451611
  453145
  463221
  487060
  467342
  475039
  491767
  465634
  471472
  529292
  466807
  469493
  474382
  552309
  575138
  575147
  575503
  576098
  544504
  545710
  560485
  571572
  572798
  573688
  574825
  575100
  575156
  575769
  576072
  576293
  576410
  545711
  552695
  560392
  560562
  562993
  567315
  570418
  570626
  573777
  575080
  575770
  578386
  548651
  549253
  558828
  562975
  563214
  570505
  572142
  573789
  574490
  574851
  574920
  576405
  584436
  591288
  595432
  596763
  588838
  788881
  758299
  801173
  748239
  606824
  629847
  789711
  382450
  384810
  395632
  400460
  411947
  416311
  424429
  443756
  447496
  467285
  418488
  465340
]
3.01 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
  105477
  151564
  153869
  192951
  213057
  285846
  382450
  384752
  384810
  387186
  392489
  395632
  396969
  400460
  407761
  410855
  411628
  411947
  414688
  416311
  418488
  420154
  420275
  424429
  429531
  430342
  431213
  442131
  443393
  443756
  446821
  447496
  451455
  451611
  453145
  454279
  455363
  458650
  463221
  465340
  465634
  466807
  467285
  467342
  469493
  471472
  474382
  475039
  475899
  478922
  487060
  491767
  505718
  506235
  519238
  522814
  523624
  529292
  538379
  544504
  545710
  545711
  548651
  549253
  552309
  552695
  558828
  560392
  560485
  560562
  562975
  562993
  563214
  567315
  570418
  570505
  570626
  571572
  572142
  572798
  573688
  573777
  573789
  574490
  574825
  574851
  574920
  575080
  575100
  575138
  575147
  575156
  575503
  575769
  575770
  576072
  576098
  576293
  576405
  576410
  578386
  584436
  588838
  591288
  595432
  596763
  606824
  629847
  699161
  726962
  742248
  748239
  758299
  760925
  788881
  789711
  801173
  801405
  802487
  802806
]
2.09 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kissing boy"
]
1.64 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "kissing парен"
]
1.49 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "kissing парен"
]
1.48 ms
(0.95%)
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.