Query Metrics
7
Database Queries
7
Different statements
385.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.77 ms (55.41%) |
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 392423 393061 394535 395578 398049 399267 399292 399311 399705 403519 406521 407322 408299 409010 414123 417797 417878 417893 417895 417904 419876 419892 420084 421556 424783 425395 428410 430696 436250 444746 446698 446870 449563 451872 458098 458625 461637 463092 464147 465513 469001 478481 480137 480779 486233 496395 496721 497687 505100 510264 513746 520137 528102 530370 532754 532995 533064 537661 538773 545532 545785 547362 557199 565507 573308 574240 577265 578412 581831 584951 591936 599862 599876 602070 604025 604466 604510 605007 605544 606858 607126 610717 612182 619645 622452 629045 630193 630955 631604 632618 636293 636576 637021 637501 641481 647665 649187 650808 682517 687881 708920 713332 715089 719832 720287 722541 733364 737177 741305 744665 744822 770625 785657 800287 800513 804756 805271 817127 818284 820780 ] |
||||||||||||||||||||||||||||||
|
144.56 ms (37.47%) |
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 392423 393061 394535 395578 398049 399267 399292 399311 399705 403519 406521 407322 408299 409010 414123 417797 417878 417893 417895 417904 419876 419892 420084 421556 424783 425395 428410 430696 436250 444746 446698 446870 449563 451872 458098 458625 461637 463092 464147 465513 469001 478481 480137 480779 486233 496395 496721 497687 505100 510264 513746 520137 528102 530370 532754 532995 533064 537661 538773 545532 545785 547362 557199 565507 573308 574240 577265 578412 581831 584951 591936 599862 599876 602070 604025 604466 604510 605007 605544 606858 607126 610717 612182 619645 622452 629045 630193 630955 631604 632618 636293 636576 637021 637501 641481 647665 649187 650808 682517 687881 708920 713332 715089 719832 720287 722541 733364 737177 741305 744665 744822 770625 785657 800287 800513 804756 805271 817127 818284 820780 ] |
||||||||||||||||||||||||||||||
|
20.48 ms (5.31%) |
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 417797 407322 414123 419876 424783 419892 417893 428410 444746 818284 451872 449563 458625 461637 463092 497687 520137 528102 469001 715089 649187 687881 719832 573308 604466 607126 591936 602070 636576 599876 604510 612182 737177 744665 606858 630955 713332 800513 395578 458098 393061 417878 480137 420084 425395 465513 399267 446870 406521 496721 510264 513746 532754 545785 637021 632618 630193 530370 605544 708920 744822 532995 537661 533064 629045 599862 636293 392423 398049 399292 399705 417895 421556 417904 430696 436250 817127 820780 486233 480779 505100 538773 496395 464147 547362 565507 577265 557199 578412 581831 584951 545532 650808 682517 647665 720287 722541 574240 604025 619645 631604 610717 605007 641481 800287 770625 804756 805271 741305 733364 622452 637501 785657 409010 446698 399311 403519 408299 394535 478481 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy bbc"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy bbc"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy bbc"
]
|
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.