Query Metrics
7
Database Queries
7
Different statements
140.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.54 ms (84.08%) |
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 146944 382285 387207 400263 403131 404418 406040 415029 419013 426238 427152 427427 430324 433815 435329 442143 447247 454961 455107 455308 456747 457601 459232 459942 459966 460379 461124 461316 461549 464578 464600 474053 476893 478361 479472 481251 481550 485549 487101 489599 490489 492227 492921 495171 495448 497761 498485 500917 500926 501287 502218 503013 504206 508367 508644 508827 509859 512345 512626 514977 516924 519303 521181 521929 522947 524646 529433 539816 549134 550469 551158 552436 554201 557422 558422 558692 559007 571988 572322 573334 574521 575071 575161 575754 579901 581135 586595 588619 588985 589936 591809 595564 599437 609356 611252 613333 621807 623856 624616 637306 655071 657398 663940 690709 691242 693576 706324 724989 727109 746983 753575 755689 761986 762353 763308 776907 787130 788342 795408 799704 ] |
||||||||||||||||||||||||||||||
|
13.38 ms (9.49%) |
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 455308 459232 461124 481550 487101 490489 539816 501287 529433 498485 464578 474053 476893 558692 559007 572322 575071 579901 581135 551158 554201 557422 558422 550469 571988 574521 657398 663940 655071 690709 693576 691242 706324 552436 575754 621807 637306 588985 589936 591809 611252 624616 588619 595564 599437 613333 623856 776907 788342 795408 799704 787130 761986 762353 755689 763308 724989 727109 746983 753575 609356 146944 382285 404418 406040 415029 387207 403131 419013 433815 442143 460379 481251 400263 427427 457601 461316 461549 455107 459942 459966 427152 456747 464600 500917 502218 504206 508367 524646 492227 500926 508644 512626 519303 521929 489599 497761 503013 522947 495171 495448 508827 509859 521181 430324 447247 454961 512345 516924 549134 573334 575161 586595 479472 426238 435329 478361 485549 492921 514977 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.82%) |
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 146944 382285 387207 400263 403131 404418 406040 415029 419013 426238 427152 427427 430324 433815 435329 442143 447247 454961 455107 455308 456747 457601 459232 459942 459966 460379 461124 461316 461549 464578 464600 474053 476893 478361 479472 481251 481550 485549 487101 489599 490489 492227 492921 495171 495448 497761 498485 500917 500926 501287 502218 503013 504206 508367 508644 508827 509859 512345 512626 514977 516924 519303 521181 521929 522947 524646 529433 539816 549134 550469 551158 552436 554201 557422 558422 558692 559007 571988 572322 573334 574521 575071 575161 575754 579901 581135 586595 588619 588985 589936 591809 595564 599437 609356 611252 613333 621807 623856 624616 637306 655071 657398 663940 690709 691242 693576 706324 724989 727109 746983 753575 755689 761986 762353 763308 776907 787130 788342 795408 799704 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.04%) |
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.