GET https://search.jues.net/search/embeds/6?q=blonde%20big%20toys

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.38 ms
(81.92%)
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
  13118
  131497
  191356
  290304
  382502
  383514
  384491
  385855
  388184
  397350
  398192
  400703
  402202
  402240
  402876
  404353
  404731
  408194
  410233
  411081
  412593
  413637
  414893
  415151
  415239
  415880
  416607
  418817
  419459
  419627
  420147
  421051
  423382
  425144
  425868
  425946
  426018
  430300
  433217
  444502
  445192
  445365
  448013
  449022
  451831
  452046
  452205
  454006
  454055
  454384
  454753
  455124
  456931
  458772
  460754
  465600
  468186
  469119
  471721
  471961
  473184
  477695
  477913
  480389
  483038
  485187
  485207
  486783
  488746
  489653
  490456
  497934
  498454
  498474
  498555
  500736
  501557
  503183
  503310
  503491
  504980
  511466
  512938
  512941
  513860
  514311
  514393
  515546
  517788
  518995
  520136
  524594
  524849
  525159
  528544
  528572
  528773
  531707
  537922
  543858
  544665
  547944
  560408
  566022
  569742
  574381
  574721
  581969
  582480
  592770
  597892
  601088
  680472
  706611
  725047
  740597
  757157
  769990
  795538
  817158
]
16.78 ms
(11.23%)
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
  592770
  415880
  385855
  384491
  398192
  400703
  404731
  465600
  456931
  528773
  524594
  680472
  383514
  458772
  13118
  448013
  477913
  504980
  486783
  485207
  469119
  512941
  517788
  473184
  512938
  514311
  455124
  480389
  454055
  488746
  430300
  511466
  490456
  544665
  408194
  451831
  454006
  452046
  483038
  498474
  404353
  497934
  419459
  413637
  817158
  452205
  531707
  706611
  795538
  725047
  769990
  740597
  388184
  423382
  454753
  520136
  503310
  560408
  582480
  445365
  449022
  547944
  581969
  574381
  597892
  402202
  402240
  454384
  498454
  514393
  543858
  419627
  425946
  471721
  503183
  515546
  524849
  569742
  757157
  425144
  382502
  421051
  131497
  415151
  415239
  418817
  397350
  426018
  445192
  485187
  528572
  501557
  513860
  518995
  525159
  528544
  402876
  414893
  410233
  601088
  444502
  425868
  411081
  433217
  489653
  471961
  477695
  498555
  537922
  566022
  574721
  460754
  191356
  290304
  420147
  468186
  503491
  500736
  412593
  416607
]
2.95 ms
(1.98%)
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
  13118
  131497
  191356
  290304
  382502
  383514
  384491
  385855
  388184
  397350
  398192
  400703
  402202
  402240
  402876
  404353
  404731
  408194
  410233
  411081
  412593
  413637
  414893
  415151
  415239
  415880
  416607
  418817
  419459
  419627
  420147
  421051
  423382
  425144
  425868
  425946
  426018
  430300
  433217
  444502
  445192
  445365
  448013
  449022
  451831
  452046
  452205
  454006
  454055
  454384
  454753
  455124
  456931
  458772
  460754
  465600
  468186
  469119
  471721
  471961
  473184
  477695
  477913
  480389
  483038
  485187
  485207
  486783
  488746
  489653
  490456
  497934
  498454
  498474
  498555
  500736
  501557
  503183
  503310
  503491
  504980
  511466
  512938
  512941
  513860
  514311
  514393
  515546
  517788
  518995
  520136
  524594
  524849
  525159
  528544
  528572
  528773
  531707
  537922
  543858
  544665
  547944
  560408
  566022
  569742
  574381
  574721
  581969
  582480
  592770
  597892
  601088
  680472
  706611
  725047
  740597
  757157
  769990
  795538
  817158
]
2.06 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde big toys"
]
1.81 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая большие toys"
]
1.77 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая большие toys"
]

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.