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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.01 ms
(55.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло туалет мам женщин"
]
137.15 ms
(36.45%)
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
  30791
  62251
  88591
  131602
  145218
  382113
  388425
  390754
  397173
  414430
  418566
  420774
  422406
  446936
  452816
  454290
  455640
  460335
  463509
  463804
  464064
  465482
  465583
  466402
  467096
  473471
  475289
  477429
  478520
  478985
  493229
  493342
  495879
  497813
  501476
  505387
  509019
  513990
  520148
  523596
  528536
  529661
  534975
  535985
  536298
  537785
  540129
  540568
  546316
  548515
  559358
  560409
  560678
  560699
  560912
  567470
  568211
  569558
  582765
  583519
  586975
  590410
  592219
  596796
  604121
  605973
  608047
  618329
  618619
  628358
  628655
  632289
  632750
  634584
  649440
  651158
  659015
  660818
  663286
  664477
  666116
  667738
  678758
  689042
  710379
  726133
  727976
  738564
  742318
  750371
  750387
  751185
  751609
  752759
  752944
  761269
  767718
  774728
  776544
  781934
  790109
  794669
  797345
  797369
  801794
  802196
  803529
  804265
  804829
  805142
  806984
  808335
  812284
  812318
  812542
  812751
  823771
  823774
  824112
  826720
]
20.02 ms
(5.32%)
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
  752759
  632289
  804265
  390754
  397173
  823774
  823771
  824112
  520148
  529661
  537785
  497813
  534975
  540129
  560678
  548515
  567470
  568211
  651158
  664477
  666116
  659015
  660818
  667738
  678758
  560912
  583519
  604121
  634584
  628358
  592219
  781934
  801794
  803529
  750371
  761269
  790109
  812284
  812318
  726133
  767718
  751185
  727976
  420774
  618619
  590410
  382113
  30791
  414430
  477429
  464064
  454290
  528536
  559358
  649440
  569558
  628655
  632750
  804829
  802196
  750387
  463804
  478520
  465583
  493342
  752944
  776544
  505387
  605973
  710379
  523596
  62251
  455640
  465482
  467096
  495879
  513990
  463509
  475289
  546316
  586975
  596796
  812542
  794669
  812751
  742318
  751609
  418566
  466402
  509019
  478985
  422406
  826720
  535985
  536298
  540568
  582765
  618329
  608047
  774728
  806984
  808335
  797369
  805142
  473471
  88591
  452816
  460335
  560409
  493229
  689042
  663286
  560699
  797345
  738564
  446936
  501476
  145218
  131602
  388425
]
3.55 ms
(0.94%)
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
  30791
  62251
  88591
  131602
  145218
  382113
  388425
  390754
  397173
  414430
  418566
  420774
  422406
  446936
  452816
  454290
  455640
  460335
  463509
  463804
  464064
  465482
  465583
  466402
  467096
  473471
  475289
  477429
  478520
  478985
  493229
  493342
  495879
  497813
  501476
  505387
  509019
  513990
  520148
  523596
  528536
  529661
  534975
  535985
  536298
  537785
  540129
  540568
  546316
  548515
  559358
  560409
  560678
  560699
  560912
  567470
  568211
  569558
  582765
  583519
  586975
  590410
  592219
  596796
  604121
  605973
  608047
  618329
  618619
  628358
  628655
  632289
  632750
  634584
  649440
  651158
  659015
  660818
  663286
  664477
  666116
  667738
  678758
  689042
  710379
  726133
  727976
  738564
  742318
  750371
  750387
  751185
  751609
  752759
  752944
  761269
  767718
  774728
  776544
  781934
  790109
  794669
  797345
  797369
  801794
  802196
  803529
  804265
  804829
  805142
  806984
  808335
  812284
  812318
  812542
  812751
  823771
  823774
  824112
  826720
]
2.13 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло туалет мам женщин"
]
1.92 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo toilet mother"
]
1.50 ms
(0.40%)
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.