GET https://search.jues.net/search/embeds/10?q=casting%20bbc

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.79 ms
(84.30%)
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
  334472
  421537
  423654
  427983
  428125
  429775
  429799
  429804
  443480
  443991
  444820
  447152
  453473
  455088
  457077
  463311
  464650
  465025
  472550
  475703
  480420
  481602
  481625
  491263
  492576
  493810
  495269
  496074
  497776
  500913
  510270
  512508
  517725
  519108
  522598
  522903
  524193
  525348
  527414
  529420
  530381
  530489
  530491
  530624
  530650
  531157
  531225
  531230
  531257
  532737
  532741
  532779
  532790
  532960
  533364
  533949
  534627
  534987
  535027
  535358
  536285
  536290
  536562
  536618
  536651
  537763
  537771
  537885
  537908
  539239
  555953
  573920
  589563
  591668
  596643
  597791
  599143
  599950
  600008
  600012
  600251
  600346
  600429
  601620
  601623
  604456
  617414
  617429
  622682
  623204
  625444
  627805
  628085
  628089
  628116
  631947
  632687
  632699
  633773
  633787
  634163
  634202
  634793
  636286
  636296
  637113
  637125
  639753
  640728
  641702
  641708
  643122
  644066
  644256
  644962
  731683
  757355
  761004
  795514
  804491
]
19.98 ms
(10.16%)
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
  601620
  625444
  631947
  634163
  640728
  641702
  641708
  600008
  600012
  617429
  632699
  633787
  634202
  637113
  637125
  644066
  591668
  596643
  600346
  628116
  636286
  643122
  644256
  589563
  599143
  599950
  600251
  600429
  601623
  623204
  627805
  628089
  634793
  639753
  731683
  795514
  757355
  761004
  617414
  622682
  628085
  632687
  633773
  636296
  804491
  428125
  457077
  481602
  429775
  463311
  480420
  481625
  423654
  444820
  455088
  453473
  475703
  517725
  493810
  496074
  522903
  492576
  495269
  522598
  524193
  525348
  497776
  510270
  464650
  573920
  555953
  597791
  604456
  527414
  512508
  334472
  421537
  427983
  429799
  443480
  429804
  443991
  644962
  447152
  465025
  472550
  491263
  519108
  530381
  530491
  530624
  531157
  531225
  531230
  531257
  532779
  532790
  534627
  535027
  536285
  536290
  536562
  536618
  536651
  537763
  537771
  537885
  537908
  539239
  500913
  529420
  530489
  530650
  532737
  532741
  532960
  533364
  533949
  534987
  535358
]
3.08 ms
(1.57%)
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
  334472
  421537
  423654
  427983
  428125
  429775
  429799
  429804
  443480
  443991
  444820
  447152
  453473
  455088
  457077
  463311
  464650
  465025
  472550
  475703
  480420
  481602
  481625
  491263
  492576
  493810
  495269
  496074
  497776
  500913
  510270
  512508
  517725
  519108
  522598
  522903
  524193
  525348
  527414
  529420
  530381
  530489
  530491
  530624
  530650
  531157
  531225
  531230
  531257
  532737
  532741
  532779
  532790
  532960
  533364
  533949
  534627
  534987
  535027
  535358
  536285
  536290
  536562
  536618
  536651
  537763
  537771
  537885
  537908
  539239
  555953
  573920
  589563
  591668
  596643
  597791
  599143
  599950
  600008
  600012
  600251
  600346
  600429
  601620
  601623
  604456
  617414
  617429
  622682
  623204
  625444
  627805
  628085
  628089
  628116
  631947
  632687
  632699
  633773
  633787
  634163
  634202
  634793
  636286
  636296
  637113
  637125
  639753
  640728
  641702
  641708
  643122
  644066
  644256
  644962
  731683
  757355
  761004
  795514
  804491
]
2.18 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.12 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "casting bbc"
]
1.87 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг bbc"
]
1.63 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кастинг bbc"
]

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.