GET https://search.jues.net/search/embeds/9?q=touch%20my

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.36 ms
(84.30%)
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
  465855
  493875
  498961
  500878
  505231
  506218
  506603
  507739
  508250
  508364
  509379
  509387
  509394
  510872
  511305
  512806
  514765
  516650
  516869
  519438
  519833
  520219
  520755
  520885
  525460
  527157
  527453
  527765
  528338
  528555
  529381
  530104
  534575
  536154
  536205
  537130
  537340
  537824
  539561
  539801
  542155
  546579
  547427
  549750
  550337
  554733
  556150
  557022
  557510
  559546
  559818
  561379
  563016
  563652
  565033
  565456
  565774
  568140
  568742
  568849
  569092
  569111
  573731
  575607
  576006
  577584
  579512
  580771
  582449
  582459
  583112
  583218
  584560
  585454
  586066
  587302
  587928
  588237
  588261
  588449
  589174
  590877
  591092
  597144
  598121
  599196
  599485
  599761
  600686
  602232
  602578
  603164
  604856
  605458
  605902
  606744
  606776
  607034
  607380
  607530
  608253
  612092
  614060
  614493
  621392
  621448
  625520
  626283
  628711
  636478
  644098
  644399
  650307
  660013
  661365
  663172
  668807
  670742
  684660
  685732
]
15.84 ms
(10.01%)
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
  500878
  506603
  520219
  520885
  525460
  528555
  529381
  537340
  509387
  510872
  516650
  516869
  519438
  520755
  505231
  506218
  511305
  512806
  519833
  527157
  527453
  527765
  536154
  536205
  537824
  539561
  539801
  498961
  507739
  508250
  508364
  509379
  509394
  514765
  528338
  530104
  534575
  537130
  465855
  493875
  542155
  547427
  557510
  563652
  565033
  576006
  577584
  579512
  583218
  554733
  556150
  563016
  565456
  582459
  550337
  557022
  559546
  561379
  565774
  568140
  568742
  568849
  569092
  569111
  573731
  575607
  580771
  660013
  668807
  684660
  650307
  663172
  670742
  661365
  685732
  546579
  549750
  559818
  582449
  583112
  584560
  587302
  589174
  590877
  606744
  606776
  607380
  628711
  585454
  586066
  587928
  591092
  597144
  598121
  599761
  614060
  626283
  636478
  588261
  599196
  599485
  600686
  602578
  604856
  607034
  614493
  621448
  588237
  588449
  602232
  603164
  605458
  605902
  607530
  608253
  612092
  621392
  625520
  644098
  644399
]
2.45 ms
(1.55%)
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
  465855
  493875
  498961
  500878
  505231
  506218
  506603
  507739
  508250
  508364
  509379
  509387
  509394
  510872
  511305
  512806
  514765
  516650
  516869
  519438
  519833
  520219
  520755
  520885
  525460
  527157
  527453
  527765
  528338
  528555
  529381
  530104
  534575
  536154
  536205
  537130
  537340
  537824
  539561
  539801
  542155
  546579
  547427
  549750
  550337
  554733
  556150
  557022
  557510
  559546
  559818
  561379
  563016
  563652
  565033
  565456
  565774
  568140
  568742
  568849
  569092
  569111
  573731
  575607
  576006
  577584
  579512
  580771
  582449
  582459
  583112
  583218
  584560
  585454
  586066
  587302
  587928
  588237
  588261
  588449
  589174
  590877
  591092
  597144
  598121
  599196
  599485
  599761
  600686
  602232
  602578
  603164
  604856
  605458
  605902
  606744
  606776
  607034
  607380
  607530
  608253
  612092
  614060
  614493
  621392
  621448
  625520
  626283
  628711
  636478
  644098
  644399
  650307
  660013
  661365
  663172
  668807
  670742
  684660
  685732
]
1.82 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трога my"
]
1.81 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "touch my"
]
1.50 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "трога my"
]
1.42 ms
(0.90%)
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.