GET https://search.jues.net/search/embeds/7?q=mother%20bbc

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.13 ms
(81.93%)
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
  79355
  320525
  382460
  382591
  387160
  387524
  387860
  388774
  396580
  399247
  400739
  401115
  401666
  415003
  415506
  417085
  418363
  421740
  430283
  435475
  463840
  464214
  464349
  467120
  468467
  468556
  475283
  477070
  480779
  481668
  482727
  489953
  498484
  520202
  529701
  530486
  530487
  531298
  531556
  533007
  536980
  537502
  537654
  537941
  540405
  540785
  541202
  543852
  543882
  545220
  545835
  545857
  550063
  554522
  557269
  558434
  565507
  566300
  582806
  585540
  591893
  596899
  600296
  601527
  601834
  601930
  603600
  604537
  604569
  604570
  604934
  607018
  610717
  614993
  615961
  622679
  631162
  631194
  634528
  636598
  641481
  641914
  646435
  653392
  653728
  673767
  678053
  715283
  716288
  717150
  720120
  722541
  723582
  725615
  727577
  733193
  733560
  740641
  741305
  745452
  746837
  750042
  750275
  755391
  756394
  780601
  783371
  785657
  793757
  797636
  800296
  804459
  804763
  805739
  815837
  816838
  817127
  817318
  817786
  820780
]
15.20 ms
(10.45%)
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
  725615
  780601
  817318
  755391
  756394
  387524
  430283
  435475
  817127
  723582
  820780
  480779
  520202
  498484
  558434
  565507
  543882
  646435
  722541
  582806
  591893
  610717
  641481
  797636
  805739
  733193
  741305
  720120
  785657
  475283
  481668
  604570
  464214
  415506
  463840
  550063
  793757
  604537
  400739
  816838
  566300
  745452
  717150
  540785
  482727
  530486
  537654
  530487
  540405
  543852
  541202
  464349
  537502
  396580
  545857
  545835
  653392
  653728
  603600
  604934
  607018
  601527
  585540
  783371
  750042
  733560
  804459
  804763
  387860
  399247
  533007
  678053
  600296
  631162
  615961
  614993
  631194
  604569
  418363
  468467
  388774
  417085
  468556
  415003
  815837
  467120
  531298
  536980
  537941
  545220
  557269
  715283
  716288
  554522
  746837
  740641
  727577
  750275
  622679
  636598
  601834
  817786
  529701
  673767
  596899
  601930
  641914
  800296
  634528
  387160
  401115
  320525
  382460
  382591
  489953
  531556
  79355
  401666
  421740
  477070
]
3.02 ms
(2.07%)
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
  79355
  320525
  382460
  382591
  387160
  387524
  387860
  388774
  396580
  399247
  400739
  401115
  401666
  415003
  415506
  417085
  418363
  421740
  430283
  435475
  463840
  464214
  464349
  467120
  468467
  468556
  475283
  477070
  480779
  481668
  482727
  489953
  498484
  520202
  529701
  530486
  530487
  531298
  531556
  533007
  536980
  537502
  537654
  537941
  540405
  540785
  541202
  543852
  543882
  545220
  545835
  545857
  550063
  554522
  557269
  558434
  565507
  566300
  582806
  585540
  591893
  596899
  600296
  601527
  601834
  601930
  603600
  604537
  604569
  604570
  604934
  607018
  610717
  614993
  615961
  622679
  631162
  631194
  634528
  636598
  641481
  641914
  646435
  653392
  653728
  673767
  678053
  715283
  716288
  717150
  720120
  722541
  723582
  725615
  727577
  733193
  733560
  740641
  741305
  745452
  746837
  750042
  750275
  755391
  756394
  780601
  783371
  785657
  793757
  797636
  800296
  804459
  804763
  805739
  815837
  816838
  817127
  817318
  817786
  820780
]
2.32 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother bbc"
]
1.94 ms
(1.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин bbc"
]
1.89 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин bbc"
]

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.