GET https://search.jues.net/search/embeds/8?q=beautiful%20mother

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.91 ms
(84.31%)
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
  28568
  172662
  229207
  382460
  395844
  398348
  400550
  400850
  401114
  401902
  402973
  403312
  404972
  406210
  409088
  412222
  413183
  413223
  418069
  419598
  420044
  421263
  425564
  428831
  430264
  430777
  430896
  445767
  447740
  452256
  453499
  453515
  455281
  456980
  466446
  478740
  485366
  485912
  489328
  490744
  494068
  497478
  505781
  508940
  509598
  510774
  514268
  518218
  519179
  519717
  522614
  523245
  524291
  524482
  524755
  526060
  531550
  533717
  534018
  534020
  534023
  535488
  538107
  541293
  541416
  545300
  545329
  545828
  548517
  549356
  549568
  549996
  552619
  557527
  559439
  561492
  562126
  562398
  562791
  563513
  570730
  570796
  573501
  591628
  592490
  593009
  593382
  598373
  598550
  599951
  600027
  604627
  607601
  610104
  611330
  612867
  621322
  639253
  649859
  673767
  683313
  684064
  687116
  702268
  707551
  726282
  754668
  756388
  756494
  762671
  780810
  788119
  789469
  790028
  794767
  798731
  798787
  800509
  810354
  823929
]
18.43 ms
(9.84%)
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
  570730
  561492
  494068
  538107
  562126
  756388
  466446
  591628
  610104
  445767
  403312
  510774
  533717
  570796
  598373
  598550
  600027
  621322
  430896
  430264
  519717
  447740
  524482
  541416
  562398
  593382
  409088
  534020
  534023
  534018
  548517
  549356
  549996
  684064
  687116
  683313
  557527
  612867
  607601
  509598
  418069
  453515
  497478
  485366
  400850
  425564
  823929
  531550
  490744
  524291
  428831
  401902
  611330
  526060
  456980
  514268
  455281
  549568
  430777
  593009
  505781
  452256
  519179
  559439
  421263
  453499
  523245
  541293
  535488
  545329
  639253
  489328
  604627
  573501
  552619
  545300
  545828
  599951
  563513
  412222
  508940
  780810
  420044
  702268
  794767
  789469
  413223
  28568
  798731
  798787
  800509
  398348
  382460
  413183
  478740
  522614
  592490
  401114
  726282
  524755
  419598
  172662
  402973
  707551
  810354
  788119
  754668
  649859
  756494
  790028
  485912
  395844
  562791
  762671
  400550
  404972
  518218
  229207
  406210
  673767
]
2.87 ms
(1.53%)
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
  28568
  172662
  229207
  382460
  395844
  398348
  400550
  400850
  401114
  401902
  402973
  403312
  404972
  406210
  409088
  412222
  413183
  413223
  418069
  419598
  420044
  421263
  425564
  428831
  430264
  430777
  430896
  445767
  447740
  452256
  453499
  453515
  455281
  456980
  466446
  478740
  485366
  485912
  489328
  490744
  494068
  497478
  505781
  508940
  509598
  510774
  514268
  518218
  519179
  519717
  522614
  523245
  524291
  524482
  524755
  526060
  531550
  533717
  534018
  534020
  534023
  535488
  538107
  541293
  541416
  545300
  545329
  545828
  548517
  549356
  549568
  549996
  552619
  557527
  559439
  561492
  562126
  562398
  562791
  563513
  570730
  570796
  573501
  591628
  592490
  593009
  593382
  598373
  598550
  599951
  600027
  604627
  607601
  610104
  611330
  612867
  621322
  639253
  649859
  673767
  683313
  684064
  687116
  702268
  707551
  726282
  754668
  756388
  756494
  762671
  780810
  788119
  789469
  790028
  794767
  798731
  798787
  800509
  810354
  823929
]
2.32 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.29 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful mother"
]
1.81 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая мам женщин"
]
1.67 ms
(0.89%)
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.