GET https://search.jues.net/search/embeds/3?q=chubby%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
202.48 ms
(89.95%)
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
  61243
  134210
  336058
  360351
  381772
  382215
  382326
  383971
  384487
  385073
  385388
  389719
  397625
  402648
  405042
  405852
  413716
  419569
  425864
  430397
  442429
  444449
  454480
  454957
  460342
  463210
  466185
  466841
  466909
  466933
  470426
  471178
  473383
  477611
  490383
  491099
  497329
  502608
  517678
  517685
  518615
  527417
  527913
  527919
  532856
  535898
  536716
  542884
  558178
  558324
  569529
  580229
  583359
  584051
  585928
  585963
  586199
  592632
  592662
  612243
  617536
  617540
  618514
  627731
  633527
  634697
  652799
  658108
  663358
  663469
  663906
  664314
  665359
  666094
  668880
  685509
  698127
  700855
  705755
  709266
  714242
  714845
  715268
  724489
  725207
  725218
  725507
  742642
  743839
  744212
  744460
  749636
  753025
  753108
  755345
  755911
  755936
  755958
  759747
  776403
  778490
  781860
  781976
  782411
  782423
  789721
  794872
  796577
  797341
  802912
  803897
  805875
  808231
  808314
  812390
  814721
  824303
  824572
  824833
  824845
]
12.19 ms
(5.42%)
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
  336058
  382215
  583359
  663469
  664314
  663358
  666094
  585928
  627731
  812390
  753108
  782423
  755958
  382326
  824833
  585963
  384487
  814721
  714242
  61243
  824303
  473383
  665359
  658108
  668880
  808314
  802912
  824572
  471178
  497329
  536716
  652799
  715268
  714845
  617540
  634697
  805875
  725507
  781976
  755936
  749636
  778490
  803897
  360351
  402648
  413716
  558324
  580229
  700855
  592632
  444449
  517685
  569529
  742642
  477611
  454480
  385388
  385073
  389719
  405852
  442429
  824845
  491099
  705755
  663906
  789721
  808231
  744460
  725207
  743839
  755911
  466909
  618514
  134210
  463210
  527417
  532856
  535898
  527913
  470426
  542884
  685509
  558178
  584051
  633527
  586199
  796577
  797341
  755345
  782411
  460342
  425864
  527919
  490383
  383971
  397625
  612243
  617536
  794872
  781860
  724489
  753025
  725218
  759747
  698127
  709266
  776403
  454957
  517678
  430397
  466841
  592662
  744212
  466933
  466185
  405042
  518615
  502608
  381772
  419569
]
3.00 ms
(1.33%)
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
  61243
  134210
  336058
  360351
  381772
  382215
  382326
  383971
  384487
  385073
  385388
  389719
  397625
  402648
  405042
  405852
  413716
  419569
  425864
  430397
  442429
  444449
  454480
  454957
  460342
  463210
  466185
  466841
  466909
  466933
  470426
  471178
  473383
  477611
  490383
  491099
  497329
  502608
  517678
  517685
  518615
  527417
  527913
  527919
  532856
  535898
  536716
  542884
  558178
  558324
  569529
  580229
  583359
  584051
  585928
  585963
  586199
  592632
  592662
  612243
  617536
  617540
  618514
  627731
  633527
  634697
  652799
  658108
  663358
  663469
  663906
  664314
  665359
  666094
  668880
  685509
  698127
  700855
  705755
  709266
  714242
  714845
  715268
  724489
  725207
  725218
  725507
  742642
  743839
  744212
  744460
  749636
  753025
  753108
  755345
  755911
  755936
  755958
  759747
  776403
  778490
  781860
  781976
  782411
  782423
  789721
  794872
  796577
  797341
  802912
  803897
  805875
  808231
  808314
  812390
  814721
  824303
  824572
  824833
  824845
]
2.04 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby girl"
]
2.02 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby девушк"
]
1.68 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby девушк"
]

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.