GET https://search.jues.net/search/embeds/3?q=%D0%BF%D1%80%D0%B5%D0%B7%D0%B8%D0%BA%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.19 ms
(86.68%)
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
  23524
  70646
  91512
  110772
  172514
  191059
  281927
  321450
  338587
  353299
  382816
  389146
  389967
  391017
  391768
  391773
  395349
  396475
  397524
  400342
  400822
  407877
  418557
  426705
  428293
  457371
  466598
  467863
  481120
  506434
  511601
  523654
  526107
  529663
  537373
  538968
  545218
  552969
  556622
  573251
  573312
  573509
  579062
  580149
  580151
  584236
  585531
  596752
  601430
  602010
  603709
  603765
  610513
  610625
  616233
  618184
  621481
  623378
  623391
  625404
  627203
  627243
  630709
  631280
  637407
  648465
  649818
  650696
  651358
  659180
  659185
  675847
  689919
  693010
  696337
  696338
  697496
  700719
  705145
  706174
  707633
  708304
  708567
  715140
  715692
  716824
  717168
  717551
  720049
  727729
  736145
  737244
  737288
  744535
  746648
  747760
  748481
  748482
  749650
  753159
  757959
  766295
  767303
  768288
  771476
  771912
  776357
  782383
  783703
  789384
  789557
  793517
  794536
  794997
  795499
  801571
  801583
  803423
  811161
]
15.01 ms
(8.12%)
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
  648465
  618184
  637407
  610625
  776357
  801583
  801571
  811161
  737288
  748482
  753159
  768288
  766295
  627243
  789384
  91512
  70646
  23524
  466598
  428293
  580151
  391768
  391017
  397524
  529663
  538968
  573312
  573509
  573251
  649818
  675847
  689919
  651358
  659180
  696338
  700719
  717551
  605785
  610513
  621481
  623391
  596752
  630709
  737244
  757959
  803423
  749650
  771476
  748481
  771912
  627203
  715140
  795499
  191059
  321450
  552969
  579062
  580149
  584236
  601430
  603709
  625404
  603765
  602010
  623378
  523654
  511601
  526107
  506434
  110772
  172514
  395349
  281927
  389967
  396475
  400342
  400822
  418557
  426705
  457371
  481120
  537373
  556622
  545218
  696337
  697496
  706174
  707633
  708304
  650696
  659185
  693010
  708567
  715692
  717168
  720049
  616233
  585531
  783703
  794997
  782383
  789557
  727729
  767303
  744535
  747760
  736145
  746648
  631280
  705145
  716824
  793517
  794536
  353299
  382816
  389146
  391773
  407877
  338587
  467863
]
2.45 ms
(1.33%)
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
  23524
  70646
  91512
  110772
  172514
  191059
  281927
  321450
  338587
  353299
  382816
  389146
  389967
  391017
  391768
  391773
  395349
  396475
  397524
  400342
  400822
  407877
  418557
  426705
  428293
  457371
  466598
  467863
  481120
  506434
  511601
  523654
  526107
  529663
  537373
  538968
  545218
  552969
  556622
  573251
  573312
  573509
  579062
  580149
  580151
  584236
  585531
  596752
  601430
  602010
  603709
  603765
  610513
  610625
  616233
  618184
  621481
  623378
  623391
  625404
  627203
  627243
  630709
  631280
  637407
  648465
  649818
  650696
  651358
  659180
  659185
  675847
  689919
  693010
  696337
  696338
  697496
  700719
  705145
  706174
  707633
  708304
  708567
  715140
  715692
  716824
  717168
  717551
  720049
  727729
  736145
  737244
  737288
  744535
  746648
  747760
  748481
  748482
  749650
  753159
  757959
  766295
  767303
  768288
  771476
  771912
  776357
  782383
  783703
  789384
  789557
  793517
  794536
  794997
  795499
  801571
  801583
  803423
  811161
]
2.16 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "презики"
]
1.91 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "презерват"
]
1.51 ms
(0.82%)
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.