Query Metrics
7
Database Queries
7
Different statements
213.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.16 ms (87.28%) |
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 187223 188009 387027 390865 391925 391961 395883 397392 401978 403893 411908 412852 413826 414253 414771 416415 416454 416989 420999 428456 429292 441251 441295 441556 446240 446272 447070 449546 452847 454514 458252 458274 459579 461367 463290 464636 470417 473038 475058 482563 482609 484681 507357 509147 514270 516197 519646 521747 524273 528320 528548 529602 537026 537845 539770 542467 545531 545533 545773 550644 550679 552282 561100 565256 571393 586429 596537 598505 601774 605244 606558 608358 610686 624504 627798 628087 641534 643226 647960 657489 662457 663916 664524 665190 665250 669784 671726 677397 696316 699487 699766 700462 713122 714470 714479 726516 729905 739178 745363 747094 750189 752359 762303 769405 773318 781019 782244 785859 788039 792749 800571 805399 806584 810744 814070 814181 818733 823196 824347 824427 ] |
||||||||||||||||||||||||||||||
|
15.66 ms (7.34%) |
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 441251 441556 824347 482609 458252 447070 458274 461367 524273 514270 537845 509147 539770 507357 521747 464636 545533 550644 552282 542467 545531 571393 665190 677397 699487 714470 714479 664524 665250 669784 713122 657489 662457 663916 696316 606558 627798 596537 601774 643226 605244 641534 800571 782244 806584 810744 726516 745363 762303 773318 785859 729905 739178 752359 747094 750189 769405 700462 781019 792749 805399 391925 397392 416454 411908 391961 454514 459579 475058 390865 395883 470417 463290 537026 528548 519646 516197 420999 414771 416415 416989 429292 565256 561100 647960 671726 545773 550679 586429 628087 610686 624504 608358 699766 413826 484681 387027 788039 446272 598505 187223 188009 401978 403893 412852 428456 441295 414253 818733 814070 823196 814181 824427 482563 449546 446240 452847 473038 528320 529602 ] |
||||||||||||||||||||||||||||||
|
4.06 ms (1.90%) |
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 187223 188009 387027 390865 391925 391961 395883 397392 401978 403893 411908 412852 413826 414253 414771 416415 416454 416989 420999 428456 429292 441251 441295 441556 446240 446272 447070 449546 452847 454514 458252 458274 459579 461367 463290 464636 470417 473038 475058 482563 482609 484681 507357 509147 514270 516197 519646 521747 524273 528320 528548 529602 537026 537845 539770 542467 545531 545533 545773 550644 550679 552282 561100 565256 571393 586429 596537 598505 601774 605244 606558 608358 610686 624504 627798 628087 641534 643226 647960 657489 662457 663916 664524 665190 665250 669784 671726 677397 696316 699487 699766 700462 713122 714470 714479 726516 729905 739178 745363 747094 750189 752359 762303 769405 773318 781019 782244 785859 788039 792749 800571 805399 806584 810744 814070 814181 818733 823196 824347 824427 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.82%) |
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.