GET https://search.jues.net/search/embeds/5?q=%D0%B0%D0%BD%D1%83%D1%81%D1%8B%20%D1%81%D0%BE%D0%BB%D0%BE

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.12 ms
(86.13%)
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
  89346
  151179
  209216
  383238
  384082
  390587
  392422
  394514
  396119
  397478
  397655
  400571
  408880
  410702
  411454
  413418
  414595
  415859
  415977
  416737
  419818
  419998
  423364
  425610
  427095
  428473
  429601
  429692
  429703
  430347
  432939
  434367
  436074
  439146
  439393
  440217
  443084
  444531
  444540
  445787
  446032
  448057
  452780
  452792
  452932
  453209
  455084
  467110
  468196
  469139
  469741
  473213
  475336
  476932
  477169
  477759
  487416
  493700
  493744
  494495
  495170
  498226
  499905
  502770
  502789
  505327
  505336
  505385
  505805
  506086
  506119
  509958
  510549
  510766
  511869
  513528
  514946
  527921
  531559
  532381
  532830
  533594
  533922
  535277
  540894
  541858
  545985
  547241
  547890
  549549
  555009
  555407
  556162
  556167
  558098
  562048
  562585
  564500
  566586
  568262
  572752
  581210
  582020
  582032
  584108
  584323
  598525
  605746
  610035
  629047
  633183
  660578
  660762
  669303
  679500
  691204
  742338
  752589
  803108
  814467
]
16.81 ms
(8.71%)
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
  505385
  510549
  535277
  468196
  493700
  562048
  566586
  582020
  582032
  556162
  564500
  568262
  541858
  660762
  679500
  660578
  691204
  669303
  545985
  556167
  584323
  598525
  633183
  742338
  752589
  803108
  397478
  419818
  452780
  452932
  384082
  425610
  440217
  419998
  469139
  427095
  429692
  452792
  513528
  487416
  495170
  415859
  444531
  477759
  547890
  581210
  629047
  434367
  506119
  547241
  610035
  605746
  436074
  498226
  383238
  151179
  209216
  394514
  392422
  89346
  390587
  396119
  397655
  400571
  413418
  416737
  423364
  430347
  408880
  414595
  439146
  439393
  443084
  444540
  411454
  415977
  429703
  410702
  428473
  429601
  432939
  814467
  448057
  455084
  469741
  446032
  467110
  445787
  453209
  473213
  476932
  493744
  499905
  502789
  505805
  506086
  509958
  531559
  532830
  494495
  510766
  511869
  532381
  533594
  533922
  502770
  505327
  505336
  514946
  527921
  475336
  477169
  540894
  549549
  555009
  555407
  558098
  562585
  572752
  584108
]
2.61 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.35 ms
(1.22%)
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
  89346
  151179
  209216
  383238
  384082
  390587
  392422
  394514
  396119
  397478
  397655
  400571
  408880
  410702
  411454
  413418
  414595
  415859
  415977
  416737
  419818
  419998
  423364
  425610
  427095
  428473
  429601
  429692
  429703
  430347
  432939
  434367
  436074
  439146
  439393
  440217
  443084
  444531
  444540
  445787
  446032
  448057
  452780
  452792
  452932
  453209
  455084
  467110
  468196
  469139
  469741
  473213
  475336
  476932
  477169
  477759
  487416
  493700
  493744
  494495
  495170
  498226
  499905
  502770
  502789
  505327
  505336
  505385
  505805
  506086
  506119
  509958
  510549
  510766
  511869
  513528
  514946
  527921
  531559
  532381
  532830
  533594
  533922
  535277
  540894
  541858
  545985
  547241
  547890
  549549
  555009
  555407
  556162
  556167
  558098
  562048
  562585
  564500
  566586
  568262
  572752
  581210
  582020
  582032
  584108
  584323
  598525
  605746
  610035
  629047
  633183
  660578
  660762
  669303
  679500
  691204
  742338
  752589
  803108
  814467
]
1.93 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анусы соло"
]
1.59 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анус соло"
]
1.48 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.