GET https://search.jues.net/search/embeds/9?q=pov%20vagina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.78 ms
(85.97%)
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
  413958
  417255
  417278
  417340
  418155
  418558
  420257
  420460
  421113
  421618
  422030
  422280
  426374
  432641
  433635
  441535
  445583
  445798
  450994
  451213
  455639
  455649
  455929
  457060
  459686
  463469
  465784
  468073
  469897
  471997
  476066
  477098
  481054
  481101
  481129
  485415
  485818
  485995
  493034
  493841
  495008
  497843
  500805
  502255
  507432
  508773
  510931
  518510
  523059
  525443
  529056
  534520
  536119
  537214
  539340
  543931
  547702
  551698
  551777
  552638
  553253
  556078
  556113
  557580
  557836
  559935
  563736
  563762
  564238
  564844
  576145
  577586
  578760
  583536
  583575
  584088
  584958
  585167
  585521
  585781
  587967
  592944
  598762
  610078
  612693
  614833
  616983
  622286
  628644
  631047
  633851
  641226
  642045
  660994
  677203
  677624
  690278
  695562
  696333
  736600
  765655
  772336
  778543
  778937
  783735
  788003
  788606
  789544
  790083
  792643
  793899
  794898
  796395
  796539
  797204
  798572
  798725
  809993
  820981
  821562
]
11.99 ms
(7.76%)
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
  598762
  788003
  445583
  422030
  463469
  418155
  465784
  563736
  696333
  585521
  736600
  485415
  455649
  432641
  418558
  420460
  433635
  471997
  455639
  497843
  518510
  534520
  523059
  481129
  551698
  551777
  557836
  577586
  556078
  564238
  584958
  556113
  563762
  578760
  614833
  631047
  610078
  641226
  789544
  809993
  778543
  793899
  445798
  459686
  476066
  481054
  422280
  457060
  455929
  469897
  502255
  507432
  557580
  585167
  493841
  525443
  495008
  417340
  477098
  510931
  543931
  529056
  539340
  583536
  553253
  592944
  536119
  583575
  628644
  417255
  420257
  421618
  441535
  413958
  421113
  426374
  417278
  821562
  820981
  450994
  451213
  485995
  485818
  468073
  500805
  508773
  537214
  481101
  493034
  547702
  564844
  584088
  559935
  677624
  690278
  695562
  660994
  677203
  552638
  576145
  585781
  616983
  633851
  612693
  622286
  587967
  642045
  778937
  790083
  798572
  798725
  783735
  794898
  796395
  797204
  765655
  772336
  788606
  792643
  796539
]
2.76 ms
(1.79%)
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
  413958
  417255
  417278
  417340
  418155
  418558
  420257
  420460
  421113
  421618
  422030
  422280
  426374
  432641
  433635
  441535
  445583
  445798
  450994
  451213
  455639
  455649
  455929
  457060
  459686
  463469
  465784
  468073
  469897
  471997
  476066
  477098
  481054
  481101
  481129
  485415
  485818
  485995
  493034
  493841
  495008
  497843
  500805
  502255
  507432
  508773
  510931
  518510
  523059
  525443
  529056
  534520
  536119
  537214
  539340
  543931
  547702
  551698
  551777
  552638
  553253
  556078
  556113
  557580
  557836
  559935
  563736
  563762
  564238
  564844
  576145
  577586
  578760
  583536
  583575
  584088
  584958
  585167
  585521
  585781
  587967
  592944
  598762
  610078
  612693
  614833
  616983
  622286
  628644
  631047
  633851
  641226
  642045
  660994
  677203
  677624
  690278
  695562
  696333
  736600
  765655
  772336
  778543
  778937
  783735
  788003
  788606
  789544
  790083
  792643
  793899
  794898
  796395
  796539
  797204
  798572
  798725
  809993
  820981
  821562
]
2.22 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov vagina"
]
1.74 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов вагин"
]
1.56 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.91%)
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.