Query Metrics
7
Database Queries
7
Different statements
160.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.23 ms (83.72%) |
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 73052 352142 375092 391976 397567 398869 401817 402739 405950 411382 416751 417366 418201 418321 419648 420226 428848 429106 432703 436965 440068 442035 444271 445099 446519 446785 446798 449001 449421 453154 456866 458109 461246 461641 464019 464911 465250 466981 468661 469188 469428 470493 471029 473432 478069 478523 478726 479706 479708 484880 485846 486640 489337 495480 496095 496120 497641 499252 499269 499941 503673 510685 512496 514244 515307 515451 517349 518671 520566 522283 523614 530436 545616 547546 550747 555560 556901 560673 568261 571401 576614 579381 582529 583558 584886 589243 590552 590553 599145 612068 618364 618799 624174 663306 692750 697460 703915 704039 712153 740556 742727 776716 777019 777279 782844 785073 785602 787502 788521 796794 797280 800707 800930 803835 806861 806887 808562 809967 810635 817226 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (9.63%) |
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 612068 703915 442035 436965 449421 560673 582529 663306 568261 808562 479708 471029 456866 583558 391976 712153 499252 589243 599145 470493 417366 787502 806861 518671 545616 411382 800930 796794 446785 419648 405950 496095 579381 704039 517349 478069 499941 464019 555560 576614 469188 461641 478726 515451 571401 497641 418321 418201 484880 499269 522283 479706 458109 464911 556901 785073 788521 800707 810635 428848 469428 523614 512496 397567 461246 446798 777279 740556 785602 520566 515307 692750 624174 618799 590553 590552 468661 503673 73052 817226 465250 446519 510685 485846 782844 803835 432703 478523 495480 809967 401817 398869 584886 416751 402739 466981 352142 486640 514244 806887 440068 473432 489337 453154 530436 777019 797280 697460 776716 449001 445099 429106 444271 375092 420226 550747 742727 547546 618364 496120 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.77%) |
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 73052 352142 375092 391976 397567 398869 401817 402739 405950 411382 416751 417366 418201 418321 419648 420226 428848 429106 432703 436965 440068 442035 444271 445099 446519 446785 446798 449001 449421 453154 456866 458109 461246 461641 464019 464911 465250 466981 468661 469188 469428 470493 471029 473432 478069 478523 478726 479706 479708 484880 485846 486640 489337 495480 496095 496120 497641 499252 499269 499941 503673 510685 512496 514244 515307 515451 517349 518671 520566 522283 523614 530436 545616 547546 550747 555560 556901 560673 568261 571401 576614 579381 582529 583558 584886 589243 590552 590553 599145 612068 618364 618799 624174 663306 692750 697460 703915 704039 712153 740556 742727 776716 777019 777279 782844 785073 785602 787502 788521 796794 797280 800707 800930 803835 806861 806887 808562 809967 810635 817226 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс игрушк домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс игрушка домашнее…"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.