Query Metrics
7
Database Queries
7
Different statements
194.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.09 ms (86.78%) |
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 292790 385189 386297 387759 388344 388365 389618 392493 392558 398507 401614 402563 402576 403252 404385 411542 412790 415757 419225 435521 441068 451299 452662 453208 453823 455214 457109 457935 467987 468327 473473 480680 483887 488514 491334 496162 500094 504634 513815 517799 521019 526291 527258 534136 535661 537630 539784 541902 542886 550456 557969 563632 564049 568291 577609 582736 586711 595229 600183 603277 608273 616014 623898 624067 628755 630460 631637 636116 636259 648279 648463 651735 653479 660788 661674 669543 675630 679243 680476 700039 700357 700359 701000 702525 704017 715156 715377 731835 740561 746546 753053 754758 758734 761564 763776 775636 775715 778926 779019 779546 782086 782139 782904 784775 786851 787161 788433 789477 791764 792338 793693 794413 803605 811519 812180 818173 824056 824105 825448 ] |
||||||||||||||||||||||||||||||
|
14.07 ms (7.22%) |
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 700357 389618 496162 651735 704017 500094 675630 653479 700039 595229 586711 791764 786851 387759 534136 582736 789477 603277 648463 624067 488514 457109 392558 403252 775636 787161 824013 731835 758734 701000 636116 457935 483887 824056 631637 388344 564049 784775 793693 803605 669543 600183 392493 402576 415757 825448 535661 680476 702525 628755 779019 779546 761564 782904 754758 746546 740561 775715 782086 388365 402563 467987 453208 455214 557969 550456 412790 419225 480680 526291 527258 491334 517799 542886 608273 753053 441068 521019 504634 563632 630460 715156 812180 411542 451299 404385 385189 386297 473473 435521 539784 541902 648279 679243 660788 661674 616014 623898 700359 452662 513815 636259 401614 811519 824105 818173 537630 468327 568291 794413 782139 292790 577609 715377 788433 792338 763776 778926 398507 453823 ] |
||||||||||||||||||||||||||||||
|
5.02 ms (2.58%) |
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 292790 385189 386297 387759 388344 388365 389618 392493 392558 398507 401614 402563 402576 403252 404385 411542 412790 415757 419225 435521 441068 451299 452662 453208 453823 455214 457109 457935 467987 468327 473473 480680 483887 488514 491334 496162 500094 504634 513815 517799 521019 526291 527258 534136 535661 537630 539784 541902 542886 550456 557969 563632 564049 568291 577609 582736 586711 595229 600183 603277 608273 616014 623898 624067 628755 630460 631637 636116 636259 648279 648463 651735 653479 660788 661674 669543 675630 679243 680476 700039 700357 700359 701000 702525 704017 715156 715377 731835 740561 746546 753053 754758 758734 761564 763776 775636 775715 778926 779019 779546 782086 782139 782904 784775 786851 787161 788433 789477 791764 792338 793693 794413 803605 811519 812180 818173 824056 824105 825448 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam amateur brunette"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер любительск черноволосая"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер любительск черноволосая"
]
|
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.