Query Metrics
7
Database Queries
7
Different statements
201.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.03 ms (87.32%) |
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 57971 394004 417704 432991 435938 438712 441683 442474 449950 450812 451436 453290 454959 454966 455098 455396 455864 459485 462593 463221 466365 466683 466723 466776 466882 471493 471599 472016 476915 477886 481747 482945 484115 489188 491439 494833 496389 502721 509179 510608 517039 524367 524651 525126 526394 530876 531380 531518 532352 535207 536897 537424 537777 544757 549772 557015 559040 563423 566892 589664 610285 613499 617650 621105 623234 623835 625456 626122 630625 639825 642331 645934 652380 659367 663262 665609 669712 671670 672229 673874 675628 685441 686610 693292 699899 705114 711761 715024 716396 717336 724713 726521 730934 732651 732655 732995 736052 739787 740966 742605 744470 744766 747563 749943 754522 755578 760317 770740 788729 792817 794191 794811 800816 802097 802778 802948 805142 810103 813669 822721 ] |
||||||||||||||||||||||||||||||
|
15.99 ms (7.93%) |
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 732995 732655 639825 800816 802097 802948 805142 57971 466776 441683 531380 726521 623234 472016 471599 524367 537424 711761 747563 617650 517039 449950 450812 466882 524651 566892 794191 730934 744470 754522 813669 645934 659367 673874 699899 705114 685441 671670 675628 794811 740966 788729 744766 724713 621105 455098 466683 466723 625456 394004 531518 530876 563423 471493 417704 455396 669712 802778 453290 454966 509179 589664 455864 451436 502721 652380 822721 686610 544757 630625 610285 760317 732651 749943 742605 557015 810103 477886 459485 482945 494833 525126 537777 462593 559040 435938 463221 526394 510608 532352 481747 489188 496389 438712 536897 693292 715024 626122 716396 717336 792817 432991 476915 484115 491439 442474 549772 623835 642331 613499 454959 535207 663262 665609 672229 736052 755578 739787 770740 466365 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.20%) |
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 57971 394004 417704 432991 435938 438712 441683 442474 449950 450812 451436 453290 454959 454966 455098 455396 455864 459485 462593 463221 466365 466683 466723 466776 466882 471493 471599 472016 476915 477886 481747 482945 484115 489188 491439 494833 496389 502721 509179 510608 517039 524367 524651 525126 526394 530876 531380 531518 532352 535207 536897 537424 537777 544757 549772 557015 559040 563423 566892 589664 610285 613499 617650 621105 623234 623835 625456 626122 630625 639825 642331 645934 652380 659367 663262 665609 669712 671670 672229 673874 675628 685441 686610 693292 699899 705114 711761 715024 716396 717336 724713 726521 730934 732651 732655 732995 736052 739787 740966 742605 744470 744766 747563 749943 754522 755578 760317 770740 788729 792817 794191 794811 800816 802097 802778 802948 805142 810103 813669 822721 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home big tits"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home большие сиськ"
]
|
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.