GET https://search.jues.net/search/embeds/9?q=dick%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.39 ms
(85.44%)
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
  188515
  387179
  397215
  397221
  398459
  403911
  408188
  415948
  429504
  444000
  451480
  451504
  451931
  451991
  452093
  452117
  453126
  454166
  454212
  454274
  454563
  460618
  463177
  464129
  465312
  465367
  465457
  466001
  466018
  466063
  466217
  466265
  466269
  466277
  466877
  467025
  467055
  467255
  467493
  467527
  470190
  470275
  470306
  470942
  472630
  474481
  474483
  474493
  475874
  476352
  476354
  477723
  477735
  477994
  478719
  479105
  479149
  480301
  480305
  481388
  484580
  484620
  484643
  484646
  484652
  484703
  485747
  486340
  489212
  490885
  490894
  490896
  490904
  491417
  491899
  491906
  491988
  495112
  496028
  500725
  502029
  506210
  509554
  511160
  511181
  511538
  518729
  518851
  519152
  519802
  520897
  522760
  523579
  534680
  534919
  537842
  537972
  553274
  554922
  580913
  619600
  624468
  667294
  712335
  714155
  726553
  726959
  728083
  731776
  736422
  741877
  742889
  757982
  774384
  780625
  788314
  806241
  815389
  816876
  823357
]
23.16 ms
(9.50%)
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
  478719
  444000
  454166
  466269
  467055
  470190
  475874
  387179
  466877
  470275
  470306
  474493
  479105
  463177
  465457
  466265
  474481
  477994
  481388
  415948
  451480
  454563
  465312
  466001
  466018
  466063
  467255
  467527
  470942
  490885
  491899
  496028
  506210
  511538
  484580
  484652
  486340
  490904
  491988
  502029
  519802
  520897
  484646
  485747
  490896
  491906
  500725
  518851
  188515
  397221
  397215
  408188
  429504
  823357
  816876
  815389
  518729
  519152
  534919
  537842
  537972
  667294
  712335
  619600
  780625
  806241
  731776
  736422
  742889
  728083
  741877
  757982
  726959
  774384
  714155
  788314
  398459
  403911
  451931
  451991
  452117
  489212
  460618
  476354
  484620
  464129
  467025
  491417
  511181
  534680
  523579
  509554
  472630
  480301
  480305
  554922
  580913
  553274
  624468
  726553
  474483
  477735
  451504
  454274
  466277
  477723
  479149
  452093
  467493
  476352
  453126
  454212
  465367
  466217
  511160
  522760
  484643
  484703
  490894
  495112
]
4.30 ms
(1.76%)
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
  188515
  387179
  397215
  397221
  398459
  403911
  408188
  415948
  429504
  444000
  451480
  451504
  451931
  451991
  452093
  452117
  453126
  454166
  454212
  454274
  454563
  460618
  463177
  464129
  465312
  465367
  465457
  466001
  466018
  466063
  466217
  466265
  466269
  466277
  466877
  467025
  467055
  467255
  467493
  467527
  470190
  470275
  470306
  470942
  472630
  474481
  474483
  474493
  475874
  476352
  476354
  477723
  477735
  477994
  478719
  479105
  479149
  480301
  480305
  481388
  484580
  484620
  484643
  484646
  484652
  484703
  485747
  486340
  489212
  490885
  490894
  490896
  490904
  491417
  491899
  491906
  491988
  495112
  496028
  500725
  502029
  506210
  509554
  511160
  511181
  511538
  518729
  518851
  519152
  519802
  520897
  522760
  523579
  534680
  534919
  537842
  537972
  553274
  554922
  580913
  619600
  624468
  667294
  712335
  714155
  726553
  726959
  728083
  731776
  736422
  741877
  742889
  757982
  774384
  780625
  788314
  806241
  815389
  816876
  823357
]
2.52 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член mature"
]
1.99 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick mature"
]
1.91 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член mature"
]
1.64 ms
(0.67%)
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.