Query Metrics
7
Database Queries
7
Different statements
147.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.62 ms (84.39%) |
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 433269 440801 442975 444708 450122 452421 454548 457443 457852 460016 462605 463790 465385 465567 466138 466869 468355 472611 472652 473949 483644 488464 489847 490212 492293 493174 493681 495059 495222 498454 507245 511257 513194 514007 514445 516043 516485 517711 517723 523836 523842 526516 526526 531992 538007 539372 542986 543983 544878 546453 547420 549846 555048 555062 555142 555334 555425 557244 558914 561447 563025 563090 564294 564301 566767 567683 571103 583539 588393 603890 605026 609825 612989 629256 644447 655186 657159 680284 705358 711728 714466 716057 717085 718119 720888 724523 726242 726934 729074 731084 733073 734440 734456 743934 746454 747095 756666 759571 761596 761598 765792 777953 778133 778215 782029 784303 784315 787479 792631 796184 797178 798801 800697 800712 802056 805736 812973 817747 826659 827632 ] |
||||||||||||||||||||||||||||||
|
13.15 ms (8.90%) |
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 472611 561447 555334 558914 792631 796184 761598 784303 609825 462605 452421 457443 468355 513194 516485 523836 498454 514007 526516 523842 490212 547420 543983 567683 655186 612989 761596 714466 511257 454548 460016 465385 488464 457852 516043 539372 557244 563025 549846 555048 555062 555142 605026 603890 517711 489847 493174 517723 526526 495222 514445 538007 733073 747095 726242 729074 782029 802056 466869 657159 680284 711728 583539 588393 629256 472652 798801 759571 718119 800712 444708 563090 827632 720888 778133 743934 756666 724523 778215 492293 450122 442975 784315 433269 463790 507245 531992 546453 705358 644447 717085 466138 777953 493681 495059 542986 566767 544878 564294 564301 765792 571103 483644 440801 826659 817747 465567 473949 555425 716057 800697 812973 734456 787479 797178 805736 734440 726934 746454 731084 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.88%) |
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 433269 440801 442975 444708 450122 452421 454548 457443 457852 460016 462605 463790 465385 465567 466138 466869 468355 472611 472652 473949 483644 488464 489847 490212 492293 493174 493681 495059 495222 498454 507245 511257 513194 514007 514445 516043 516485 517711 517723 523836 523842 526516 526526 531992 538007 539372 542986 543983 544878 546453 547420 549846 555048 555062 555142 555334 555425 557244 558914 561447 563025 563090 564294 564301 566767 567683 571103 583539 588393 603890 605026 609825 612989 629256 644447 655186 657159 680284 705358 711728 714466 716057 717085 718119 720888 724523 726242 726934 729074 731084 733073 734440 734456 743934 746454 747095 756666 759571 761596 761598 765792 777953 778133 778215 782029 784303 784315 787479 792631 796184 797178 798801 800697 800712 802056 805736 812973 817747 826659 827632 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелые мамки домашнее"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин мам женщин домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.02%) |
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.