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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.02 ms
(83.05%)
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
  145314
  383818
  386719
  409948
  422233
  425003
  434281
  447562
  451748
  453513
  457953
  461696
  467544
  471347
  471916
  479029
  479176
  484355
  498867
  500191
  501784
  503277
  503395
  503887
  504994
  505042
  506629
  506702
  510362
  511599
  512593
  513072
  519848
  524380
  525208
  551419
  552232
  554146
  554764
  561667
  568369
  569867
  574890
  575801
  576014
  576280
  576379
  576381
  578843
  595516
  600403
  601313
  605961
  609896
  612574
  613850
  626891
  651924
  653260
  654315
  655418
  660522
  660959
  669858
  672475
  672486
  675359
  676499
  676927
  677029
  677039
  677400
  679706
  681525
  701487
  701873
  706668
  709769
  716033
  716127
  718967
  719162
  720985
  721408
  721447
  723013
  726398
  727523
  728681
  731604
  735625
  736260
  738432
  740587
  741596
  741823
  742602
  745268
  747421
  750922
  751918
  755587
  758314
  764137
  764158
  768163
  770438
  770579
  781583
  782524
  789240
  789450
  790569
  795243
  795696
  799726
  799778
  800738
  808761
  809802
]
14.18 ms
(9.82%)
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
  660522
  790569
  795696
  799778
  735625
  471916
  554146
  576280
  551419
  651924
  677029
  720985
  676927
  677400
  721408
  721447
  568369
  576014
  601313
  609896
  434281
  479176
  461696
  383818
  503395
  505042
  524380
  500191
  512593
  672486
  719162
  672475
  612574
  768163
  726398
  727523
  764137
  654315
  600403
  576379
  409948
  506702
  513072
  595516
  576381
  422233
  479029
  467544
  471347
  457953
  447562
  503887
  503277
  552232
  660959
  681525
  675359
  716127
  718967
  741823
  795243
  755587
  731604
  770579
  758314
  747421
  574890
  569867
  575801
  554764
  613850
  626891
  453513
  501784
  525208
  510362
  511599
  519848
  386719
  504994
  506629
  578843
  701487
  655418
  677039
  561667
  799726
  781583
  728681
  742602
  750922
  741596
  751918
  740587
  745268
  782524
  451748
  425003
  484355
  716033
  605961
  736260
  498867
  653260
  679706
  669858
  676499
  706668
  709769
  789450
  808761
  800738
  789240
  764158
  738432
  770438
  701873
  723013
  809802
  145314
]
2.55 ms
(1.76%)
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
  145314
  383818
  386719
  409948
  422233
  425003
  434281
  447562
  451748
  453513
  457953
  461696
  467544
  471347
  471916
  479029
  479176
  484355
  498867
  500191
  501784
  503277
  503395
  503887
  504994
  505042
  506629
  506702
  510362
  511599
  512593
  513072
  519848
  524380
  525208
  551419
  552232
  554146
  554764
  561667
  568369
  569867
  574890
  575801
  576014
  576280
  576379
  576381
  578843
  595516
  600403
  601313
  605961
  609896
  612574
  613850
  626891
  651924
  653260
  654315
  655418
  660522
  660959
  669858
  672475
  672486
  675359
  676499
  676927
  677029
  677039
  677400
  679706
  681525
  701487
  701873
  706668
  709769
  716033
  716127
  718967
  719162
  720985
  721408
  721447
  723013
  726398
  727523
  728681
  731604
  735625
  736260
  738432
  740587
  741596
  741823
  742602
  745268
  747421
  750922
  751918
  755587
  758314
  764137
  764158
  768163
  770438
  770579
  781583
  782524
  789240
  789450
  790569
  795243
  795696
  799726
  799778
  800738
  808761
  809802
]
2.06 ms
(1.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian massage"
]
1.93 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск массаж"
]
1.72 ms
(1.19%)
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.