Query Metrics
7
Database Queries
7
Different statements
172.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.31 ms (86.38%) |
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 382585 388280 389124 390938 391675 402730 412827 418133 422477 425157 426075 426703 427819 432380 432719 433600 435401 443877 445187 451557 453640 455351 456222 456573 457974 458063 458156 458755 461333 461443 462236 463331 463935 467588 468222 470160 478168 479178 481409 481444 484301 484318 486327 490328 495331 496732 498910 502334 505370 511487 512458 512662 516527 518807 521432 522087 524070 526101 527810 533770 537393 541251 541400 541807 542173 544083 552228 556474 558205 565189 565496 573661 581082 586638 586838 589029 595882 600105 601930 604342 604406 613983 622887 624315 626842 634950 645031 646656 648622 651723 653270 656488 656907 659164 661658 673178 677339 677344 678916 680730 680808 685449 685832 686271 686414 692040 702150 705476 715654 721680 723178 740357 776397 781011 782527 793892 805172 810812 816607 ] |
||||||||||||||||||||||||||||||
|
13.20 ms (7.64%) |
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 604342 443877 479178 484318 481409 586638 432380 433600 458156 463331 402730 435401 461333 382585 388280 391675 412827 453640 461443 458755 486327 512458 505370 512662 527810 490328 541807 565189 581082 556474 565496 678916 558205 586838 604406 426703 427819 432719 456222 457974 462236 468222 418133 422477 463935 467588 481444 390938 445187 456573 470160 478168 425157 426075 451557 511487 496732 498910 518807 522087 541251 516527 526101 484301 521432 524070 455351 589029 458063 541400 389124 816607 533770 495331 502334 537393 542173 552228 544083 573661 646656 651723 653270 656488 659164 677339 715654 645031 648622 661658 686271 686414 692040 702150 721680 656907 673178 677344 680730 680808 685449 685832 705476 723178 595882 626842 600105 601930 613983 622887 624315 634950 793892 805172 810812 776397 781011 782527 740357 754040 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy teen russian"
]
|
||||||||||||||||||||||||||||||
|
2.40 ms (1.39%) |
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 382585 388280 389124 390938 391675 402730 412827 418133 422477 425157 426075 426703 427819 432380 432719 433600 435401 443877 445187 451557 453640 455351 456222 456573 457974 458063 458156 458755 461333 461443 462236 463331 463935 467588 468222 470160 478168 479178 481409 481444 484301 484318 486327 490328 495331 496732 498910 502334 505370 511487 512458 512662 516527 518807 521432 522087 524070 526101 527810 533770 537393 541251 541400 541807 542173 544083 552228 556474 558205 565189 565496 573661 581082 586638 586838 589029 595882 600105 601930 604342 604406 613983 622887 624315 626842 634950 645031 646656 648622 651723 653270 656488 656907 659164 661658 673178 677339 677344 678916 680730 680808 685449 685832 686271 686414 692040 702150 705476 715654 721680 723178 740357 776397 781011 782527 793892 805172 810812 816607 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак teen русск"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак teen русск"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.93%) |
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.