GET https://search.jues.net/search/embeds/7?q=chubby%20panties

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.83 ms
(86.76%)
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
  30958
  45225
  153376
  387661
  391767
  398954
  401398
  401423
  406068
  406635
  407666
  407684
  409803
  411916
  413734
  414429
  415569
  415852
  417438
  433415
  440755
  440992
  442025
  444707
  456067
  456581
  460479
  461115
  461282
  463973
  464031
  465431
  472403
  480900
  482735
  483457
  484763
  503476
  509225
  522102
  525189
  528529
  530566
  530924
  536352
  541078
  542348
  544039
  544826
  549222
  549655
  550262
  555504
  561524
  565630
  567540
  568221
  574448
  577197
  579498
  583151
  584047
  588230
  592901
  592999
  599489
  601611
  607608
  609047
  646164
  649772
  652983
  662931
  663871
  664240
  668982
  686185
  701245
  712672
  713122
  714216
  714698
  715416
  715593
  725467
  754125
  757097
  763141
  770139
  772102
  781856
  781857
  781875
  782407
  797144
  800763
  801704
  803373
  804266
  807749
  808067
  808558
  809542
  813798
  813812
  814184
  814692
  817750
  818781
  819961
  823362
  823958
  825444
  825997
  826195
  826387
  827204
  827945
  827998
  828146
]
17.40 ms
(8.68%)
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
  45225
  401423
  413734
  442025
  407684
  814692
  823362
  536352
  549655
  579498
  712672
  715593
  713122
  714698
  664240
  609047
  599489
  803373
  809542
  801704
  763141
  770139
  781856
  808558
  725467
  754125
  772102
  782407
  808067
  401398
  409803
  398954
  406068
  460479
  509225
  417438
  549222
  541078
  503476
  406635
  407666
  461115
  528529
  781875
  781857
  440755
  465431
  30958
  444707
  456067
  482735
  797144
  807749
  757097
  800763
  461282
  391767
  433415
  440992
  525189
  463973
  480900
  686185
  607608
  411916
  456581
  484763
  464031
  472403
  387661
  804266
  153376
  414429
  415569
  415852
  817750
  823958
  825444
  825997
  813798
  819961
  826387
  827204
  814184
  826195
  813812
  818781
  828146
  827945
  827998
  483457
  530566
  530924
  522102
  561524
  584047
  542348
  567540
  568221
  574448
  544039
  544826
  555504
  565630
  646164
  649772
  715416
  652983
  662931
  663871
  668982
  701245
  714216
  550262
  577197
  583151
  588230
  592901
  592999
  601611
]
2.41 ms
(1.20%)
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
  30958
  45225
  153376
  387661
  391767
  398954
  401398
  401423
  406068
  406635
  407666
  407684
  409803
  411916
  413734
  414429
  415569
  415852
  417438
  433415
  440755
  440992
  442025
  444707
  456067
  456581
  460479
  461115
  461282
  463973
  464031
  465431
  472403
  480900
  482735
  483457
  484763
  503476
  509225
  522102
  525189
  528529
  530566
  530924
  536352
  541078
  542348
  544039
  544826
  549222
  549655
  550262
  555504
  561524
  565630
  567540
  568221
  574448
  577197
  579498
  583151
  584047
  588230
  592901
  592999
  599489
  601611
  607608
  609047
  646164
  649772
  652983
  662931
  663871
  664240
  668982
  686185
  701245
  712672
  713122
  714216
  714698
  715416
  715593
  725467
  754125
  757097
  763141
  770139
  772102
  781856
  781857
  781875
  782407
  797144
  800763
  801704
  803373
  804266
  807749
  808067
  808558
  809542
  813798
  813812
  814184
  814692
  817750
  818781
  819961
  823362
  823958
  825444
  825997
  826195
  826387
  827204
  827945
  827998
  828146
]
1.93 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby panties"
]
1.73 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby трусик нижн бел"
]
1.56 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby трусик нижн бел"
]
1.50 ms
(0.75%)
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.