0.0027 | User_model->get_pen_by_pen_id line:1356
SELECT * FROM (`ab_user_pennames`) INNER JOIN `ab_user_pennames_extra` ON `ab_user_pennames_extra`.`pen_id` = `ab_user_pennames`.`pen_id` WHERE `ab_user_pennames`.`pen_id` IN (995716)
|
0.0008 | User_model->get_user_by_user_id line:1500
SELECT `ab_users`.*, IF (ab_users.lang_id = 1, DATE_FORMAT(ab_users.date_joined, '%b %d, %Y'), DATE_FORMAT(ab_users.date_joined, '%d/%m/%Y')) as date_joined_mdy FROM (`ab_users`) WHERE `ab_users`.`id` = '934377'
|
0.0061 | User_model->get_pen_by_pen_id line:1356
SELECT * FROM (`ab_user_pennames`) WHERE `ab_user_pennames`.`pen_id` IN ('995716')
|
0.0007 | User_model->get_pen_by_pen_id line:1356
SELECT * FROM (`ab_user_pennames`) WHERE `ab_user_pennames`.`pen_id` IN ('995716')
|
0.0009 | User_model->get_qa_pen_stats line:2028
SELECT COUNT(1) AS total_questions FROM (`ab_questions`) WHERE `ab_questions`.`pen_id` = 995716 AND `ab_questions`.`status` = 'active'
|
0.0005 | User_model->get_qa_pen_stats line:2047
SELECT COUNT(1) AS total_answers FROM (`ab_answers`) WHERE `ab_answers`.`pen_id` = 995716 AND `ab_answers`.`status` = 'active'
|
0.0005 | User_model->get_qa_pen_stats line:2067
SELECT COUNT(1) AS total_qa_comments FROM (`ab_answers_comments`) WHERE `ab_answers_comments`.`pen_id` = 995716 AND `ab_answers_comments`.`status` = 'active'
|
0.0006 | User_model->get_pen_stats line:1051
SELECT SUM(ab_articles_stats.views) AS views FROM (`ab_articles_meta`) INNER JOIN `ab_articles_stats` ON `ab_articles_meta`.`id` = `ab_articles_stats`.`id` WHERE `ab_articles_meta`.`pen_id` = 995716 AND `ab_articles_meta`.`status_id` = 1
|
0.0007 | User_model->get_pen_stats line:1070
SELECT COUNT(1) AS total_articles FROM (`ab_articles_meta`) WHERE `ab_articles_meta`.`pen_id` = 995716 AND `ab_articles_meta`.`status_id` = 1
|
0.0017 | User_model->get_pen_stats line:1091
SELECT COUNT(1) AS total_comments FROM (`ab_comments`) WHERE `ab_comments`.`pen_id` = 995716 AND `ab_comments`.`comment_status` = 'A'
|
0.0006 | Article_model->get_articles_list_order_by line:77
SELECT `ab_articles_pen_keys`.`id` FROM (`ab_articles_pen_keys`) WHERE `ab_articles_pen_keys`.`pen_id` = '995716' ORDER BY `ab_articles_pen_keys`.`id` desc LIMIT 10
|
0.0012 | Article_model->get_articles_list_by_ids line:893
SELECT ab_user_pennames.pen_name, ab_user_pennames.pen_id, ab_user_pennames.pen_photo, ab_categories.cat_id, ab_categories.cat_name, ab_categories.cat_name_uri, ab_categories.cat_meta_desc, ab_categories.cat_parent_id, ca.cat_name as cat_parent_name, ca.cat_name_uri as cat_parent_name_uri, ca.cat_meta_desc as cat_parent_meta_desc, ab_articles_meta.id, ab_articles_meta.title, IF (ab_articles_meta.lang_id = 1, DATE_FORMAT(ab_articles_meta.date_submitted, '%b %d, %Y'), DATE_FORMAT(ab_articles_meta.date_submitted, '%d/%m/%Y') ) as date_submitted_mdy, ab_articles_meta.meta_desc, ab_articles_meta.date_submitted, ab_articles_meta.url, ab_articles_stats.views, ab_articles_stats.votes, ab_articles_stats.score, ab_articles_stats.comments_count, if(votes>3, score/votes*10, 0) as rate_avg FROM (ab_articles_meta) JOIN ab_articles_stats ON ab_articles_meta.id=ab_articles_stats.id JOIN ab_categories ON ab_categories.cat_id = ab_articles_meta.cat_id JOIN ab_user_pennames ON ab_user_pennames.pen_id = ab_articles_meta.pen_id LEFT JOIN ab_categories as ca ON ab_categories.cat_parent_id = ca.cat_id WHERE ab_articles_meta.id IN ('6046571') ORDER BY FIELD(ab_articles_meta.id, 6046571)
|
0.0013 | Question_model->get_latest_questions_by_category line:319
SELECT ab_questions.id as question_id, ab_questions.pen_id, ab_questions.datetime_created as question_date, ab_questions.title as question_body, ab_questions.lang_id, ab_questions.title_uri as question_url, ab_categories.cat_id, ab_categories.cat_name, ab_categories.cat_name_uri, ab_categories.cat_parent_id, ca.cat_name as cat_parent_name, ca.cat_name_uri as cat_parent_name_uri, ab_user_pennames.pen_photo, ab_user_pennames.pen_name FROM (ab_questions) JOIN ab_user_pennames ON ab_user_pennames.pen_id = ab_questions.pen_id LEFT JOIN ab_categories ON ab_categories.cat_id = ab_questions.cat_id LEFT JOIN ab_categories as ca ON ab_categories.cat_parent_id = ca.cat_id WHERE `ab_questions`.`status` = 'active' AND `ab_questions`.`lang_id` = 7 AND `ab_questions`.`pen_id` = '995716' ORDER BY ab_questions.id desc LIMIT 10
|
0.0018 | Answer_model->get_latest_answers_by line:549
SELECT ab_answers.id, ab_answers.question_id, ab_answers.pen_id, ab_answers.datetime_created, ab_answers.datetime_updated, ab_answers.status, ab_answers.content, ab_answers.likes, ab_answers.lang_id, ab_answers.datetime_created as date_submitted_mdy, ab_questions.title_uri as question_url, ab_questions.title as question_body, ab_categories.cat_id, ab_categories.cat_name, ab_categories.cat_name_uri, ab_categories.cat_parent_id, ca.cat_name as cat_parent_name, ca.cat_name_uri as cat_parent_name_uri, ab_user_pennames.pen_user_id, ab_user_pennames.pen_bio, ab_user_pennames.pen_photo, ab_user_pennames.pen_name, ab_users.advertising, ab_users.nofollow, ab_users.nofollow_content FROM (ab_answers) JOIN ab_questions ON ab_answers.question_id = ab_questions.id JOIN ab_user_pennames ON ab_user_pennames.pen_id = ab_answers.pen_id JOIN ab_users ON ab_user_pennames.pen_user_id = ab_users.id LEFT JOIN ab_categories ON ab_categories.cat_id = ab_questions.cat_id LEFT JOIN ab_categories as ca ON ab_categories.cat_parent_id = ca.cat_id WHERE `ab_answers`.`lang_id` = 7 AND `ab_answers`.`status` = 'active' AND `ab_questions`.`status` = 'active' AND `ab_answers`.`pen_id` = '995716' ORDER BY ab_answers.datetime_created desc LIMIT 10
|
0.0012 | Qa_comment_model->get_latest_comments_by line:290
SELECT ab_answers_comments.id, ab_answers_comments.answer_id, ab_answers_comments.pen_id, ab_answers_comments.datetime_created, ab_answers_comments.status, ab_answers_comments.content, ab_answers.lang_id, ab_answers.content as answer_body, ab_questions.title_uri as question_url, ab_categories.cat_id, ab_categories.cat_name, ab_categories.cat_name_uri, ab_categories.cat_parent_id, ca.cat_name as cat_parent_name, ca.cat_name_uri as cat_parent_name_uri, ab_user_pennames.pen_user_id, ab_user_pennames.pen_bio, ab_user_pennames.pen_photo, ab_user_pennames.pen_name, ab_answers_comments.datetime_created as comment_date_mdy FROM (ab_answers_comments) JOIN ab_answers ON ab_answers.id = ab_answers_comments.answer_id JOIN ab_user_pennames ON ab_user_pennames.pen_id = ab_answers_comments.pen_id JOIN ab_questions ON ab_answers.question_id = ab_questions.id LEFT JOIN ab_categories ON ab_categories.cat_id = ab_questions.cat_id LEFT JOIN ab_categories as ca ON ab_categories.cat_parent_id = ca.cat_id WHERE `ab_answers`.`lang_id` = 7 AND `ab_answers_comments`.`status` = 'active' AND `ab_answers_comments`.`pen_id` = '995716' ORDER BY ab_answers_comments.datetime_created desc LIMIT 10
|
0.0020 | User_model->get_pen_by_pen_id line:1356
SELECT * FROM (ab_user_pennames) WHERE ab_user_pennames.pen_id IN ('995716')
|
0.0007 | User_model->get_pen_by_pen_id line:1356
SELECT * FROM (ab_user_pennames) WHERE ab_user_pennames.pen_id IN ('995716')
|