GET https://search.jues.net/search/embeds/5?q=neighbor%20big%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.25 ms
(84.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
  383248
  388949
  411868
  415777
  426508
  430278
  437257
  438878
  446060
  449907
  451490
  453301
  453465
  454035
  456382
  461822
  462592
  463104
  463203
  464970
  467991
  474457
  477850
  479354
  480667
  480819
  482869
  485008
  485583
  489591
  492991
  493308
  494508
  495057
  495599
  496754
  498748
  505502
  505720
  508771
  512612
  513493
  513507
  519518
  520136
  522515
  526446
  528063
  533434
  541130
  542628
  544062
  546879
  549729
  552719
  552844
  555973
  556975
  560523
  566953
  569401
  569482
  575037
  586330
  586918
  587558
  607047
  608345
  610376
  610680
  614723
  615100
  617018
  621225
  623488
  634891
  634962
  637605
  642444
  642725
  643927
  643929
  645822
  660649
  668276
  669213
  671193
  671355
  689973
  696916
  715972
  721280
  721893
  724852
  737207
  738576
  741048
  744444
  748153
  752790
  755627
  762430
  773922
  779199
  779344
  782204
  785604
  790894
  795226
  795320
  796866
  798686
  802766
  807584
  809864
  814676
  816326
  818512
  820107
  820306
]
16.52 ms
(8.83%)
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
  779344
  744444
  738576
  607047
  480819
  495599
  485583
  513493
  426508
  430278
  782204
  802766
  809864
  453465
  533434
  542628
  569401
  480667
  449907
  621225
  513507
  508771
  544062
  546879
  634891
  454035
  456382
  526446
  560523
  669213
  715972
  643929
  623488
  519518
  748153
  762430
  485008
  566953
  773922
  388949
  489591
  512612
  411868
  642444
  586330
  446060
  451490
  437257
  495057
  383248
  755627
  820107
  660649
  721893
  807584
  737207
  643927
  795320
  463203
  461822
  816326
  814676
  569482
  668276
  608345
  637605
  586918
  779199
  796866
  724852
  741048
  617018
  785604
  492991
  463104
  479354
  541130
  552719
  795226
  752790
  522515
  520136
  552844
  671193
  689973
  615100
  610680
  610376
  634962
  798686
  721280
  505502
  575037
  498748
  474457
  464970
  528063
  438878
  415777
  494508
  496754
  549729
  645822
  462592
  467991
  482869
  820306
  818512
  477850
  505720
  493308
  671355
  696916
  642725
  587558
  614723
  790894
  555973
  453301
  556975
]
3.18 ms
(1.70%)
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
  383248
  388949
  411868
  415777
  426508
  430278
  437257
  438878
  446060
  449907
  451490
  453301
  453465
  454035
  456382
  461822
  462592
  463104
  463203
  464970
  467991
  474457
  477850
  479354
  480667
  480819
  482869
  485008
  485583
  489591
  492991
  493308
  494508
  495057
  495599
  496754
  498748
  505502
  505720
  508771
  512612
  513493
  513507
  519518
  520136
  522515
  526446
  528063
  533434
  541130
  542628
  544062
  546879
  549729
  552719
  552844
  555973
  556975
  560523
  566953
  569401
  569482
  575037
  586330
  586918
  587558
  607047
  608345
  610376
  610680
  614723
  615100
  617018
  621225
  623488
  634891
  634962
  637605
  642444
  642725
  643927
  643929
  645822
  660649
  668276
  669213
  671193
  671355
  689973
  696916
  715972
  721280
  721893
  724852
  737207
  738576
  741048
  744444
  748153
  752790
  755627
  762430
  773922
  779199
  779344
  782204
  785604
  790894
  795226
  795320
  796866
  798686
  802766
  807584
  809864
  814676
  816326
  818512
  820107
  820306
]
3.08 ms
(1.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "neighbor большие сиськ"
]
2.29 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "neighbor big tits"
]
2.14 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "neighbor большие сиськ"
]

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.