GET https://search.jues.net/search/embeds/5?q=%D1%82%D1%80%D1%91%D1%82%D1%81%D1%8F%20%D0%BF%D0%B8%D1%81%D1%8C

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.75 ms
(85.60%)
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
  207540
  423825
  445936
  457319
  457849
  457934
  469137
  470550
  473372
  477362
  483005
  483085
  486290
  487615
  488604
  497426
  503461
  507310
  508039
  508593
  508748
  510200
  510557
  511162
  511328
  515234
  516669
  516975
  516982
  516989
  517650
  517683
  520482
  520837
  520890
  521078
  521849
  523182
  525171
  525935
  526440
  527029
  527812
  527939
  529104
  529175
  533339
  533353
  534850
  536136
  536151
  536637
  541370
  542059
  544898
  545639
  552919
  554783
  557503
  560515
  562106
  565149
  567147
  569663
  570737
  571829
  576400
  578463
  578497
  580769
  581673
  581852
  583037
  587152
  587286
  588600
  588716
  589600
  590881
  590899
  592619
  593833
  595037
  596360
  598243
  599274
  599414
  600498
  603191
  603210
  604554
  606808
  607750
  610002
  615774
  617322
  618668
  619455
  620206
  622188
  623619
  624137
  624931
  624990
  640697
  647362
  650532
  652897
  662801
  663835
  668139
  673522
  674360
  679092
  679109
  687461
  687484
  717179
  753240
  802734
]
13.33 ms
(8.53%)
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
  523182
  640697
  457934
  445936
  517683
  511328
  503461
  527029
  508039
  571829
  576400
  662801
  668139
  674360
  650532
  588600
  592619
  599274
  618668
  588716
  619455
  607750
  587152
  536151
  527939
  544898
  560515
  647362
  717179
  600498
  603191
  624990
  802734
  511162
  521078
  554783
  673522
  525935
  526440
  527812
  570737
  652897
  598243
  590899
  595037
  615774
  508748
  473372
  603210
  623619
  606808
  470550
  488604
  510200
  516975
  536637
  542059
  557503
  565149
  569663
  580769
  545639
  578497
  679092
  663835
  687461
  589600
  622188
  624137
  596360
  599414
  497426
  520837
  753240
  469137
  483085
  487615
  516669
  520890
  533339
  552919
  578463
  581673
  583037
  679109
  620206
  604554
  617322
  587286
  593833
  624931
  529104
  483005
  510557
  525171
  517650
  536136
  508593
  610002
  457319
  423825
  207540
  590881
  520482
  533353
  541370
  477362
  529175
  562106
  581852
  567147
  457849
  687484
  486290
  507310
  534850
  515234
  516982
  516989
  521849
]
2.60 ms
(1.66%)
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
  207540
  423825
  445936
  457319
  457849
  457934
  469137
  470550
  473372
  477362
  483005
  483085
  486290
  487615
  488604
  497426
  503461
  507310
  508039
  508593
  508748
  510200
  510557
  511162
  511328
  515234
  516669
  516975
  516982
  516989
  517650
  517683
  520482
  520837
  520890
  521078
  521849
  523182
  525171
  525935
  526440
  527029
  527812
  527939
  529104
  529175
  533339
  533353
  534850
  536136
  536151
  536637
  541370
  542059
  544898
  545639
  552919
  554783
  557503
  560515
  562106
  565149
  567147
  569663
  570737
  571829
  576400
  578463
  578497
  580769
  581673
  581852
  583037
  587152
  587286
  588600
  588716
  589600
  590881
  590899
  592619
  593833
  595037
  596360
  598243
  599274
  599414
  600498
  603191
  603210
  604554
  606808
  607750
  610002
  615774
  617322
  618668
  619455
  620206
  622188
  623619
  624137
  624931
  624990
  640697
  647362
  650532
  652897
  662801
  663835
  668139
  673522
  674360
  679092
  679109
  687461
  687484
  717179
  753240
  802734
]
1.94 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трет вагин"
]
1.70 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трётся пись"
]
1.53 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "трет вагин"
]
1.40 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.