GET https://search.jues.net/search/embeds/6?q=swinger%20russian%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
228.48 ms
(88.63%)
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
  419529
  442171
  443591
  443658
  443767
  444139
  444141
  444185
  454129
  454277
  455507
  456448
  460731
  462305
  462702
  466056
  466074
  466075
  466111
  466291
  466316
  469764
  470584
  470622
  470666
  470944
  472784
  473788
  474632
  474650
  475912
  477360
  477735
  477943
  477966
  479049
  479149
  480059
  482499
  482510
  484416
  484459
  484469
  484477
  484563
  484570
  484636
  484655
  484669
  484674
  484695
  484703
  484706
  484722
  484738
  485633
  489310
  490262
  494161
  495182
  500596
  504165
  506042
  507767
  508720
  509910
  511193
  512558
  513603
  515361
  517556
  519776
  520473
  522328
  522423
  522525
  522526
  524613
  525702
  526568
  526721
  542062
  542743
  542748
  542750
  542759
  542765
  542791
  544040
  544755
  545377
  546724
  547997
  551553
  555972
  556001
  557977
  559575
  560454
  566392
  577120
  583997
  590505
  590693
  590860
  591908
  593835
  598918
  601364
  603630
  606794
  609531
  651214
  668977
  696178
  715387
  718698
  741203
  748336
  751589
]
18.80 ms
(7.29%)
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
  522526
  557977
  469764
  444185
  542062
  551553
  454129
  495182
  504165
  556001
  470944
  472784
  542759
  482510
  542748
  560454
  546724
  601364
  455507
  515361
  526568
  484655
  494161
  500596
  651214
  454277
  583997
  609531
  462305
  466111
  466056
  466316
  484570
  484636
  506042
  513603
  484722
  511193
  668977
  715387
  696178
  566392
  741203
  748336
  442171
  443658
  477943
  590505
  419529
  443767
  444141
  466291
  477735
  477966
  466074
  466075
  474650
  479049
  479149
  443591
  462702
  473788
  475912
  444139
  460731
  509910
  519776
  484469
  484563
  484695
  484703
  490262
  507767
  484416
  484738
  517556
  484459
  484669
  484674
  508720
  520473
  525702
  484477
  482499
  593835
  603630
  474632
  522423
  484706
  480059
  512558
  456448
  470622
  522328
  522525
  524613
  542743
  542750
  526721
  485633
  489310
  544755
  477360
  547997
  470584
  470666
  555972
  542765
  542791
  544040
  545377
  559575
  577120
  718698
  606794
  590693
  598918
  590860
  591908
  751589
]
3.35 ms
(1.30%)
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
  419529
  442171
  443591
  443658
  443767
  444139
  444141
  444185
  454129
  454277
  455507
  456448
  460731
  462305
  462702
  466056
  466074
  466075
  466111
  466291
  466316
  469764
  470584
  470622
  470666
  470944
  472784
  473788
  474632
  474650
  475912
  477360
  477735
  477943
  477966
  479049
  479149
  480059
  482499
  482510
  484416
  484459
  484469
  484477
  484563
  484570
  484636
  484655
  484669
  484674
  484695
  484703
  484706
  484722
  484738
  485633
  489310
  490262
  494161
  495182
  500596
  504165
  506042
  507767
  508720
  509910
  511193
  512558
  513603
  515361
  517556
  519776
  520473
  522328
  522423
  522525
  522526
  524613
  525702
  526568
  526721
  542062
  542743
  542748
  542750
  542759
  542765
  542791
  544040
  544755
  545377
  546724
  547997
  551553
  555972
  556001
  557977
  559575
  560454
  566392
  577120
  583997
  590505
  590693
  590860
  591908
  593835
  598918
  601364
  603630
  606794
  609531
  651214
  668977
  696178
  715387
  718698
  741203
  748336
  751589
]
2.15 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "swinger russian wife"
]
1.92 ms
(0.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.61%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "свингер русск жен"
]
1.52 ms
(0.59%)
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.