GET https://search.jues.net/search/embeds/3?q=pov%20car

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.31 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
  198191
  269276
  413531
  413969
  416163
  418403
  423187
  423670
  423796
  424268
  424376
  424529
  424757
  425987
  437974
  443439
  448273
  453692
  455770
  456047
  456331
  456352
  462151
  462258
  467948
  470088
  470664
  471517
  472075
  474250
  474908
  474969
  475371
  476634
  478241
  479094
  480216
  481573
  482191
  492477
  493452
  497298
  498078
  498757
  501326
  501621
  505186
  505431
  505773
  522019
  522112
  522659
  524774
  527328
  527692
  529150
  539169
  542296
  546750
  552846
  553949
  555545
  559258
  560156
  561181
  561203
  563653
  566492
  568708
  568723
  569503
  571406
  572291
  574380
  578041
  592553
  596766
  599045
  601991
  607303
  607359
  613640
  626915
  636623
  637874
  639218
  640855
  640868
  652309
  729354
  740756
  762286
  765924
  768831
  769245
  783064
  786040
  786224
  789309
  794116
  798938
  798959
  799897
  809223
  810133
  817400
  817408
  817523
  817524
  817616
  820857
  821322
  822026
  823324
  828005
  828127
  828241
  828266
  828273
  828279
]
14.55 ms
(8.37%)
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
  563653
  568708
  571406
  613640
  423796
  455770
  456352
  462151
  474969
  470664
  472075
  478241
  498078
  501326
  505186
  527328
  497298
  561181
  637874
  639218
  794116
  765924
  799897
  640868
  783064
  729354
  740756
  592553
  820857
  828279
  828266
  601991
  817408
  828273
  828241
  626915
  505431
  810133
  768831
  817524
  539169
  542296
  505773
  828127
  762286
  456331
  467948
  498757
  527692
  529150
  501621
  555545
  578041
  568723
  546750
  572291
  559258
  560156
  599045
  607303
  607359
  470088
  480216
  418403
  475371
  479094
  443439
  437974
  448273
  474908
  522019
  492477
  522659
  198191
  786040
  269276
  821322
  822026
  453692
  474250
  652309
  640855
  789309
  524774
  476634
  424529
  569503
  566492
  416163
  424757
  413969
  424268
  574380
  786224
  424376
  425987
  462258
  552846
  809223
  423670
  471517
  481573
  493452
  522112
  817400
  817523
  817616
  823324
  828005
  561203
  798938
  769245
  798959
  636623
  482191
  553949
  596766
  413531
  423187
  456047
]
2.83 ms
(1.63%)
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
  198191
  269276
  413531
  413969
  416163
  418403
  423187
  423670
  423796
  424268
  424376
  424529
  424757
  425987
  437974
  443439
  448273
  453692
  455770
  456047
  456331
  456352
  462151
  462258
  467948
  470088
  470664
  471517
  472075
  474250
  474908
  474969
  475371
  476634
  478241
  479094
  480216
  481573
  482191
  492477
  493452
  497298
  498078
  498757
  501326
  501621
  505186
  505431
  505773
  522019
  522112
  522659
  524774
  527328
  527692
  529150
  539169
  542296
  546750
  552846
  553949
  555545
  559258
  560156
  561181
  561203
  563653
  566492
  568708
  568723
  569503
  571406
  572291
  574380
  578041
  592553
  596766
  599045
  601991
  607303
  607359
  613640
  626915
  636623
  637874
  639218
  640855
  640868
  652309
  729354
  740756
  762286
  765924
  768831
  769245
  783064
  786040
  786224
  789309
  794116
  798938
  798959
  799897
  809223
  810133
  817400
  817408
  817523
  817524
  817616
  820857
  821322
  822026
  823324
  828005
  828127
  828241
  828266
  828273
  828279
]
2.25 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov car"
]
1.88 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов вмашин"
]
1.31 ms
(0.75%)
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.