GET https://search.jues.net/search/embeds/4?q=extreme%20dick

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.14 ms
(84.86%)
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
  32620
  96297
  124661
  197398
  204778
  205205
  214602
  382188
  382388
  382620
  383621
  384332
  384769
  385113
  387281
  387993
  388379
  390729
  394589
  394661
  396694
  396701
  396728
  396780
  397663
  398416
  398982
  400102
  400788
  400967
  402185
  413869
  414021
  414043
  415292
  415561
  443205
  445406
  447248
  453228
  467601
  468790
  478653
  491424
  491860
  497894
  513809
  515559
  517288
  519253
  521289
  521290
  531129
  531236
  532658
  533283
  534056
  534664
  536101
  536177
  536227
  536597
  537750
  540942
  550298
  554257
  555058
  610029
  619847
  629774
  631202
  633444
  641689
  642029
  665973
  666539
  666549
  666897
  677766
  677986
  678066
  678067
  678144
  681164
  693926
  707376
  713027
  713168
  714086
  716086
  716652
  716681
  720608
  732277
  738830
  743663
  747468
  748975
  753552
  760696
  763128
  771588
  771714
  771724
  772216
  781619
  788893
  793437
  793461
  807917
  817199
  820682
  820775
  821411
  825011
  825554
  825565
  827831
  827839
]
11.99 ms
(8.33%)
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
  610029
  771724
  771588
  382188
  415292
  396694
  550298
  631202
  678144
  677986
  666897
  678066
  633444
  443205
  382388
  825011
  716086
  629774
  793437
  743663
  707376
  385113
  124661
  521289
  536227
  747468
  825554
  447248
  665973
  714086
  693926
  713027
  555058
  642029
  788893
  748975
  738830
  387993
  398416
  468790
  536177
  517288
  519253
  32620
  204778
  387281
  390729
  396701
  396780
  445406
  453228
  515559
  414021
  197398
  396728
  413869
  415561
  397663
  533283
  497894
  400967
  414043
  531129
  677766
  383621
  214602
  394661
  467601
  619847
  400788
  96297
  821411
  827831
  827839
  536101
  537750
  534056
  536597
  540942
  554257
  388379
  478653
  825565
  827979
  400102
  521290
  394589
  382620
  398982
  402185
  817199
  716652
  713168
  681164
  641689
  781619
  793461
  760696
  772216
  732277
  763128
  753552
  771714
  716681
  720608
  807917
  205205
  513809
  531236
  534664
  532658
  666539
  678067
  666549
  384332
  384769
  820682
  820775
  491424
  491860
]
2.18 ms
(1.52%)
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
  32620
  96297
  124661
  197398
  204778
  205205
  214602
  382188
  382388
  382620
  383621
  384332
  384769
  385113
  387281
  387993
  388379
  390729
  394589
  394661
  396694
  396701
  396728
  396780
  397663
  398416
  398982
  400102
  400788
  400967
  402185
  413869
  414021
  414043
  415292
  415561
  443205
  445406
  447248
  453228
  467601
  468790
  478653
  491424
  491860
  497894
  513809
  515559
  517288
  519253
  521289
  521290
  531129
  531236
  532658
  533283
  534056
  534664
  536101
  536177
  536227
  536597
  537750
  540942
  550298
  554257
  555058
  610029
  619847
  629774
  631202
  633444
  641689
  642029
  665973
  666539
  666549
  666897
  677766
  677986
  678066
  678067
  678144
  681164
  693926
  707376
  713027
  713168
  714086
  716086
  716652
  716681
  720608
  732277
  738830
  743663
  747468
  748975
  753552
  760696
  763128
  771588
  771714
  771724
  772216
  781619
  788893
  793437
  793461
  807917
  817199
  820682
  820775
  821411
  825011
  825554
  825565
  827831
  827839
]
2.08 ms
(1.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.06 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme dick"
]
1.80 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор член"
]
1.67 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.