Query Metrics
7
Database Queries
7
Different statements
173.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.86 ms (81.21%) |
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 382105 391583 400945 412609 418893 426634 426868 427737 432413 432508 438369 443070 444987 445007 446604 447551 448306 449829 452557 452769 454159 455114 455190 455406 455971 456738 459499 461013 463725 464135 464548 464753 465154 467016 469164 470145 470208 470737 471053 473679 477862 478304 478390 479148 480668 482695 489759 490339 491103 491320 492841 494400 494418 495182 496682 497034 497319 499177 500157 500437 501801 503383 505878 507452 508563 509060 512165 517121 518789 520000 521170 524507 525389 528057 528655 545630 552209 552373 553248 555750 555790 558610 559012 559539 559702 564809 565019 565328 567309 570213 570288 570328 570586 570614 570618 570628 570674 571902 571904 571909 572107 572155 572381 572992 573614 573678 573692 574628 574767 576305 579215 594638 597811 598466 598749 661410 680102 814309 816755 817608 ] |
||||||||||||||||||||||||||||||
|
22.20 ms (12.80%) |
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 574628 565019 579215 594638 597811 598466 427737 432413 432508 455190 456738 464548 469164 471053 478304 478390 480668 382105 412609 446604 452557 467016 473679 479148 391583 448306 452769 455114 455971 470145 470208 470737 400945 418893 438369 443070 444987 449829 455406 461013 463725 464135 464753 447551 454159 459499 465154 477862 500157 500437 501801 507452 518789 491320 492841 494400 495182 503383 508563 521170 525389 528057 491103 496682 509060 489759 490339 494418 497034 497319 499177 505878 512165 524507 598749 426868 445007 426634 816755 814309 817608 482695 520000 528655 517121 553248 558610 559539 564809 570674 571904 571909 573614 552209 559012 559702 565328 570213 570288 570328 570614 570618 572107 572381 573678 573692 545630 552373 555750 555790 567309 570586 570628 571902 572155 572992 574767 576305 661410 680102 ] |
||||||||||||||||||||||||||||||
|
3.64 ms (2.10%) |
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 382105 391583 400945 412609 418893 426634 426868 427737 432413 432508 438369 443070 444987 445007 446604 447551 448306 449829 452557 452769 454159 455114 455190 455406 455971 456738 459499 461013 463725 464135 464548 464753 465154 467016 469164 470145 470208 470737 471053 473679 477862 478304 478390 479148 480668 482695 489759 490339 491103 491320 492841 494400 494418 495182 496682 497034 497319 499177 500157 500437 501801 503383 505878 507452 508563 509060 512165 517121 518789 520000 521170 524507 525389 528057 528655 545630 552209 552373 553248 555750 555790 558610 559012 559539 559702 564809 565019 565328 567309 570213 570288 570328 570586 570614 570618 570628 570674 571902 571904 571909 572107 572155 572381 572992 573614 573678 573692 574628 574767 576305 579215 594638 597811 598466 598749 661410 680102 814309 816755 817608 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sexy"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск sexy"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск sexy"
]
|
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.