GET https://search.jues.net/search/embeds/8?q=pov%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.65 ms
(85.85%)
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
  401558
  444837
  450663
  473020
  488841
  496662
  519170
  525000
  525167
  533166
  536886
  546638
  555148
  557908
  559484
  560936
  566062
  566778
  585466
  586075
  587566
  588121
  588294
  590111
  591629
  594786
  596133
  597769
  600587
  609361
  611040
  612014
  616550
  618700
  618736
  621907
  622411
  628677
  643132
  657162
  658795
  667169
  671473
  674846
  676196
  700571
  700637
  708756
  713833
  716796
  722448
  756072
  770334
  773301
  773325
  775345
  775374
  776099
  776159
  778824
  780599
  781874
  783886
  784023
  785359
  785476
  785760
  785763
  787050
  787549
  788992
  791335
  793855
  795343
  796683
  796842
  796936
  797579
  798357
  799075
  799114
  801037
  801224
  801890
  802401
  805672
  806838
  807099
  807728
  808427
  811147
  811728
  812947
  813430
  813444
  813683
  816596
  816604
  818930
  820517
  820550
  820708
  820933
  821157
  821380
  821456
  821494
  821650
  821685
  821890
  822377
  822844
  823136
  823154
  823405
  823408
  823475
  824014
  824279
]
12.34 ms
(7.27%)
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
  770334
  773301
  773325
  700571
  700637
  775374
  776159
  776323
  778824
  783886
  785476
  785760
  795343
  796936
  807099
  813430
  444837
  496662
  473020
  588294
  808427
  401558
  674846
  525000
  533166
  536886
  600587
  643132
  618736
  807728
  785763
  756072
  780599
  806838
  596133
  820517
  820550
  820708
  821456
  822377
  824014
  824279
  818930
  820933
  821380
  821685
  822844
  823136
  823154
  823475
  813683
  816596
  816604
  821157
  821494
  821650
  821890
  823405
  823408
  450663
  519170
  525167
  488841
  557908
  566062
  566778
  560936
  559484
  657162
  667169
  713833
  658795
  671473
  676196
  708756
  716796
  722448
  546638
  555148
  587566
  588121
  591629
  628677
  594786
  612014
  622411
  616550
  585466
  586075
  590111
  597769
  609361
  611040
  618700
  621907
  787050
  787549
  793855
  796842
  797579
  798357
  799075
  799114
  801037
  801224
  802401
  811147
  775345
  776099
  781874
  784023
  785359
  788992
  791335
  796683
  801890
  805672
  811728
  812947
  813444
]
4.50 ms
(2.65%)
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
  401558
  444837
  450663
  473020
  488841
  496662
  519170
  525000
  525167
  533166
  536886
  546638
  555148
  557908
  559484
  560936
  566062
  566778
  585466
  586075
  587566
  588121
  588294
  590111
  591629
  594786
  596133
  597769
  600587
  609361
  611040
  612014
  616550
  618700
  618736
  621907
  622411
  628677
  643132
  657162
  658795
  667169
  671473
  674846
  676196
  700571
  700637
  708756
  713833
  716796
  722448
  756072
  770334
  773301
  773325
  775345
  775374
  776099
  776159
  778824
  780599
  781874
  783886
  784023
  785359
  785476
  785760
  785763
  787050
  787549
  788992
  791335
  793855
  795343
  796683
  796842
  796936
  797579
  798357
  799075
  799114
  801037
  801224
  801890
  802401
  805672
  806838
  807099
  807728
  808427
  811147
  811728
  812947
  813430
  813444
  813683
  816596
  816604
  818930
  820517
  820550
  820708
  820933
  821157
  821380
  821456
  821494
  821650
  821685
  821890
  822377
  822844
  823136
  823154
  823405
  823408
  823475
  824014
  824279
]
1.99 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов латинская"
]
1.91 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov latina"
]
1.71 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(0.92%)
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.