GET https://search.jues.net/search/embeds/10?q=hot%20boobs

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.98 ms
(80.58%)
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
  6694
  12203
  34593
  57971
  104990
  152529
  188655
  191343
  191420
  213662
  230243
  271001
  274758
  321414
  327898
  361665
  382160
  382384
  382399
  382499
  383210
  385952
  388022
  390839
  395520
  396030
  396807
  397005
  397174
  397739
  397882
  402419
  407801
  408410
  409405
  410026
  410796
  411629
  415554
  424793
  427658
  428799
  448896
  450835
  453444
  454050
  457056
  457949
  460625
  460707
  461327
  464344
  468002
  479284
  510604
  515531
  515748
  524472
  533219
  533291
  533401
  535365
  535807
  539117
  539609
  540092
  540691
  545504
  546026
  548049
  548425
  556040
  559408
  563898
  568651
  572568
  575373
  575596
  584541
  604634
  642331
  650447
  651296
  655295
  664810
  665832
  674194
  760837
  798770
  798846
  799181
  799558
  800247
  801234
  801419
  802833
  803246
  805007
  806081
  806242
  811335
  813604
  814571
  814962
  815621
  815892
  816805
  817929
  817948
  819157
  819196
  819256
  819910
  820054
  823617
  824104
  825915
  826307
  826883
  827432
]
20.75 ms
(12.39%)
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
  799181
  799558
  800247
  801419
  802833
  803246
  805007
  806081
  806242
  6694
  152529
  361665
  385952
  397882
  424793
  57971
  104990
  274758
  382499
  388022
  397005
  191343
  213662
  396030
  396807
  397739
  415554
  427658
  533291
  515748
  584541
  604634
  642331
  798770
  798846
  801234
  811335
  760837
  448896
  428799
  383210
  188655
  191420
  230243
  395520
  321414
  327898
  271001
  382399
  382384
  382160
  34593
  12203
  390839
  397174
  402419
  408410
  407801
  409405
  411629
  410026
  410796
  815621
  817948
  819256
  825915
  826307
  813604
  814571
  815892
  819157
  819910
  820054
  827432
  814962
  823617
  824104
  816805
  817929
  819196
  826883
  450835
  453444
  460707
  454050
  461327
  479284
  457056
  457949
  460625
  524472
  540691
  533401
  539117
  539609
  510604
  535807
  540092
  515531
  533219
  535365
  464344
  468002
  546026
  559408
  568651
  575596
  545504
  556040
  548049
  548425
  563898
  572568
  575373
  650447
  651296
  655295
  664810
  665832
  674194
]
4.34 ms
(2.59%)
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
  6694
  12203
  34593
  57971
  104990
  152529
  188655
  191343
  191420
  213662
  230243
  271001
  274758
  321414
  327898
  361665
  382160
  382384
  382399
  382499
  383210
  385952
  388022
  390839
  395520
  396030
  396807
  397005
  397174
  397739
  397882
  402419
  407801
  408410
  409405
  410026
  410796
  411629
  415554
  424793
  427658
  428799
  448896
  450835
  453444
  454050
  457056
  457949
  460625
  460707
  461327
  464344
  468002
  479284
  510604
  515531
  515748
  524472
  533219
  533291
  533401
  535365
  535807
  539117
  539609
  540092
  540691
  545504
  546026
  548049
  548425
  556040
  559408
  563898
  568651
  572568
  575373
  575596
  584541
  604634
  642331
  650447
  651296
  655295
  664810
  665832
  674194
  760837
  798770
  798846
  799181
  799558
  800247
  801234
  801419
  802833
  803246
  805007
  806081
  806242
  811335
  813604
  814571
  814962
  815621
  815892
  816805
  817929
  817948
  819157
  819196
  819256
  819910
  820054
  823617
  824104
  825915
  826307
  826883
  827432
]
1.98 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.98 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot boobs"
]
1.77 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot boobs"
]
1.70 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot boobs"
]

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.