GET https://search.jues.net/search/embeds/3?q=solo%20tights

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.89 ms
(82.89%)
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
  113794
  381993
  385008
  398073
  398500
  406346
  409251
  410847
  412855
  418132
  419616
  421290
  423765
  423905
  435598
  435620
  438865
  442803
  453011
  460354
  460356
  464967
  465137
  468240
  468297
  469450
  472621
  472812
  472944
  475288
  475643
  480555
  480557
  480951
  493908
  496020
  496846
  498648
  510331
  513202
  514233
  522646
  524030
  534393
  534475
  535962
  536100
  537162
  540033
  545504
  547790
  548634
  551598
  552112
  552382
  555063
  556201
  568894
  572917
  575376
  578328
  580121
  582032
  587494
  588339
  588973
  591420
  596657
  603739
  605244
  616989
  618808
  642895
  651700
  662833
  663193
  703944
  707466
  708505
  711709
  713369
  714395
  731456
  739156
  739814
  739908
  739960
  740908
  741011
  741857
  742549
  756480
  757514
  760598
  772230
  776032
  777761
  778858
  781404
  781455
  785584
  785974
  788485
  788778
  791036
  791914
  795731
  799058
  799630
  801643
  808037
  810461
  810532
  811060
  811103
  811110
  813926
  814206
  814363
]
17.87 ms
(9.38%)
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
  741857
  739908
  711709
  799058
  799630
  811060
  113794
  381993
  406346
  493908
  524030
  548634
  469450
  514233
  547790
  580121
  791914
  385008
  423905
  435598
  813926
  814363
  535962
  545504
  568894
  708505
  713369
  663193
  623097
  778858
  781455
  810532
  788778
  739814
  760598
  785584
  739960
  772230
  777761
  785974
  472812
  472944
  419616
  480557
  465137
  475643
  537162
  551598
  423765
  435620
  418132
  814206
  472621
  536100
  496020
  496846
  534475
  475288
  552112
  572917
  555063
  578328
  703944
  714395
  662833
  588973
  616989
  618808
  591420
  788485
  810461
  776032
  731456
  757514
  739156
  756480
  791036
  801643
  808037
  811103
  453011
  460356
  398073
  460354
  498648
  513202
  522646
  534393
  412855
  781404
  398500
  421290
  409251
  410847
  468297
  464967
  480555
  540033
  468240
  552382
  582032
  575376
  556201
  651700
  707466
  642895
  596657
  587494
  588339
  605244
  740908
  741011
  795731
  742549
  603739
  811110
  480951
  438865
  442803
  510331
]
6.03 ms
(3.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo tights"
]
3.50 ms
(1.84%)
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
  113794
  381993
  385008
  398073
  398500
  406346
  409251
  410847
  412855
  418132
  419616
  421290
  423765
  423905
  435598
  435620
  438865
  442803
  453011
  460354
  460356
  464967
  465137
  468240
  468297
  469450
  472621
  472812
  472944
  475288
  475643
  480555
  480557
  480951
  493908
  496020
  496846
  498648
  510331
  513202
  514233
  522646
  524030
  534393
  534475
  535962
  536100
  537162
  540033
  545504
  547790
  548634
  551598
  552112
  552382
  555063
  556201
  568894
  572917
  575376
  578328
  580121
  582032
  587494
  588339
  588973
  591420
  596657
  603739
  605244
  616989
  618808
  642895
  651700
  662833
  663193
  703944
  707466
  708505
  711709
  713369
  714395
  731456
  739156
  739814
  739908
  739960
  740908
  741011
  741857
  742549
  756480
  757514
  760598
  772230
  776032
  777761
  778858
  781404
  781455
  785584
  785974
  788485
  788778
  791036
  791914
  795731
  799058
  799630
  801643
  808037
  810461
  810532
  811060
  811103
  811110
  813926
  814206
  814363
]
1.78 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло колготк"
]
1.73 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло колготк"
]
1.68 ms
(0.88%)
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.