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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.41 ms
(80.73%)
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
  395394
  419912
  428387
  428406
  432899
  441017
  442390
  442439
  443587
  444343
  444972
  445184
  445607
  448574
  451441
  452443
  455210
  455822
  455840
  456798
  458199
  461221
  462170
  465745
  466073
  466490
  466727
  470339
  470350
  471400
  471503
  471517
  471548
  472127
  473790
  473799
  475181
  475223
  475556
  476544
  477456
  480759
  482226
  482256
  483805
  484760
  486116
  486134
  486953
  487144
  492705
  493284
  495302
  495326
  496864
  496865
  496870
  499795
  499970
  500600
  501227
  502000
  504769
  506258
  506562
  513520
  513521
  514045
  515816
  516754
  516902
  517626
  520299
  521914
  521916
  522197
  522540
  524573
  525892
  526777
  527074
  529497
  540794
  541109
  541193
  542526
  544040
  546374
  551267
  551448
  552616
  553949
  556422
  557592
  557596
  558210
  562806
  565400
  567089
  569532
  572198
  572385
  584990
  590829
  590860
  592408
  592417
  598186
  598921
  603744
  605913
  607321
  608553
  618230
  619186
  619508
  619522
  624843
  626428
  663789
]
18.87 ms
(13.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
  486134
  506258
  515816
  521916
  475556
  471517
  484760
  513520
  461221
  442390
  465745
  558210
  482256
  458199
  443587
  502000
  456798
  455840
  487144
  476544
  495302
  475181
  546374
  562806
  567089
  444343
  516902
  514045
  395394
  444972
  445607
  473790
  525892
  500600
  516754
  480759
  542526
  541193
  544040
  557596
  569532
  572198
  541109
  663789
  565400
  592417
  626428
  598186
  590860
  619522
  603744
  451441
  475223
  472127
  471503
  428387
  471548
  477456
  499970
  496864
  524573
  492705
  486116
  486953
  495326
  513521
  572385
  432899
  455822
  470350
  520299
  499795
  522197
  522540
  482226
  442439
  473799
  471400
  428406
  441017
  462170
  470339
  501227
  521914
  452443
  556422
  557592
  506562
  552616
  445184
  527074
  466490
  493284
  624843
  590829
  592408
  598921
  619508
  455210
  496865
  517626
  540794
  448574
  419912
  526777
  483805
  551267
  605913
  504769
  584990
  553949
  551448
  607321
  618230
  466727
  466073
  496870
  529497
  608553
  619186
]
2.37 ms
(1.64%)
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
  395394
  419912
  428387
  428406
  432899
  441017
  442390
  442439
  443587
  444343
  444972
  445184
  445607
  448574
  451441
  452443
  455210
  455822
  455840
  456798
  458199
  461221
  462170
  465745
  466073
  466490
  466727
  470339
  470350
  471400
  471503
  471517
  471548
  472127
  473790
  473799
  475181
  475223
  475556
  476544
  477456
  480759
  482226
  482256
  483805
  484760
  486116
  486134
  486953
  487144
  492705
  493284
  495302
  495326
  496864
  496865
  496870
  499795
  499970
  500600
  501227
  502000
  504769
  506258
  506562
  513520
  513521
  514045
  515816
  516754
  516902
  517626
  520299
  521914
  521916
  522197
  522540
  524573
  525892
  526777
  527074
  529497
  540794
  541109
  541193
  542526
  544040
  546374
  551267
  551448
  552616
  553949
  556422
  557592
  557596
  558210
  562806
  565400
  567089
  569532
  572198
  572385
  584990
  590829
  590860
  592408
  592417
  598186
  598921
  603744
  605913
  607321
  608553
  618230
  619186
  619508
  619522
  624843
  626428
  663789
]
1.74 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur pickup"
]
1.65 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск пикап"
]
1.61 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск пикап"
]
1.55 ms
(1.08%)
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.