GET https://search.jues.net/search/embeds/7?q=solo%20teen%20toys

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.69 ms
(88.12%)
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
  154491
  382205
  386497
  397478
  402648
  408880
  414253
  415921
  419633
  420277
  420874
  427539
  427714
  428742
  428924
  429566
  430366
  431234
  432927
  437708
  439146
  443248
  444540
  444922
  445810
  447318
  447734
  451082
  452595
  452792
  452807
  452850
  452873
  452875
  452903
  452914
  452915
  452923
  453160
  453170
  453223
  455084
  456700
  457486
  459851
  462223
  466842
  467110
  469221
  469741
  473038
  473087
  477169
  477411
  478998
  481861
  482731
  487425
  493744
  497690
  498619
  499936
  500327
  500779
  502770
  505370
  510781
  512674
  514941
  522288
  522639
  523896
  525970
  530956
  532381
  535916
  536377
  536474
  538725
  541277
  541328
  548954
  549549
  550919
  553441
  557343
  559294
  560054
  561189
  562585
  568302
  568303
  572777
  575610
  576321
  576979
  579381
  583472
  594208
  652249
  655458
  660441
  664236
  669668
  674204
  679194
  686821
  691808
  696594
  712433
  713185
  783745
  784744
  785851
  813809
  814411
  814418
  814470
  814519
  819862
]
16.94 ms
(7.29%)
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
  783745
  784744
  785851
  382205
  397478
  443248
  477411
  386497
  459851
  437708
  452792
  473087
  431234
  500779
  505370
  420277
  432927
  445810
  447318
  497690
  469221
  594208
  428924
  452923
  430366
  452875
  522288
  154491
  402648
  415921
  420874
  428742
  408880
  427714
  439146
  444540
  414253
  427539
  444922
  419633
  429566
  814418
  813809
  814519
  819862
  814411
  814470
  452595
  452914
  452915
  453223
  455084
  457486
  469741
  447734
  451082
  452873
  452903
  453160
  456700
  466842
  467110
  481861
  452807
  452850
  453170
  462223
  473038
  478998
  482731
  493744
  498619
  510781
  512674
  525970
  532381
  536474
  499936
  500327
  502770
  535916
  536377
  538725
  514941
  522639
  523896
  530956
  477169
  487425
  541277
  548954
  553441
  557343
  560054
  568303
  575610
  579381
  583472
  541328
  549549
  550919
  559294
  562585
  572777
  576979
  561189
  568302
  576321
  655458
  664236
  669668
  674204
  679194
  712433
  713185
  652249
  660441
  686821
  691808
  696594
]
3.39 ms
(1.46%)
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
  154491
  382205
  386497
  397478
  402648
  408880
  414253
  415921
  419633
  420277
  420874
  427539
  427714
  428742
  428924
  429566
  430366
  431234
  432927
  437708
  439146
  443248
  444540
  444922
  445810
  447318
  447734
  451082
  452595
  452792
  452807
  452850
  452873
  452875
  452903
  452914
  452915
  452923
  453160
  453170
  453223
  455084
  456700
  457486
  459851
  462223
  466842
  467110
  469221
  469741
  473038
  473087
  477169
  477411
  478998
  481861
  482731
  487425
  493744
  497690
  498619
  499936
  500327
  500779
  502770
  505370
  510781
  512674
  514941
  522288
  522639
  523896
  525970
  530956
  532381
  535916
  536377
  536474
  538725
  541277
  541328
  548954
  549549
  550919
  553441
  557343
  559294
  560054
  561189
  562585
  568302
  568303
  572777
  575610
  576321
  576979
  579381
  583472
  594208
  652249
  655458
  660441
  664236
  669668
  674204
  679194
  686821
  691808
  696594
  712433
  713185
  783745
  784744
  785851
  813809
  814411
  814418
  814470
  814519
  819862
]
2.15 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло teen toys"
]
1.66 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло teen toys"
]
1.48 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo teen 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.