Query Metrics
7
Database Queries
7
Different statements
189.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.42 ms (85.20%) |
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 2291 111756 276696 358398 385062 388979 390051 391287 391437 391588 392957 396902 406616 413307 428317 428874 439292 439576 458830 460261 465397 465535 465793 465860 466258 468886 470770 471413 481254 482877 483394 488543 490917 495156 496325 498702 500977 503094 504774 507140 507225 514697 522638 522923 529465 529804 531320 535102 539461 545630 550493 551875 557311 568221 577602 578040 581231 584376 587226 590625 595329 595985 601380 603056 603299 606615 608352 611560 663390 664804 665359 665932 667581 667863 669672 670557 682534 689697 693901 705461 705549 710202 710540 717215 719910 721432 729576 729587 729625 739060 740136 744922 746032 750461 756869 767735 770061 770192 778308 781663 781668 781685 782225 785298 786455 790640 794684 795158 801760 803263 809867 810069 816243 817480 817701 817705 817929 818907 824938 828006 ] |
||||||||||||||||||||||||||||||
|
16.49 ms (8.71%) |
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 782225 781668 756869 465860 665359 781663 392957 496325 483394 507225 358398 568221 577602 663390 670557 584376 590625 603299 803263 729625 740136 785298 801760 767735 744922 729576 778308 385062 390051 471413 406616 488543 439292 710202 705549 581231 603056 587226 606615 810069 770192 750461 786455 2291 465397 470770 466258 498702 490917 522923 111756 396902 818907 816243 817701 828006 539461 535102 529804 507140 557311 693901 717215 664804 705461 719910 551875 601380 595985 795158 746032 729587 770061 809867 465793 531320 721432 608352 794684 781685 481254 276696 790640 465535 391588 391287 468886 388979 458830 500977 495156 460261 545630 550493 739060 391437 428874 428317 439576 503094 504774 482877 529465 413307 824938 817480 817705 817929 522638 514697 578040 665932 667581 669672 689697 667863 682534 710540 595329 611560 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (1.85%) |
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 2291 111756 276696 358398 385062 388979 390051 391287 391437 391588 392957 396902 406616 413307 428317 428874 439292 439576 458830 460261 465397 465535 465793 465860 466258 468886 470770 471413 481254 482877 483394 488543 490917 495156 496325 498702 500977 503094 504774 507140 507225 514697 522638 522923 529465 529804 531320 535102 539461 545630 550493 551875 557311 568221 577602 578040 581231 584376 587226 590625 595329 595985 601380 603056 603299 606615 608352 611560 663390 664804 665359 665932 667581 667863 669672 670557 682534 689697 693901 705461 705549 710202 710540 717215 719910 721432 729576 729587 729625 739060 740136 744922 746032 750461 756869 767735 770061 770192 778308 781663 781668 781685 782225 785298 786455 790640 794684 795158 801760 803263 809867 810069 816243 817480 817701 817705 817929 818907 824938 828006 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother and guy"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин guy"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин guy"
]
|
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.