Query Metrics
7
Database Queries
7
Different statements
150.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.78 ms (83.48%) |
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 90485 150798 151018 188456 382726 401617 415926 418197 418360 418836 420753 429355 434215 434532 437807 438413 443906 446858 447543 448370 452990 456988 457003 466336 467087 467562 468687 468937 473452 474099 474734 477699 482799 484155 491104 512130 517703 521599 525461 531452 533388 534366 536525 544223 545336 547565 551810 552094 557365 557817 558471 561872 565627 570922 572204 572740 577007 577178 586360 600814 601508 603742 613000 618005 630760 633738 648918 650339 651832 662469 663409 674263 674292 680749 685931 693679 693799 695386 701935 709732 710308 715290 716383 735839 738464 741779 743933 745565 747563 749935 758244 758587 761030 765403 765451 765578 766773 768739 769990 770156 771161 773740 774287 774664 777017 777846 780715 782821 787556 788811 791808 792055 794421 794830 797773 801483 807373 814232 814988 821195 ] |
||||||||||||||||||||||||||||||
|
15.16 ms (10.06%) |
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 648918 534366 651832 600814 797773 452990 674263 738464 618005 467087 491104 685931 693679 794421 773740 418360 466336 814988 561872 663409 741779 792055 749935 188456 434532 525461 577178 557817 709732 613000 630760 794830 791808 758587 765451 770156 777017 382726 401617 443906 512130 484155 151018 821195 814232 468687 474734 533388 536525 558471 777846 769990 788811 801483 765403 771161 150798 477699 437807 457003 710308 650339 551810 633738 758244 787556 418197 420753 448370 474099 572204 547565 695386 693799 782821 766773 418836 447543 429355 521599 517703 545336 552094 565627 570922 577007 544223 572740 715290 557365 586360 765578 774664 780715 807373 446858 90485 768739 701935 735839 662469 674292 601508 747563 774287 680749 745565 743933 761030 716383 531452 473452 415926 438413 456988 482799 467562 603742 434215 468937 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.85%) |
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 90485 150798 151018 188456 382726 401617 415926 418197 418360 418836 420753 429355 434215 434532 437807 438413 443906 446858 447543 448370 452990 456988 457003 466336 467087 467562 468687 468937 473452 474099 474734 477699 482799 484155 491104 512130 517703 521599 525461 531452 533388 534366 536525 544223 545336 547565 551810 552094 557365 557817 558471 561872 565627 570922 572204 572740 577007 577178 586360 600814 601508 603742 613000 618005 630760 633738 648918 650339 651832 662469 663409 674263 674292 680749 685931 693679 693799 695386 701935 709732 710308 715290 716383 735839 738464 741779 743933 745565 747563 749935 758244 758587 761030 765403 765451 765578 766773 768739 769990 770156 771161 773740 774287 774664 777017 777846 780715 782821 787556 788811 791808 792055 794421 794830 797773 801483 807373 814232 814988 821195 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural fuck"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.01%) |
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.