Query Metrics
7
Database Queries
7
Different statements
391.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.95 ms (52.87%) |
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 383109 396397 397599 410770 413053 418414 418575 422524 427487 430713 431512 432631 437618 437816 440526 440563 441158 443170 445136 449447 449690 453854 455300 455331 456892 456993 457523 458149 461418 462215 463179 467833 473333 475398 475699 476066 476929 477008 481461 481824 483227 484256 490152 490155 491089 492631 492725 494323 495178 496963 506440 506714 508612 509031 509055 509077 510127 511213 512027 512147 512488 516260 520577 522296 522517 522750 524230 535724 537618 544536 551217 552862 553171 553615 556674 557362 559391 561330 565587 568299 568485 570907 577445 596220 596592 598986 600587 608363 618222 618234 621949 623821 626209 632887 639951 650983 651758 653287 665051 677155 690625 725303 728924 730288 741710 744711 746076 752848 753993 761717 762185 766851 773876 777770 789767 794384 797330 803158 807627 812286 ] |
||||||||||||||||||||||||||||||
|
159.71 ms (40.80%) |
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 383109 396397 397599 410770 413053 418414 418575 422524 427487 430713 431512 432631 437618 437816 440526 440563 441158 443170 445136 449447 449690 453854 455300 455331 456892 456993 457523 458149 461418 462215 463179 467833 473333 475398 475699 476066 476929 477008 481461 481824 483227 484256 490152 490155 491089 492631 492725 494323 495178 496963 506440 506714 508612 509031 509055 509077 510127 511213 512027 512147 512488 516260 520577 522296 522517 522750 524230 535724 537618 544536 551217 552862 553171 553615 556674 557362 559391 561330 565587 568299 568485 570907 577445 596220 596592 598986 600587 608363 618222 618234 621949 623821 626209 632887 639951 650983 651758 653287 665051 677155 690625 725303 728924 730288 741710 744711 746076 752848 753993 761717 762185 766851 773876 777770 789767 794384 797330 803158 807627 812286 ] |
||||||||||||||||||||||||||||||
|
18.26 ms (4.67%) |
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 437816 441158 511213 544536 552862 651758 690625 553615 577445 746076 475398 397599 440563 462215 741710 812286 752848 476066 455331 467833 445136 484256 556674 600587 807627 432631 461418 490152 453854 475699 481824 520577 512027 621949 596592 598986 773876 618222 794384 803158 440526 494323 553171 427487 557362 418414 508612 431512 410770 492631 516260 535724 665051 608363 725303 458149 477008 443170 510127 491089 522517 422524 473333 483227 495178 565587 551217 677155 777770 789767 753993 437618 456892 463179 481461 449690 476929 522296 506714 492725 383109 430713 456993 496963 509077 524230 561330 559391 570907 568485 653287 650983 623821 626209 639951 596220 618234 761717 762185 744711 413053 455300 396397 418575 457523 449447 522750 512488 537618 568299 632887 766851 728924 730288 797330 506440 509031 509055 490155 512147 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"camera sex"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"camera секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"camera секс"
]
|
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.