Query Metrics
7
Database Queries
7
Different statements
173.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.88 ms (83.50%) |
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 145635 153723 299335 338181 366284 382120 382669 386985 390220 391251 415356 421388 421404 427345 444449 445834 446140 446975 448902 450520 451517 451688 452275 452954 454019 454764 456371 456547 457035 457128 457567 460083 462119 465002 465559 466193 468291 469280 470384 471105 473440 475729 477217 477222 480931 484251 484254 484962 485863 487646 488783 493732 495308 495543 495554 496049 496345 496878 497063 497594 498685 499359 499940 500794 501118 503651 506683 506694 507837 509246 509451 509458 509984 511862 514023 515966 516440 516931 520183 520848 528575 531021 545971 548179 550151 557988 558172 564502 566752 567484 567727 568206 568640 581743 590192 598448 598690 600822 602251 602255 632920 641753 648489 648880 669552 671536 672779 700826 705825 716526 730962 742411 743692 753198 776167 781621 791602 794063 801398 803827 ] |
||||||||||||||||||||||||||||||
|
18.36 ms (10.58%) |
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 465002 499940 496878 485863 648489 669552 672779 671536 548179 550151 567484 456547 497594 498685 528575 338181 801398 366284 386985 557988 632920 600822 598448 602255 390220 391251 475729 477222 568206 803827 445834 466193 450520 484254 497063 484962 495554 415356 460083 753198 648880 514023 471105 516440 454764 452275 641753 495308 520183 568640 602251 382669 427345 516931 730962 507837 503651 451517 480931 558172 581743 487646 470384 506694 501118 468291 567727 564502 700826 566752 456371 469280 499359 493732 509246 454019 457128 484251 473440 477217 496345 509451 520848 506683 511862 531021 496049 515966 465559 545971 716526 598690 590192 794063 791602 742411 705825 781621 451688 446975 457035 448902 382120 444449 452954 509458 500794 509984 488783 495543 145635 153723 299335 421388 421404 457567 446140 462119 776167 743692 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.63%) |
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 145635 153723 299335 338181 366284 382120 382669 386985 390220 391251 415356 421388 421404 427345 444449 445834 446140 446975 448902 450520 451517 451688 452275 452954 454019 454764 456371 456547 457035 457128 457567 460083 462119 465002 465559 466193 468291 469280 470384 471105 473440 475729 477217 477222 480931 484251 484254 484962 485863 487646 488783 493732 495308 495543 495554 496049 496345 496878 497063 497594 498685 499359 499940 500794 501118 503651 506683 506694 507837 509246 509451 509458 509984 511862 514023 515966 516440 516931 520183 520848 528575 531021 545971 548179 550151 557988 558172 564502 566752 567484 567727 568206 568640 581743 590192 598448 598690 600822 602251 602255 632920 641753 648489 648880 669552 671536 672779 700826 705825 716526 730962 742411 743692 753198 776167 781621 791602 794063 801398 803827 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam homemade"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.01%) |
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.