Query Metrics
7
Database Queries
7
Different statements
163.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.10 ms (85.05%) |
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 372346 391567 393937 400096 401803 403272 404121 404390 412914 416446 417021 417940 418466 419658 420248 421027 423919 425160 426153 427857 430267 432547 433063 436529 437914 443010 443554 444244 444257 444873 445329 446220 446611 447277 449660 452286 452496 458038 462078 462556 463628 468106 471596 473345 473430 473715 476012 482080 488496 492773 493508 498872 502689 503725 505876 508345 509010 510321 511983 512954 517330 520703 529109 548701 557523 566866 574522 577638 584576 584837 586310 592323 594415 599306 604346 604413 625100 628258 642097 670820 687432 691170 691472 704644 707233 712380 712959 714235 717853 720136 723628 730928 732822 740009 742005 744381 752565 752603 756331 757564 761611 761628 765545 766849 766969 769418 772729 774038 779689 782187 786988 790464 792735 794917 804859 805643 807190 813277 816625 827590 ] |
||||||||||||||||||||||||||||||
|
15.14 ms (9.26%) |
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 557523 418466 463628 416446 436529 403272 427857 508345 502689 604413 510321 372346 712380 599306 642097 730928 761628 765545 807190 757564 761611 804859 391567 827590 509010 720136 444244 473715 443554 447277 446220 473430 444873 468106 471596 437914 446611 420248 473345 449660 503725 488496 423919 492773 452286 412914 594415 417940 433063 452496 432547 520703 670820 401803 404390 816625 498872 584837 577638 707233 717853 586310 740009 790464 794917 732822 756331 752565 786988 393937 404121 419658 574522 529109 476012 517330 462556 604346 493508 443010 566866 548701 687432 691170 691472 712959 714235 584576 628258 592323 625100 813277 779689 782187 744381 752603 769418 772729 766969 742005 774038 704644 792735 805643 400096 458038 505876 482080 444257 421027 426153 425160 445329 462078 512954 430267 766849 511983 417021 723628 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.84%) |
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 372346 391567 393937 400096 401803 403272 404121 404390 412914 416446 417021 417940 418466 419658 420248 421027 423919 425160 426153 427857 430267 432547 433063 436529 437914 443010 443554 444244 444257 444873 445329 446220 446611 447277 449660 452286 452496 458038 462078 462556 463628 468106 471596 473345 473430 473715 476012 482080 488496 492773 493508 498872 502689 503725 505876 508345 509010 510321 511983 512954 517330 520703 529109 548701 557523 566866 574522 577638 584576 584837 586310 592323 594415 599306 604346 604413 625100 628258 642097 670820 687432 691170 691472 704644 707233 712380 712959 714235 717853 720136 723628 730928 732822 740009 742005 744381 752565 752603 756331 757564 761611 761628 765545 766849 766969 769418 772729 774038 779689 782187 786988 790464 792735 794917 804859 805643 807190 813277 816625 827590 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam teen blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер teen минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер teen минет оральн секс"
]
|
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.