Query Metrics
7
Database Queries
7
Different statements
155.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.28 ms (85.69%) |
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 546193 548301 548448 552378 553221 554712 554836 555615 556079 556098 557218 557838 559419 559420 561784 562161 562575 563284 573187 581366 583301 586432 587691 588058 588498 589626 590525 593208 603138 609556 610953 612978 617573 620528 620581 623689 624916 625027 625743 628611 629638 629725 631490 632501 632940 633479 638467 641516 641522 641604 643146 643447 644713 649738 650526 650538 653126 661901 662812 663339 664457 665450 666053 666395 666602 669655 675513 681538 682612 684855 684888 684891 687366 689930 692744 694193 697301 697759 698249 698252 698256 699304 699383 700237 700900 702318 703259 703271 704990 705210 705769 706013 707481 709224 710280 711975 712784 713159 713416 713453 714190 719451 719960 720026 720278 777276 779302 783905 785881 792237 796837 801806 801816 801818 801833 803032 803133 803189 803478 804482 ] |
||||||||||||||||||||||||||||||
|
13.14 ms (8.45%) |
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 583301 548301 548448 552378 553221 556079 557218 557838 559420 561784 562575 573187 662812 663339 665450 666053 669655 675513 684888 684891 694193 699304 699383 700237 702318 704990 707481 713159 713453 719960 720026 649738 650526 653126 681538 682612 689930 692744 697301 697759 703259 703271 705769 706013 710280 711975 713416 720278 650538 661901 664457 666395 666602 684855 687366 698249 698252 698256 700900 705210 709224 712784 714190 719451 546193 554712 554836 555615 556098 559419 562161 563284 581366 587691 588058 612978 620581 625027 629638 633479 641604 643146 643447 586432 609556 620528 623689 624916 629725 588498 589626 590525 593208 603138 617573 628611 632501 644713 610953 625743 631490 632940 638467 641516 641522 777276 779302 783905 785881 792237 796837 801806 801816 801818 801833 803032 803133 803189 803478 804482 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.63%) |
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 546193 548301 548448 552378 553221 554712 554836 555615 556079 556098 557218 557838 559419 559420 561784 562161 562575 563284 573187 581366 583301 586432 587691 588058 588498 589626 590525 593208 603138 609556 610953 612978 617573 620528 620581 623689 624916 625027 625743 628611 629638 629725 631490 632501 632940 633479 638467 641516 641522 641604 643146 643447 644713 649738 650526 650538 653126 661901 662812 663339 664457 665450 666053 666395 666602 669655 675513 681538 682612 684855 684888 684891 687366 689930 692744 694193 697301 697759 698249 698252 698256 699304 699383 700237 700900 702318 703259 703271 704990 705210 705769 706013 707481 709224 710280 711975 712784 713159 713416 713453 714190 719451 719960 720026 720278 777276 779302 783905 785881 792237 796837 801806 801816 801818 801833 803032 803133 803189 803478 804482 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy hole"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy дырк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy дырк"
]
|
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.