Query Metrics
7
Database Queries
7
Different statements
163.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.36 ms (85.85%) |
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 392109 394566 412941 423426 425440 427065 428516 436965 440563 447259 459520 461186 466761 471506 472306 475942 476440 480591 484352 489591 495410 496543 497443 499950 500230 507779 518952 529917 536959 541797 558220 558785 563312 565657 565865 566376 577204 577445 579332 579557 579813 581190 583534 588781 594589 600905 603613 604952 605597 605604 605704 606889 608415 613311 615367 615945 618201 618753 619489 625369 633860 633992 636066 637613 639366 642260 644229 650867 653612 663545 666504 672707 679405 682243 684977 685072 685559 689120 690117 695784 697735 701472 704704 705742 707144 708696 712651 713004 720163 722266 722506 726248 727330 729268 740051 759891 779199 781739 787895 789109 789172 791410 793203 796550 799776 801065 801249 802022 803158 804537 806715 808503 808633 809693 813118 813208 815189 819416 824420 824528 ] |
||||||||||||||||||||||||||||||
|
12.16 ms (7.43%) |
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 541797 579332 566376 653612 650867 684977 565865 577445 633860 729268 801065 726248 603613 803158 466761 475942 425440 412941 500230 496543 499950 423426 428516 476440 497443 529917 461186 565657 579557 689120 558220 615367 605597 608415 615945 633992 588781 806715 808503 809693 759891 606889 472306 459520 427065 447259 489591 394566 392109 436965 440563 819416 824528 815189 824420 480591 484352 507779 518952 495410 536959 471506 563312 583534 577204 581190 558785 579813 666504 672707 685072 697735 712651 720163 722266 682243 695784 701472 705742 708696 722506 663545 679405 685559 690117 704704 707144 713004 618201 637613 639366 644229 594589 613311 642260 600905 604952 605604 625369 605704 618753 619489 636066 779199 781739 787895 799776 802022 804537 789109 789172 791410 793203 796550 801249 808633 813118 813208 727330 740051 ] |
||||||||||||||||||||||||||||||
|
4.09 ms (2.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 392109 394566 412941 423426 425440 427065 428516 436965 440563 447259 459520 461186 466761 471506 472306 475942 476440 480591 484352 489591 495410 496543 497443 499950 500230 507779 518952 529917 536959 541797 558220 558785 563312 565657 565865 566376 577204 577445 579332 579557 579813 581190 583534 588781 594589 600905 603613 604952 605597 605604 605704 606889 608415 613311 615367 615945 618201 618753 619489 625369 633860 633992 636066 637613 639366 642260 644229 650867 653612 663545 666504 672707 679405 682243 684977 685072 685559 689120 690117 695784 697735 701472 704704 705742 707144 708696 712651 713004 720163 722266 722506 726248 727330 729268 740051 759891 779199 781739 787895 789109 789172 791410 793203 796550 799776 801065 801249 802022 803158 804537 806715 808503 808633 809693 813118 813208 815189 819416 824420 824528 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass husband"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп husband"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп husband"
]
|
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.