GET https://search.jues.net/search/embeds/3?q=%D0%BF%D1%80%D0%BE%D1%81%D1%8F%D1%82

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.51 ms
(87.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
  70359
  123300
  233133
  238994
  351182
  365314
  386983
  392477
  392671
  394704
  398791
  398847
  405437
  405551
  406513
  410008
  411399
  417034
  417233
  420720
  421168
  426968
  429138
  429458
  436257
  437360
  441516
  449472
  451724
  454030
  454557
  456677
  456733
  457408
  457518
  457878
  460131
  460280
  460628
  460950
  460971
  461039
  463136
  464267
  465123
  465190
  465518
  470075
  474607
  475282
  482573
  483577
  485300
  485669
  486361
  492542
  493445
  495333
  495644
  496004
  497628
  499411
  509082
  524418
  535704
  553887
  560327
  560339
  570131
  581262
  608110
  615005
  617599
  622275
  628705
  628917
  637394
  643647
  645770
  653013
  656660
  661595
  661968
  663174
  664842
  666645
  688215
  720631
  725222
  725355
  725663
  728780
  732916
  736900
  748540
  749009
  757815
  759595
  761794
  766704
  767466
  769045
  769301
  773289
  773365
  777775
  780364
  784164
  787956
  788422
  789184
  791092
  791513
  794084
  795840
  796578
  797090
  801037
  801630
  807351
]
14.39 ms
(7.04%)
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
  492542
  457878
  474607
  460950
  460971
  485300
  493445
  535704
  499411
  509082
  581262
  570131
  560327
  560339
  656660
  666645
  688215
  653013
  661595
  661968
  664842
  645770
  663174
  720631
  553887
  628705
  622275
  637394
  608110
  617599
  643647
  788422
  789184
  801037
  780364
  787956
  791092
  797090
  725222
  725663
  748540
  769045
  795840
  796578
  801630
  757815
  759595
  766704
  769301
  773289
  725355
  732916
  761794
  767466
  728780
  736900
  749009
  773365
  615005
  628917
  777775
  784164
  791513
  794084
  807351
  406513
  123300
  392671
  460280
  461039
  233133
  351182
  386983
  411399
  420720
  238994
  365314
  394704
  495333
  524418
  485669
  496004
  70359
  392477
  398791
  398847
  405551
  405437
  417034
  429458
  436257
  410008
  417233
  437360
  421168
  441516
  429138
  426968
  482573
  449472
  451724
  460131
  463136
  465190
  465518
  483577
  454030
  454557
  456677
  456733
  457408
  457518
  460628
  464267
  465123
  470075
  475282
  486361
  497628
  495644
]
3.13 ms
(1.53%)
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
  70359
  123300
  233133
  238994
  351182
  365314
  386983
  392477
  392671
  394704
  398791
  398847
  405437
  405551
  406513
  410008
  411399
  417034
  417233
  420720
  421168
  426968
  429138
  429458
  436257
  437360
  441516
  449472
  451724
  454030
  454557
  456677
  456733
  457408
  457518
  457878
  460131
  460280
  460628
  460950
  460971
  461039
  463136
  464267
  465123
  465190
  465518
  470075
  474607
  475282
  482573
  483577
  485300
  485669
  486361
  492542
  493445
  495333
  495644
  496004
  497628
  499411
  509082
  524418
  535704
  553887
  560327
  560339
  570131
  581262
  608110
  615005
  617599
  622275
  628705
  628917
  637394
  643647
  645770
  653013
  656660
  661595
  661968
  663174
  664842
  666645
  688215
  720631
  725222
  725355
  725663
  728780
  732916
  736900
  748540
  749009
  757815
  759595
  761794
  766704
  767466
  769045
  769301
  773289
  773365
  777775
  780364
  784164
  787956
  788422
  789184
  791092
  791513
  794084
  795840
  796578
  797090
  801037
  801630
  807351
]
2.22 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "прос"
]
1.97 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "просят"
]
1.91 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.66%)
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.