Query Metrics
7
Database Queries
7
Different statements
152.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.87 ms (84.04%) |
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 51972 188189 390669 396369 409805 412984 415287 417460 421637 432618 432625 434767 437670 441395 441409 441583 441958 442851 450338 452683 453833 457141 458117 460873 461677 465584 466898 468020 469636 497647 502164 534600 534748 541474 541868 552697 555093 557677 558574 572181 579471 582097 582479 584222 585017 588082 591992 592587 594531 623289 624895 625599 626917 628484 629171 636242 656497 656548 657200 661984 680434 680454 680459 687463 689442 694953 695473 707177 711417 713896 715012 715373 721869 724307 724403 727280 727743 727785 733149 737185 738216 738679 740115 740481 740869 748658 756704 758141 758355 759878 759928 761199 761600 763516 765322 765400 765743 766637 766777 766866 769044 771613 775376 777631 785198 786051 787033 788839 788856 791160 795313 800376 804339 804568 804935 807419 809747 824164 824200 827484 ] |
||||||||||||||||||||||||||||||
|
14.30 ms (9.40%) |
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 188189 785198 727280 432618 765322 534748 572181 804568 771613 766777 441395 588082 558574 441583 432625 827484 824200 468020 761199 786051 724307 763516 409805 442851 585017 534600 591992 625599 721869 715373 552697 415287 437670 421637 465584 541868 656548 695473 715012 636242 787033 788839 795313 807419 740869 788856 804935 758141 765400 769044 724403 737185 738679 733149 738216 748658 758355 765743 458117 466898 51972 390669 824164 804339 759878 727785 623289 687463 680434 775376 497647 624895 791160 761600 766637 766866 417460 460873 461677 450338 628484 412984 441958 453833 469636 582479 657200 582097 592587 594531 727743 759928 800376 809747 740481 756704 434767 441409 452683 396369 457141 579471 502164 541474 557677 584222 656497 680454 694953 713896 661984 680459 689442 555093 629171 777631 740115 626917 707177 711417 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (2.03%) |
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 51972 188189 390669 396369 409805 412984 415287 417460 421637 432618 432625 434767 437670 441395 441409 441583 441958 442851 450338 452683 453833 457141 458117 460873 461677 465584 466898 468020 469636 497647 502164 534600 534748 541474 541868 552697 555093 557677 558574 572181 579471 582097 582479 584222 585017 588082 591992 592587 594531 623289 624895 625599 626917 628484 629171 636242 656497 656548 657200 661984 680434 680454 680459 687463 689442 694953 695473 707177 711417 713896 715012 715373 721869 724307 724403 727280 727743 727785 733149 737185 738216 738679 740115 740481 740869 748658 756704 758141 758355 759878 759928 761199 761600 763516 765322 765400 765743 766637 766777 766866 769044 771613 775376 777631 785198 786051 787033 788839 788856 791160 795313 800376 804339 804568 804935 807419 809747 824164 824200 827484 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade creampie anal"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск creampie анал"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск creampie анал"
]
|
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.