GET https://search.jues.net/search/embeds/3?q=sucking%20and%20licking

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.47 ms
(85.17%)
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
  61226
  79683
  382955
  384532
  387599
  395459
  407762
  418272
  418699
  423880
  430014
  443055
  445723
  445747
  448647
  451479
  454649
  455386
  461512
  465741
  465756
  466538
  472778
  474538
  475492
  480223
  480328
  484140
  487376
  488190
  489874
  492123
  495682
  495968
  497022
  497331
  497746
  498056
  510079
  510864
  516497
  521280
  521686
  521812
  524468
  528628
  529255
  531308
  538062
  539338
  539524
  540195
  543378
  543910
  545172
  546381
  551540
  555112
  557168
  565720
  565859
  571710
  572918
  578571
  581030
  584070
  585735
  587655
  589624
  590480
  591418
  591741
  591960
  593618
  594401
  594825
  594826
  595115
  595404
  597031
  599973
  600482
  601024
  601027
  603623
  603992
  615042
  623288
  630119
  630562
  631286
  633853
  637488
  639051
  643315
  657529
  670246
  670456
  675095
  677020
  697180
  701573
  720618
  724361
  726507
  726702
  729264
  733048
  737152
  748159
  762848
  770278
  772681
  776316
  781980
  795497
  795918
  800316
  805474
  809516
]
16.30 ms
(9.11%)
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
  539338
  539524
  516497
  540195
  551540
  571710
  584070
  557168
  670246
  701573
  670456
  697180
  657529
  555112
  578571
  585735
  587655
  589624
  594401
  594826
  595404
  590480
  591741
  637488
  591960
  630562
  776316
  795497
  795918
  724361
  729264
  733048
  772681
  805474
  748159
  726702
  737152
  770278
  726507
  615042
  781980
  382955
  466538
  61226
  423880
  480328
  395459
  418699
  465741
  465756
  475492
  430014
  445747
  461512
  484140
  489874
  495968
  497331
  497746
  454649
  565720
  677020
  603992
  510079
  495682
  601027
  603623
  384532
  407762
  487376
  445723
  492123
  510864
  528628
  531308
  538062
  497022
  521280
  521812
  529255
  524468
  472778
  474538
  480223
  546381
  543910
  545172
  543378
  572918
  581030
  675095
  720618
  565859
  639051
  594825
  633853
  643315
  591418
  623288
  630119
  593618
  595115
  597031
  599973
  600482
  601024
  631286
  809516
  762848
  800316
  443055
  448647
  79683
  387599
  418272
  451479
  455386
  521686
  488190
  498056
]
2.99 ms
(1.67%)
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
  61226
  79683
  382955
  384532
  387599
  395459
  407762
  418272
  418699
  423880
  430014
  443055
  445723
  445747
  448647
  451479
  454649
  455386
  461512
  465741
  465756
  466538
  472778
  474538
  475492
  480223
  480328
  484140
  487376
  488190
  489874
  492123
  495682
  495968
  497022
  497331
  497746
  498056
  510079
  510864
  516497
  521280
  521686
  521812
  524468
  528628
  529255
  531308
  538062
  539338
  539524
  540195
  543378
  543910
  545172
  546381
  551540
  555112
  557168
  565720
  565859
  571710
  572918
  578571
  581030
  584070
  585735
  587655
  589624
  590480
  591418
  591741
  591960
  593618
  594401
  594825
  594826
  595115
  595404
  597031
  599973
  600482
  601024
  601027
  603623
  603992
  615042
  623288
  630119
  630562
  631286
  633853
  637488
  639051
  643315
  657529
  670246
  670456
  675095
  677020
  697180
  701573
  720618
  724361
  726507
  726702
  729264
  733048
  737152
  748159
  762848
  770278
  772681
  776316
  781980
  795497
  795918
  800316
  805474
  809516
]
2.11 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sucking and licking"
]
1.78 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sucking лиза"
]
1.66 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sucking лиза"
]

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.