Query Metrics
7
Database Queries
7
Different statements
165.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.50 ms (85.65%) |
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 177739 387046 392279 397613 401250 417255 427771 428902 428904 436838 441336 455261 464870 469492 476698 489688 494931 500095 507141 510223 514444 515615 517254 517256 522190 539353 540462 540895 544591 546268 547884 548395 550787 554314 557372 557587 559654 561123 568728 571374 574573 576800 578787 579739 579756 582678 582852 582941 584944 585319 587983 588325 588433 592073 592083 592105 592123 592133 592134 592142 592145 592147 592323 595117 598913 600865 603005 607010 612035 612233 620547 626843 627774 628824 629443 633253 633824 634895 635057 638117 638859 645575 645736 647703 648424 649713 666669 667469 675142 678217 691229 697390 697661 702497 704425 712484 715378 717848 728360 729576 732543 732783 733516 739963 742618 748707 755550 759913 767693 768197 769846 772157 783722 787317 787830 789597 791625 804326 808453 819449 ] |
||||||||||||||||||||||||||||||
|
12.92 ms (7.82%) |
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 489688 579739 557587 702497 592134 598913 635057 540462 557372 715378 585319 592142 629443 769846 772157 742618 729576 759913 517256 507141 540895 579756 649713 691229 697661 675142 645575 647703 712484 728360 767693 633824 789597 397613 678217 704425 547884 768197 633253 717848 428904 469492 517254 582941 634895 607010 755550 732783 748707 732543 515615 819449 578787 584944 603005 612035 587983 612233 791625 638859 548395 550787 568728 574573 561123 592083 592145 787317 427771 455261 582852 645736 697390 588325 592123 787830 739963 476698 401250 177739 464870 510223 554314 544591 648424 559654 620547 595117 628824 592073 592323 626843 783722 638117 436838 500095 417255 576800 592147 600865 804326 808453 733516 428902 571374 546268 592105 627774 441336 522190 539353 514444 582678 666669 667469 588433 592133 392279 387046 494931 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.00%) |
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 177739 387046 392279 397613 401250 417255 427771 428902 428904 436838 441336 455261 464870 469492 476698 489688 494931 500095 507141 510223 514444 515615 517254 517256 522190 539353 540462 540895 544591 546268 547884 548395 550787 554314 557372 557587 559654 561123 568728 571374 574573 576800 578787 579739 579756 582678 582852 582941 584944 585319 587983 588325 588433 592073 592083 592105 592123 592133 592134 592142 592145 592147 592323 595117 598913 600865 603005 607010 612035 612233 620547 626843 627774 628824 629443 633253 633824 634895 635057 638117 638859 645575 645736 647703 648424 649713 666669 667469 675142 678217 691229 697390 697661 702497 704425 712484 715378 717848 728360 729576 732543 732783 733516 739963 742618 748707 755550 759913 767693 768197 769846 772157 783722 787317 787830 789597 791625 804326 808453 819449 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"quickie sex"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"quickie секс"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"quickie секс"
]
|
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.