Query Metrics
7
Database Queries
7
Different statements
199.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.12 ms (87.10%) |
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 207540 382723 387396 395182 396911 432580 433322 441760 445423 451222 451336 451853 455494 463015 463360 465504 475849 477795 480712 497748 498297 498550 500186 505093 508226 509009 513382 520083 520936 521696 525661 527190 535405 541999 542087 544957 546571 556677 559188 568047 577087 577661 583027 584431 584917 589549 590129 592110 592276 592652 594443 595318 595358 596272 596632 598448 599741 602251 607697 614516 618852 621040 621056 621500 626104 628289 631604 632143 635022 635846 643201 643542 653349 659199 663307 663749 668601 668824 668825 690002 705493 705504 705870 707711 712475 717514 724002 724113 725423 725429 728657 729179 741133 741155 743043 746633 746905 747737 749475 768647 769141 795214 800910 801146 813184 818150 823755 823830 823858 824435 824478 825810 826161 828456 828605 828631 828669 828809 ] |
||||||||||||||||||||||||||||||
|
14.65 ms (7.33%) |
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 498297 508226 527190 505093 521696 475849 568047 584431 542087 559188 583027 584917 541999 546571 556677 577661 712475 653349 659199 663749 596632 589549 592652 607697 631604 635022 596272 598448 614516 618852 643542 590129 592276 594443 595318 595358 621040 621056 632143 643201 728657 813184 602251 626104 628289 717514 463360 465504 480712 441760 432580 433322 445423 477795 451336 455494 451222 451853 463015 520083 498550 500186 509009 525661 497748 520936 826161 823830 823858 828605 828456 795214 747737 577087 395182 513382 725429 769141 800910 725423 818150 824478 599741 382723 825810 823755 824435 828669 828631 592110 724002 743043 801146 768647 741133 387396 535405 544957 668824 707711 705504 663307 668825 621500 724113 705870 396911 668601 635846 741155 746905 207540 690002 705493 749475 729179 730401 746633 826537 828809 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.57%) |
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 207540 382723 387396 395182 396911 432580 433322 441760 445423 451222 451336 451853 455494 463015 463360 465504 475849 477795 480712 497748 498297 498550 500186 505093 508226 509009 513382 520083 520936 521696 525661 527190 535405 541999 542087 544957 546571 556677 559188 568047 577087 577661 583027 584431 584917 589549 590129 592110 592276 592652 594443 595318 595358 596272 596632 598448 599741 602251 607697 614516 618852 621040 621056 621500 626104 628289 631604 632143 635022 635846 643201 643542 653349 659199 663307 663749 668601 668824 668825 690002 705493 705504 705870 707711 712475 717514 724002 724113 725423 725429 728657 729179 741133 741155 743043 746633 746905 747737 749475 768647 769141 795214 800910 801146 813184 818150 823755 823830 823858 824435 824478 825810 826161 828456 828605 828631 828669 828809 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding жен"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding wife"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding жен"
]
|
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.