GET https://search.jues.net/search/embeds/3?q=asian%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.94 ms
(87.79%)
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
  172340
  355652
  385040
  387304
  387346
  388226
  390574
  390970
  391048
  398609
  401414
  401513
  408766
  408783
  409743
  417650
  419585
  424729
  424918
  425366
  425424
  427449
  428850
  431497
  435618
  435645
  443582
  446480
  457407
  457749
  457752
  459262
  460074
  460474
  462288
  469800
  469803
  471168
  473755
  473774
  484281
  492637
  500684
  512204
  529825
  530639
  533132
  535555
  538674
  546039
  547130
  552013
  552016
  553259
  554340
  571157
  575344
  578559
  582669
  583406
  584093
  587898
  595056
  600455
  602691
  602983
  610017
  613040
  618318
  622336
  622643
  623568
  635061
  645662
  645673
  650495
  651565
  655882
  658187
  658556
  660979
  674463
  674469
  678758
  694200
  707727
  711290
  712184
  715293
  717274
  717281
  717289
  721756
  724590
  729857
  731503
  731576
  734492
  740831
  741098
  741812
  749807
  749812
  750447
  750943
  753216
  760216
  762136
  766781
  772011
  777426
  787884
  788987
  790344
  791307
  797376
  805057
  811868
  826441
  828213
]
12.78 ms
(7.15%)
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
  622643
  602983
  618318
  711290
  712184
  797376
  419585
  484281
  717274
  694200
  492637
  750943
  741098
  760216
  741812
  575344
  457407
  584093
  655882
  645673
  658187
  658556
  674463
  595056
  613040
  731503
  707727
  471168
  398609
  390970
  622336
  750447
  387304
  387346
  553259
  587898
  417650
  678758
  811868
  571157
  401414
  469800
  469803
  401513
  408783
  425424
  435618
  457749
  552013
  552016
  390574
  435645
  172340
  530639
  715293
  717289
  788987
  790344
  753216
  724590
  731576
  762136
  749807
  749812
  772011
  623568
  535555
  583406
  651565
  674469
  645662
  660979
  547130
  610017
  635061
  602691
  600455
  427449
  457752
  385040
  512204
  650495
  828213
  554340
  428850
  424729
  443582
  446480
  460074
  473755
  473774
  500684
  533132
  546039
  582669
  460474
  538674
  408766
  391048
  424918
  425366
  462288
  826441
  529825
  791307
  734492
  805057
  409743
  459262
  355652
  388226
  431497
  578559
  717281
  740831
  766781
  729857
  721756
  777426
  787884
]
2.69 ms
(1.51%)
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
  172340
  355652
  385040
  387304
  387346
  388226
  390574
  390970
  391048
  398609
  401414
  401513
  408766
  408783
  409743
  417650
  419585
  424729
  424918
  425366
  425424
  427449
  428850
  431497
  435618
  435645
  443582
  446480
  457407
  457749
  457752
  459262
  460074
  460474
  462288
  469800
  469803
  471168
  473755
  473774
  484281
  492637
  500684
  512204
  529825
  530639
  533132
  535555
  538674
  546039
  547130
  552013
  552016
  553259
  554340
  571157
  575344
  578559
  582669
  583406
  584093
  587898
  595056
  600455
  602691
  602983
  610017
  613040
  618318
  622336
  622643
  623568
  635061
  645662
  645673
  650495
  651565
  655882
  658187
  658556
  660979
  674463
  674469
  678758
  694200
  707727
  711290
  712184
  715293
  717274
  717281
  717289
  721756
  724590
  729857
  731503
  731576
  734492
  740831
  741098
  741812
  749807
  749812
  750447
  750943
  753216
  760216
  762136
  766781
  772011
  777426
  787884
  788987
  790344
  791307
  797376
  805057
  811868
  826441
  828213
]
1.67 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк любительск"
]
1.65 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "азиатк любительск"
]
1.53 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian amateur"
]
1.50 ms
(0.84%)
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.