Query Metrics
7
Database Queries
7
Different statements
194.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.96 ms (85.46%) |
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 393338 397331 418436 418528 418833 419559 420206 422633 463118 473037 477034 477776 480439 484980 491595 493184 497543 498254 502230 511514 511648 515170 515199 516218 518607 519852 525296 526320 527074 529664 535581 539790 540747 540992 541840 544686 545731 552690 556037 558072 560957 560970 569677 571724 575161 575380 579389 580383 583180 583536 585096 595192 605420 605462 605669 608231 619612 619852 620318 621410 621412 622465 626206 628126 633449 635220 638137 640813 642928 655298 666876 669281 671724 677874 686210 686749 693897 693957 694715 696140 696498 696556 698708 700846 701548 711337 711555 711946 714090 715792 716529 717906 720193 727611 727633 740399 740407 740900 740902 746335 753960 759675 762721 763303 764342 764947 768914 772449 784393 784608 786898 789079 789457 793586 795571 796644 801078 802405 811975 812105 ] |
||||||||||||||||||||||||||||||
|
18.61 ms (9.58%) |
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 579389 556037 529664 545731 714090 716529 720193 795571 784393 793586 801078 764947 759675 768914 583536 552690 655298 669281 686210 700846 686749 696140 605669 642928 762721 796644 727611 622465 477034 558072 540747 740900 740407 491595 585096 605462 511648 583180 789457 740902 812105 698708 786898 498254 518607 535581 621412 628126 635220 502230 540992 541840 784608 544686 640813 393338 484980 571724 575161 626206 595192 511514 666876 621410 539790 701548 711337 638137 418436 419559 560957 693897 693957 711946 696498 696556 715792 671724 677874 560970 802405 772449 740399 764342 789079 515170 569677 480439 493184 422633 473037 420206 633449 463118 516218 519852 525296 526320 575380 580383 711555 694715 608231 620318 605420 811975 746335 763303 727633 619852 397331 418528 418833 497543 527074 717906 515199 477776 619612 753960 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.50%) |
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 393338 397331 418436 418528 418833 419559 420206 422633 463118 473037 477034 477776 480439 484980 491595 493184 497543 498254 502230 511514 511648 515170 515199 516218 518607 519852 525296 526320 527074 529664 535581 539790 540747 540992 541840 544686 545731 552690 556037 558072 560957 560970 569677 571724 575161 575380 579389 580383 583180 583536 585096 595192 605420 605462 605669 608231 619612 619852 620318 621410 621412 622465 626206 628126 633449 635220 638137 640813 642928 655298 666876 669281 671724 677874 686210 686749 693897 693957 694715 696140 696498 696556 698708 700846 701548 711337 711555 711946 714090 715792 716529 717906 720193 727611 727633 740399 740407 740900 740902 746335 753960 759675 762721 763303 764342 764947 768914 772449 784393 784608 786898 789079 789457 793586 795571 796644 801078 802405 811975 812105 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small little girl"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая little девушк"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая little девушк"
]
|
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.