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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.97 ms
(88.20%)
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
  185753
  246506
  382234
  386357
  387359
  390178
  420032
  422252
  427219
  428961
  434429
  441005
  447350
  447476
  447548
  453697
  454066
  457018
  458778
  462673
  466219
  466940
  467273
  469675
  475547
  476366
  478760
  481284
  482069
  487010
  487712
  489110
  490790
  492197
  499444
  501720
  501732
  501746
  501760
  501799
  502006
  503064
  503215
  509675
  509780
  513328
  513396
  516536
  516542
  518328
  519841
  520599
  521888
  523567
  523978
  524003
  525533
  526834
  527660
  528066
  545809
  554777
  558617
  560396
  561721
  563796
  568081
  569622
  572010
  572016
  573776
  576039
  576384
  576401
  595493
  595519
  596618
  596629
  598087
  598774
  599433
  601618
  602725
  603583
  604116
  609731
  615004
  616798
  621527
  622986
  637037
  641711
  653239
  653247
  653248
  653253
  653516
  663536
  665645
  672485
  672528
  672540
  672547
  672561
  672564
  677006
  679088
  683288
  721225
  722820
  731652
  744479
  753343
  758980
  761607
  767504
  768114
  791924
  810842
  813419
]
12.27 ms
(6.72%)
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
  509780
  653253
  672540
  672528
  672547
  672561
  622986
  602725
  810842
  758980
  185753
  554777
  558617
  576039
  563796
  569622
  572016
  572010
  653247
  615004
  603583
  478760
  447476
  482069
  454066
  503215
  489110
  499444
  513396
  525533
  523567
  502006
  453697
  523978
  501799
  501746
  382234
  672485
  672564
  722820
  481284
  476366
  813419
  791924
  561721
  596618
  596629
  458778
  434429
  422252
  466219
  427219
  516542
  595519
  595493
  492197
  526834
  568081
  573776
  576401
  599433
  469675
  447350
  447548
  516536
  501720
  520599
  524003
  641711
  560396
  653239
  679088
  653516
  616798
  601618
  767504
  420032
  462673
  466940
  637037
  621527
  457018
  390178
  677006
  663536
  653248
  545809
  246506
  490790
  683288
  744479
  753343
  768114
  598087
  598774
  428961
  386357
  387359
  487712
  509675
  501760
  521888
  503064
  528066
  518328
  576384
  441005
  467273
  501732
  513328
  519841
  527660
  609731
  475547
  487010
  721225
  731652
  761607
  604116
  665645
]
3.03 ms
(1.66%)
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
  185753
  246506
  382234
  386357
  387359
  390178
  420032
  422252
  427219
  428961
  434429
  441005
  447350
  447476
  447548
  453697
  454066
  457018
  458778
  462673
  466219
  466940
  467273
  469675
  475547
  476366
  478760
  481284
  482069
  487010
  487712
  489110
  490790
  492197
  499444
  501720
  501732
  501746
  501760
  501799
  502006
  503064
  503215
  509675
  509780
  513328
  513396
  516536
  516542
  518328
  519841
  520599
  521888
  523567
  523978
  524003
  525533
  526834
  527660
  528066
  545809
  554777
  558617
  560396
  561721
  563796
  568081
  569622
  572010
  572016
  573776
  576039
  576384
  576401
  595493
  595519
  596618
  596629
  598087
  598774
  599433
  601618
  602725
  603583
  604116
  609731
  615004
  616798
  621527
  622986
  637037
  641711
  653239
  653247
  653248
  653253
  653516
  663536
  665645
  672485
  672528
  672540
  672547
  672561
  672564
  677006
  679088
  683288
  721225
  722820
  731652
  744479
  753343
  758980
  761607
  767504
  768114
  791924
  810842
  813419
]
1.93 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian massage"
]
1.49 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск массаж"
]
1.48 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.