GET https://search.jues.net/search/embeds/9?q=threesome%20hardcore

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.92 ms
(86.34%)
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
  381752
  406324
  408262
  410051
  414075
  415109
  415883
  415954
  416166
  417787
  419132
  419627
  421520
  426551
  428276
  428372
  430561
  436178
  444795
  448840
  448878
  452136
  452263
  454210
  457064
  462381
  464445
  468035
  468733
  472777
  474643
  476113
  483319
  484706
  485100
  486332
  489424
  492097
  492111
  492215
  493122
  495273
  495752
  500180
  506269
  513126
  514772
  515896
  521136
  521832
  522138
  525287
  527902
  530377
  530696
  530703
  532849
  533007
  533063
  533372
  533928
  536248
  536645
  536691
  537648
  537663
  537773
  538542
  542524
  542954
  543772
  544816
  544840
  545501
  545791
  551736
  560203
  583507
  590230
  590256
  597239
  598859
  599966
  599983
  600249
  600337
  600415
  613832
  628087
  628117
  633524
  639712
  639716
  639760
  642069
  643079
  647905
  647972
  649192
  649546
  649576
  653870
  665768
  666528
  674077
  678095
  678504
  686069
  699334
  704235
  714279
  714447
  726431
  730818
  732316
  747649
  776206
  805797
  818447
  827943
]
17.00 ms
(8.49%)
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
  415954
  416166
  417787
  408262
  448878
  532849
  513126
  533007
  483319
  492215
  647905
  545791
  590230
  597239
  639712
  613832
  381752
  495752
  521832
  714447
  649576
  415109
  421520
  428276
  485100
  533928
  536645
  537773
  544816
  545501
  542524
  678504
  704235
  666528
  600415
  600337
  628117
  410051
  414075
  484706
  486332
  515896
  454210
  472777
  492097
  600249
  468035
  747649
  533372
  590256
  500180
  514772
  643079
  533063
  599983
  642069
  536691
  506269
  521136
  726431
  818447
  419627
  527902
  674077
  649546
  730818
  428372
  530703
  406324
  530696
  544840
  492111
  444795
  489424
  560203
  653870
  599966
  639716
  522138
  419132
  537663
  536248
  537648
  468733
  647972
  665768
  415883
  493122
  495273
  538542
  448840
  551736
  639760
  474643
  583507
  628087
  732316
  633524
  476113
  699334
  649192
  543772
  776206
  525287
  686069
  805797
  714279
  827943
  542954
  436178
  426551
  457064
  464445
  452263
  530377
  462381
  678095
  598859
  430561
  452136
]
3.35 ms
(1.67%)
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
  381752
  406324
  408262
  410051
  414075
  415109
  415883
  415954
  416166
  417787
  419132
  419627
  421520
  426551
  428276
  428372
  430561
  436178
  444795
  448840
  448878
  452136
  452263
  454210
  457064
  462381
  464445
  468035
  468733
  472777
  474643
  476113
  483319
  484706
  485100
  486332
  489424
  492097
  492111
  492215
  493122
  495273
  495752
  500180
  506269
  513126
  514772
  515896
  521136
  521832
  522138
  525287
  527902
  530377
  530696
  530703
  532849
  533007
  533063
  533372
  533928
  536248
  536645
  536691
  537648
  537663
  537773
  538542
  542524
  542954
  543772
  544816
  544840
  545501
  545791
  551736
  560203
  583507
  590230
  590256
  597239
  598859
  599966
  599983
  600249
  600337
  600415
  613832
  628087
  628117
  633524
  639712
  639716
  639760
  642069
  643079
  647905
  647972
  649192
  649546
  649576
  653870
  665768
  666528
  674077
  678095
  678504
  686069
  699334
  704235
  714279
  714447
  726431
  730818
  732316
  747649
  776206
  805797
  818447
  827943
]
1.98 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро хардкор"
]
1.81 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome hardcore"
]
1.54 ms
(0.77%)
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.