Query Metrics
7
Database Queries
7
Different statements
135.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.84 ms (85.24%) |
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 6715 51420 52595 198191 233915 340242 381921 387046 387722 392032 392033 395305 396543 401189 401945 402866 412776 416128 424068 432272 432384 437265 438047 443986 445731 445993 448332 451594 452716 454278 458967 464593 469783 476443 479481 490853 492501 494436 497545 499578 517578 518299 523092 523174 524224 526427 538521 541938 546351 554161 558912 559974 563965 580695 594312 594381 599447 602362 626236 631020 640826 650275 652212 667402 670702 690329 690364 690366 690429 690439 690455 690468 690508 690516 691235 691241 691244 691250 691879 692412 692842 693160 693163 693170 693176 693539 694386 694852 697291 705538 708120 715620 718971 720418 721223 731581 735712 738597 741591 745123 750287 750298 751426 757915 760303 763802 766303 768831 769098 773907 774028 786047 793210 794067 799882 805426 810731 817596 817611 828128 ] |
||||||||||||||||||||||||||||||
|
11.71 ms (8.62%) |
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 602362 694386 479481 774028 691244 691879 690455 670702 594381 691235 692412 751426 690516 490853 526427 402866 454278 580695 412776 554161 546351 476443 524224 523092 720418 757915 697291 451594 763802 690508 563965 693163 690329 693176 766303 690439 690429 810731 52595 721223 799882 794067 735712 769098 6715 626236 392032 499578 692842 690364 690468 640826 786047 805426 705538 718971 51420 464593 492501 452716 445993 381921 693170 667402 631020 691241 691250 715620 652212 793210 745123 750287 750298 731581 438047 396543 387722 432272 458967 559974 424068 198191 432384 437265 445731 650275 693160 594312 599447 773907 768831 233915 392033 817596 738597 340242 443986 558912 708120 693539 690366 760303 741591 401945 497545 518299 395305 416128 469783 523174 494436 817611 828128 694852 387046 401189 448332 517578 538521 541938 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.84%) |
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 6715 51420 52595 198191 233915 340242 381921 387046 387722 392032 392033 395305 396543 401189 401945 402866 412776 416128 424068 432272 432384 437265 438047 443986 445731 445993 448332 451594 452716 454278 458967 464593 469783 476443 479481 490853 492501 494436 497545 499578 517578 518299 523092 523174 524224 526427 538521 541938 546351 554161 558912 559974 563965 580695 594312 594381 599447 602362 626236 631020 640826 650275 652212 667402 670702 690329 690364 690366 690429 690439 690455 690468 690508 690516 691235 691241 691244 691250 691879 692412 692842 693160 693163 693170 693176 693539 694386 694852 697291 705538 708120 715620 718971 720418 721223 731581 735712 738597 741591 745123 750287 750298 751426 757915 760303 763802 766303 768831 769098 773907 774028 786047 793210 794067 799882 805426 810731 817596 817611 828128 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen in car"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.24 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen вмашин"
]
|
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.