GET https://search.jues.net/search/embeds/8?q=homemade%20rides

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.15 ms
(84.33%)
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
  72889
  325660
  412830
  416446
  427380
  427399
  432785
  434278
  439098
  439240
  440486
  440580
  440836
  441048
  441051
  441289
  441708
  442051
  448013
  449161
  449894
  449916
  450156
  451687
  452847
  455560
  455965
  455991
  457652
  457898
  458249
  464022
  464245
  465691
  466203
  468738
  479285
  482478
  486315
  491594
  496239
  501902
  510487
  517957
  520951
  521404
  521599
  523640
  523736
  524358
  527791
  536201
  537030
  540423
  542778
  547659
  551623
  553435
  554559
  560931
  563776
  568864
  573462
  576560
  578524
  578525
  584322
  584501
  587307
  588132
  588590
  592587
  594143
  594280
  594305
  595307
  598311
  600442
  604578
  607623
  609614
  612137
  628024
  640317
  654230
  706717
  707588
  710590
  712547
  718804
  720037
  720079
  726317
  736563
  739119
  740409
  741185
  750483
  750861
  750881
  755022
  755689
  758442
  767228
  767968
  769299
  772210
  772254
  776310
  777765
  783353
  784608
  785820
  785883
  787738
  793022
  796570
  797001
  798229
  814463
]
14.95 ms
(9.33%)
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
  540423
  536201
  578525
  578524
  712547
  706717
  707588
  588132
  588590
  594305
  594280
  612137
  628024
  521404
  527791
  440836
  427399
  440486
  440580
  441051
  455991
  450156
  457652
  451687
  452847
  455560
  464022
  521599
  501902
  496239
  510487
  537030
  464245
  542778
  554559
  584322
  551623
  584501
  547659
  563776
  568864
  573462
  654230
  710590
  718804
  720079
  553435
  560931
  576560
  607623
  640317
  587307
  600442
  604578
  592587
  598311
  594143
  595307
  609614
  777765
  785883
  796570
  776310
  785820
  793022
  798229
  726317
  741185
  750483
  767228
  769299
  772210
  772254
  784608
  787738
  736563
  739119
  740409
  750861
  767968
  755022
  755689
  758442
  750881
  720037
  783353
  797001
  432785
  412830
  416446
  441708
  458249
  466203
  479285
  448013
  457898
  491594
  517957
  523736
  523640
  524358
  520951
  72889
  325660
  441289
  427380
  442051
  434278
  439240
  439098
  441048
  814463
  482478
  449894
  455965
  486315
  449161
  449916
  465691
  468738
]
2.90 ms
(1.81%)
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
  72889
  325660
  412830
  416446
  427380
  427399
  432785
  434278
  439098
  439240
  440486
  440580
  440836
  441048
  441051
  441289
  441708
  442051
  448013
  449161
  449894
  449916
  450156
  451687
  452847
  455560
  455965
  455991
  457652
  457898
  458249
  464022
  464245
  465691
  466203
  468738
  479285
  482478
  486315
  491594
  496239
  501902
  510487
  517957
  520951
  521404
  521599
  523640
  523736
  524358
  527791
  536201
  537030
  540423
  542778
  547659
  551623
  553435
  554559
  560931
  563776
  568864
  573462
  576560
  578524
  578525
  584322
  584501
  587307
  588132
  588590
  592587
  594143
  594280
  594305
  595307
  598311
  600442
  604578
  607623
  609614
  612137
  628024
  640317
  654230
  706717
  707588
  710590
  712547
  718804
  720037
  720079
  726317
  736563
  739119
  740409
  741185
  750483
  750861
  750881
  755022
  755689
  758442
  767228
  767968
  769299
  772210
  772254
  776310
  777765
  783353
  784608
  785820
  785883
  787738
  793022
  796570
  797001
  798229
  814463
]
1.91 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск rides"
]
1.88 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade rides"
]
1.83 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск rides"
]

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.