Query Metrics
7
Database Queries
7
Different statements
167.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.05 ms (78.25%) |
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 325936 381775 384422 396013 396217 397371 399418 400878 401105 401116 403353 404209 404829 413189 413824 420499 421486 424929 427475 428742 429042 431694 432306 444180 444841 452980 453081 454625 454842 455787 457492 459484 461423 461469 461622 461886 461900 461938 461998 463945 464257 464856 468095 470782 471787 472739 473324 473774 473925 474580 478091 478464 479496 482075 489118 489524 489650 489651 490794 491202 491474 491540 493271 493479 493849 494139 494146 494386 496725 497294 502118 505798 507228 507899 508876 512426 513307 514917 521865 522096 524027 524718 525942 526766 534060 539126 546970 555955 560630 561832 561891 565496 569567 570462 575723 576021 584539 590413 598695 600123 632638 642111 647032 661034 676328 677355 679659 719266 725409 730893 746432 752587 765285 775707 783433 788905 790920 791557 804695 827829 ] |
||||||||||||||||||||||||||||||
|
25.19 ms (15.04%) |
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 457492 461886 464856 470782 413824 401116 403353 427475 429042 454625 461938 464257 471787 444180 461469 468095 472739 512426 521865 526766 491540 493849 507228 489650 489651 490794 491202 493479 494146 507899 491474 505798 478091 752587 783433 765285 413189 397371 461900 632638 428742 474580 461622 473774 575723 560630 570462 788905 444841 453081 478464 381775 421486 482075 479496 459484 508876 524718 489118 493271 494139 494386 534060 496725 525942 539126 396013 546970 561891 561832 565496 677355 590413 598695 424929 455787 473925 404829 461423 461998 384422 431694 463945 502118 513307 524027 497294 489524 569567 555955 473324 454842 522096 584539 399418 452980 514917 676328 679659 719266 661034 775707 420499 396217 325936 404209 647032 642111 790920 791557 804695 746432 401105 600123 827829 576021 725409 730893 400878 432306 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.76%) |
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 325936 381775 384422 396013 396217 397371 399418 400878 401105 401116 403353 404209 404829 413189 413824 420499 421486 424929 427475 428742 429042 431694 432306 444180 444841 452980 453081 454625 454842 455787 457492 459484 461423 461469 461622 461886 461900 461938 461998 463945 464257 464856 468095 470782 471787 472739 473324 473774 473925 474580 478091 478464 479496 482075 489118 489524 489650 489651 490794 491202 491474 491540 493271 493479 493849 494139 494146 494386 496725 497294 502118 505798 507228 507899 508876 512426 513307 514917 521865 522096 524027 524718 525942 526766 534060 539126 546970 555955 560630 561832 561891 565496 569567 570462 575723 576021 584539 590413 598695 600123 632638 642111 647032 661034 676328 677355 679659 719266 725409 730893 746432 752587 765285 775707 783433 788905 790920 791557 804695 827829 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая 18 анал"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful 18 anal"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая 18 анал"
]
|
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.