GET https://search.jues.net/search/embeds/7?q=vagina%20asian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.53 ms
(82.97%)
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
  20907
  153364
  165570
  166675
  265847
  327421
  382176
  383153
  383560
  383744
  386371
  387374
  392696
  396337
  396928
  398609
  400732
  401122
  401507
  401513
  404841
  407566
  408539
  409949
  410724
  411009
  411196
  412474
  413712
  413745
  417658
  418428
  419143
  419165
  420230
  420252
  422589
  428728
  429025
  429949
  444117
  447928
  456639
  456886
  457259
  457267
  460474
  462288
  463752
  469803
  475804
  478425
  491448
  491453
  500712
  512224
  513193
  514341
  522190
  524387
  534922
  538674
  542219
  550644
  550752
  551941
  551995
  552053
  552638
  552896
  554071
  554298
  556366
  558367
  558421
  559866
  559902
  559905
  564798
  565471
  565473
  568869
  578420
  578685
  580100
  580269
  583633
  584794
  585781
  590944
  595792
  596422
  601317
  606699
  613163
  614731
  619432
  619455
  623601
  623610
  641452
  643379
  644363
  653240
  654369
  690866
  717921
  727903
  730894
  735602
  740928
  742480
  743426
  743436
  753216
  754812
  785021
  791307
  793630
  812879
]
15.05 ms
(10.45%)
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
  410724
  551941
  559905
  550752
  551995
  554298
  578685
  584794
  595792
  513193
  407566
  512224
  558367
  392696
  382176
  396337
  400732
  401122
  422589
  411196
  522190
  514341
  500712
  558421
  542219
  559902
  717921
  552638
  580100
  585781
  596422
  614731
  606699
  619432
  641452
  785021
  740928
  754812
  793630
  730894
  735602
  743436
  742480
  727903
  623601
  644363
  812879
  417658
  420230
  383153
  265847
  404841
  491448
  791307
  753216
  401507
  387374
  383744
  428728
  429025
  420252
  457259
  463752
  534922
  578420
  654369
  565473
  590944
  409949
  554071
  411009
  327421
  408539
  413712
  456886
  457267
  478425
  524387
  552053
  559866
  619455
  623610
  419165
  412474
  475804
  386371
  153364
  166675
  20907
  419143
  413745
  418428
  429949
  447928
  469803
  460474
  538674
  491453
  550644
  552896
  556366
  580269
  690866
  653240
  643379
  613163
  456639
  398609
  401513
  462288
  583633
  165570
  564798
  568869
  743426
  565471
  601317
  383560
  396928
  444117
]
3.10 ms
(2.16%)
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
  20907
  153364
  165570
  166675
  265847
  327421
  382176
  383153
  383560
  383744
  386371
  387374
  392696
  396337
  396928
  398609
  400732
  401122
  401507
  401513
  404841
  407566
  408539
  409949
  410724
  411009
  411196
  412474
  413712
  413745
  417658
  418428
  419143
  419165
  420230
  420252
  422589
  428728
  429025
  429949
  444117
  447928
  456639
  456886
  457259
  457267
  460474
  462288
  463752
  469803
  475804
  478425
  491448
  491453
  500712
  512224
  513193
  514341
  522190
  524387
  534922
  538674
  542219
  550644
  550752
  551941
  551995
  552053
  552638
  552896
  554071
  554298
  556366
  558367
  558421
  559866
  559902
  559905
  564798
  565471
  565473
  568869
  578420
  578685
  580100
  580269
  583633
  584794
  585781
  590944
  595792
  596422
  601317
  606699
  613163
  614731
  619432
  619455
  623601
  623610
  641452
  643379
  644363
  653240
  654369
  690866
  717921
  727903
  730894
  735602
  740928
  742480
  743426
  743436
  753216
  754812
  785021
  791307
  793630
  812879
]
2.05 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vagina asian"
]
1.47 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вагин азиатк"
]
1.45 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин азиатк"
]
1.41 ms
(0.98%)
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.