GET https://search.jues.net/search/embeds/6?q=russian%20massage

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.30 ms
(81.62%)
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
  390898
  420591
  423946
  426433
  426777
  426806
  426836
  426841
  427086
  429231
  437742
  438971
  442558
  454677
  455280
  457418
  459708
  460739
  461644
  466124
  466705
  470523
  473286
  475378
  476391
  478940
  482913
  483253
  488138
  492703
  494148
  494202
  495772
  498198
  500176
  501772
  501795
  506436
  507193
  507220
  512495
  512658
  517125
  519073
  519713
  522498
  522813
  523871
  524607
  525311
  527329
  527821
  552193
  552210
  552463
  555933
  555993
  557972
  559518
  562194
  562278
  568349
  572037
  575164
  579188
  595507
  595854
  596412
  596423
  599531
  600489
  601630
  608347
  609248
  609268
  609274
  610694
  616856
  617613
  618476
  619223
  619520
  619920
  620644
  623003
  629766
  631302
  636270
  637444
  641011
  653458
  656067
  659394
  675705
  693307
  705226
  721427
  721487
  721721
  722751
  722851
  722871
  727400
  741279
  742404
  757549
  762514
  785761
  786428
  796925
  802588
  816736
  817782
  819921
  823165
  823647
  824612
  825826
  826481
  828664
]
18.01 ms
(11.73%)
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
  757549
  786428
  478940
  559518
  575164
  595854
  442558
  429231
  426433
  653458
  608347
  519713
  600489
  461644
  523871
  525311
  498198
  705226
  721427
  721487
  609274
  619223
  623003
  616856
  636270
  609268
  741279
  641011
  721721
  785761
  438971
  454677
  455280
  501772
  488138
  507220
  527821
  817782
  610694
  609248
  482913
  495772
  507193
  501795
  512495
  595507
  596423
  552463
  555933
  659394
  675705
  631302
  637444
  727400
  619520
  426777
  390898
  426806
  500176
  527329
  601630
  618476
  517125
  579188
  572037
  555993
  557972
  722751
  629766
  596412
  742404
  722851
  470523
  492703
  519073
  524607
  494148
  620644
  824612
  656067
  599531
  722871
  427086
  475378
  506436
  522498
  494202
  619920
  823647
  423946
  819921
  828664
  568349
  826481
  816736
  512658
  457418
  466705
  466124
  522813
  825826
  802588
  762514
  796925
  562278
  460739
  617613
  562194
  459708
  426836
  437742
  426841
  823165
  483253
  552193
  420591
  473286
  476391
  552210
  693307
]
3.20 ms
(2.09%)
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
  390898
  420591
  423946
  426433
  426777
  426806
  426836
  426841
  427086
  429231
  437742
  438971
  442558
  454677
  455280
  457418
  459708
  460739
  461644
  466124
  466705
  470523
  473286
  475378
  476391
  478940
  482913
  483253
  488138
  492703
  494148
  494202
  495772
  498198
  500176
  501772
  501795
  506436
  507193
  507220
  512495
  512658
  517125
  519073
  519713
  522498
  522813
  523871
  524607
  525311
  527329
  527821
  552193
  552210
  552463
  555933
  555993
  557972
  559518
  562194
  562278
  568349
  572037
  575164
  579188
  595507
  595854
  596412
  596423
  599531
  600489
  601630
  608347
  609248
  609268
  609274
  610694
  616856
  617613
  618476
  619223
  619520
  619920
  620644
  623003
  629766
  631302
  636270
  637444
  641011
  653458
  656067
  659394
  675705
  693307
  705226
  721427
  721487
  721721
  722751
  722851
  722871
  727400
  741279
  742404
  757549
  762514
  785761
  786428
  796925
  802588
  816736
  817782
  819921
  823165
  823647
  824612
  825826
  826481
  828664
]
1.95 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian massage"
]
1.72 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск массаж"
]
1.71 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск массаж"
]
1.61 ms
(1.05%)
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.