Query Metrics
7
Database Queries
7
Different statements
155.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.04 ms (82.60%) |
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 337627 389583 398431 421338 429475 442197 446495 448969 456050 456158 456759 461842 461868 469546 472957 474528 485294 486397 486833 492109 500358 502575 503706 507429 513002 513817 514125 514278 517794 521938 535686 536912 537030 538045 549576 584322 592880 599386 606389 608225 611037 613598 613912 620938 625300 629391 630883 636468 636858 639153 642187 652913 653475 654174 662534 664525 664551 672795 683449 686183 689514 691229 693250 693670 694614 696493 699207 704797 709818 718044 719267 719937 720140 721002 723766 724854 725391 726412 728471 728564 728771 729880 729932 730105 730119 730159 733342 734258 734680 734958 737351 738179 739859 740136 747416 748463 750301 751496 753218 755169 756565 756609 759672 760496 765689 772077 772773 773061 787015 792815 796469 801366 807203 812314 812372 815965 822705 824856 825365 ] |
||||||||||||||||||||||||||||||
|
16.44 ms (10.60%) |
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 723766 729880 729932 730105 737351 747416 753218 772773 773061 787015 738179 739859 751496 756565 760496 725391 726412 730119 734958 765689 639153 442197 538045 584322 613912 636468 724854 421338 486397 521938 689514 606389 625300 642187 608225 620938 812314 337627 461868 456050 536912 513817 537030 652913 696493 653475 683449 796469 812372 719937 461842 492109 502575 469546 514125 500358 664525 654174 748463 389583 815965 448969 535686 672795 691229 693250 693670 694614 662534 664551 686183 704797 592880 630883 636858 629391 728564 740136 772077 801366 734258 734680 755169 699207 707498 721002 807203 709818 728471 792815 429475 474528 513002 517794 398431 446495 456759 507429 514278 472957 485294 503706 486833 456158 720140 599386 613598 730159 728771 750301 719267 549576 718044 611037 733342 759672 756609 824856 822705 825365 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.99%) |
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 337627 389583 398431 421338 429475 442197 446495 448969 456050 456158 456759 461842 461868 469546 472957 474528 485294 486397 486833 492109 500358 502575 503706 507429 513002 513817 514125 514278 517794 521938 535686 536912 537030 538045 549576 584322 592880 599386 606389 608225 611037 613598 613912 620938 625300 629391 630883 636468 636858 639153 642187 652913 653475 654174 662534 664525 664551 672795 683449 686183 689514 691229 693250 693670 694614 696493 699207 704797 709818 718044 719267 719937 720140 721002 723766 724854 725391 726412 728471 728564 728771 729880 729932 730105 730119 730159 733342 734258 734680 734958 737351 738179 739859 740136 747416 748463 750301 751496 753218 755169 756565 756609 759672 760496 765689 772077 772773 773061 787015 792815 796469 801366 807203 812314 812372 815965 822705 824856 825365 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation big cock"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац большие cock"
]
|
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.