Query Metrics
7
Database Queries
7
Different statements
195.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.21 ms (84.89%) |
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 382341 396305 399083 406917 407170 413544 416056 422725 425353 428067 428778 430916 433464 434277 438219 442198 444733 446501 448195 453540 454883 456000 457289 461631 462915 463352 464833 465902 467285 469167 469528 470511 471847 472821 473148 475419 476981 477337 478043 478652 478760 479860 480238 480787 482060 482248 482378 482504 483248 483579 489205 491516 497881 504408 506749 508393 511371 512526 514279 515370 517074 517131 517278 518203 518504 518582 519949 520249 521596 521706 522212 523659 523773 524928 524934 525663 529305 533592 536702 539610 545718 546550 546607 546830 547738 549367 554927 556607 559958 567038 569126 569994 571367 572548 574109 578412 579859 581454 584021 586917 588082 591628 596763 597834 599178 602011 605918 610906 620775 665781 668485 698102 724996 753251 756192 775677 779846 786523 801287 802357 ] |
||||||||||||||||||||||||||||||
|
18.23 ms (9.31%) |
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 665781 569126 571367 597834 586917 786523 801287 756192 698102 399083 438219 442198 469167 469528 407170 457289 476981 479860 480787 482378 454883 472821 473148 478652 416056 444733 511371 518504 523773 489205 506749 508393 533592 483248 504408 517278 520249 524928 529305 497881 514279 517131 525663 602011 448195 522212 524934 428067 539610 536702 546550 668485 779846 753251 775677 471847 413544 462915 545718 554927 605918 425353 465902 478043 428778 446501 422725 482248 519949 521596 518203 523659 517074 515370 518582 433464 406917 430916 461631 470511 480238 512526 521706 463352 482504 483579 491516 572548 581454 547738 556607 578412 546607 546830 549367 567038 559958 569994 574109 579859 584021 591628 596763 599178 620775 588082 610906 802357 724996 382341 453540 464833 467285 475419 478760 396305 434277 456000 477337 482060 ] |
||||||||||||||||||||||||||||||
|
3.86 ms (1.97%) |
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 382341 396305 399083 406917 407170 413544 416056 422725 425353 428067 428778 430916 433464 434277 438219 442198 444733 446501 448195 453540 454883 456000 457289 461631 462915 463352 464833 465902 467285 469167 469528 470511 471847 472821 473148 475419 476981 477337 478043 478652 478760 479860 480238 480787 482060 482248 482378 482504 483248 483579 489205 491516 497881 504408 506749 508393 511371 512526 514279 515370 517074 517131 517278 518203 518504 518582 519949 520249 521596 521706 522212 523659 523773 524928 524934 525663 529305 533592 536702 539610 545718 546550 546607 546830 547738 549367 554927 556607 559958 567038 569126 569994 571367 572548 574109 578412 579859 581454 584021 586917 588082 591628 596763 597834 599178 602011 605918 610906 620775 665781 668485 698102 724996 753251 756192 775677 779846 786523 801287 802357 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother beautiful"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин красивая"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.