Query Metrics
7
Database Queries
7
Different statements
144.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.12 ms (83.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 290366 397568 411183 415874 417334 420517 428742 430369 431090 436639 439102 444180 448642 452791 452878 458867 460351 462377 467110 470034 480206 480454 484953 493271 493849 495140 496725 499931 504078 505798 509988 510547 513646 521559 523751 523885 525466 547480 547483 547486 547489 547809 556335 566863 569594 573270 576943 582538 590778 598580 600087 601546 601789 604969 605129 605199 624298 626597 628104 629108 632920 636156 637503 648455 648594 657478 660385 662026 670442 671070 676476 679051 680423 682926 687299 697839 705312 706359 711480 714235 723368 724961 729905 731511 737578 739946 741157 742005 744389 747155 748504 751727 754589 760471 766825 770386 770404 772578 776883 777659 777921 784744 785814 785851 785856 785972 787507 789771 790162 791012 795431 800697 802029 803120 803133 804802 805366 806514 814965 819235 ] |
||||||||||||||||||||||||||||||
|
13.94 ms (9.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 495140 480454 509988 510547 679051 648594 657478 714235 636156 624298 785814 776883 800697 804802 731511 772578 742005 760471 741157 723368 430369 480206 547486 573270 547483 680423 590778 770404 458867 460351 452791 484953 397568 428742 467110 687299 711480 598580 605129 806514 748504 751727 787507 448642 411183 493271 504078 496725 523751 582538 462377 420517 431090 499931 626597 513646 415874 629108 814965 819235 556335 697839 705312 648455 671070 662026 670442 676476 628104 601546 795431 789771 790162 803120 744389 724961 729905 739946 737578 747155 754589 770386 604969 637503 777659 777921 784744 785851 525466 682926 803133 290366 452878 521559 547809 576943 547489 569594 547480 660385 706359 566863 632920 600087 785856 785972 805366 766825 605199 791012 802029 417334 436639 439102 444180 493849 505798 601789 470034 523885 ] |
||||||||||||||||||||||||||||||
|
2.67 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 290366 397568 411183 415874 417334 420517 428742 430369 431090 436639 439102 444180 448642 452791 452878 458867 460351 462377 467110 470034 480206 480454 484953 493271 493849 495140 496725 499931 504078 505798 509988 510547 513646 521559 523751 523885 525466 547480 547483 547486 547489 547809 556335 566863 569594 573270 576943 582538 590778 598580 600087 601546 601789 604969 605129 605199 624298 626597 628104 629108 632920 636156 637503 648455 648594 657478 660385 662026 670442 671070 676476 679051 680423 682926 687299 697839 705312 706359 711480 714235 723368 724961 729905 731511 737578 739946 741157 742005 744389 747155 748504 751727 754589 760471 766825 770386 770404 772578 776883 777659 777921 784744 785814 785851 785856 785972 787507 789771 790162 791012 795431 800697 802029 803120 803133 804802 805366 806514 814965 819235 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty anal solo"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty анал соло"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty анал соло"
]
|
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.