GET https://search.jues.net/search/embeds/9?q=%D0%BF%D0%B8%D0%BA%D0%B0%D0%BF%D0%B5%20%D0%B2

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
233.60 ms
(34.79%)
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
  21397
  169962
  185428
  385890
  388481
  398733
  400460
  405551
  415107
  417750
  418991
  427092
  428409
  429247
  439640
  443593
  443642
  447296
  451574
  451590
  451596
  453130
  456359
  460126
  460147
  465991
  472107
  472305
  472336
  472337
  472341
  472343
  475056
  475204
  475973
  476378
  476693
  477574
  481140
  487133
  489130
  494690
  494734
  496976
  510079
  512688
  516883
  516997
  520661
  522677
  522833
  525526
  525925
  527517
  528906
  529074
  540722
  543498
  543831
  550067
  551196
  551267
  551269
  552686
  557592
  563611
  565355
  565364
  567584
  569877
  569883
  570028
  570196
  570221
  570299
  570357
  570653
  571537
  571546
  571922
  572522
  572806
  573006
  573360
  574586
  574817
  575090
  575109
  575510
  575514
  576359
  580054
  589835
  594931
  611702
  619135
  624856
  663255
  666409
  672417
  673277
  676330
  685926
  690480
  691234
  691547
  704860
  717243
  726015
  732472
  743119
  743447
  745035
  747403
  754539
  764099
  777863
  779867
  798981
  826882
]
210.57 ms
(31.36%)
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
  21397
  169962
  185428
  385890
  388481
  398733
  400460
  405551
  415107
  417750
  418991
  427092
  428409
  429247
  439640
  443593
  443642
  447296
  451574
  451590
  451596
  453130
  456359
  460126
  460147
  465991
  472107
  472305
  472336
  472337
  472341
  472343
  475056
  475204
  475973
  476378
  476693
  477574
  481140
  487133
  489130
  494690
  494734
  496976
  510079
  512688
  516883
  516997
  520661
  522677
  522833
  525526
  525925
  527517
  528906
  529074
  540722
  543498
  543831
  550067
  551196
  551267
  551269
  552686
  557592
  563611
  565355
  565364
  567584
  569877
  569883
  570028
  570196
  570221
  570299
  570357
  570653
  571537
  571546
  571922
  572522
  572806
  573006
  573360
  574586
  574817
  575090
  575109
  575510
  575514
  576359
  580054
  589835
  594931
  611702
  619135
  624856
  663255
  666409
  672417
  673277
  676330
  685926
  690480
  691234
  691547
  704860
  717243
  726015
  732472
  743119
  743447
  745035
  747403
  754539
  764099
  777863
  779867
  798981
  826882
]
205.85 ms
(30.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пикапе в"
]
16.72 ms
(2.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
  405551
  512688
  527517
  551196
  570299
  571546
  690480
  685926
  572522
  477574
  415107
  525925
  522833
  169962
  494734
  570028
  543498
  571922
  672417
  21397
  475973
  385890
  551267
  398733
  826882
  569883
  673277
  691234
  704860
  717243
  663255
  666409
  676330
  691547
  611702
  619135
  779867
  798981
  777863
  743119
  747403
  754539
  732472
  764099
  726015
  745035
  743447
  624856
  460147
  185428
  550067
  570653
  565364
  557592
  529074
  443593
  475056
  575514
  570221
  575109
  565355
  589835
  428409
  439640
  472341
  475204
  476693
  460126
  472336
  528906
  487133
  510079
  525526
  489130
  494690
  496976
  388481
  418991
  429247
  451590
  472305
  516883
  522677
  572806
  574586
  574817
  543831
  552686
  570196
  573360
  575090
  575510
  567584
  551269
  563611
  569877
  570357
  571537
  573006
  576359
  580054
  594931
  400460
  417750
  453130
  476378
  427092
  451574
  481140
  451596
  472343
  447296
  472337
  443642
  456359
  465991
  472107
  516997
  520661
  540722
]
1.94 ms
(0.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пикап в"
]
1.25 ms
(0.19%)
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.