Query Metrics
7
Database Queries
7
Different statements
208.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.70 ms (87.56%) |
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 386751 396286 417006 417368 418627 421074 421294 422152 424671 424986 425008 433072 435114 436452 437120 437415 437580 440650 441910 443862 444206 446244 447007 447902 449622 452181 452367 455273 455738 456173 461693 464272 467663 468278 469950 471325 473784 473973 474939 475599 477691 478753 480969 481206 486476 487628 487656 487864 487998 488767 489769 490037 493499 496956 498949 503699 509576 510022 513941 514414 515651 519958 520388 520670 520906 521656 523613 523959 524327 524596 526147 526318 528215 532012 534333 535578 538967 539889 542946 544087 546375 547644 548283 549808 552249 555336 557109 557559 557634 561454 567932 569241 571971 577243 577897 583607 586563 591627 592143 592591 593136 602402 602802 612404 613973 618992 621676 625111 630850 635227 648874 661976 665929 671864 772167 775494 810138 810359 813249 813253 ] |
||||||||||||||||||||||||||||||
|
15.59 ms (7.47%) |
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 526147 452181 417006 421074 421294 424986 441910 418627 447007 490037 514414 524596 467663 544087 671864 648874 592591 591627 775494 813253 437120 480969 455738 437580 473784 443862 478753 498949 534333 487656 635227 661976 665929 602802 577897 436452 487998 528215 538967 424671 473973 520388 571971 593136 602402 625111 456173 477691 481206 523959 396286 435114 489769 446244 447902 455273 487864 493499 520906 539889 520670 526318 549808 557109 557634 569241 542946 555336 548283 557559 567932 577243 552249 583607 630850 612404 618992 621676 592143 613973 813249 772167 810138 810359 417368 468278 475599 449622 461693 471325 425008 469950 496956 513941 488767 521656 509576 452367 523613 444206 464272 561454 546375 586563 422152 437415 503699 487628 547644 386751 524327 515651 519958 486476 532012 535578 474939 510022 440650 433072 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.47%) |
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 386751 396286 417006 417368 418627 421074 421294 422152 424671 424986 425008 433072 435114 436452 437120 437415 437580 440650 441910 443862 444206 446244 447007 447902 449622 452181 452367 455273 455738 456173 461693 464272 467663 468278 469950 471325 473784 473973 474939 475599 477691 478753 480969 481206 486476 487628 487656 487864 487998 488767 489769 490037 493499 496956 498949 503699 509576 510022 513941 514414 515651 519958 520388 520670 520906 521656 523613 523959 524327 524596 526147 526318 528215 532012 534333 535578 538967 539889 542946 544087 546375 547644 548283 549808 552249 555336 557109 557559 557634 561454 567932 569241 571971 577243 577897 583607 586563 591627 592143 592591 593136 602402 602802 612404 613973 618992 621676 625111 630850 635227 648874 661976 665929 671864 772167 775494 810138 810359 813249 813253 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov ванная"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов ван"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.69%) |
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.