Query Metrics
7
Database Queries
7
Different statements
188.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.05 ms (84.59%) |
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 6640 12326 12331 72889 150495 198001 233889 310758 326300 364718 383631 383778 385355 388838 391491 391591 391653 397242 401734 403166 406068 407500 409179 409709 409984 412189 413714 413718 414753 420501 420586 423823 426436 427258 429955 443426 443740 447013 453503 453514 453874 454016 455409 456741 456923 457224 457535 457914 458066 459733 460242 461604 462013 462017 462089 462263 462518 463352 463699 464101 467860 468844 470636 470706 470785 470837 471912 472016 473292 475503 475843 475847 477872 479481 479885 482922 483228 484312 487533 488185 488206 491514 492500 493532 500555 503751 504167 504324 509210 515310 519447 523187 526078 544512 546911 550646 551274 552368 552370 558460 559275 562237 562999 565020 568367 569587 574732 574746 580029 585452 714024 717900 725382 736363 746662 756399 756725 765666 799124 813916 ] |
||||||||||||||||||||||||||||||
|
12.18 ms (6.48%) |
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 482922 565020 756725 397242 326300 388838 457914 453503 484312 447013 467860 470706 461604 580029 550646 562237 574732 391653 401734 443740 464101 470785 198001 463699 479481 488185 483228 491514 383778 799124 407500 409709 409179 504167 569587 423823 462263 552370 462518 459733 765666 443426 454016 385355 717900 456741 475503 523187 493532 562999 462013 470636 475843 412189 475847 756399 544512 383631 420586 12326 457224 457535 462089 515310 455409 233889 391491 463352 519447 427258 413718 470837 453874 552368 458066 714024 746662 364718 403166 473292 546911 558460 585452 420501 460242 551274 310758 725382 574746 391591 409984 471912 472016 426436 413714 479885 414753 6640 150495 500555 406068 456923 488206 736363 12331 468844 492500 503751 568367 559275 477872 72889 462017 453514 429955 509210 504324 526078 813916 487533 ] |
||||||||||||||||||||||||||||||
|
8.33 ms (4.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.53 ms (1.35%) |
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 6640 12326 12331 72889 150495 198001 233889 310758 326300 364718 383631 383778 385355 388838 391491 391591 391653 397242 401734 403166 406068 407500 409179 409709 409984 412189 413714 413718 414753 420501 420586 423823 426436 427258 429955 443426 443740 447013 453503 453514 453874 454016 455409 456741 456923 457224 457535 457914 458066 459733 460242 461604 462013 462017 462089 462263 462518 463352 463699 464101 467860 468844 470636 470706 470785 470837 471912 472016 473292 475503 475843 475847 477872 479481 479885 482922 483228 484312 487533 488185 488206 491514 492500 493532 500555 503751 504167 504324 509210 515310 519447 523187 526078 544512 546911 550646 551274 552368 552370 558460 559275 562237 562999 565020 568367 569587 574732 574746 580029 585452 714024 717900 725382 736363 746662 756399 756725 765666 799124 813916 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy blow job"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.99%) |
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.