Query Metrics
7
Database Queries
7
Different statements
226.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.91 ms (86.44%) |
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 52454 193895 210377 382518 396400 396765 401189 401559 401844 413525 413531 413534 417069 418347 419150 420464 425629 429603 434532 440753 444281 444343 444980 446548 451013 455951 457349 458199 461055 461117 461367 466551 470680 471167 471188 472344 472727 476442 478867 485159 489167 489296 490326 492711 492965 493460 493571 498115 498843 503117 504471 506533 509945 515833 519419 521298 521914 522270 523092 523105 524459 531611 532850 536483 539162 540377 543400 545561 546920 551539 553305 554536 554563 554648 557903 565439 567130 568837 572756 577655 581965 593212 594784 595151 599808 606255 609565 618302 620656 627558 628189 636625 637907 645472 647998 669210 691600 696708 718227 729480 739151 744173 744430 749633 757521 766234 768870 777537 784397 792429 797591 817400 817664 817853 822148 822257 824763 824865 825670 828332 ] |
||||||||||||||||||||||||||||||
|
18.58 ms (8.20%) |
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 543400 581965 466551 489167 572756 539162 595151 52454 413531 478867 461367 506533 557903 554648 546920 618302 593212 594784 797591 777537 749633 396400 418347 470680 417069 822148 828332 696708 718227 645472 647998 691600 545561 636625 637907 599808 792429 766234 444281 824763 628189 551539 401844 729480 446548 524459 554536 503117 532850 739151 757521 627558 413534 492711 523092 461117 554563 568837 457349 444343 515833 521914 458199 401189 434532 822257 455951 472727 451013 471167 531611 536483 504471 476442 553305 606255 425629 471188 210377 420464 472344 493571 509945 522270 492965 519419 620656 565439 429603 193895 540377 744173 784397 768870 577655 461055 521298 493460 498843 382518 413525 440753 489296 523105 490326 567130 419150 444980 401559 498115 485159 669210 609565 744430 396765 817853 824865 825670 817400 817664 ] |
||||||||||||||||||||||||||||||
|
4.31 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 52454 193895 210377 382518 396400 396765 401189 401559 401844 413525 413531 413534 417069 418347 419150 420464 425629 429603 434532 440753 444281 444343 444980 446548 451013 455951 457349 458199 461055 461117 461367 466551 470680 471167 471188 472344 472727 476442 478867 485159 489167 489296 490326 492711 492965 493460 493571 498115 498843 503117 504471 506533 509945 515833 519419 521298 521914 522270 523092 523105 524459 531611 532850 536483 539162 540377 543400 545561 546920 551539 553305 554536 554563 554648 557903 565439 567130 568837 572756 577655 581965 593212 594784 595151 599808 606255 609565 618302 620656 627558 628189 636625 637907 645472 647998 669210 691600 696708 718227 729480 739151 744173 744430 749633 757521 766234 768870 777537 784397 792429 797591 817400 817664 817853 822148 822257 824763 824865 825670 828332 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"car big ass"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вмашин большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.77%) |
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.