Query Metrics
7
Database Queries
7
Different statements
190.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.66 ms (85.00%) |
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 306275 398712 400912 409532 419042 431805 436031 436044 442696 443964 447314 451542 451561 451565 452018 453614 454289 454298 461532 462088 462161 462349 462830 462937 470229 470238 470253 470534 470536 470743 471583 472340 472792 473998 474058 476413 484687 484844 484862 488732 489991 489998 491371 491513 495195 495622 497085 497535 497544 497572 497574 497578 497579 497876 500429 504302 508470 511756 511758 511759 511767 512267 512285 514816 515507 518951 521927 522529 523309 523321 523702 523711 523935 528806 534078 540902 540918 542933 542964 548738 548753 557954 560466 562250 562257 562259 563662 575752 575803 576367 576373 576405 578366 582201 595717 595764 607730 610847 613333 617432 622111 626063 648259 659295 659321 701501 708144 715395 716804 718521 736151 741114 742203 742226 762257 775797 776971 779148 790870 797940 ] |
||||||||||||||||||||||||||||||
|
19.38 ms (10.19%) |
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 557954 659321 548738 576367 576405 607730 511756 511767 523321 534078 562257 562259 562250 563662 575752 542933 542964 648259 715395 701501 718521 708144 716804 576373 578366 610847 622111 595717 626063 613333 617432 797940 762257 742203 742226 736151 741114 776971 779148 790870 471583 476413 442696 451561 461532 470238 470253 462937 470534 306275 398712 409532 454289 462161 472340 518951 523935 484862 497574 497876 504302 515507 491371 508470 511758 512267 522529 484844 491513 497535 497578 523702 489998 595764 452018 775797 436044 462349 472792 473998 474058 454298 512285 484687 500429 560466 575803 548753 659295 582201 400912 431805 436031 453614 470743 470229 470536 419042 443964 462088 462830 447314 451565 451542 514816 540918 488732 497572 497579 528806 540902 489991 497085 521927 523309 523711 495195 495622 497544 511759 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.35%) |
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 306275 398712 400912 409532 419042 431805 436031 436044 442696 443964 447314 451542 451561 451565 452018 453614 454289 454298 461532 462088 462161 462349 462830 462937 470229 470238 470253 470534 470536 470743 471583 472340 472792 473998 474058 476413 484687 484844 484862 488732 489991 489998 491371 491513 495195 495622 497085 497535 497544 497572 497574 497578 497579 497876 500429 504302 508470 511756 511758 511759 511767 512267 512285 514816 515507 518951 521927 522529 523309 523321 523702 523711 523935 528806 534078 540902 540918 542933 542964 548738 548753 557954 560466 562250 562257 562259 563662 575752 575803 576367 576373 576405 578366 582201 595717 595764 607730 610847 613333 617432 622111 626063 648259 659295 659321 701501 708144 715395 716804 718521 736151 741114 742203 742226 762257 775797 776971 779148 790870 797940 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian teens group"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск teens group"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск teens group"
]
|
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.