Query Metrics
7
Database Queries
7
Different statements
149.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.59 ms (81.47%) |
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 391986 411905 418906 419544 421626 423212 425031 429185 439373 439392 443482 444001 448576 452262 454300 455006 455747 455770 458513 458619 462685 463286 464290 466545 469327 470781 470959 470966 471603 475354 475615 476788 478325 479176 479920 480641 481454 484997 485277 490361 490599 490712 490759 491899 492537 494569 495319 495909 499458 501475 504995 505279 505792 506415 509794 511727 512603 513257 514042 515580 517385 517808 518387 518880 519379 521408 522023 522272 522426 524243 525400 525430 525970 526289 527194 527233 527534 528119 528374 529617 534530 534587 534596 539956 544108 546941 547543 550021 550251 554775 557922 561679 564422 564556 571103 574322 581104 583289 584134 584771 585331 586594 595138 595419 595506 598917 599198 604396 659974 660271 662884 664799 671179 733700 747815 750814 785552 813065 813148 ] |
||||||||||||||||||||||||||||||
|
17.95 ms (12.03%) |
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 509794 517385 534530 539956 519379 525970 528374 534587 527194 529617 534596 499458 524243 464290 475354 478325 544108 547543 584134 581104 557922 561679 659974 662884 660271 664799 671179 546941 550021 564422 598917 595138 595419 595506 599198 785552 813065 733700 813148 747815 750814 419544 439392 476788 481454 421626 452262 455770 463286 470781 479176 429185 458513 470959 479920 439373 444001 455747 466545 471603 475615 480641 501475 511727 512603 517808 522023 485277 490361 490759 492537 494569 504995 513257 518880 525400 527534 484997 490599 495909 526289 506415 586594 462685 514042 470966 518387 564556 584771 585331 425031 411905 391986 443482 521408 528119 491899 515580 522272 505279 490712 458619 455006 454300 574322 423212 418906 448576 469327 495319 505792 522426 525430 527233 527940 583289 571103 554775 550251 604396 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.68%) |
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 391986 411905 418906 419544 421626 423212 425031 429185 439373 439392 443482 444001 448576 452262 454300 455006 455747 455770 458513 458619 462685 463286 464290 466545 469327 470781 470959 470966 471603 475354 475615 476788 478325 479176 479920 480641 481454 484997 485277 490361 490599 490712 490759 491899 492537 494569 495319 495909 499458 501475 504995 505279 505792 506415 509794 511727 512603 513257 514042 515580 517385 517808 518387 518880 519379 521408 522023 522272 522426 524243 525400 525430 525970 526289 527194 527233 527534 528119 528374 529617 534530 534587 534596 539956 544108 546941 547543 550021 550251 554775 557922 561679 564422 564556 571103 574322 581104 583289 584134 584771 585331 586594 595138 595419 595506 598917 599198 604396 659974 660271 662884 664799 671179 733700 747815 750814 785552 813065 813148 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трусики с дырочкой"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел дырочк"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.04%) |
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.