Query Metrics
7
Database Queries
7
Different statements
211.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.63 ms (85.02%) |
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 395738 396321 399700 400196 404273 404953 405145 405188 407148 407156 407414 407549 407895 408467 409506 411415 411751 425043 425622 426203 430095 430810 432807 433669 435700 439699 440619 447464 460609 462488 464329 464395 466213 467523 468760 469509 472124 478546 480372 480526 480782 481341 481844 482101 482355 485037 488011 490894 492099 493224 494724 494842 497537 499802 499814 502304 506348 508474 508525 510251 510887 511160 511369 511517 511568 514926 518750 518948 519927 521206 522673 524296 531512 535264 543440 556320 563844 565467 572038 582024 590861 596147 616097 630766 633130 640022 640721 644373 644748 650844 674780 677279 681478 681647 681833 684910 685682 687507 688041 688050 688548 698284 711893 712694 717852 718798 719343 721617 731678 753990 784152 788604 790218 802109 805420 805558 807363 807386 807399 807492 ] |
||||||||||||||||||||||||||||||
|
22.20 ms (10.51%) |
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 468760 508474 524296 494724 518948 535264 506348 511568 518750 521206 514926 522673 531512 462488 482101 572038 543440 556320 563844 674780 677279 681833 685682 718798 721617 650844 681478 684910 687507 688050 688548 711893 717852 681647 688041 698284 712694 719343 565467 582024 640022 640721 644373 590861 630766 644748 596147 616097 805558 807363 784152 790218 802109 805420 807386 807492 753990 788604 807399 731678 633130 396321 399700 400196 404273 407414 407549 407895 409506 430810 432807 433669 440619 464395 469509 480526 480782 482355 395738 411751 439699 460609 466213 478546 480372 404953 407156 425043 425622 430095 435700 464329 472124 405145 405188 426203 407148 408467 411415 447464 467523 481341 481844 499802 499814 510251 510887 511160 511369 511517 519927 488011 490894 494842 508525 485037 492099 493224 497537 502304 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.12%) |
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 395738 396321 399700 400196 404273 404953 405145 405188 407148 407156 407414 407549 407895 408467 409506 411415 411751 425043 425622 426203 430095 430810 432807 433669 435700 439699 440619 447464 460609 462488 464329 464395 466213 467523 468760 469509 472124 478546 480372 480526 480782 481341 481844 482101 482355 485037 488011 490894 492099 493224 494724 494842 497537 499802 499814 502304 506348 508474 508525 510251 510887 511160 511369 511517 511568 514926 518750 518948 519927 521206 522673 524296 531512 535264 543440 556320 563844 565467 572038 582024 590861 596147 616097 630766 633130 640022 640721 644373 644748 650844 674780 677279 681478 681647 681833 684910 685682 687507 688041 688050 688548 698284 711893 712694 717852 718798 719343 721617 731678 753990 784152 788604 790218 802109 805420 805558 807363 807386 807399 807492 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful mom old"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.77%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая mom old"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая mom old"
]
|
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.