GET https://search.jues.net/search/embeds/3?q=%D0%B2%20%D0%BE%D1%87%D0%BA%D0%B0%D1%85%20%D1%82%D0%B0%D1%82%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.06 ms
(82.03%)
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
  34057
  53396
  96431
  131474
  134404
  187840
  285885
  375092
  381865
  382476
  383705
  385123
  385522
  385910
  388792
  392479
  392778
  394487
  395881
  401564
  404188
  415523
  418009
  419222
  420544
  427526
  433673
  438488
  439150
  443625
  445597
  447050
  448214
  449203
  452671
  453804
  454001
  454476
  456781
  457003
  457155
  457809
  458113
  459820
  460157
  461194
  463798
  465563
  470344
  472668
  477660
  484482
  486763
  488431
  489074
  489796
  492517
  493473
  494371
  495646
  496337
  510125
  511355
  513090
  515373
  520932
  523582
  526984
  528637
  530437
  540431
  541758
  542682
  542685
  544480
  554394
  556406
  557347
  558281
  562332
  563666
  566997
  567022
  577062
  577068
  577100
  579379
  587085
  587530
  590546
  603124
  606134
  606482
  615583
  615627
  617597
  621770
  637168
  643100
  643517
  660724
  661054
  666666
  672328
  697242
  726456
  763994
  780002
  780492
  782738
  783343
  786767
  802554
  807165
  811311
  812843
  813200
  823939
  828113
]
17.24 ms
(10.96%)
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
  526984
  530437
  496337
  554394
  660724
  637168
  579379
  577100
  661054
  577068
  513090
  542685
  562332
  587530
  643517
  463798
  544480
  556406
  643100
  419222
  486763
  541758
  540431
  672328
  577062
  470344
  603124
  418009
  621770
  617597
  606482
  404188
  187840
  763994
  96431
  134404
  557347
  433673
  401564
  528637
  786767
  780492
  477660
  383705
  53396
  375092
  495646
  457155
  606134
  615583
  812843
  726456
  438488
  563666
  448214
  523582
  394487
  666666
  780002
  807165
  415523
  439150
  388792
  458113
  587085
  489074
  802554
  811311
  813200
  381865
  520932
  488431
  823939
  558281
  427526
  382476
  392778
  459820
  457809
  447050
  515373
  460157
  566997
  590546
  452671
  465563
  492517
  494371
  511355
  484482
  385522
  385123
  285885
  456781
  542682
  567022
  697242
  615627
  783343
  782738
  449203
  131474
  493473
  510125
  823699
  828113
  385910
  395881
  392479
  34057
  420544
  443625
  445597
  454001
  454476
  457003
  461194
  489796
  453804
  472668
]
3.70 ms
(2.35%)
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
  34057
  53396
  96431
  131474
  134404
  187840
  285885
  375092
  381865
  382476
  383705
  385123
  385522
  385910
  388792
  392479
  392778
  394487
  395881
  401564
  404188
  415523
  418009
  419222
  420544
  427526
  433673
  438488
  439150
  443625
  445597
  447050
  448214
  449203
  452671
  453804
  454001
  454476
  456781
  457003
  457155
  457809
  458113
  459820
  460157
  461194
  463798
  465563
  470344
  472668
  477660
  484482
  486763
  488431
  489074
  489796
  492517
  493473
  494371
  495646
  496337
  510125
  511355
  513090
  515373
  520932
  523582
  526984
  528637
  530437
  540431
  541758
  542682
  542685
  544480
  554394
  556406
  557347
  558281
  562332
  563666
  566997
  567022
  577062
  577068
  577100
  579379
  587085
  587530
  590546
  603124
  606134
  606482
  615583
  615627
  617597
  621770
  637168
  643100
  643517
  660724
  661054
  666666
  672328
  697242
  726456
  763994
  780002
  780492
  782738
  783343
  786767
  802554
  807165
  811311
  812843
  813200
  823939
  828113
]
1.90 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в очках тату"
]
1.87 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "очкастые татуированные"
]
1.72 ms
(1.10%)
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.