GET https://search.jues.net/search/embeds/8?q=russian%20wife%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.86 ms
(80.05%)
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
  402969
  418884
  418915
  420010
  421374
  421660
  424153
  434908
  437959
  438020
  443387
  444615
  451137
  455514
  455839
  456267
  456648
  456969
  459069
  461956
  462570
  464525
  464530
  466373
  467804
  469638
  469715
  470500
  472804
  472807
  474193
  475369
  476016
  476535
  476884
  477351
  477665
  478022
  478319
  478518
  479064
  479364
  479549
  480650
  480682
  481318
  483601
  483876
  484246
  486992
  487847
  487865
  488441
  488539
  488541
  489087
  490012
  490279
  492355
  494461
  494584
  496882
  498206
  500989
  506208
  506704
  513708
  516163
  517377
  518899
  520200
  525892
  534111
  537393
  540691
  543943
  544512
  544614
  551876
  552368
  552803
  552820
  554222
  555983
  555996
  556001
  559258
  559445
  559623
  560911
  562359
  565000
  565622
  568719
  578877
  588710
  602037
  605973
  609759
  627667
  646748
  669907
  695366
  707956
  712567
  730670
  731376
  736153
  741044
  744418
  749620
  758313
  759369
  769469
  775297
  778200
  778521
  790256
  804882
  805150
]
19.15 ms
(12.68%)
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
  540691
  534111
  537393
  543943
  552803
  695366
  707956
  712567
  605973
  778200
  741044
  805150
  736153
  744418
  758313
  769469
  749620
  778521
  804882
  464525
  494584
  479064
  525892
  518899
  489087
  759369
  451137
  483601
  476884
  555996
  588710
  420010
  459069
  466373
  480650
  421660
  438020
  456267
  478022
  513708
  469715
  444615
  487847
  483876
  421374
  456969
  469638
  472807
  461956
  472804
  476535
  516163
  479364
  669907
  609759
  486992
  480682
  552820
  627667
  418884
  402969
  478518
  492355
  517377
  552368
  602037
  496882
  484246
  556001
  578877
  424153
  488539
  560911
  456648
  478319
  490279
  488541
  555983
  437959
  455514
  476016
  481318
  477351
  730670
  490012
  475369
  494461
  464530
  565000
  731376
  443387
  554222
  520200
  470500
  568719
  544614
  488441
  418915
  551876
  559258
  559445
  474193
  434908
  455839
  477665
  479549
  462570
  467804
  500989
  506208
  506704
  487865
  498206
  562359
  544512
  559623
  646748
  565622
  790256
  775297
]
2.74 ms
(1.81%)
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
  402969
  418884
  418915
  420010
  421374
  421660
  424153
  434908
  437959
  438020
  443387
  444615
  451137
  455514
  455839
  456267
  456648
  456969
  459069
  461956
  462570
  464525
  464530
  466373
  467804
  469638
  469715
  470500
  472804
  472807
  474193
  475369
  476016
  476535
  476884
  477351
  477665
  478022
  478319
  478518
  479064
  479364
  479549
  480650
  480682
  481318
  483601
  483876
  484246
  486992
  487847
  487865
  488441
  488539
  488541
  489087
  490012
  490279
  492355
  494461
  494584
  496882
  498206
  500989
  506208
  506704
  513708
  516163
  517377
  518899
  520200
  525892
  534111
  537393
  540691
  543943
  544512
  544614
  551876
  552368
  552803
  552820
  554222
  555983
  555996
  556001
  559258
  559445
  559623
  560911
  562359
  565000
  565622
  568719
  578877
  588710
  602037
  605973
  609759
  627667
  646748
  669907
  695366
  707956
  712567
  730670
  731376
  736153
  741044
  744418
  749620
  758313
  759369
  769469
  775297
  778200
  778521
  790256
  804882
  805150
]
2.25 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian wife public"
]
2.25 ms
(1.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.11 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск жен на улиц"
]
1.62 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.