Query Metrics
7
Database Queries
7
Different statements
194.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.05 ms (85.58%) |
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 416252 432310 439910 443779 448074 453511 453689 455507 455771 458022 460361 460958 462155 462330 463061 464528 464699 465356 469876 469919 469920 470343 470944 473608 474495 477354 477363 478557 482120 482674 483037 484392 484568 484609 484655 484659 484719 486339 492040 494161 495051 495740 495744 497240 497936 498194 498269 500596 500901 502477 502484 503304 503314 503965 504158 506050 506821 509842 510427 510750 514455 515361 516635 520132 522999 523301 524408 526568 527031 542539 542745 542748 542765 542791 543960 544040 545377 546724 549799 550484 556001 557942 557943 557945 557949 557983 559575 559771 560454 562815 567382 568193 571775 577120 590693 590860 590885 591908 594487 598207 598786 598918 599197 601364 603636 603863 606567 606794 608772 618017 625556 666530 679821 682389 691409 693338 718698 738440 751589 755176 ] |
||||||||||||||||||||||||||||||
|
17.78 ms (9.16%) |
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 557942 559771 542539 542748 542765 542791 543960 544040 545377 557949 557983 560454 542745 546724 550484 557943 557945 559575 562815 568193 571775 577120 679821 666530 682389 691409 693338 718698 567382 598786 603863 606794 590693 594487 598207 598918 599197 601364 603636 590860 590885 591908 738440 751589 755176 416252 439910 448074 453511 455771 463061 464699 432310 460361 460958 462155 462330 464528 477363 453689 455507 465356 469876 470343 473608 474495 482120 469919 469920 477354 478557 458022 503304 510427 510750 515361 527031 484719 492040 495051 495740 498269 502477 503965 506050 506821 509842 516635 522999 523301 526568 483037 484609 484655 494161 495744 497240 500596 500901 504158 524408 484392 484568 484659 486339 497936 498194 502484 503314 514455 482674 520132 556001 549799 606567 608772 618017 625556 443779 470944 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.40%) |
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 416252 432310 439910 443779 448074 453511 453689 455507 455771 458022 460361 460958 462155 462330 463061 464528 464699 465356 469876 469919 469920 470343 470944 473608 474495 477354 477363 478557 482120 482674 483037 484392 484568 484609 484655 484659 484719 486339 492040 494161 495051 495740 495744 497240 497936 498194 498269 500596 500901 502477 502484 503304 503314 503965 504158 506050 506821 509842 510427 510750 514455 515361 516635 520132 522999 523301 524408 526568 527031 542539 542745 542748 542765 542791 543960 544040 545377 546724 549799 550484 556001 557942 557943 557945 557949 557983 559575 559771 560454 562815 567382 568193 571775 577120 590693 590860 590885 591908 594487 598207 598786 598918 599197 601364 603636 603863 606567 606794 608772 618017 625556 666530 679821 682389 691409 693338 718698 738440 751589 755176 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian swinger"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск свингер"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.80%) |
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.