GET https://search.jues.net/search/embeds/10?q=public%20flash%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.25 ms
(83.59%)
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
  6640
  68383
  388812
  395472
  396540
  433283
  451515
  457521
  460408
  474072
  475991
  477521
  479710
  488712
  489335
  491521
  494663
  495581
  496307
  510040
  523979
  530418
  533308
  538856
  543943
  550576
  551570
  555672
  559022
  565455
  572545
  584691
  589746
  594050
  599666
  603307
  604637
  604806
  605654
  606089
  610817
  612909
  614327
  617780
  619533
  621041
  623659
  627658
  630279
  632112
  635313
  641625
  654208
  661375
  668479
  672355
  680946
  686021
  691851
  693160
  699136
  703646
  709637
  710323
  712830
  712929
  714426
  716159
  716202
  716744
  717856
  718520
  721954
  722190
  722212
  723549
  729601
  735528
  738433
  738909
  741295
  743897
  746135
  746594
  751243
  757548
  760823
  763740
  769469
  772483
  773244
  773470
  777827
  778200
  778521
  786330
  788156
  788528
  789213
  789655
  794033
  796622
  798805
  804882
  807271
  813285
  813587
  814285
  817948
  818422
  819490
  822027
  822154
  823269
  823295
  823585
  823791
  823884
]
14.14 ms
(9.36%)
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
  489335
  494663
  530418
  479710
  551570
  661375
  714426
  680946
  718520
  672355
  717856
  588719
  604806
  606089
  621041
  788528
  735528
  746135
  746594
  772483
  798805
  738909
  763740
  738433
  605654
  794033
  807271
  451515
  460408
  474072
  396540
  433283
  475991
  477521
  488712
  491521
  68383
  395472
  6640
  388812
  814285
  817948
  823295
  823791
  723549
  813587
  822027
  823585
  823884
  819490
  823269
  818422
  822154
  457521
  510040
  495581
  523979
  538856
  496307
  533308
  543943
  572545
  550576
  555672
  573937
  584691
  559022
  668479
  691851
  699136
  709637
  716744
  722212
  712830
  654208
  686021
  693160
  712929
  716159
  716202
  722190
  565455
  627658
  641625
  599666
  632112
  589746
  610817
  619533
  623659
  594050
  603307
  604637
  612909
  630279
  777827
  786330
  789213
  789655
  813285
  778200
  729601
  743897
  788156
  773244
  760823
  769469
  773470
  741295
  751243
  757548
  614327
  617780
  635313
  703646
  710323
  721954
  778521
  796622
  804882
]
3.22 ms
(2.14%)
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
  6640
  68383
  388812
  395472
  396540
  433283
  451515
  457521
  460408
  474072
  475991
  477521
  479710
  488712
  489335
  491521
  494663
  495581
  496307
  510040
  523979
  530418
  533308
  538856
  543943
  550576
  551570
  555672
  559022
  565455
  572545
  584691
  589746
  594050
  599666
  603307
  604637
  604806
  605654
  606089
  610817
  612909
  614327
  617780
  619533
  621041
  623659
  627658
  630279
  632112
  635313
  641625
  654208
  661375
  668479
  672355
  680946
  686021
  691851
  693160
  699136
  703646
  709637
  710323
  712830
  712929
  714426
  716159
  716202
  716744
  717856
  718520
  721954
  722190
  722212
  723549
  729601
  735528
  738433
  738909
  741295
  743897
  746135
  746594
  751243
  757548
  760823
  763740
  769469
  772483
  773244
  773470
  777827
  778200
  778521
  786330
  788156
  788528
  789213
  789655
  794033
  796622
  798805
  804882
  807271
  813285
  813587
  814285
  817948
  818422
  819490
  822027
  822154
  823269
  823295
  823585
  823791
  823884
]
2.09 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public flash pussy"
]
2.02 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на flash улиц pussy"
]
1.69 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на flash улиц pussy"
]

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.