Query Metrics
7
Database Queries
7
Different statements
181.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.67 ms (87.27%) |
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 391873 394586 397899 398552 398773 430526 431516 437708 441952 476244 479071 482132 505625 505803 506321 508882 511254 512561 512949 514069 516332 522286 524169 526082 526122 527386 531869 532221 534129 534542 534544 534545 534551 535724 536460 538997 540100 547856 548474 566392 575566 576981 580055 583472 583712 583716 585963 586294 587407 589185 598107 606405 615312 616716 616795 626439 639184 653475 654078 656924 657244 666856 667981 673923 674467 677155 690609 692453 693628 694142 697839 708144 710096 713454 718983 720202 720207 720833 723606 723660 724292 726896 727325 728146 728493 730329 730415 733816 742286 742356 743497 744033 750359 750637 751309 761688 761781 765221 765236 768186 773553 775934 776248 777750 781300 784054 785503 785603 787379 788580 791844 801311 804697 806397 806514 808101 811221 813275 814423 827326 ] |
||||||||||||||||||||||||||||||
|
14.05 ms (7.72%) |
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 761688 785603 730329 751309 726896 743497 787379 516332 508882 598107 512561 615312 398552 814423 506321 534129 534544 547856 697839 694142 720202 616716 616795 804697 811221 801311 784054 806397 808101 730415 727325 728146 765236 639184 718983 397899 391873 437708 482132 713454 512949 540100 576981 657244 720833 693628 505803 505625 476244 514069 430526 827326 526122 653475 566392 777750 788580 761781 524169 511254 538997 654078 733816 394586 398773 441952 431516 723606 723660 527386 534545 536460 532221 534551 535724 534542 522286 526082 531869 479071 548474 575566 583472 583712 583716 692453 710096 666856 667981 674467 677155 720207 656924 673923 690609 708144 580055 586294 587407 585963 589185 626439 606405 775934 776248 806514 742286 744033 750637 773553 781300 785503 791844 813275 728493 765221 768186 724292 742356 750359 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.51%) |
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 391873 394586 397899 398552 398773 430526 431516 437708 441952 476244 479071 482132 505625 505803 506321 508882 511254 512561 512949 514069 516332 522286 524169 526082 526122 527386 531869 532221 534129 534542 534544 534545 534551 535724 536460 538997 540100 547856 548474 566392 575566 576981 580055 583472 583712 583716 585963 586294 587407 589185 598107 606405 615312 616716 616795 626439 639184 653475 654078 656924 657244 666856 667981 673923 674467 677155 690609 692453 693628 694142 697839 708144 710096 713454 718983 720202 720207 720833 723606 723660 724292 726896 727325 728146 728493 730329 730415 733816 742286 742356 743497 744033 750359 750637 751309 761688 761781 765221 765236 768186 773553 775934 776248 777750 781300 784054 785503 785603 787379 788580 791844 801311 804697 806397 806514 808101 811221 813275 814423 827326 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск double penetration"
]
|
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.