GET https://search.jues.net/search/embeds/3?q=latina%20chubby

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.05 ms
(87.52%)
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
  172688
  189022
  389495
  397655
  399869
  411925
  413991
  417047
  438952
  441952
  442080
  442095
  446031
  449849
  452318
  452322
  461029
  461048
  473398
  473445
  473449
  478582
  507096
  528077
  529681
  530924
  550425
  554843
  563777
  564886
  565738
  583005
  584193
  584697
  590415
  610643
  611413
  612923
  615957
  626362
  629544
  636219
  636444
  640315
  642731
  649772
  667974
  697215
  700595
  703422
  707149
  709405
  711616
  713440
  713833
  714248
  714354
  716104
  716218
  726471
  726474
  726500
  726709
  726716
  726820
  726821
  732203
  732704
  732717
  732967
  734183
  734229
  738447
  740955
  744361
  747173
  748395
  750767
  750771
  753160
  759017
  762766
  766630
  767257
  768059
  770022
  775164
  776995
  781832
  781838
  781874
  781911
  782395
  785118
  785724
  785733
  788831
  796189
  796562
  796674
  801088
  801217
  803810
  804587
  808071
  810868
  815428
  818565
  824161
  824177
  824283
  824344
  824781
  824953
  825348
  825384
  826010
  826230
  826545
  828686
]
12.46 ms
(7.08%)
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
  397655
  441952
  442080
  411925
  442095
  824177
  473449
  449849
  473398
  473445
  461029
  528077
  584193
  782395
  452322
  189022
  389495
  413991
  417047
  438952
  478582
  824283
  825384
  826010
  824161
  825348
  818565
  824953
  815428
  824344
  824781
  828686
  529681
  584697
  711616
  667974
  700595
  714354
  714248
  554843
  563777
  626362
  610643
  642731
  781832
  788831
  804587
  808071
  785724
  796674
  810868
  732967
  747173
  753160
  766630
  767257
  803810
  759017
  726474
  738447
  744361
  740955
  732203
  748395
  713440
  716104
  781838
  785118
  796562
  399869
  452318
  461048
  565738
  446031
  507096
  172688
  826545
  826230
  530924
  550425
  564886
  583005
  649772
  703422
  709405
  713833
  697215
  707149
  716218
  629544
  640315
  590415
  615957
  636219
  611413
  612923
  636444
  776995
  781911
  801088
  801217
  775164
  781874
  796189
  726500
  726709
  734183
  734229
  770022
  785733
  750767
  750771
  768059
  726820
  726821
  732704
  732717
  762766
  726471
  726716
]
2.69 ms
(1.53%)
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
  172688
  189022
  389495
  397655
  399869
  411925
  413991
  417047
  438952
  441952
  442080
  442095
  446031
  449849
  452318
  452322
  461029
  461048
  473398
  473445
  473449
  478582
  507096
  528077
  529681
  530924
  550425
  554843
  563777
  564886
  565738
  583005
  584193
  584697
  590415
  610643
  611413
  612923
  615957
  626362
  629544
  636219
  636444
  640315
  642731
  649772
  667974
  697215
  700595
  703422
  707149
  709405
  711616
  713440
  713833
  714248
  714354
  716104
  716218
  726471
  726474
  726500
  726709
  726716
  726820
  726821
  732203
  732704
  732717
  732967
  734183
  734229
  738447
  740955
  744361
  747173
  748395
  750767
  750771
  753160
  759017
  762766
  766630
  767257
  768059
  770022
  775164
  776995
  781832
  781838
  781874
  781911
  782395
  785118
  785724
  785733
  788831
  796189
  796562
  796674
  801088
  801217
  803810
  804587
  808071
  810868
  815428
  818565
  824161
  824177
  824283
  824344
  824781
  824953
  825348
  825384
  826010
  826230
  826545
  828686
]
1.89 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina chubby"
]
1.74 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская chubby"
]
1.67 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "латинская chubby"
]

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.