Query Metrics
7
Database Queries
7
Different statements
183.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.90 ms (83.74%) |
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 388903 390502 390713 390950 395182 397781 405848 407444 410651 414135 417836 419320 422354 435695 440893 442970 443726 443820 444003 446079 446275 448861 454188 455890 457998 460208 466392 466561 467047 467619 467877 467908 467929 468072 468099 468154 472595 472630 472706 473832 474661 475056 476671 476905 480079 482501 486539 487632 491209 491636 493163 493207 494296 497492 499906 511027 512809 513130 516015 517001 517528 518147 518554 518576 518918 519047 519215 519230 523562 524987 526277 529369 535384 536639 538870 541757 544323 554866 555233 555435 559139 560077 568060 586398 591487 592027 593608 596844 622369 656200 677724 680215 681075 681223 694222 696120 697449 720117 722212 726942 731328 733416 758256 766613 769291 770199 784307 798705 799127 800344 800712 815943 816545 817119 817154 817632 818468 820586 823746 825304 ] |
||||||||||||||||||||||||||||||
|
18.69 ms (10.17%) |
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 817632 823746 816545 820586 815943 817119 818468 538870 554866 694222 722212 656200 680215 677724 681075 696120 697449 596844 800712 798705 733416 758256 720117 476905 446275 536639 454188 468072 491209 529369 535384 559139 568060 544323 592027 726942 769291 731328 472630 422354 467619 474661 487632 388903 390713 414135 442970 467908 468099 472706 395182 455890 466561 516015 482501 518918 440893 486539 493163 405848 472595 476671 523562 468154 555435 770199 784307 518147 519047 390502 407444 435695 448861 480079 467047 497492 518554 524987 526277 519230 499906 513130 517528 541757 555233 586398 591487 622369 799127 457998 467877 467929 443820 443726 460208 517001 519215 518576 493207 491636 494296 390950 419320 466392 475056 473832 766613 397781 410651 417836 825304 817154 446079 512809 511027 560077 681223 593608 800344 444003 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.58%) |
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 388903 390502 390713 390950 395182 397781 405848 407444 410651 414135 417836 419320 422354 435695 440893 442970 443726 443820 444003 446079 446275 448861 454188 455890 457998 460208 466392 466561 467047 467619 467877 467908 467929 468072 468099 468154 472595 472630 472706 473832 474661 475056 476671 476905 480079 482501 486539 487632 491209 491636 493163 493207 494296 497492 499906 511027 512809 513130 516015 517001 517528 518147 518554 518576 518918 519047 519215 519230 523562 524987 526277 529369 535384 536639 538870 541757 544323 554866 555233 555435 559139 560077 568060 586398 591487 592027 593608 596844 622369 656200 677724 680215 681075 681223 694222 696120 697449 720117 722212 726942 731328 733416 758256 766613 769291 770199 784307 798705 799127 800344 800712 815943 816545 817119 817154 817632 818468 820586 823746 825304 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal hairy"
]
|
||||||||||||||||||||||||||||||
|
2.22 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал волосатая"
]
|
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.