Query Metrics
7
Database Queries
7
Different statements
164.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.38 ms (84.80%) |
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 389273 393752 401501 406689 411513 412881 415360 417989 418454 420111 427971 429182 430320 434561 434810 435318 437963 438995 442379 448198 448507 451867 452750 456060 456454 465735 465761 465796 466809 467004 467565 467796 480133 480438 484312 485552 486101 488004 488060 488134 489421 491110 496042 496870 496971 503488 506142 507309 511724 516270 518901 521653 521714 523578 523658 523668 525262 525941 526428 526926 527467 530117 540805 549433 552941 553261 554231 555688 558325 565569 574578 579177 579198 585266 588094 588475 588724 596514 598733 602927 607117 613787 614588 615042 615150 616995 629515 633166 672289 699551 700509 706936 716563 718468 720724 721883 722890 731468 739559 745305 746117 747186 747219 748895 749931 759691 765178 770062 775402 776138 778267 780467 781615 788407 790058 790706 796259 799300 809485 816782 ] |
||||||||||||||||||||||||||||||
|
14.93 ms (9.08%) |
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 790706 748895 629515 778267 781615 816782 775402 747186 456060 521714 553261 615150 616995 799300 731468 615042 780467 411513 739559 790058 417989 438995 770062 429182 722890 465796 549433 716563 718468 588475 747219 765178 796259 467796 480133 496971 401501 418454 448198 484312 489421 530117 485552 598733 602927 480438 467565 527467 706936 721883 700509 776138 720724 465761 466809 749931 699551 558325 430320 745305 442379 746117 523668 435318 465735 579177 579198 672289 607117 809485 434810 488134 456454 554231 614588 420111 540805 406689 596514 452750 412881 788407 488060 585266 389273 486101 496042 565569 427971 488004 555688 613787 448507 588094 393752 503488 518901 523658 574578 521653 523578 437963 467004 526926 552941 415360 451867 759691 434561 511724 525262 516270 526428 491110 496870 507309 506142 525941 588724 633166 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.87%) |
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 389273 393752 401501 406689 411513 412881 415360 417989 418454 420111 427971 429182 430320 434561 434810 435318 437963 438995 442379 448198 448507 451867 452750 456060 456454 465735 465761 465796 466809 467004 467565 467796 480133 480438 484312 485552 486101 488004 488060 488134 489421 491110 496042 496870 496971 503488 506142 507309 511724 516270 518901 521653 521714 523578 523658 523668 525262 525941 526428 526926 527467 530117 540805 549433 552941 553261 554231 555688 558325 565569 574578 579177 579198 585266 588094 588475 588724 596514 598733 602927 607117 613787 614588 615042 615150 616995 629515 633166 672289 699551 700509 706936 716563 718468 720724 721883 722890 731468 739559 745305 746117 747186 747219 748895 749931 759691 765178 770062 775402 776138 778267 780467 781615 788407 790058 790706 796259 799300 809485 816782 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс tongue"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob tongue"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс tongue"
]
|
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.