Query Metrics
7
Database Queries
7
Different statements
174.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.24 ms (84.61%) |
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 44495 98749 285231 385296 387203 394772 395516 402260 405252 415602 416184 417914 419539 421065 426378 426536 426765 428858 429383 429441 430023 433217 433359 435930 439519 439746 442233 444044 444083 445596 446275 450315 450811 451849 452297 453494 453660 454911 456612 459158 459661 460071 460794 462462 462656 463877 464857 465169 465485 465593 466025 466208 466897 467402 467661 467952 469832 470523 472336 472948 473846 474457 474975 475852 475883 476088 477373 477963 477981 478155 478525 479247 480399 480515 483022 484057 484521 484611 484668 484672 484737 485803 485835 490166 491209 491962 493807 497793 499487 499788 501487 501499 502775 504091 506779 509376 512084 513857 515370 516178 517239 517833 517874 518128 518589 520283 522501 524200 525095 527444 528925 531423 535934 536446 554927 555120 565360 580022 586652 590633 ] |
||||||||||||||||||||||||||||||
|
16.71 ms (9.60%) |
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 522501 446275 466897 501487 491209 402260 421065 459158 474457 428858 480515 465593 477963 484611 535934 490166 484672 474975 456612 554927 555120 419539 480399 467402 475883 478525 433359 426378 439746 452297 466025 477981 472336 483022 517874 531423 497793 515370 453494 395516 466208 462462 504091 484737 501499 484668 536446 385296 429383 426536 464857 499788 590633 426765 459661 517833 98749 387203 485835 465485 394772 506779 44495 429441 433217 435930 439519 444083 442233 453660 460794 467661 469832 451849 454911 484521 450315 450811 465169 467952 473846 509376 513857 460071 472948 580022 565360 586652 415602 462656 476088 405252 463877 475852 285231 430023 444044 470523 478155 479247 416184 445596 477373 417914 516178 524200 525095 527444 517239 518589 520283 528925 484057 485803 493807 499487 502775 512084 518128 491962 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.79%) |
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 44495 98749 285231 385296 387203 394772 395516 402260 405252 415602 416184 417914 419539 421065 426378 426536 426765 428858 429383 429441 430023 433217 433359 435930 439519 439746 442233 444044 444083 445596 446275 450315 450811 451849 452297 453494 453660 454911 456612 459158 459661 460071 460794 462462 462656 463877 464857 465169 465485 465593 466025 466208 466897 467402 467661 467952 469832 470523 472336 472948 473846 474457 474975 475852 475883 476088 477373 477963 477981 478155 478525 479247 480399 480515 483022 484057 484521 484611 484668 484672 484737 485803 485835 490166 491209 491962 493807 497793 499487 499788 501487 501499 502775 504091 506779 509376 512084 513857 515370 516178 517239 517833 517874 518128 518589 520283 522501 524200 525095 527444 528925 531423 535934 536446 554927 555120 565360 580022 586652 590633 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"потрахал маму"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"потраха мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"потраха мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.