Query Metrics
7
Database Queries
7
Different statements
166.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.08 ms (83.51%) |
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 7286 324916 373416 391423 402598 417722 417731 417744 420232 424014 425018 429256 429263 429273 429275 443645 450646 450653 450861 451580 451601 453139 454075 454335 460030 461005 461314 461621 463240 464582 466110 466786 467300 468867 468879 470345 471786 471971 472332 472356 472370 472801 475282 477567 478087 478905 480717 480922 481641 483992 484072 485903 488219 491566 491696 491724 491865 499805 501865 504613 508818 510082 511299 512464 513445 516993 517254 519657 520461 521923 522807 548650 551173 551565 552661 559022 559236 562290 562319 565391 565424 566576 569843 570033 570034 570037 570256 570289 570338 570340 570351 570370 570478 570526 570528 570559 570605 570609 570647 571630 571646 571854 572134 572442 572504 573004 573858 574598 574861 575208 589758 590573 597836 605913 665513 669457 669641 820628 828269 828338 ] |
||||||||||||||||||||||||||||||
|
17.22 ms (10.34%) |
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 548650 574861 575208 551565 572134 570605 574598 472801 464582 391423 402598 450646 450653 463240 461005 466110 471971 417722 425018 451580 491566 510082 488219 828269 461621 665513 597836 417744 429256 471786 483992 559236 565391 566576 589758 424014 443645 481641 472370 478905 429263 480717 472332 511299 513445 516993 491865 501865 521923 491724 508818 828338 324916 7286 477567 571630 570609 570370 573858 669457 551173 571646 454335 451601 470345 475282 512464 517254 468867 565424 570351 571854 572504 570256 570289 559022 562319 570037 570033 570478 417731 468879 429273 472356 504613 522807 491696 590573 453139 450861 478087 420232 499805 519657 520461 820628 669641 605913 373416 429275 466786 485903 454075 480922 484072 460030 461314 467300 570526 570559 572442 562290 569843 570034 570338 570340 570528 570647 573004 552661 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.93%) |
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 7286 324916 373416 391423 402598 417722 417731 417744 420232 424014 425018 429256 429263 429273 429275 443645 450646 450653 450861 451580 451601 453139 454075 454335 460030 461005 461314 461621 463240 464582 466110 466786 467300 468867 468879 470345 471786 471971 472332 472356 472370 472801 475282 477567 478087 478905 480717 480922 481641 483992 484072 485903 488219 491566 491696 491724 491865 499805 501865 504613 508818 510082 511299 512464 513445 516993 517254 519657 520461 521923 522807 548650 551173 551565 552661 559022 559236 562290 562319 565391 565424 566576 569843 570033 570034 570037 570256 570289 570338 570340 570351 570370 570478 570526 570528 570559 570605 570609 570647 571630 571646 571854 572134 572442 572504 573004 573858 574598 574861 575208 589758 590573 597836 605913 665513 669457 669641 820628 828269 828338 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пикап ххх"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пикап ххх"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.90%) |
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.