Visi Misi Fakultas Tarbiyah

VISI DAN MISI FAKULTAS TARBIYAH

INSTITUT KEISLAMAN ABDULLAH FAQIH (INKAFA) GRESIK

 

Visi

Menjadi Fakultas Tarbiyah yang unggul dalam penyelenggaraan Tridharma perguruan tinggi berbasis pesantren dengan haluan Ahlissunnah wal Jamaah.

 

Misi

Misi dari Fakultas Tarbiyah adalah:   

1.     Menyelenggarakan pendidikan berbasis pesantren yang berkualitas dalam bidang Pendidikan Agama Islam, Pendidikan Bahasa Arab dan Pendidikan Bahasa Inggris

2.     Mempersiapkan lulusan yang berkarakter, memiliki kekayaan pengetahuan, kedalaman spiritual dan kekokohan aqidah ahlissunnah wal jamaah

3.        Mempersiapkan lulusan yang mengintegrasikan ilmu pengetahuan dan praktik

4.     Melaksanakan penelitian dan pengabdian kepada masyarakat yang memberikan kemashlahatan bagi pengembangan ilmu pengetahuan dan masyarakat

5.       Membangun kerjasama dengan lembaga-lembaga dalam negeri dan luar negeri.

 

Tujuan

Tujuan dari Fakultas Tarbiyah Institut Keislaman Abdullah Faqih Gresik adalah untuk:      

1.       Menghasilkan pendidik berakhlaqul karimah yang memiliki kompetensi profesional, pedagogik, sosial dan kepribadian

2.         Menghasilkan sarjana yang memiliki integritas keagamaan dan keilmuan.

3.       Menghasilkan penelitian yang relevan dengan kebutuhan masyarakat dan dunia pendidikan

4.       Menghasilkan kerjasama untuk pengembangan pendidikan

 

Sasaran dan strategi pencapaiannya

Sasaran yang ingin dicapai oleh fakultas dengan strategi pencapaiannya adalah sebagai berikut :

(1)   Bidang Pendidikan dan Pengajaran

Sasaran: Meningkatkan kualitas penyelenggaraan pendidikan dan pengajaran.

Strategi: Dalam rangka meningkatkan kualitas penyelenggaraan pendidikan dan pengajaran yang lebih berkualitas pada fakultas Tarbiyah INKAFA strategi yang dirancang adalah:

a.    Meningkatkan animo calon mahasiswa dan passing grade rata-rata calon mahasiswa melalui sosialisasi profil fakultas Tarbiyah secara luas dan efektif melalui multimedia dan alumni.

b.    Meningkatkan kualitas mahasiswa baru yang diterima

c.    Peningkatan relevansi kurikulum dengan perkembangan ilmu, teknologi dan kebutuhan stakeholder

d.    Meningkatkan kualitas dan kinerja dosen dalam proses pembelajaran

e.    Meningkatkan pelayanan akademik

f.     Meningkatkan daya saing lulusan

g.   Meningkatkan persentase IPK dan lama studi mahasiswa

h.    Meningkatkan suasana akademik

i.      Meningkatkan masa tunggu kerja lulusan

 

(2)  Bidang Penelitian dan Pengembangan ilmu

Sasaran: Peningkatan kualitas dan kuantitas penyelenggaraan penelitian dan pengembangan ilmu yang progresif dan kompetitif.

Strategi: Dalam rangka meningkatkan kualitas penyelenggaraan penelitian dan pengembangan ilmu di Fakultas Tarbiyah sehingga lebih berkualitas, maka strategi yang dirancang adalah:

a.    Meningkatkan usaha-usaha yang dapat mendorong kreatifitas dan produktifitas dosen di bidang penelitian dan pengembangan ilmu, baik melalui pelatihan metodologi penelitian untuk mendapatkan hibah, kerjasama dengan intitusi pemerintah atau swasta, dan kebijakan untuk untuk memberi penghargaan bagi dosen yang melakukan penelitian.

b.      Membuat kebijakan-kebijakan yang menstimulasi semangat dan kreatifitas dosen dalam penelitian.

c.      Meningkatkan kuantitas  dan kualitas penelitian dosen

d.      Menyediakan sarana publikasi penelitian dosen

e.     Meningkatkan sarana dan prasarana penunjang efektivitas dan efisiensi sistem informasi penelitian.

 

 (3) Bidang Pengabdian kepada Masyarakat

Sasaran: Peningkatan kualitas penyelenggaraan pengabdian pada masyarakat yang progresif dan kompetitif.

Strategi: Dalam rangka meningkatkan kualitas penyelenggaraan penelitian dan pengembangan ilmu di Fakultas Tarbiyah maka strategi yang ditempuh adalah:

a.  Membangun sistem informasi pengabdian pada masyarakat yang dapat diakses oleh dosen, mahasiswa, dan masyarakat

b.     Menjalin kemitraan dengan Pemerintah Daerah, Swasta dan Perguruan Tinggi lainnya.

c.      Melakukan pemantauan rekam jejak pengabdian kepada masyarakat yang dilakukan dosen

d.      Peningkatan kontribusi penerapan iptek di bidang pendidikan.

e.   Meningkatkan sarana dan kualitas sumber daya manusia dalam meningkatkan kualitas produk layanan masyarakat.

 

(4) Bidang organisasi dan manajemen

Sasaran: Peningkatkan kualitas organisasi dan manajemen.

Strategi: Dalam rangka meningkatkan kualitas organisasi dan manajemen, fakultas Tarbiyah INKAFA merencanakan beberapa strategi sebagai berikut:

a.     Menerapkan manajemen organisasi yang sehat, efektif, efisien, kondusif, transparan, dan akuntabel

b.   Meningkatkan sumber daya manusia organisasi dengan tugas studi atau pelatihan

c.    Meningkatkan pelayanan menujugood university governent;

d.  Melakukan penguatan kelembagaan untuk mendapat pengakuan dari pihak luar

e.   Membuat job description, mekanisme kerja dan SOP masing-masing unit kerja

f.    Meningkatan sistem monitoring dan evaluasi kinerja dosen dan staf

g.  Menerbitkankebijakan-kebijakan yang dapat memperkuat kelembagaan secara bertahap.

h.  Meningkatkan peran alumni dalam networking dan pengembangan intitusi melalui organisasi alumni

 

(5)   Bidang Pembinaan Bidang kemahasiswaan dan alumni

Sasaran: Peningkatan Kualitas Pembinaan Bidang kemahasiswaan dan alumni.

Strategi: Dalam rangka meningkatkan kualitas Pembinaan Bidang kemahasiswaan dan alumni di Fakultas Tarbiyah maka strategi yang dicanangkan adalah :

a.   Mengembangkan soft skill mahasiswa

b.   Meningkatkan suasana akademik yang kondusif bagi pengembangan intelektualitas, sikap dan perilaku mahasiswa, kebebasan mimbar akademik, kegiatan ekstrakulikuler dan seminar, dengan menjunjung tinggi nilai-nilai kebenaran, kejujuran, objektivitas dan demokratis.

c.   Meningkatkan peran alumni dalam networking dan pengembangan institusi melalui organisasi alumni.

 

(6)   Bidang kerjasama institusional

Sasaran: Peningkatkan Kualitas Penyelenggaraan Kerjasama institusional

Strategi: Dalam rangka meningkatkan kualitas penyelenggaraan kerjasama institusional Fakultas Tarbiyah, maka strategi yang dipakai adalah:

a.Peningkatan kepercayaan pemerintah atau lembaga penyelenggara pendidikan dalam mengembangkan sumber daya manusia.

b.     Peningkatan kerjasama internal antara fakultas Tarbiyah dengan Fakultas lainnya di lingkungan INKAFA.

c.      Meningkatan kerjasama dan kemitraan program dalam melaksanakan Tridharma Perguruan Tinggi baik dengan institusi dalam negeri maupun luar negeri.

          d.   Meningkatkan kerjasama dengan pengguna lulusan

 

 

 

VISI MISI & PETA

VISI MISI & PETA


Visi

 Visi Institut Keislaman Abdullah Faqih (INKAFA) Gresik adalah sebagai Fakultas penyelenggara pendidikan, penelitian, dan pengabdian masyarakat di bidang tarbiyah yang berkualitas dan berbasis pesantren, sesuai aqidah Islam Ahlissunnah wal Jamaah.

 

Kampus Inkafa Position

Logo Inkafa warna

KAMPUS INSTITUT KEISLAMAN ABDULLAH FAQIH

(INKAFA)

Alamat            : Jl.KH. Syafi'i 07

Desa              : Suci

Kecamatan      : Manyar

Kabupaten      : Gresik

 

Halaman 2 dari 3

<< Awal < Sebelumnya 1 2 3 Berikutnya > Akhir >>
image


17166
TodayToday6
YesterdayYesterday18
This_WeekThis_Week106
This_MonthThis_Month585
All_DaysAll_Days17166
DEBUG
Time:[0.0046451091766357sec]

Informasi Profil

Application 0.001 seconds (+0.001); 1.15 MB (+1.153) - afterLoad
Application 0.117 seconds (+0.116); 5.24 MB (+4.088) - afterInitialise
Application 0.209 seconds (+0.092); 8.90 MB (+3.656) - afterRoute
Application 0.322 seconds (+0.113); 12.54 MB (+3.643) - afterDispatch
Application 0.397 seconds (+0.075); 12.94 MB (+0.403) - beforeRenderModule mod_menu ()
Application 0.516 seconds (+0.119); 13.37 MB (+0.422) - afterRenderModule mod_menu ()
Application 0.597 seconds (+0.082); 13.23 MB (-0.140) - beforeRenderModule mod_wmedia_player (WMedia Radio Player)
Application 0.598 seconds (+0.000); 13.23 MB (+0.008) - afterRenderModule mod_wmedia_player (WMedia Radio Player)
Application 0.598 seconds (+0.000); 13.23 MB (-0.004) - beforeRenderModule mod_custom (YM)
Application 0.599 seconds (+0.001); 13.24 MB (+0.008) - afterRenderModule mod_custom (YM)
Application 0.599 seconds (+0.000); 13.25 MB (+0.014) - beforeRenderModule mod_vvisit_counter (Visitors Counter)
Application 0.609 seconds (+0.010); 14.91 MB (+1.656) - afterRenderModule mod_vvisit_counter (Visitors Counter)
Application 0.609 seconds (+0.000); 14.86 MB (-0.048) - beforeRenderModule mod_ninja_simple_icon_menu (Follow Us)
Application 0.611 seconds (+0.002); 14.92 MB (+0.062) - afterRenderModule mod_ninja_simple_icon_menu (Follow Us)
Application 0.611 seconds (+0.000); 14.84 MB (-0.078) - beforeRenderModule mod_yahoo_messenger (Yahoo Messenger)
Application 0.612 seconds (+0.001); 14.85 MB (+0.005) - afterRenderModule mod_yahoo_messenger (Yahoo Messenger)
Application 0.706 seconds (+0.094); 15.02 MB (+0.175) - afterRender

Penggunaan Memori

15.12 MB (15,859,232 Bytes)

73 Queries Pencatatan

  1. SELECT `data`
      FROM `slf50_session`
      WHERE `session_id` = 'rprhdgba2bk2ds41c8eod2s503'
  2. SELECT `session_id`
      FROM `slf50_session`
      WHERE `session_id` = 'rprhdgba2bk2ds41c8eod2s503'
      LIMIT 0, 1
  3. INSERT INTO `slf50_session` (`session_id`, `client_id`, `time`)
      VALUES ('rprhdgba2bk2ds41c8eod2s503', 0, 1440890930)
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM slf50_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  5. SELECT id, rules
      FROM `slf50_viewlevels`
  6. SELECT folder AS type, element AS name, params
      FROM slf50_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  7. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM slf50_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  8. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
      FROM slf50_menu AS m
      LEFT JOIN slf50_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
  9. SHOW COLUMNS
      FROM slf50_content
  10. SELECT *
      FROM slf50_jcomments_settings
  11. SELECT id, home, template, s.params
      FROM slf50_template_styles as s
      LEFT JOIN slf50_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
  12. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM slf50_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  13. SELECT *
      FROM slf50_languages
      WHERE published=1
      ORDER BY ordering ASC
  14. SELECT a.rules
      FROM slf50_assets AS a
      WHERE a.id = 1
  15. SELECT b.rules
      FROM slf50_assets AS a
      LEFT JOIN slf50_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  16. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM slf50_content AS a
      LEFT JOIN slf50_categories AS c
      ON c.id = a.catid
      LEFT JOIN slf50_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN slf50_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN slf50_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN slf50_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN slf50_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM slf50_categories AS cat JOIN slf50_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      INNER JOIN slf50_content_frontpage AS fp
      ON fp.content_id = a.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-08-29 23:28:50')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-08-29 23:28:50')
      GROUP BY a.id
      ORDER BY fp.ordering, a.created DESC
      LIMIT 4, 3
  17. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM slf50_content AS a
      LEFT JOIN slf50_categories AS c
      ON c.id = a.catid
      LEFT JOIN slf50_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN slf50_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN slf50_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN slf50_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN slf50_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM slf50_categories AS cat JOIN slf50_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      INNER JOIN slf50_content_frontpage AS fp
      ON fp.content_id = a.id
      WHERE a.access IN (1,1)
      AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-08-29 23:28:50')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-08-29 23:28:50')
      GROUP BY a.id
      ORDER BY fp.ordering, a.created DESC
  18. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM slf50_categories as c
      LEFT JOIN slf50_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM slf50_categories AS cat JOIN slf50_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=2
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  19. SELECT count(*)
      FROM slf50_jcomments AS c
      WHERE c.object_id = 3
      AND c.object_group = 'com_content'
      AND c.published = 1
  20. SELECT count(*)
      FROM slf50_jcomments AS c
      WHERE c.object_id = 2
      AND c.object_group = 'com_content'
      AND c.published = 1
  21. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM slf50_modules AS m
      LEFT JOIN slf50_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN slf50_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2015-08-29 23:28:50')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2015-08-29 23:28:50')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 101 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  22. SELECT params
      FROM slf50_menu
      WHERE id = 1
      AND params !=""
  23. SELECT params
      FROM slf50_menu
      WHERE id = 1
      AND params !=""
  24. SELECT params
      FROM slf50_menu
      WHERE id = 104
      AND params !=""
  25. SELECT params
      FROM slf50_menu
      WHERE id = 104
      AND params !=""
  26. SELECT params
      FROM slf50_menu
      WHERE id = 104
      AND params !=""
  27. SELECT params
      FROM slf50_menu
      WHERE id = 104
      AND params !=""
  28. SELECT params
      FROM slf50_menu
      WHERE id = 104
      AND params !=""
  29. SELECT params
      FROM slf50_menu
      WHERE id = 104
      AND params !=""
  30. SELECT params
      FROM slf50_menu
      WHERE id = 104
      AND params !=""
  31. SELECT params
      FROM slf50_menu
      WHERE id = 1
      AND params !=""
  32. SELECT params
      FROM slf50_menu
      WHERE id = 107
      AND params !=""
  33. SELECT params
      FROM slf50_menu
      WHERE id = 120
      AND params !=""
  34. SELECT params
      FROM slf50_menu
      WHERE id = 120
      AND params !=""
  35. SELECT params
      FROM slf50_menu
      WHERE id = 120
      AND params !=""
  36. SELECT params
      FROM slf50_menu
      WHERE id = 107
      AND params !=""
  37. SELECT params
      FROM slf50_menu
      WHERE id = 121
      AND params !=""
  38. SELECT params
      FROM slf50_menu
      WHERE id = 121
      AND params !=""
  39. SELECT params
      FROM slf50_menu
      WHERE id = 107
      AND params !=""
  40. SELECT params
      FROM slf50_menu
      WHERE id = 122
      AND params !=""
  41. SELECT params
      FROM slf50_menu
      WHERE id = 107
      AND params !=""
  42. SELECT params
      FROM slf50_menu
      WHERE id = 123
      AND params !=""
  43. SELECT params
      FROM slf50_menu
      WHERE id = 107
      AND params !=""
  44. SELECT params
      FROM slf50_menu
      WHERE id = 1
      AND params !=""
  45. SELECT params
      FROM slf50_menu
      WHERE id = 108
      AND params !=""
  46. SELECT params
      FROM slf50_menu
      WHERE id = 108
      AND params !=""
  47. SELECT params
      FROM slf50_menu
      WHERE id = 1
      AND params !=""
  48. SELECT params
      FROM slf50_menu
      WHERE id = 109
      AND params !=""
  49. SELECT params
      FROM slf50_menu
      WHERE id = 109
      AND params !=""
  50. SELECT params
      FROM slf50_menu
      WHERE id = 109
      AND params !=""
  51. SELECT params
      FROM slf50_menu
      WHERE id = 1
      AND params !=""
  52. SELECT params
      FROM slf50_menu
      WHERE id = 110
      AND params !=""
  53. SELECT params
      FROM slf50_menu
      WHERE id = 110
      AND params !=""
  54. SELECT params
      FROM slf50_menu
      WHERE id = 110
      AND params !=""
  55. SELECT params
      FROM slf50_menu
      WHERE id = 110
      AND params !=""
  56. SELECT params
      FROM slf50_menu
      WHERE id = 1
      AND params !=""
  57. SELECT params
      FROM slf50_menu
      WHERE id = 111
      AND params !=""
  58. SELECT params
      FROM slf50_menu
      WHERE id = 111
      AND params !=""
  59. SELECT params
      FROM slf50_menu
      WHERE id = 1
      AND params !=""
  60. SELECT params
      FROM slf50_menu
      WHERE id = 1
      AND params !=""
  61. SELECT params
      FROM slf50_menu
      WHERE id = 1
      AND params !=""
  62. SELECT params
      FROM slf50_menu
      WHERE id = 130
      AND params !=""
  63. SELECT params
      FROM slf50_menu
      WHERE id = 130
      AND params !=""
  64. SELECT params
      FROM slf50_menu
      WHERE id = 130
      AND params !=""
  65. CREATE TABLE IF NOT EXISTS slf50_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1
  66. SELECT count( * ) AS records, MAX( id ) AS max
      FROM slf50_vvisitcounter
  67. SELECT COUNT(*)
      FROM slf50_vvisitcounter
      WHERE ip=UNHEX(SHA1('54.221.83.86'))
      AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )
  68. INSERT INTO slf50_vvisitcounter ( tm, ip, data )
      VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('54.221.83.86')) , NULL )
  69. SELECT COUNT(*)
      FROM slf50_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
      AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)
  70. SELECT COUNT(*)
      FROM slf50_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY))
      AND UNIX_TIMESTAMP(DATE(NOW()))
  71. SELECT COUNT(*)
      FROM slf50_vvisitcounter
      WHERE tm BETWEEN 1440374400
      AND 1440979200
  72. SELECT COUNT(*)
      FROM slf50_vvisitcounter
      WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01"))
      AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)
  73. UPDATE `slf50_session`
      SET `data` = 'Mo8baYVcV5BYnScTq6oV0g6wmihC_qHxCbJNoN79yGXWYFDDqE1Zj0JjPgY2j3IUTXA6pb6FSUOFuFH9rJ1wOm_wuCfsFVvDBNgDJ-AhRWgROBrAvQjA4frGbG6GBoxiPtMz3yJBYU09k6CpiT8ZBaFxUQ8Yj0_yq4S8HjFe8gWIywkOfIp5py9A-21uHGZD8MDWPqqtSUMVxOFOE-uWBMmRNcJU0g3QRhHwuC7pQsodIDevOb6fXplyUUTQrlatz1sttfjNWJmAWUK03OWF5kG-Tvra1yF4CMUKH2M1GOBsPlHXfqP-ASWgdswoMRHb2qmMAqOLclEpCyON_CmWt6jQmjDFCiuzNrh--69p5wCNwod1M0WreSh15gIiuzQ2Q457ncsrj3Zr6n8iKwZtsnnGCfDF4USysGahatlSt3qaejiGKrP5r3J-ZN5igxPSvA1FV0Unq0t9-2BNMhaus4yZA1w01-o1z2rbfmKGe0TBf1KJVtmA8CDqqZPGY9nVnn79micqp266-yCaJyjuAo25_127tLLBWL7KD8nn2av-jsOtlK9AG3U4RXiEbvHjq4C70iyZ79qU6gNovxN8Afy7vquMkCj5G09QssTRXUYB08aZPpHeZn9lHQDRXczpf35VTX19qJOfyYxtuLaKJ-yTD7YO6Ek6v_jDibT79yXRB7PCCu3asBP5jXVyhpuw2SosQEkySgIeZSwkY6Ae3HhJ10mDisEyXtIJVpPVlMbTJAzbuFM8lNyRtjhw0YkGEO_dnwN2ai8-ZF6UhjfUubjY5yUUMSkzh7m8EmgDNzqwzEqYXklcMM9Ebf1fFL3aT99ut4eby4PPB_tNMVgVBS161l1N0n8XOI1xAYY9WoZt-1KVvXQ7M365cSf_mp2-l-2-FW95_uyrOpGIIwzhC3pJtnFDe0GlaOfxc_o-GL-Ot-CgmCJKqJwvzBChFgRdM5E2QFGafQ4mexVNpD6SYVQtsviJYIvlq4YRSwSHmCY0Inuicrx8SpMzs8nlRWDDBRJE27Lq81V4kfKzJzNnEd7STtrHm0vNHqzFXZ_MUcjFfIc_cjVYeEdQ8qsImzxrvit3JuzLnnSy3jCOQH7yXMROuTtWmbP-EIdV5ealdmCEUhhhrasHeldkhg65PItxERRd8sEPDAMVUHsZKwqQ_g..', `time` = 1440890930
      WHERE `session_id` = 'rprhdgba2bk2ds41c8eod2s503'

23 Tipe Query Pencatatan, Urut berdasarkan Kemunculan.

SELECT Tabel:
  1. 43 × SELECT params FROM slf50_menu
  2. 5 × SELECT COUNT(*) FROM slf50_vvisitcounter
  3. 3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM slf50_extensions
  4. 2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM slf50_content AS a LEFT JOIN slf50_categories AS c ON c.id = a.catid LEFT JOIN slf50_users AS ua ON ua.id = a.created_by LEFT JOIN slf50_users AS uam ON uam.id = a.modified_by LEFT JOIN slf50_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN slf50_categories as parent ON parent.id = c.parent_id LEFT JOIN slf50_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM slf50_categories AS cat JOIN slf50_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  5. 2 × SELECT count(*) FROM slf50_jcomments AS c
  6. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM slf50_categories as c LEFT JOIN slf50_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM slf50_categories AS cat JOIN slf50_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  7. 1 × SELECT b.rules FROM slf50_assets AS a LEFT JOIN slf50_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  8. 1 × SELECT count( * ) AS records, MAX( id ) AS max FROM slf50_vvisitcounte
  9. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM slf50_modules AS m LEFT JOIN slf50_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN slf50_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  10. 1 × SELECT * FROM slf50_languages
  11. 1 × SELECT folder AS type, element AS name, params FROM slf50_extensions
  12. 1 × SELECT id, rules FROM `slf50_viewlevels
  13. 1 × SELECT `session_id` FROM `slf50_session`
  14. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM slf50_menu AS m LEFT JOIN slf50_extensions AS e ON m.component_id = e.extension_id
  15. 1 × SELECT * FROM slf50_jcomments_setting
  16. 1 × SELECT `data` FROM `slf50_session`
  17. 1 × SELECT id, home, template, s.params FROM slf50_template_styles as s LEFT JOIN slf50_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  18. 1 × SELECT a.rules FROM slf50_assets AS a
Tabel LAIN:
  1. 1 × UPDATE `slf50_session` SET `data` = 'Mo8baYVcV5BYnScTq6oV0g6wmihC_qHxCbJNoN79yGXWYFDDqE1Zj0JjPgY2j3IUTXA6pb6FSUOFuFH9rJ1wOm_wuCfsFVvDBNgDJ-AhRWgROBrAvQjA4frGbG6GBoxiPtMz3yJBYU09k6CpiT8ZBaFxUQ8Yj0_yq4S8HjFe8gWIywkOfIp5py9A-21uHGZD8MDWPqqtSUMVxOFOE-uWBMmRNcJU0g3QRhHwuC7pQsodIDevOb6fXplyUUTQrlatz1sttfjNWJmAWUK03OWF5kG-Tvra1yF4CMUKH2M1GOBsPlHXfqP-ASWgdswoMRHb2qmMAqOLclEpCyON_CmWt6jQmjDFCiuzNrh--69p5wCNwod1M0WreSh15gIiuzQ2Q457ncsrj3Zr6n8iKwZtsnnGCfDF4USysGahatlSt3qaejiGKrP5r3J-ZN5igxPSvA1FV0Unq0t9-2BNMhaus4yZA1w01-o1z2rbfmKGe0TBf1KJVtmA8CDqqZPGY9nVnn79micqp266-yCaJyjuAo25_127tLLBWL7KD8nn2av-jsOtlK9AG3U4RXiEbvHjq4C70iyZ79qU6gNovxN8Afy7vquMkCj5G09QssTRXUYB08aZPpHeZn9lHQDRXczpf35VTX19qJOfyYxtuLaKJ-yTD7YO6Ek6v_jDibT79yXRB7PCCu3asBP5jXVyhpuw2SosQEkySgIeZSwkY6Ae3HhJ10mDisEyXtIJVpPVlMbTJAzbuFM8lNyRtjhw0YkGEO_dnwN2ai8-ZF6UhjfUubjY5yUUMSkzh7m8EmgDNzqwzEqYXklcMM9Ebf1fFL3aT99ut4eby4PPB_tNMVgVBS161l1N0n8XOI1xAYY9WoZt-1KVvXQ7M365cSf_mp2-l-2-FW95_uyrOpGIIwzhC3pJtnFDe0GlaOfxc_o-GL-Ot-CgmCJKqJwvzBChFgRdM5E2QFGafQ4mexVNpD6SYVQtsviJYIvlq4YRSwSHmCY0Inuicrx8SpMzs8nlRWDDBRJE27Lq81V4kfKzJzNnEd7STtrHm0vNHqzFXZ_MUcjFfIc_cjVYeEdQ8qsImzxrvit3JuzLnnSy3jCOQH7yXMROuTtWmbP-EIdV5ealdmCEUhhhrasHeldkhg65PItxERRd8sEPDAMVUHsZKwqQ_g..', `time` = 1440890930
  2. 1 × INSERT INTO slf50_vvisitcounter ( tm, ip, data ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('54.221.83.86')) , NULL
  3. 1 × CREATE TABLE IF NOT EXISTS slf50_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=
  4. 1 × SHOW COLUMNS FROM slf50_conten
  5. 1 × INSERT INTO `slf50_session` (`session_id`, `client_id`, `time`) VALUES ('rprhdgba2bk2ds41c8eod2s503', 0, 1440890930