Query Metrics
7
Database Queries
7
Different statements
162.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.14 ms (84.84%) |
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 12573 14232 44174 193662 320525 385915 393677 394646 396069 396706 397958 398204 398388 399016 399418 401070 401115 402243 403255 404384 409452 418061 418452 421743 457228 457240 457329 459229 463953 464347 465082 467120 467606 468089 469581 472647 476111 478498 486061 494447 497452 497732 517154 522160 527761 530024 530482 531298 531698 533090 533384 536632 537614 537941 540410 540437 541868 542209 545220 546785 546804 549088 558777 570175 579049 583982 585296 587323 590167 592255 596844 600363 604476 604494 612247 613122 630435 630546 630550 633611 633792 634140 637148 637151 637567 644246 654460 656321 658094 666582 673816 674001 674995 683183 698407 709922 712805 716189 718934 719243 720669 721870 725596 725636 728424 732292 735112 744630 744656 747313 750275 761086 771834 778069 800288 806268 806377 825241 825915 827895 ] |
||||||||||||||||||||||||||||||
|
14.97 ms (9.19%) |
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 709922 744656 12573 401115 396069 398388 398204 421743 517154 527761 542209 654460 674001 637567 728424 735112 744630 720669 721870 457228 592255 540437 530024 674995 396706 418452 486061 497732 464347 546785 590167 613122 761086 604476 193662 825915 465082 537614 558777 596844 397958 44174 469581 716189 409452 825241 403255 583982 393677 656321 468089 459229 399016 463953 467120 478498 531298 533090 537941 545220 579049 658094 718934 673816 712805 644246 587323 725636 750275 385915 827895 540410 600363 633792 394646 320525 630546 530482 401070 418061 533384 531698 666582 771834 604494 546804 497452 630550 778069 404384 457329 536632 800288 806268 747313 806377 472647 14232 683183 698407 612247 630435 476111 570175 585296 725596 634140 637148 399418 467606 494447 522160 541868 719243 549088 633611 637151 732292 402243 457240 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.64%) |
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 12573 14232 44174 193662 320525 385915 393677 394646 396069 396706 397958 398204 398388 399016 399418 401070 401115 402243 403255 404384 409452 418061 418452 421743 457228 457240 457329 459229 463953 464347 465082 467120 467606 468089 469581 472647 476111 478498 486061 494447 497452 497732 517154 522160 527761 530024 530482 531298 531698 533090 533384 536632 537614 537941 540410 540437 541868 542209 545220 546785 546804 549088 558777 570175 579049 583982 585296 587323 590167 592255 596844 600363 604476 604494 612247 613122 630435 630546 630550 633611 633792 634140 637148 637151 637567 644246 654460 656321 658094 666582 673816 674001 674995 683183 698407 709922 712805 716189 718934 719243 720669 721870 725596 725636 728424 732292 735112 744630 744656 747313 750275 761086 771834 778069 800288 806268 806377 825241 825915 827895 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal bbc big"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал bbc большие"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал bbc большие"
]
|
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.