GET https://search.jues.net/search/embeds/6?q=hard%20extreme

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.63 ms
(82.56%)
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
  6666
  34016
  75762
  114360
  118141
  124361
  124494
  151062
  153246
  155232
  168977
  182895
  198191
  205809
  233676
  237293
  266061
  271293
  278236
  317791
  320786
  322760
  324555
  350425
  377241
  382282
  382359
  382907
  384262
  384793
  384917
  384963
  385228
  385280
  385476
  385507
  385710
  385832
  386225
  386717
  388115
  389028
  389551
  390587
  390981
  391868
  393188
  394167
  395162
  395881
  395887
  396075
  396186
  396231
  396672
  397099
  397209
  398354
  398744
  398908
  399096
  399865
  400410
  400470
  401767
  401979
  402016
  402147
  402582
  402788
  403067
  403129
  404087
  404212
  405809
  406361
  406372
  407561
  407876
  408249
  408464
  409939
  410147
  411710
  411985
  412015
  413053
  414085
  415640
  420383
  423630
  431784
  445948
  453007
  466737
  467855
  469187
  473873
  475502
  475504
  481169
  505382
  526683
  572505
  573936
  583418
  593557
  613172
  615266
  679289
  693815
  724073
  736231
  757840
  759818
  767991
  772001
  784941
  797203
  816776
]
19.43 ms
(11.66%)
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
  34016
  198191
  322760
  384963
  385832
  390981
  385280
  386717
  404212
  445948
  481169
  724073
  736231
  526683
  797203
  767991
  615266
  505382
  679289
  572505
  784941
  759818
  583418
  385507
  385710
  385476
  386225
  384917
  385228
  384262
  384793
  118141
  124494
  205809
  114360
  124361
  151062
  237293
  168977
  182895
  394167
  395881
  395887
  271293
  317791
  324555
  320786
  377241
  350425
  75762
  6666
  389028
  388115
  390587
  396075
  396672
  397209
  398354
  400470
  398744
  399096
  402147
  402582
  401767
  401979
  402016
  402788
  403067
  406361
  406372
  408249
  410147
  420383
  408464
  409939
  411985
  415640
  412015
  423630
  411710
  816776
  453007
  469187
  475502
  467855
  475504
  573936
  693815
  593557
  613172
  757840
  772001
  155232
  266061
  389551
  395162
  413053
  431784
  278236
  382282
  382359
  382907
  393188
  396186
  396231
  398908
  403129
  404087
  405809
  407561
  414085
  153246
  233676
  391868
  397099
  399865
  400410
  407876
  466737
  473873
]
2.76 ms
(1.65%)
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
  6666
  34016
  75762
  114360
  118141
  124361
  124494
  151062
  153246
  155232
  168977
  182895
  198191
  205809
  233676
  237293
  266061
  271293
  278236
  317791
  320786
  322760
  324555
  350425
  377241
  382282
  382359
  382907
  384262
  384793
  384917
  384963
  385228
  385280
  385476
  385507
  385710
  385832
  386225
  386717
  388115
  389028
  389551
  390587
  390981
  391868
  393188
  394167
  395162
  395881
  395887
  396075
  396186
  396231
  396672
  397099
  397209
  398354
  398744
  398908
  399096
  399865
  400410
  400470
  401767
  401979
  402016
  402147
  402582
  402788
  403067
  403129
  404087
  404212
  405809
  406361
  406372
  407561
  407876
  408249
  408464
  409939
  410147
  411710
  411985
  412015
  413053
  414085
  415640
  420383
  423630
  431784
  445948
  453007
  466737
  467855
  469187
  473873
  475502
  475504
  481169
  505382
  526683
  572505
  573936
  583418
  593557
  613172
  615266
  679289
  693815
  724073
  736231
  757840
  759818
  767991
  772001
  784941
  797203
  816776
]
1.88 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard хардкор"
]
1.82 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard extreme"
]
1.48 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard хардкор"
]

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.