GET https://search.jues.net/search/embeds/7?q=amateur%20pickup

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.45 ms
(82.74%)
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
  391808
  418141
  420589
  420680
  425473
  428382
  428388
  436040
  442547
  443986
  450635
  450657
  450861
  455514
  455920
  456660
  458195
  458348
  458429
  458433
  460126
  460531
  460538
  461006
  461774
  462258
  462285
  465071
  467165
  467735
  469711
  470826
  472069
  473508
  473637
  474489
  475204
  475207
  476972
  478756
  479483
  479511
  480487
  480894
  482401
  482489
  484009
  485347
  486965
  487133
  489003
  489187
  489792
  491695
  491699
  491720
  493953
  496976
  497146
  497199
  498234
  498899
  499224
  502180
  503109
  505421
  506208
  506946
  508747
  508836
  510106
  512399
  512652
  512769
  513320
  516250
  519657
  519665
  521095
  521298
  521898
  523666
  527270
  527314
  527626
  546340
  547986
  548316
  552323
  552353
  554303
  554563
  554955
  558505
  560257
  564096
  566100
  568392
  568608
  568666
  569068
  570910
  571656
  571983
  573731
  573783
  584646
  590573
  594505
  594979
  597869
  606321
  620072
  621937
  635422
  636264
  645096
  668005
  716351
  721967
]
15.55 ms
(10.09%)
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
  484009
  497146
  512769
  523666
  489792
  493953
  505421
  482401
  450657
  461006
  479483
  428382
  489003
  508836
  590573
  450861
  519657
  391808
  474489
  465071
  521898
  467165
  472069
  460538
  461774
  418141
  476972
  480487
  460531
  473508
  497199
  503109
  506208
  513320
  485347
  491695
  498234
  527314
  478756
  460126
  469711
  458429
  473637
  554563
  552323
  571983
  554303
  443986
  436040
  487133
  491699
  527270
  594979
  594505
  621937
  552353
  480894
  482489
  512399
  564096
  606321
  597869
  636264
  470826
  420589
  450635
  510106
  506946
  527626
  425473
  475204
  496976
  519665
  458348
  458433
  462258
  521095
  498899
  502180
  546340
  547986
  558505
  568666
  569068
  570910
  571656
  548316
  560257
  566100
  568392
  554955
  568608
  573731
  584646
  716351
  645096
  668005
  573783
  620072
  635422
  721967
  456660
  428388
  455920
  467735
  479511
  420680
  455514
  458195
  462285
  475207
  442547
  508747
  516250
  491720
  512652
  486965
  489187
  499224
  521298
]
2.58 ms
(1.68%)
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
  391808
  418141
  420589
  420680
  425473
  428382
  428388
  436040
  442547
  443986
  450635
  450657
  450861
  455514
  455920
  456660
  458195
  458348
  458429
  458433
  460126
  460531
  460538
  461006
  461774
  462258
  462285
  465071
  467165
  467735
  469711
  470826
  472069
  473508
  473637
  474489
  475204
  475207
  476972
  478756
  479483
  479511
  480487
  480894
  482401
  482489
  484009
  485347
  486965
  487133
  489003
  489187
  489792
  491695
  491699
  491720
  493953
  496976
  497146
  497199
  498234
  498899
  499224
  502180
  503109
  505421
  506208
  506946
  508747
  508836
  510106
  512399
  512652
  512769
  513320
  516250
  519657
  519665
  521095
  521298
  521898
  523666
  527270
  527314
  527626
  546340
  547986
  548316
  552323
  552353
  554303
  554563
  554955
  558505
  560257
  564096
  566100
  568392
  568608
  568666
  569068
  570910
  571656
  571983
  573731
  573783
  584646
  590573
  594505
  594979
  597869
  606321
  620072
  621937
  635422
  636264
  645096
  668005
  716351
  721967
]
2.26 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur pickup"
]
2.18 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск пикап"
]
2.15 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.