Query Metrics
7
Database Queries
7
Different statements
188.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.41 ms (87.62%) |
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 384790 390242 401070 406363 407374 421598 427359 432955 435688 437352 444625 445993 449232 449628 452990 453957 458056 458082 459783 462237 463145 464015 467147 467207 472411 474954 479241 479298 483416 487408 489797 489933 493844 496120 499389 499469 503758 505615 505959 506403 507537 510465 511224 511227 512237 512593 528826 535987 542923 547618 551144 556597 558015 559702 562876 565014 570955 574675 580383 583549 585818 586784 589337 599146 601378 602554 603650 609268 620984 625624 635992 637419 637559 647984 649622 661350 673260 673704 677222 687527 692718 693675 697161 700375 703496 703603 705800 710588 719693 720843 727696 729090 729264 737916 740101 744296 744444 753686 757953 759704 763358 764141 767384 769160 770644 772959 776493 777223 777914 779119 781743 785603 789693 790812 798189 806469 809354 812844 821045 825481 ] |
||||||||||||||||||||||||||||||
|
14.30 ms (7.58%) |
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 602554 798189 729090 779119 467147 511227 535987 661350 693675 697161 703603 781743 812844 767384 759704 737916 449628 649622 687527 384790 499389 586784 401070 407374 583549 703496 603650 458056 499469 556597 547618 692718 601378 777223 809354 770644 435688 432955 421598 821045 825481 505615 551144 580383 710588 719693 625624 637559 599146 637419 589337 609268 777914 790812 729264 727696 753686 763358 764141 463145 406363 427359 453957 472411 510465 483416 512593 452990 449232 505959 542923 562876 673260 677222 647984 776493 479241 462237 489797 496120 474954 489933 565014 785603 757953 445993 437352 464015 458082 506403 503758 559702 705800 673704 700375 585818 620984 806469 789693 769160 744444 744296 511224 487408 507537 493844 512237 528826 444625 467207 574675 558015 570955 772959 740101 635992 720843 390242 459783 479298 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.76%) |
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 384790 390242 401070 406363 407374 421598 427359 432955 435688 437352 444625 445993 449232 449628 452990 453957 458056 458082 459783 462237 463145 464015 467147 467207 472411 474954 479241 479298 483416 487408 489797 489933 493844 496120 499389 499469 503758 505615 505959 506403 507537 510465 511224 511227 512237 512593 528826 535987 542923 547618 551144 556597 558015 559702 562876 565014 570955 574675 580383 583549 585818 586784 589337 599146 601378 602554 603650 609268 620984 625624 635992 637419 637559 647984 649622 661350 673260 673704 677222 687527 692718 693675 697161 700375 703496 703603 705800 710588 719693 720843 727696 729090 729264 737916 740101 744296 744444 753686 757953 759704 763358 764141 767384 769160 770644 772959 776493 777223 777914 779119 781743 785603 789693 790812 798189 806469 809354 812844 821045 825481 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex for help"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс help"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс help"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.64%) |
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.