Query Metrics
7
Database Queries
7
Different statements
158.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.58 ms (85.12%) |
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 394760 399522 401383 413712 417562 417948 420513 424575 424969 424996 426779 435020 435754 437156 437580 437613 437634 442416 443310 444429 447704 447848 448295 449647 449657 450442 454876 456286 459225 459628 459866 459872 460439 462242 463530 463590 463599 463654 463710 464822 468025 472122 473375 473568 473626 476067 476071 477815 478743 479298 480654 484111 484213 486633 487259 488090 488616 489110 489370 489372 489630 490452 491331 492657 492975 494277 498095 499021 500010 500190 500226 501133 501383 503947 505952 506565 506615 507249 508309 508549 511588 512394 514449 516124 516918 517634 519664 520787 521062 521979 521984 522118 522635 522993 523476 525213 526518 526519 528122 529161 543437 552591 556482 562043 563267 568570 576474 579532 584538 584741 586741 602504 614060 620742 643602 662042 676658 709431 711274 757501 ] |
||||||||||||||||||||||||||||||
|
14.74 ms (9.32%) |
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 420513 435020 463654 442416 490452 508309 508549 437634 476067 491331 463590 520787 507249 473375 543437 552591 711274 447848 424969 479298 449647 449657 435754 463599 464822 476071 516124 501383 528122 501133 484111 514449 522635 394760 506565 529161 484213 437613 460439 399522 459866 473626 417948 489370 521984 489372 525213 519664 526518 584538 676658 709431 563267 586741 462242 506615 500226 473568 456286 463530 517634 488616 602504 424575 459872 437156 468025 492975 505952 521979 492657 489630 579532 662042 556482 757501 643602 614060 401383 424996 417562 448295 477815 459628 480654 494277 522993 500190 526519 516918 498095 562043 568570 584741 620742 459225 450442 437580 443310 454876 426779 444429 472122 478743 500010 511588 512394 489110 486633 488090 521062 523476 487259 499021 503947 522118 413712 447704 463710 576474 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.60%) |
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 394760 399522 401383 413712 417562 417948 420513 424575 424969 424996 426779 435020 435754 437156 437580 437613 437634 442416 443310 444429 447704 447848 448295 449647 449657 450442 454876 456286 459225 459628 459866 459872 460439 462242 463530 463590 463599 463654 463710 464822 468025 472122 473375 473568 473626 476067 476071 477815 478743 479298 480654 484111 484213 486633 487259 488090 488616 489110 489370 489372 489630 490452 491331 492657 492975 494277 498095 499021 500010 500190 500226 501133 501383 503947 505952 506565 506615 507249 508309 508549 511588 512394 514449 516124 516918 517634 519664 520787 521062 521979 521984 522118 522635 522993 523476 525213 526518 526519 528122 529161 543437 552591 556482 562043 563267 568570 576474 579532 584538 584741 586741 602504 614060 620742 643602 662042 676658 709431 711274 757501 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big sister fuck"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие sister секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие sister секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.93%) |
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.