GET https://search.jues.net/search/embeds/4?q=%D1%80%D0%B0%D0%BA%D0%BE%D0%BC%20%D0%B1%D0%B4%D1%81%D0%BC

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.00 ms
(88.70%)
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
  385125
  387588
  390610
  413707
  424449
  426911
  431513
  433594
  448874
  456818
  459096
  460209
  463775
  463915
  474933
  476075
  477149
  487768
  493172
  494933
  496114
  496237
  496733
  496758
  502464
  503336
  511348
  514381
  516144
  516452
  517100
  517620
  522487
  523435
  526344
  532500
  532536
  533536
  534221
  535585
  536012
  536958
  537118
  538919
  541579
  543744
  546177
  546180
  547848
  547852
  549119
  557198
  559197
  560987
  566775
  568478
  573265
  583386
  584023
  587216
  596569
  596587
  596612
  597108
  598859
  600824
  603959
  605583
  628212
  633340
  647003
  648524
  650595
  653557
  653560
  655840
  657860
  659289
  659952
  661652
  667993
  677919
  677920
  685979
  689483
  689964
  694914
  695849
  696097
  696975
  705752
  713970
  714279
  716751
  722993
  727423
  728735
  731444
  747530
  758459
  761484
  765356
  765752
  775711
  784713
  788577
  790819
  790873
  794907
  796728
  796769
  796968
  797110
  797325
  802931
  809808
  809846
  810675
  817280
  817750
]
10.77 ms
(5.93%)
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
  538919
  496114
  543744
  560987
  659289
  659952
  661652
  667993
  689964
  648524
  689483
  705752
  722993
  677919
  695849
  714279
  546180
  596569
  790819
  796728
  802931
  747530
  761484
  731444
  727423
  765356
  728735
  633340
  696975
  713970
  385125
  387588
  514381
  487768
  653560
  503336
  390610
  413707
  476075
  448874
  494933
  511348
  573265
  424449
  474933
  477149
  523435
  526344
  522487
  496733
  493172
  496237
  496758
  517100
  653557
  598859
  817750
  817280
  517620
  535585
  516144
  536012
  536958
  532536
  537118
  516452
  533536
  534221
  541579
  546177
  568478
  566775
  547848
  557198
  655840
  685979
  694914
  716751
  647003
  650595
  657860
  677920
  696097
  547852
  549119
  584023
  597108
  628212
  596587
  596612
  603959
  605583
  600824
  775711
  797325
  809846
  784713
  788577
  796968
  794907
  796769
  758459
  790873
  809808
  810675
  431513
  433594
  426911
  463775
  463915
  456818
  532500
  502464
  460209
  559197
  583386
  587216
  765752
  797110
  459096
]
3.43 ms
(1.89%)
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
  385125
  387588
  390610
  413707
  424449
  426911
  431513
  433594
  448874
  456818
  459096
  460209
  463775
  463915
  474933
  476075
  477149
  487768
  493172
  494933
  496114
  496237
  496733
  496758
  502464
  503336
  511348
  514381
  516144
  516452
  517100
  517620
  522487
  523435
  526344
  532500
  532536
  533536
  534221
  535585
  536012
  536958
  537118
  538919
  541579
  543744
  546177
  546180
  547848
  547852
  549119
  557198
  559197
  560987
  566775
  568478
  573265
  583386
  584023
  587216
  596569
  596587
  596612
  597108
  598859
  600824
  603959
  605583
  628212
  633340
  647003
  648524
  650595
  653557
  653560
  655840
  657860
  659289
  659952
  661652
  667993
  677919
  677920
  685979
  689483
  689964
  694914
  695849
  696097
  696975
  705752
  713970
  714279
  716751
  722993
  727423
  728735
  731444
  747530
  758459
  761484
  765356
  765752
  775711
  784713
  788577
  790819
  790873
  794907
  796728
  796769
  796968
  797110
  797325
  802931
  809808
  809846
  810675
  817280
  817750
]
1.83 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "раком бдсм"
]
1.68 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак бдсм"
]
1.29 ms
(0.71%)
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.