GET https://search.jues.net/search/embeds/2?q=anal%20big%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.34 ms
(88.07%)
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
  151564
  185353
  187819
  188293
  385984
  386545
  388957
  389199
  397647
  401109
  421603
  427311
  435213
  447094
  454713
  456393
  478457
  487059
  493587
  505286
  511266
  521537
  523554
  529103
  532812
  533831
  536588
  552272
  555074
  555076
  568324
  576649
  604251
  604413
  611662
  613683
  616094
  620575
  621712
  623380
  625901
  635250
  645276
  646270
  647192
  647895
  656621
  665789
  670965
  671721
  673791
  677332
  679373
  680300
  698496
  703542
  705291
  706599
  709594
  710368
  712518
  716528
  719781
  719946
  719960
  720067
  722666
  726641
  727632
  727757
  731261
  731360
  731482
  734466
  740604
  740773
  740791
  740890
  742799
  743059
  743345
  745478
  746067
  746160
  746979
  747533
  747709
  748322
  748487
  749328
  750063
  750292
  750469
  755410
  760964
  762884
  763009
  766690
  769772
  769829
  773644
  777036
  783145
  784155
  784307
  791095
  797505
  799650
  801213
  801807
  804464
  811657
  815196
  815266
  815804
  820039
  820840
  820875
  822363
  826131
]
12.75 ms
(6.92%)
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
  705291
  386545
  427311
  188293
  447094
  555074
  677332
  679373
  604413
  604251
  389199
  523554
  722666
  742799
  755410
  385984
  397647
  799650
  746979
  698496
  727757
  743059
  826131
  529103
  670965
  625901
  493587
  820039
  712518
  748322
  747533
  740791
  719960
  746067
  623380
  822363
  815804
  706599
  750063
  505286
  388957
  784155
  784307
  454713
  536588
  613683
  646270
  716528
  671721
  719781
  555076
  791095
  734466
  743345
  750469
  762884
  745478
  769772
  720067
  680300
  703542
  719946
  647192
  665789
  611662
  777036
  731482
  760964
  773644
  731261
  763009
  750292
  726641
  710368
  456393
  740773
  820840
  709594
  783145
  187819
  820875
  511266
  811657
  727632
  740890
  740604
  801807
  151564
  421603
  532812
  769829
  568324
  645276
  621712
  435213
  815266
  746160
  748487
  747709
  815196
  673791
  620575
  616094
  185353
  487059
  656621
  635250
  801213
  797505
  731360
  749328
  766690
  552272
  647895
  804464
  401109
  478457
  533831
  576649
  521537
]
2.96 ms
(1.61%)
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
  151564
  185353
  187819
  188293
  385984
  386545
  388957
  389199
  397647
  401109
  421603
  427311
  435213
  447094
  454713
  456393
  478457
  487059
  493587
  505286
  511266
  521537
  523554
  529103
  532812
  533831
  536588
  552272
  555074
  555076
  568324
  576649
  604251
  604413
  611662
  613683
  616094
  620575
  621712
  623380
  625901
  635250
  645276
  646270
  647192
  647895
  656621
  665789
  670965
  671721
  673791
  677332
  679373
  680300
  698496
  703542
  705291
  706599
  709594
  710368
  712518
  716528
  719781
  719946
  719960
  720067
  722666
  726641
  727632
  727757
  731261
  731360
  731482
  734466
  740604
  740773
  740791
  740890
  742799
  743059
  743345
  745478
  746067
  746160
  746979
  747533
  747709
  748322
  748487
  749328
  750063
  750292
  750469
  755410
  760964
  762884
  763009
  766690
  769772
  769829
  773644
  777036
  783145
  784155
  784307
  791095
  797505
  799650
  801213
  801807
  804464
  811657
  815196
  815266
  815804
  820039
  820840
  820875
  822363
  826131
]
1.92 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal big pussy"
]
1.50 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал большие pussy"
]
1.37 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал большие pussy"
]

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.