Query Metrics
7
Database Queries
7
Different statements
157.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.05 ms (85.34%) |
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 2808 191199 382359 388228 390455 394173 396048 396314 396534 416020 421009 421745 427432 428083 428920 432381 441662 443925 449894 453989 455965 455978 456130 457664 460396 460864 461902 464035 464407 466655 467119 469269 470866 471654 472159 472580 473334 474226 475826 475839 478148 479083 482326 485694 485952 489169 490813 497906 503020 507829 507834 508705 510229 514339 514657 516574 517121 517617 517638 519678 525130 525301 526684 527842 528460 531718 535050 535698 536887 537122 538949 544552 544752 545679 546517 548907 549250 555027 555203 555448 558903 559441 560686 561567 563827 568594 569811 572287 572703 574756 575302 578701 580953 583572 584773 587554 587619 588662 588804 592388 596449 599152 604644 606223 607286 607697 621492 622309 624986 665889 674269 687506 690139 691178 701554 719642 784983 814992 827199 ] |
||||||||||||||||||||||||||||||
|
13.60 ms (8.66%) |
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 428920 460396 473334 466655 517617 510229 510295 536887 517638 535050 549250 558903 578701 548907 559441 561567 575302 544752 555027 604644 607697 621492 592388 588804 455978 470866 471654 443925 460864 514657 516574 519678 527842 485952 497906 507829 191199 432381 441662 535698 449894 453989 455965 475826 456130 457664 485694 464035 467119 525301 517121 568594 690139 665889 555203 555448 572287 587554 606223 587619 784983 469269 382359 394173 421745 474226 396534 428083 396048 427432 475839 421009 478148 508705 526684 528460 489169 514339 525130 490813 827199 607286 2808 537122 624986 482326 388228 390455 396314 416020 461902 538949 472159 563827 574756 674269 583572 599152 596449 464407 479083 507834 814992 472580 503020 531718 580953 544552 545679 546517 560686 569811 584773 691178 701554 719642 687506 572703 622309 588662 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.72%) |
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 2808 191199 382359 388228 390455 394173 396048 396314 396534 416020 421009 421745 427432 428083 428920 432381 441662 443925 449894 453989 455965 455978 456130 457664 460396 460864 461902 464035 464407 466655 467119 469269 470866 471654 472159 472580 473334 474226 475826 475839 478148 479083 482326 485694 485952 489169 490813 497906 503020 507829 507834 508705 510229 514339 514657 516574 517121 517617 517638 519678 525130 525301 526684 527842 528460 531718 535050 535698 536887 537122 538949 544552 544752 545679 546517 548907 549250 555027 555203 555448 558903 559441 560686 561567 563827 568594 569811 572287 572703 574756 575302 578701 580953 583572 584773 587554 587619 588662 588804 592388 596449 599152 604644 606223 607286 607697 621492 622309 624986 665889 674269 687506 690139 691178 701554 719642 784983 814992 827199 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женщин наездниц поз"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"женщин наездниц поз"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"женщин сверху"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.97%) |
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.