Query Metrics
7
Database Queries
7
Different statements
244.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
220.87 ms (90.26%) |
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 391592 397918 399176 400816 421815 421817 421847 421870 421885 422152 432650 433240 433351 433372 433375 435356 435747 440979 448955 449692 449893 457455 457980 458438 459519 460226 461843 465385 467952 468369 469372 469389 471407 473511 474778 479669 483654 485057 493174 494327 494967 495222 495227 500796 502813 507003 516226 516478 516712 517711 518807 520861 521220 522992 523832 524486 524497 524540 532932 538003 538022 538970 542706 544120 546955 549846 549849 549850 550672 555263 557969 559737 572697 582339 587158 591355 595483 600798 603890 605026 606266 612079 620245 635834 669080 671465 686807 700975 701192 738503 739985 743890 744968 748690 750893 757277 766612 769990 775172 775855 776940 784279 784804 786525 787488 788860 788946 791501 791916 794375 795988 801409 803046 803524 806789 806952 818532 823607 824121 826571 ] |
||||||||||||||||||||||||||||||
|
14.98 ms (6.12%) |
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 686807 620245 612079 795988 806952 748690 769990 739985 750893 775172 788946 459519 572697 788860 826571 449893 474778 524540 555263 557969 542706 700975 591355 744968 635834 468369 399176 435356 521220 784279 701192 458438 467952 544120 549850 433351 421815 421885 448955 457455 460226 421817 433240 469372 421870 461843 516478 523832 538003 494327 494967 500796 502813 524486 433375 522992 516226 595483 435747 824121 818532 823607 479669 532932 582339 559737 587158 787488 791501 757277 766612 791916 794375 806789 483654 485057 465385 473511 457980 524497 546955 549849 550672 671465 669080 549846 606266 600798 605026 786525 775855 801409 803524 743890 784804 738503 603890 776940 803046 469389 422152 440979 471407 400816 421847 433372 449692 516712 517711 538022 538970 518807 493174 507003 495222 495227 520861 391592 397918 432650 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.93%) |
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 391592 397918 399176 400816 421815 421817 421847 421870 421885 422152 432650 433240 433351 433372 433375 435356 435747 440979 448955 449692 449893 457455 457980 458438 459519 460226 461843 465385 467952 468369 469372 469389 471407 473511 474778 479669 483654 485057 493174 494327 494967 495222 495227 500796 502813 507003 516226 516478 516712 517711 518807 520861 521220 522992 523832 524486 524497 524540 532932 538003 538022 538970 542706 544120 546955 549846 549849 549850 550672 555263 557969 559737 572697 582339 587158 591355 595483 600798 603890 605026 606266 612079 620245 635834 669080 671465 686807 700975 701192 738503 739985 743890 744968 748690 750893 757277 766612 769990 775172 775855 776940 784279 784804 786525 787488 788860 788946 791501 791916 794375 795988 801409 803046 803524 806789 806952 818532 823607 824121 826571 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom anal homemade"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom анал домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.63%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom анал домашн любительск"
]
|
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.