Query Metrics
7
Database Queries
7
Different statements
191.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.93 ms (82.40%) |
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 381903 391437 391692 395406 395563 395596 395639 395819 395869 396013 400962 404695 404777 411045 414157 418521 418939 419619 424351 424460 426399 427112 435624 437797 441129 441784 441848 442673 443874 446038 446856 449425 454277 458191 462845 463783 464194 465688 467878 467932 468096 468097 471022 471814 474593 475333 475904 476344 480059 483152 483413 484227 484628 484727 484762 493083 493573 493775 496794 497665 498226 499096 501488 504989 511345 512355 517654 518587 519013 519047 521798 522556 523360 525133 526052 528328 528702 535282 535423 538360 555009 555291 557544 558176 558788 565156 570394 579701 583913 584301 586673 589591 591736 593372 593821 598863 604960 605461 610695 615757 618060 624148 624227 650659 662898 666049 676176 703140 709916 715368 717516 722373 722478 725120 731888 776217 787874 801262 811870 814850 ] |
||||||||||||||||||||||||||||||
|
23.30 ms (12.16%) |
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 396013 499096 471814 615757 484762 395639 449425 501488 484727 517654 475333 731888 395596 523360 725120 404777 518587 666049 722478 395819 464194 404695 715368 493083 703140 395563 437797 395869 476344 483413 465688 454277 528702 504989 555291 589591 424460 467878 426399 458191 497665 484227 391692 441784 480059 605461 624148 528328 441129 493775 414157 462845 586673 446038 512355 467932 604960 557544 662898 709916 801262 776217 427112 814850 593372 558788 411045 811870 593821 618060 787874 418939 676176 468097 381903 579701 498226 624227 519013 424351 538360 496794 583913 558176 584301 446856 570394 463783 483152 535282 722373 484628 521798 441848 525133 468096 474593 717516 591736 598863 650659 493573 610695 418521 419619 526052 443874 511345 391437 435624 535423 400962 395406 519047 471022 442673 565156 475904 522556 555009 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.81%) |
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 381903 391437 391692 395406 395563 395596 395639 395819 395869 396013 400962 404695 404777 411045 414157 418521 418939 419619 424351 424460 426399 427112 435624 437797 441129 441784 441848 442673 443874 446038 446856 449425 454277 458191 462845 463783 464194 465688 467878 467932 468096 468097 471022 471814 474593 475333 475904 476344 480059 483152 483413 484227 484628 484727 484762 493083 493573 493775 496794 497665 498226 499096 501488 504989 511345 512355 517654 518587 519013 519047 521798 522556 523360 525133 526052 528328 528702 535282 535423 538360 555009 555291 557544 558176 558788 565156 570394 579701 583913 584301 586673 589591 591736 593372 593821 598863 604960 605461 610695 615757 618060 624148 624227 650659 662898 666049 676176 703140 709916 715368 717516 722373 722478 725120 731888 776217 787874 801262 811870 814850 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал с волосатыми жен%…"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал волосатая жен"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал волосатая жен"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.77%) |
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.