Query Metrics
7
Database Queries
7
Different statements
377.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.92 ms (54.61%) |
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 410770 413053 418575 425354 427487 427643 432743 435266 437618 444952 446253 449447 449690 454533 454537 455300 457523 458149 458648 459256 459267 459472 460484 464565 466379 466548 467814 470805 470809 473333 474210 476929 481461 483227 487891 491089 492631 492654 492816 492844 493417 495552 496963 498972 505862 506714 506744 508612 509077 510127 511471 511982 513990 514586 514852 515938 516260 522239 522296 522517 522750 524026 524230 526131 526461 526837 533574 535724 536030 537051 542184 551228 551451 553248 556674 557362 557365 559973 561330 565587 567186 570907 572715 576243 577632 578432 580500 591340 592006 600502 600587 600788 608363 614614 618234 619009 623821 624923 625669 639951 663190 665822 667047 677155 700685 704078 714493 725303 744711 753993 761717 762185 777770 786610 789767 794223 794248 800851 804265 805257 ] |
||||||||||||||||||||||||||||||
|
143.24 ms (37.99%) |
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 410770 413053 418575 425354 427487 427643 432743 435266 437618 444952 446253 449447 449690 454533 454537 455300 457523 458149 458648 459256 459267 459472 460484 464565 466379 466548 467814 470805 470809 473333 474210 476929 481461 483227 487891 491089 492631 492654 492816 492844 493417 495552 496963 498972 505862 506714 506744 508612 509077 510127 511471 511982 513990 514586 514852 515938 516260 522239 522296 522517 522750 524026 524230 526131 526461 526837 533574 535724 536030 537051 542184 551228 551451 553248 556674 557362 557365 559973 561330 565587 567186 570907 572715 576243 577632 578432 580500 591340 592006 600502 600587 600788 608363 614614 618234 619009 623821 624923 625669 639951 663190 665822 667047 677155 700685 704078 714493 725303 744711 753993 761717 762185 777770 786610 789767 794223 794248 800851 804265 805257 ] |
||||||||||||||||||||||||||||||
|
21.02 ms (5.57%) |
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 639951 619009 618234 515938 491089 492816 505862 432743 492631 496963 526461 565587 570907 663190 557362 576243 725303 493417 511471 522239 410770 470809 483227 524026 535724 536030 542184 553248 556674 561330 567186 578432 667047 677155 704078 557365 580500 614614 623821 600587 608363 777770 794223 753993 804265 413053 427643 437618 455300 460484 446253 458149 427487 457523 476929 464565 511982 526837 492844 522296 492654 522750 551228 624923 425354 454533 459256 473333 459267 466548 470805 516260 509077 514852 524230 513990 467814 714493 700685 572715 600788 789767 800851 761717 762185 744711 786610 794248 805257 466379 444952 418575 481461 435266 449690 454537 474210 449447 495552 510127 514586 506714 508612 487891 498972 506744 522517 537051 559973 551451 459472 458648 577632 600502 533574 526131 665822 591340 592006 625669 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade camera"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск camera"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск camera"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.41%) |
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.