GET https://search.jues.net/search/embeds/3?q=swinger%20young%20boy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.01 ms
(83.71%)
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
  16971
  387905
  401351
  410254
  412132
  414313
  415746
  418427
  420541
  420891
  421890
  424648
  424695
  434000
  442281
  443591
  443658
  443767
  446505
  454277
  460282
  460731
  460733
  460734
  460739
  462279
  462315
  462700
  464542
  464743
  466069
  466074
  466090
  466094
  466097
  466112
  466223
  466321
  469919
  470019
  470028
  470487
  470512
  470596
  470749
  470941
  472328
  474631
  474650
  474817
  475115
  475439
  476251
  476261
  476797
  477079
  479049
  479108
  482824
  483627
  484383
  484469
  484472
  484656
  484661
  484669
  484693
  484696
  484706
  484711
  484722
  484748
  484750
  485703
  485940
  487550
  490201
  496397
  500691
  502310
  503875
  506053
  507813
  511023
  512384
  514692
  514808
  515361
  516121
  516634
  520826
  521852
  522525
  523335
  523686
  524141
  525238
  525871
  526568
  527608
  528146
  530726
  530884
  538832
  542748
  542794
  543407
  546774
  556420
  575509
  590693
  614262
  653876
  688324
  724425
  726487
  726543
  817070
  823585
  823613
]
21.19 ms
(11.15%)
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
  420541
  546774
  421890
  490201
  500691
  496397
  575509
  542748
  653876
  590693
  724425
  464743
  470019
  479108
  424695
  466223
  469919
  475115
  515361
  525238
  526568
  410254
  511023
  527608
  470596
  475439
  484693
  446505
  507813
  530726
  462315
  470028
  414313
  462279
  460739
  462700
  472328
  466069
  466094
  466097
  466112
  466321
  484656
  484706
  484748
  484750
  514808
  521852
  460733
  401351
  614262
  443658
  412132
  516634
  538832
  542794
  688324
  556420
  726543
  443767
  476251
  415746
  466074
  470512
  474650
  479049
  424648
  443591
  470941
  460731
  503875
  514692
  484469
  506053
  484472
  484711
  485940
  484669
  474817
  543407
  523686
  823585
  487550
  464542
  477079
  476797
  466090
  470487
  485703
  512384
  524141
  484696
  523335
  387905
  418427
  434000
  420891
  474631
  454277
  470749
  502310
  520826
  528146
  530884
  460282
  726487
  476261
  460734
  16971
  442281
  516121
  525871
  484722
  522525
  482824
  484383
  484661
  817070
  823613
  483627
]
2.93 ms
(1.54%)
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
  16971
  387905
  401351
  410254
  412132
  414313
  415746
  418427
  420541
  420891
  421890
  424648
  424695
  434000
  442281
  443591
  443658
  443767
  446505
  454277
  460282
  460731
  460733
  460734
  460739
  462279
  462315
  462700
  464542
  464743
  466069
  466074
  466090
  466094
  466097
  466112
  466223
  466321
  469919
  470019
  470028
  470487
  470512
  470596
  470749
  470941
  472328
  474631
  474650
  474817
  475115
  475439
  476251
  476261
  476797
  477079
  479049
  479108
  482824
  483627
  484383
  484469
  484472
  484656
  484661
  484669
  484693
  484696
  484706
  484711
  484722
  484748
  484750
  485703
  485940
  487550
  490201
  496397
  500691
  502310
  503875
  506053
  507813
  511023
  512384
  514692
  514808
  515361
  516121
  516634
  520826
  521852
  522525
  523335
  523686
  524141
  525238
  525871
  526568
  527608
  528146
  530726
  530884
  538832
  542748
  542794
  543407
  546774
  556420
  575509
  590693
  614262
  653876
  688324
  724425
  726487
  726543
  817070
  823585
  823613
]
2.03 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "swinger young boy"
]
1.79 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "свингер young парен"
]
1.45 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "свингер young парен"
]

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.