Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "family-therapy"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'family-therapy' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  436449
  446595
  447012
  458179
  445107
  452180
  457663
  437383
  463623
  497206
  499487
  528769
  430324
  434003
  446713
  455329
  461603
  464043
  451838
  464330
  523782
  497160
  510256
  461346
  559566
  565195
  561089
  573923
  629819
  472127
  430349
  437497
  481874
  435039
  461353
  463199
  463201
  505999
  489656
  497416
  496266
  483499
  511514
  432297
  421118
  477545
  523496
  461599
  475121
  558353
  698284
  566257
  605576
  588642
  623462
  527062
  558348
  617195
  463614
  523474
  428276
  473948
  521822
  509997
  698312
  567338
  509345
  520657
  625675
  460249
  523492
  680824
  461602
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (436449, 446595, 447012, 458179, 445107, 452180, 457663, 437383, 463623, 497206, 499487, 528769, 430324, 434003, 446713, 455329, 461603, 464043, 451838, 464330, 523782, 497160, 510256, 461346, 559566, 565195, 561089, 573923, 629819, 472127, 430349, 437497, 481874, 435039, 461353, 463199, 463201, 505999, 489656, 497416, 496266, 483499, 511514, 432297, 421118, 477545, 523496, 461599, 475121, 558353, 698284, 566257, 605576, 588642, 623462, 527062, 558348, 617195, 463614, 523474, 428276, 473948, 521822, 509997, 698312, 567338, 509345, 520657, 625675, 460249, 523492, 680824, 461602);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  421118
  428276
  430324
  430349
  432297
  434003
  435039
  436449
  437383
  437497
  445107
  446595
  446713
  447012
  451838
  452180
  455329
  457663
  458179
  460249
  461346
  461353
  461599
  461602
  461603
  463199
  463201
  463614
  463623
  464043
  464330
  472127
  473948
  475121
  477545
  481874
  483499
  489656
  496266
  497160
  497206
  497416
  499487
  505999
  509345
  509997
  510256
  511514
  520657
  521822
  523474
  523492
  523496
  523782
  527062
  528769
  558348
  558353
  559566
  561089
  565195
  566257
  567338
  573923
  588642
  605576
  617195
  623462
  625675
  629819
  680824
  698284
  698312
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (421118, 428276, 430324, 430349, 432297, 434003, 435039, 436449, 437383, 437497, 445107, 446595, 446713, 447012, 451838, 452180, 455329, 457663, 458179, 460249, 461346, 461353, 461599, 461602, 461603, 463199, 463201, 463614, 463623, 464043, 464330, 472127, 473948, 475121, 477545, 481874, 483499, 489656, 496266, 497160, 497206, 497416, 499487, 505999, 509345, 509997, 510256, 511514, 520657, 521822, 523474, 523492, 523496, 523782, 527062, 528769, 558348, 558353, 559566, 561089, 565195, 566257, 567338, 573923, 588642, 605576, 617195, 623462, 625675, 629819, 680824, 698284, 698312);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  421118
  428276
  430324
  430349
  432297
  434003
  435039
  436449
  437383
  437497
  445107
  446595
  446713
  447012
  451838
  452180
  455329
  457663
  458179
  460249
  461346
  461353
  461599
  461602
  461603
  463199
  463201
  463614
  463623
  464043
  464330
  472127
  473948
  475121
  477545
  481874
  483499
  489656
  496266
  497160
  497206
  497416
  499487
  505999
  509345
  509997
  510256
  511514
  520657
  521822
  523474
  523492
  523496
  523782
  527062
  528769
  558348
  558353
  559566
  561089
  565195
  566257
  567338
  573923
  588642
  605576
  617195
  623462
  625675
  629819
  680824
  698284
  698312
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (421118, 428276, 430324, 430349, 432297, 434003, 435039, 436449, 437383, 437497, 445107, 446595, 446713, 447012, 451838, 452180, 455329, 457663, 458179, 460249, 461346, 461353, 461599, 461602, 461603, 463199, 463201, 463614, 463623, 464043, 464330, 472127, 473948, 475121, 477545, 481874, 483499, 489656, 496266, 497160, 497206, 497416, 499487, 505999, 509345, 509997, 510256, 511514, 520657, 521822, 523474, 523492, 523496, 523782, 527062, 528769, 558348, 558353, 559566, 561089, 565195, 566257, 567338, 573923, 588642, 605576, 617195, 623462, 625675, 629819, 680824, 698284, 698312);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "familytherapy"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'familytherapy';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "familytherapy"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'familytherapy';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "family-therapy"
  "family-therapy"
  "family-therapy"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('family-therapy') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('family-therapy')
              AND `query` <> 'family-therapy'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;