Query Metrics
7
Database Queries
7
Different statements
181.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.00 ms (88.70%) |
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 385125 387588 390610 413707 424449 426911 431513 433594 448874 456818 459096 460209 463775 463915 474933 476075 477149 487768 493172 494933 496114 496237 496733 496758 502464 503336 511348 514381 516144 516452 517100 517620 522487 523435 526344 532500 532536 533536 534221 535585 536012 536958 537118 538919 541579 543744 546177 546180 547848 547852 549119 557198 559197 560987 566775 568478 573265 583386 584023 587216 596569 596587 596612 597108 598859 600824 603959 605583 628212 633340 647003 648524 650595 653557 653560 655840 657860 659289 659952 661652 667993 677919 677920 685979 689483 689964 694914 695849 696097 696975 705752 713970 714279 716751 722993 727423 728735 731444 747530 758459 761484 765356 765752 775711 784713 788577 790819 790873 794907 796728 796769 796968 797110 797325 802931 809808 809846 810675 817280 817750 ] |
||||||||||||||||||||||||||||||
|
10.77 ms (5.93%) |
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 538919 496114 543744 560987 659289 659952 661652 667993 689964 648524 689483 705752 722993 677919 695849 714279 546180 596569 790819 796728 802931 747530 761484 731444 727423 765356 728735 633340 696975 713970 385125 387588 514381 487768 653560 503336 390610 413707 476075 448874 494933 511348 573265 424449 474933 477149 523435 526344 522487 496733 493172 496237 496758 517100 653557 598859 817750 817280 517620 535585 516144 536012 536958 532536 537118 516452 533536 534221 541579 546177 568478 566775 547848 557198 655840 685979 694914 716751 647003 650595 657860 677920 696097 547852 549119 584023 597108 628212 596587 596612 603959 605583 600824 775711 797325 809846 784713 788577 796968 794907 796769 758459 790873 809808 810675 431513 433594 426911 463775 463915 456818 532500 502464 460209 559197 583386 587216 765752 797110 459096 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.89%) |
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 385125 387588 390610 413707 424449 426911 431513 433594 448874 456818 459096 460209 463775 463915 474933 476075 477149 487768 493172 494933 496114 496237 496733 496758 502464 503336 511348 514381 516144 516452 517100 517620 522487 523435 526344 532500 532536 533536 534221 535585 536012 536958 537118 538919 541579 543744 546177 546180 547848 547852 549119 557198 559197 560987 566775 568478 573265 583386 584023 587216 596569 596587 596612 597108 598859 600824 603959 605583 628212 633340 647003 648524 650595 653557 653560 655840 657860 659289 659952 661652 667993 677919 677920 685979 689483 689964 694914 695849 696097 696975 705752 713970 714279 716751 722993 727423 728735 731444 747530 758459 761484 765356 765752 775711 784713 788577 790819 790873 794907 796728 796769 796968 797110 797325 802931 809808 809846 810675 817280 817750 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"раком бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.71%) |
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.