GET https://search.jues.net/search/embeds/3?q=big%20curvy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.02 ms
(58.00%)
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
  30208
  30791
  37495
  72386
  178567
  191246
  251476
  381942
  383110
  391701
  395584
  396365
  397708
  407187
  411621
  418739
  440908
  454410
  459257
  466703
  475387
  478035
  510830
  523904
  529701
  561213
  578200
  596795
  596969
  600543
  601618
  607405
  607607
  607650
  614726
  614733
  623638
  630370
  633824
  641794
  647645
  664227
  664275
  666712
  667751
  669652
  675964
  678806
  690480
  691180
  697184
  697391
  698125
  698128
  699441
  707642
  709623
  716164
  716331
  716883
  723189
  728429
  735836
  736465
  738209
  738297
  740985
  748523
  753783
  754191
  755363
  758791
  760406
  761244
  764414
  769501
  773579
  774294
  775558
  776176
  776557
  781978
  782408
  784794
  784961
  786600
  788230
  788490
  793683
  799872
  800005
  800543
  800869
  801416
  802445
  802671
  802834
  803176
  804800
  805737
  807769
  808037
  808531
  810000
  810105
  810410
  813620
  814282
  814293
  814722
  815991
  817116
  819262
  819351
  823536
  823585
  823887
  825405
  826235
]
133.09 ms
(36.40%)
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
  30208
  30791
  37495
  72386
  178567
  191246
  251476
  381942
  383110
  391701
  395584
  396365
  397708
  407187
  411621
  418739
  440908
  454410
  459257
  466703
  475387
  478035
  510830
  523904
  529701
  561213
  578200
  596795
  596969
  600543
  601618
  607405
  607607
  607650
  614726
  614733
  623638
  630370
  633824
  641794
  647645
  664227
  664275
  666712
  667751
  669652
  675964
  678806
  690480
  691180
  697184
  697391
  698125
  698128
  699441
  707642
  709623
  716164
  716331
  716883
  723189
  728429
  735836
  736465
  738209
  738297
  740985
  748523
  753783
  754191
  755363
  758791
  760406
  761244
  764414
  769501
  773579
  774294
  775558
  776176
  776557
  781978
  782408
  784794
  784961
  786600
  788230
  788490
  793683
  799872
  800005
  800543
  800869
  801416
  802445
  802671
  802834
  803176
  804800
  805737
  807769
  808037
  808531
  810000
  810105
  810410
  813620
  814282
  814293
  814722
  815991
  817116
  819262
  819351
  823536
  823585
  823887
  825405
  826235
]
13.73 ms
(3.76%)
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
  735836
  754191
  728648
  716164
  191246
  391701
  814722
  819351
  478035
  523904
  716883
  697391
  709623
  675964
  600543
  607405
  596795
  607607
  775558
  776557
  802834
  736465
  773579
  800005
  760406
  764414
  738297
  753783
  707642
  782408
  788230
  803176
  383110
  178567
  440908
  815991
  823536
  825405
  691180
  596969
  810105
  633824
  814282
  397708
  411621
  454410
  510830
  690480
  776176
  807769
  748523
  728429
  799872
  30791
  823887
  813620
  817116
  475387
  647645
  664275
  698125
  698128
  614726
  601618
  623638
  761244
  808531
  810000
  784961
  72386
  396365
  30208
  407187
  819262
  826235
  814293
  664227
  667751
  666712
  697184
  716331
  561213
  641794
  630370
  784794
  802445
  740985
  758791
  793683
  800543
  801416
  774294
  769501
  800869
  802671
  804800
  805737
  808037
  459257
  381942
  823585
  529701
  678806
  699441
  723189
  781978
  810410
  788490
  755363
  738209
  607650
  614733
  37495
  251476
  395584
  418739
  466703
  578200
  669652
  786600
]
2.08 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big curvy"
]
1.65 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие curvy"
]
1.53 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие curvy"
]
1.49 ms
(0.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.