Query Metrics
7
Database Queries
7
Different statements
219.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
194.61 ms (88.65%) |
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 81651 97231 226028 286252 343398 382437 385048 385436 388569 391204 395548 396087 397364 397530 400209 401180 403100 406954 409200 411858 412081 412261 413000 416098 417132 417631 419012 419176 420270 424321 424325 424846 425802 425980 428477 430241 431350 431361 431376 433656 437818 437843 442999 443704 443790 443822 445934 447373 448672 449170 453691 454364 454709 455126 456393 462485 465549 467572 469017 470667 471008 471628 473735 474029 474147 479100 479820 482304 484432 484465 484648 485591 485702 487383 488897 489280 492098 496540 499498 501338 504189 505048 514815 517081 520134 520440 523335 523803 524943 526954 527030 538205 555681 570532 571609 583819 593253 601063 612868 616745 621317 628707 635788 663884 665296 665465 667514 693990 719350 722860 722861 726589 761393 769924 790015 790413 808946 810770 813913 816755 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (6.93%) |
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 571609 693990 810770 722860 391204 401180 382437 442999 813913 447373 455126 523803 790015 474029 479100 430241 471008 538205 527030 621317 474147 489280 395548 424846 411858 419012 517081 570532 665296 722861 769924 808946 470667 385436 403100 409200 471628 523335 448672 396087 343398 526954 616745 761393 487383 397364 482304 462485 286252 419176 816755 663884 665465 667514 593253 790413 388569 417132 453691 433656 488897 412261 425980 612868 406954 504189 505048 484432 456393 437843 397530 454709 400209 413000 424321 467572 726589 473735 424325 416098 524943 499498 484648 492098 443822 469017 445934 420270 443790 485702 437818 454364 555681 601063 412081 485591 514815 520440 81651 97231 635788 417631 428477 583819 425802 431376 484465 628707 496540 719350 520134 431361 465549 443704 431350 449170 479820 501338 385048 226028 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.27%) |
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 81651 97231 226028 286252 343398 382437 385048 385436 388569 391204 395548 396087 397364 397530 400209 401180 403100 406954 409200 411858 412081 412261 413000 416098 417132 417631 419012 419176 420270 424321 424325 424846 425802 425980 428477 430241 431350 431361 431376 433656 437818 437843 442999 443704 443790 443822 445934 447373 448672 449170 453691 454364 454709 455126 456393 462485 465549 467572 469017 470667 471008 471628 473735 474029 474147 479100 479820 482304 484432 484465 484648 485591 485702 487383 488897 489280 492098 496540 499498 501338 504189 505048 514815 517081 520134 520440 523335 523803 524943 526954 527030 538205 555681 570532 571609 583819 593253 601063 612868 616745 621317 628707 635788 663884 665296 665465 667514 693990 719350 722860 722861 726589 761393 769924 790015 790413 808946 810770 813913 816755 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy threesome"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.64%) |
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.